"Too many connections" error?

[ccw]

Hi,

Today I receive an error message as below:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections /xxx/htdocs/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Thursday, November 13th 2014 @ 04:32:30 AM
Error Date : Thursday, November 13th 2014 @ 04:32:30 AM
Script : http://forums.mysite.com/search.php?search_type=1
Referrer :
IP Address : ##.##.###.##
Username :
Classname : vB_Database
MySQL Version :

How to solve this problem?

Thanks

[Dave]

<a href="http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html" target="_blank">http://dev.mysql.com/doc/refman/5.5/...nnections.html</a>
Increase the max_connections variable of MySQL.

[RichieBoy67]

I agree with Dave. Change the setting in the mysql.cnf but also make sure you limit searches because these are very intensive and this is what is causing your issue. Only allow them 30 seconds apart and lower the max output as well.

[ccw]

Thank you very much. I think the error is caused by DOS attacks. So how to prevent this? How to allow the search 30 seconds apart and lower the max output? Should I modify in vBulltin or in MySQL settings?

[ozzy47]

What makes you think it is a Dos attack?

[RichieBoy67]

Originally Posted by ccw

Thank you very much. I think the error is caused by DOS attacks. So how to prevent this? How to allow the search 30 seconds apart and lower the max output? Should I modify in vBulltin or in MySQL settings?

Under message searching options in your admin panel.

I doubt it is ddos but you can check server logs to be sure.

[ccw]

Because in the past, I also encounter similar error messages and sometimes there will be about thousands of such messages, which makes me believe that is a DOS attack.

[ozzy47]

Well check your server logs and see.

[ccw]

Now today I receive 39 "Too many connections" errors, as below:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections /var/www/vhost/forums.datanumen.com/htdocs/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Friday, November 14th 2014 @ 05:36:50 AM
Error Date : Friday, November 14th 2014 @ 05:36:50 AM
Script : http://forums.datanumen.com/private....=newpm&u=15515
Referrer :
IP Address : 157.55.39.30
Username :
Classname : vB_Database
MySQL Version :

and

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections /var/www/vhost/forums.datanumen.com/htdocs/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Friday, November 14th 2014 @ 05:42:33 AM
Error Date : Friday, November 14th 2014 @ 05:42:34 AM
Script : http://forums.datanumen.com/entry.ph...ods-Girlfriend
Referrer :
IP Address : 199.58.86.206
Username :
Classname : vB_Database
MySQL Version :

The error body will be different a little, but all said "Too many connections"

It seems that the attacker is try to using different way to attack my server. Is there a way to prevent this, other than just increase the max connection for My SQL?

Thanks

[ForceHSS]

Getting a better host if the one you have can't handle what it has now