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