[SR-Users] Registrar Server, location and auth_db table

[Santiago Soares]

I think you're right, but this is the way our db was contructed, it would be
very expensive to change it now.
I probably will call an external webservice to save users location.

Thank you very much.

Santiago Soares
Fone: (41) 8488-0537


On Mon, Apr 11, 2011 at 5:51 AM, Henning Westerholt <
henning.westerholt at 1und1.de> wrote:

> On Sunday 10 April 2011, Santiago Soares wrote:
> > I'm trying to use kamailio 1.5.3 as a registrar server. I have a table
> > on my db that contains all user information, like username, password,
> > expire time and ip address, so kamailio should use the same table to
> > authenticate users AND save their location.
> > The problem is that kamailio complains about table version when
> > starts. It expects a different version number for location table and
> > auth_db table. Is there any way I could use the same table for both
> > functions? I'd appreciate any help!
>
> Hi Santiago,
>
> so you want to store subscriber data (which is mostly read-only) in the
> same
> table as location data (which gets updated frequently)? I don't think this
> is
> a good idea. Furthermore booth tables are not really compatible, you
> probably
> need to change something in the code to be able to do this.
>
> If you need to present this data in one point, what about just using the
> two
> standard tables and then creating a view that presents it appropriately?
>
> Cheers,
>
> Henning
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110412/b87a83fd/attachment.htm>