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

I answer to myself (and hope it will help others):

the issue was due to my server MySQL that was bound to 127.0.0.1 !

-pascal

On Thu, Apr 17, 2008 at 2:51 PM, Pascal Maugeri <pascal.maugeri1 at gmail.com>
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,
>
>
> 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/991a318c/attachment.htm>