[OpenSIPS-Users] Subscriber table in a remote DB

[Flavio E. Goncalves]

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