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

17 Apr 2008

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 
 &lt;bogdan(a)voice-system.ro <mailto:bogdan@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(a)lists.openser.org <mailto:Users@lists.openser.org>
         http://lists.openser.org/cgi-bin/mailman/listinfo/users