[OpenSIPS-Users] Subscriber table in a remote DB

[Hasitha Lalinda]

Thanks Flavio.
All works perfectly now. :)

On Thu, Oct 22, 2009 at 2:35 PM, Flavio E. Goncalves <
flavio at asteriskguide.com> wrote:

> Hi Hasitha,
>
> You need to have a table version, with the name of the table and the
> right versions. Check in the source code the MySQL scripts who create
> the databases. For each OpenSIPS table  there is a record in the
> version table.
>
> Regards,
>
> Flavio E. Goncalves
>
> At 11:30 AM 10/22/2009, you wrote:
> >Hello,
> >
> >   Is it possible to use a view/table from a remote database (not
> > from opensips db) for authenticating users?
> >
> >I'm testing following scenario but cannot get it to work.
> >I have a separate user provisioning system which store username,
> >password and domain in a external mysql db. I want opensips to query
> >user credentials from external database when authenticating users.
> >
> >I created a view named "subscriber" in the external DB which
> >contains following fields;
> >  - username
> >  - domain
> >  - ha1
> >  - ha1b
> >
> >In the opensips.conf file I've changed auth_db params as below;
> >
> >modparam("auth_db", "calculate_ha1", yes)
> >modparam("auth_db", "password_column", "password")
> >modparam("auth_db", "db_url","mysql://dbuser:dbpassword@dbserveraddress
> /mydb")
> >modparam("auth_db", "load_credentials", "")
> >
> >
> >When I try to start OpenSIPS it attempts to query from a table
> >called "version" and fail to start.
> >
> >Oct 22 13:54:48 opensips /sbin/opensips[18071]:
> >ERROR:db_mysql:db_mysql_submit_query: driver error: Table
> >'mydb.version' doesn't exist.
> >
> >Any thoughts? Suggestions?
> >
> >Thanks in advance.
> >
> >
> >Hasitha
> >
> >
> >
> >
> >_______________________________________________
> >Users mailing list
> >Users at lists.opensips.org
> >http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091022/58de3aa4/attachment.htm