you have a mail

[richardroi]

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.

[richardroi]

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.

[tarundas]

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

[richardroi]

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

[richardroi]

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.

[richardroi]

any advice?

[DomeDan]

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.