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

[Julien REVERET]

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 ?



-- 
Julien REVERET
OSIATIS - LIFO https://www.lifo-osiatis.com