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-313...@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.
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users