[OpenSIPS-Users] Subscriber table in a remote DB

[Hasitha Lalinda]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091022/5d24dfb7/attachment-0001.htm