[OpenSER-Users] Can't start usrloc using mysql connection (mysql:db_mysql_new_connection: driver error: Can't connect to MySQL server on ...)
17 Apr
2008
17 Apr
'08
2:13 p.m.
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' 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
17 Apr
17 Apr
2:32 p.m.
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@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@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
http://lists.openser.org/cgi-bin/mailman/listinfo/users
2:51 p.m.
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(a)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@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@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
http://lists.openser.org/cgi-bin/mailman/listinfo/users
2:52 p.m.
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(a)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(a)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@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@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
http://lists.openser.org/cgi-bin/mailman/listinfo/users
5875
days inactive
5875
days old
3 comments
2 participants
participants (2)
-
Bogdan-Andrei Iancu -
Pascal Maugeri