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

[Bogdan-Andrei Iancu]

There are parameters that should point to the same DB as both openser 
and openserctl should operate on the same DB.

Regards,
Bogdan

Pascal Maugeri wrote:
> You're right Bogdan, I changed my configuration to connect to localhost:
>
> modparam("usrloc", "db_url", 
> "mysql://openser:openserrw@localhost/openser")
>
> Thanks for your prompt reply !
>
> Now it works very well.
>
> just for curiosity, is it important that the DBHOST in the file 
> openserctl file match the host used in openser.cfg for db_url ? Are 
> these two parameters independent ?
>
> Regards,
> Pascal
>
>
>
>
>
>
>
>
> On Thu, Apr 17, 2008 at 2:32 PM, Bogdan-Andrei Iancu 
> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>
>     Hi Pascal,
>
>     try to connect with the mysql client (mysql) from the openser
>     machine to the mysql server machine and see if it works.
>
>     Maybe your mysql server is not configured to listen on 192.168.1.4
>     <http://192.168.1.4>, but only on 127.0.0.1 <http://127.0.0.1>
>     (for local connections).
>
>     Regards,
>     Bogdan
>
>     Pascal Maugeri wrote:
>
>         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
>         <http://openser:openserrw@192.168.1.4/openser>
>         <http://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
>         <http://xxxx:xxxx@192.168.1.4/openser>
>         <http://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
>         <http://192.168.1.4> <http://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
>         <http://openser:openserrw@192.168.1.4/openser>
>         <http://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
>         ------------------------------------------------------------------------
>
>         _______________________________________________
>         Users mailing list
>         Users at lists.openser.org <mailto:Users at lists.openser.org>
>         http://lists.openser.org/cgi-bin/mailman/listinfo/users
>          
>
>
>