[OpenSER-Users] bug ? remote mysql server in openser-devel

[Daniel-Constantin Mierla]

Hello,

you have to set the db_url parameter for uri_db module. Just introduce 
it in the line:

modparam("usrloc|auth_db","db_url","mysql://foo:bar@192.168.1.62:3306/openser")

to become:

modparam("usrloc|auth_db|uri_db","db_url","mysql://foo:bar@192.168.1.62:3306/openser")

Cheers,
Daniel


On 07/23/07 18:38, Julien REVERET wrote:
> Hi,
>
> I'm currently using openser-devel release 2497 and I'm facing what I think is a bug. I'm using a remote mysql server. My openser.cfg file contains the following lines :
>
> loadmodule "/usr/local/lib/openser/modules/mysql.so"
> loadmodule "/usr/local/lib/openser/modules/usrloc.so"
> loadmodule "/usr/local/lib/openser/modules/auth.so"
> loadmodule "/usr/local/lib/openser/modules/auth_db.so"
> loadmodule "/usr/local/lib/openser/modules/uri_db.so"
>
> modparam("usrloc", "db_mode", 2)
>
> modparam("auth_db", "calculate_ha1", 1)
> modparam("auth_db", "password_column", "password")
> modparam("auth_db", "user_column", "username")
> modparam("auth_db", "domain_column", "domain")
> modparam("usrloc|auth_db","db_url","mysql://foo:bar@192.168.1.62:3306/openser")
>
>
> When starting openser, I get these lines in the logs :
>
> openser[30331]: INFO: statistics manager successfully initialized
> openser[30331]: StateLess module - initializing
> openser[30331]: TM - initializing...
> openser[30331]: maxfwd:initializing
> openser[30331]: INFO:ul_init_locks: locks array size 512
> openser[30331]: TextOPS - initializing
> openser[30331]: new_connection: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
> openser[30331]: ERROR: uridb_db_ver: unable to open database connection
> openser[30331]: ERROR: uri_db:mod_init(): Error while querying table version
> openser[30331]: init_mod(): Error while initializing module uri_db
> openser[30331]: INFO:mi_fifo:mi_destroy: process hasn't been created -> nothing to kill 
>
> I tried to launch a local mysql and as far as I can see, openser only connects to the local server, it doesn't do any requests. So is there a bug or am I missing something ?
>
>
>
>