vicidial.org

Support,

Need help with this issue.

I'm always having a root mail with this error!

"DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/astguiclient/AST_manager_kill_hung_congested.pl line 193.
executing: SELECT channel FROM live_sip_channels where server_ip = '192.xxx.xxx.xxx' and extension = 'CONGEST' and channel LIKE "Local%" limit 99 MySQL server has gone"

What am i missing?

Please Help!


Thank you.

I read some solutions, some forum said to adjust the wait_timeout, and make max_connections to 500 (mflorell advice in an old forum). how can i do that? where to start?
Please help.

I am not sure if 'max_connections' will solve your problame ... but here is how you can check your setting :
login to your server with a ssh client ( ex. Putty)

Code: Select all

#mysql

on mysql prompt check your setting by running the following SQL command

Code: Select all

mysql> show variables like "max_connections";

This will return a resultset like this, showing you what your current max connections setting is, here is mine:

Code: Select all

+--------------------------+---------+
| Variable_name     | Value |
+--------------------------+---------+
| max_connections | 640    |
+--------------------------+---------+
1 row in set (0.00 sec)

type exit to come out from mysql prompt

thanks tarundas! already changed the value. how about the wait_timeout? where can i find it?

I noticed this error occurs when i reboot. but everything is fine with the server, outgoing and incoming are ok.
what seems to be causing the issue?
we're still on testing so load is minimal.

Thank you.

any advice?

You can safely ignore those mails if you only got a few after a reboot.

The reason is that then your doing a reboot, all services are shut down
if the mysql service is shut down before vicidial then vicidial-scripts cant connect to mysql of course,
that produces an error and sent in a mail.