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.<br>
<br><br><br><div class="gmail_quote">On Tue, Feb 1, 2011 at 6:47 PM, ambertch <span dir="ltr"><<a href="mailto:ambertch@gmail.com">ambertch@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<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("<a href="http://serve.name" target="_blank">serve.name</a>", "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. 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>
<font color="#888888"><br>
--<br>
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-tp5983295p5983295.html" target="_blank">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>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>