Hi
I have 3 server with 172.16.0.10/13/14 IP address.
My DB is located for 172.16.0.10. I tried to connect mysql from terminal, it works great.
But when I start kamailio it gives me following error..
*kamailio.cfg*
loadmodule "usrloc.so" ----- ----- ----- modparam("usrloc", "socket_column", "socket") modparam("usrloc", "use_domain", 0) modparam("usrloc", "desc_time_order", 0) modparam("usrloc", "timer_interval", 60) modparam("usrloc", "db_url", "mysql://openser:openserrw@172.16.0.10/openser ")
*error....
*Feb 4 17:10:53 localhost /usr/local/sbin/kamailio[28792]: ERROR:core:db_do_init: could not add connection to the pool Feb 4 17:10:53 localhost /usr/local/sbin/kamailio[28792]: ERROR:usrloc:child_init: child(8): failed to connect to database Feb 4 17:10:53 localhost /usr/local/sbin/kamailio[28792]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 8 Feb 4 17:10:53 localhost /usr/local/sbin/kamailio[28792]: ERROR:core:main_loop: init_child failed for UDP listener Feb 4 17:10:53 localhost /usr/local/sbin/kamailio[28793]: ERROR:db_mysql:db_mysql_new_connection: driver error: Can't connect to MySQL server on '172.16.0.10' (4)* *
Chandrakant Solanki wrote:
Hi
I have 3 server with 172.16.0.10/13/14 http://172.16.0.10/13/14 IP address.
My DB is located for 172.16.0.10. I tried to connect mysql from terminal, it works great.
But when I start kamailio it gives me following error..
Hello
Just to double check Have you tried:
mysql --user=openser -p --host=172.16.0.10 openser
from 172.16.0.13 and it works?
From localhost afaik mysql client might use Unix socks(/tmp/mysql.sock) . Use should double check that your MySQL server allows TCP connections
Cheers
Marius
-
Chandrakant Solanki -
marius zbihlei