Hey Duane,
<br><br>Yeah, that's what I ended up doing. It doesn't seem like ideal
<br>behavior, though - I guess I just wanted to hear from the horse's
<br>mouth if this was the only way the server can behave out of the box.
<br><br>Thanks!
<br>Ambert
<br><br>On Tue, Feb 1, 2011 at 5:18 PM, osiris123d [via OpenSIPS (Open SIP
<br>Server)] <<a href="/user/SendEmail.jtp?type=node&node=5983385&i=0" target="_top" rel="nofollow">[hidden email]</a>> wrote:
<div class='shrinkable-quote'><br>> If I understand you correctly your local version of OpenSIPS has a couple of
<br>> modules that use DB and are pointed to the local mysql server and then you
<br>> also have a remote DB and point auth_db to that remote DB? Is that
<br>> correct? It sounds like for the OpenSIPS databases on both MySQL servers
<br>> have different stuff in their "Version" table. You need to make sure the
<br>> stuff in the version table's on both servers are the correct value. Maybe
<br>> the best thing to do is within the untar'ed folder of OpenSIPS you installed
<br>> look in the /scripts/mysql folder and the look in all the .sql files to see
<br>> what all needs to be in your "Version" table.
<br>>
<br>>
<br>>
<br>> On Tue, Feb 1, 2011 at 6:47 PM, ambertch <[hidden email]> wrote:
<br>>>
<br>>> I pointed auth_db at a remote DB and table via the following:
<br>>>
<br>>> modparam("auth_db", "db_url", "mysql://user:pass@server/MY_REMOTE_DB")
<br>>> ...
<br>>> if (!www_authorize("serve.name", "users")) {
<br>>>
<br>>>
<br>>> Doing this, it complains that the table "MY_REMOTE_DB.version" doesn't
<br>>> exist.
<br>>> When I create MY_REMOTE_DB.version and copy over opensips.version, it then
<br>>> complains about users not being the correct version.
<br>>>
<br>>> I addressed this by noting a db entry in opensips.version for the default
<br>>> user storage table of subscriber = 7 and adding users = 7 that into
<br>>> MY_DB_NAME.version
<br>>>
<br>>>
<br>>> It works, but it looks to me that pointing to a remote db, some logic in
<br>>> OpenSIPS is expecting the same things as if auth_db were pointed locally.
<br>>> Is
<br>>> there any way to address this so I can remove the opensips version table
<br>>> from MY_REMOTE_DB?
<br>>>
<br>>> Thanks!
<br>>> Ambert
<br>>>
<br>>> --
<br>>> View this message in context:
<br>>> <a href="http://opensips-open-sip-server.1449251.n2.nabble.com/Pointing-auth-db-at-remote-database-OpenSIPS-is-expecting-a-local-like-schema-tp5983295p5983295.html?by-user=t" target="_top" rel="nofollow" link="external">http://opensips-open-sip-server.1449251.n2.nabble.com/Pointing-auth-db-at-remote-database-OpenSIPS-is-expecting-a-local-like-schema-tp5983295p5983295.html</a><br>>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
<br>>>
<br>>> _______________________________________________
<br>>> Users mailing list
<br>>> [hidden email]
<br>>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_top" rel="nofollow" link="external">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>
<br>>
<br>>
<br>> --
<br>> --
<br>> *--*--*--*--*--*
<br>> Duane
<br>> *--*--*--*--*--*
<br>> --
<br>>
<br>> _______________________________________________
<br>> Users mailing list
<br>> [hidden email]
<br>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_top" rel="nofollow" link="external">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>
<br>>
<br>> ________________________________
<br>> If you reply to this email, your message will be added to the discussion
<br>> below:
<br>> <a href="http://opensips-open-sip-server.1449251.n2.nabble.com/Pointing-auth-db-at-remote-database-OpenSIPS-is-expecting-a-local-like-schema-tp5983295p5983342.html?by-user=t" target="_top" rel="nofollow" link="external">http://opensips-open-sip-server.1449251.n2.nabble.com/Pointing-auth-db-at-remote-database-OpenSIPS-is-expecting-a-local-like-schema-tp5983295p5983342.html</a><br>> To unsubscribe from Pointing auth_db at remote database, OpenSIPS is
<br>> expecting a local-like schema?, click here.
<br></div>
<br><hr align="left" width="300">
View this message in context: <a href="http://opensips-open-sip-server.1449251.n2.nabble.com/Pointing-auth-db-at-remote-database-OpenSIPS-is-expecting-a-local-like-schema-tp5983295p5983385.html">Re: Pointing auth_db at remote database, OpenSIPS is expecting a local-like schema?</a><br>
Sent from the <a href="http://opensips-open-sip-server.1449251.n2.nabble.com/OpenSIPS-Users-f1449235.html">OpenSIPS - Users mailing list archive</a> at Nabble.com.<br>