On 08/17/2015 01:19 PM, Ben Fitzgerald wrote:
Actually I think I've found the issue. The two servers are connected via
two different ethernet interfaces. I initially setup the Kamailio user
with the IP of eth1 and that worked but Kamailio was trying to connect
to MySQL using eth0 (which I did not
Actually I think I've found the issue. The two servers are connected via
two different ethernet interfaces. I initially setup the Kamailio user with
the IP of eth1 and that worked but Kamailio was trying to connect to MySQL
using eth0 (which I did not have that IP authorized to connect). By trying
The language of the error is ambiguous. "many connection errors" could mean
lots of connections, or lots of errors related to connections.
Benjamin Fitzgerald
LETS Corporation
(925) 235-1154
b...@letscorp.us
***Confidential Notice:
This message is intended only for the use of the individua
I should add, I fixed the error and restarted Kamailio - so it's possible
that Kamailio had way more connections at the time of the error but I did
not check the stats at that time, I was focused on fixing it. However, I
would think it's unlikely for Kamailio to create so many connections.
Benjami
Oh, I misread your initial post. The error message is about connection
"errors", not excessive connections.
--
Alex Balashov | Principal | Evariste Systems LLC
303 Perimeter Center North, Suite 300
Atlanta, GA 30346
United States
Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct)
Web:
Alex,
There are 15 total connections and 8 of them are from Kamailio. my.cnf
limit is currently set to 500.
Benjamin Fitzgerald
LETS Corporation
(925) 235-1154
b...@letscorp.us
***Confidential Notice:
This message is intended only for the use of the individual or entity to
which it is add
Ben,
if you look at the MySQL server, what does netstat tell you, e.g.
netstat --inet -n | grep 3306?
-- Alex
--
Alex Balashov | Principal | Evariste Systems LLC
303 Perimeter Center North, Suite 300
Atlanta, GA 30346
United States
Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct)
W
Thanks for your quick reply. I left it default, my config is like this:
fork=yes
children=4
and if I check the process list for Kamailio it looks like there are 11
processes. Even so, this is not near the maximum connections supported by
MySQL.
Benjamin Fitzgerald
LETS Corporation
(925) 235-1154
Ben,
AFAIK, every Kamailio child process creates its own MySQL connection
handle. What are your 'children' set to?
--
Alex Balashov | Principal | Evariste Systems LLC
303 Perimeter Center North, Suite 300
Atlanta, GA 30346
United States
Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (dire
Has anyone seen this error before?
" ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error
on query: Host '192.168.xxx.xxx is blocked because of many connection
errors; unblock with 'mysqladmin flush-hosts'"
I fixed it using flush hosts but I'm curious why this popped up? Is the
10 matches
Mail list logo
