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 ?