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

[ambertch]

Hey Duane,

Yeah, that's what I ended up doing. It doesn't seem like ideal
behavior, though - I guess I just wanted to hear from the horse's
mouth if this was the only way the server can behave out of the box.

Thanks!
Ambert

On Tue, Feb 1, 2011 at 5:18 PM, osiris123d [via OpenSIPS (Open SIP
Server)] <ml-node+5983342-1942267049-313641 at n2.nabble.com> wrote:
> If I understand you correctly your local version of OpenSIPS has a couple of
> modules that use DB and are pointed to the local mysql server and then you
> also have a remote DB and point auth_db to that remote DB?  Is that
> correct?  It sounds like for the OpenSIPS databases on both MySQL servers
> have different stuff in their "Version" table.  You need to make sure the
> stuff in the version table's on both servers are the correct value.  Maybe
> the best thing to do is within the untar'ed folder of OpenSIPS you installed
> look in the /scripts/mysql folder and the look in all the .sql files to see
> what all needs to be in your "Version" table.
>
>
>
> On Tue, Feb 1, 2011 at 6:47 PM, ambertch <[hidden email]> 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
>>
>> --
>> 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-tp5983295p5983295.html
>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> --
> --
> *--*--*--*--*--*
> Duane
> *--*--*--*--*--*
> --
>
> _______________________________________________
> 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-tp5983295p5983342.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-tp5983295p5983385.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/20110201/baf8fe9c/attachment.htm>