[OpenSER-Users] Can't start usrloc using mysql connection (mysql:db_mysql_new_connection: driver error: Can't connect to MySQL server on ...)

[Pascal Maugeri]

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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080417/44263f48/attachment.htm