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

[Duane Larson]

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 <ambertch at gmail.com> 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110201/a3a2b1a8/attachment-0001.htm>