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
?