Hi
I have the following error in connection with MySQL when I enable usrloc to use the DB (db_mode=1):
[...]
Apr 17 14:05:48 [32444] DBG:mysql:db_mysql_init: connection 'mysql://openser:openserrw@192.168.1.4/openser' not found in pool
Apr 17 14:05:48 [32444] DBG:mysql:db_mysql_new_connection: opening connection: mysql://xxxx:xxxx@192.168.1.4/openser
Apr 17 14:05:48 [32444] ERROR:mysql:db_mysql_new_connection: driver error: Can't connect to MySQL server on '192.168.1.4' (111)
Apr 17 14:05:48 [32444] ERROR:usrloc:register_udomain: failed to open database connection
Apr 17 14:05:48 [32444] ERROR:registrar:domain_fixup: failed to register domain
Apr 17 14:05:48 [32444] ERROR:core:fix_actions: fixing failed (code=-1) at cfg line 323
[...]
My configuration file is:
loadmodule "mysql.so"
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
[...]
# ----- usrloc params -----
modparam("usrloc", "db_mode", 1)
modparam("usrloc", "db_url", "mysql://openser:openserrw@192.168.1.4/openser")
I see that mysql server is started and I've managed at installation to create the openser DB (using openserdbctl create).
Could you help me doing the troubleshooting of this ? What else should I verify ?
Regards,
Pascal