[OpenSIPS-Users] Pointing auth_db at remote database, OpenSIPS is expecting a local-like schema?

[ambertch]

O ok thanks for the clarification. Just have to make sure to include
that in my web server code to make sure that table is always there
then.

On Wed, Feb 2, 2011 at 4:11 AM, Bogdan-Andrei Iancu-2 [via OpenSIPS
(Open SIP Server)] <ml-node+5984529-875472476-313641 at n2.nabble.com>
wrote:
> Hi Ambert,
>
> Just to be sure it is clear. When you configure a DB connection for a
> certain module, OpenSIPS will use that particular connection to check in
> a version table for the entries corresponding to that module.
>
> So, for your case, opensips will check in the remote DB, in the version
> table, only for the version of the "subscriber" table (used by auth_db)
> module ; for the rest of the modules (pointing to local DB), the version
> from the local Db will be queried.
>
> Regards,
> Bogdan
>
> ambertch wrote:
>> I pointed auth_db at a remote DB and table via the following:
>>
>> modparam("auth_db", "db_url", "mysql://user:pass@server/MY_REMOTE_DB")
>> ...
>> if (!www_authorize("serve.name", "users")) {
>>
>>
>> Doing this, it complains that the table "MY_REMOTE_DB.version" doesn't
>> exist.
>> When I create MY_REMOTE_DB.version and copy over opensips.version, it then
>> complains about users not being the correct version.
>>
>> I addressed this by noting a db entry in opensips.version for the default
>> user storage table of subscriber = 7 and adding users = 7 that into
>> MY_DB_NAME.version
>>
>>
>> It works, but it looks to me that pointing to a remote db, some logic in
>> OpenSIPS is expecting the same things as if auth_db were pointed locally.
>> Is
>> there any way to address this so I can remove the opensips version table
>> from MY_REMOTE_DB?
>>
>> Thanks!
>> Ambert
>>
>>
>
> --
> Bogdan-Andrei Iancu
> OpenSIPS Event - expo, conf, social, bootcamp
> 2 - 4 February 2011, ITExpo, Miami,  USA
> OpenSIPS solutions and "know-how"
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> ________________________________
> If you reply to this email, your message will be added to the discussion
> below:
> http://opensips-open-sip-server.1449251.n2.nabble.com/Pointing-auth-db-at-remote-database-OpenSIPS-is-expecting-a-local-like-schema-tp5983295p5984529.html
> To unsubscribe from Pointing auth_db at remote database, OpenSIPS is
> expecting a local-like schema?, click here.

-- 
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Pointing-auth-db-at-remote-database-OpenSIPS-is-expecting-a-local-like-schema-tp5983295p5985847.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110202/bd3507a5/attachment.htm>