[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]

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,


On Thu, Apr 17, 2008 at 2:32 PM, Bogdan-Andrei Iancu <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, but
> only on 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 at 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>
> > 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>'
> > (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 at 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
> > http://lists.openser.org/cgi-bin/mailman/listinfo/users
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080417/7482d635/attachment.htm>