MySQLi - Too Many Connections Error due to Amazon AWS

[RobNH]

All of a sudden this week, my forums have been getting slammed on two different servers from a ton of hits coming in from various IP addresses that all go back to Amazon AWS.

I've increased max_user_connections in MySQL to 10,000 and tried blocking some of the IP ranges but nothing seems to be working.

Is anyone else seeing this in their forums?

Example:

Database error in vBulletin :

mysqli_real_connect(): (HY000/1040): Too many connections
/home/public_html/forums/includes/class_core.php on line 1351

MySQL Error :
Error Number :
Request Date : Thursday, June 21st 2018 @ 11:48:43 AM
Error Date : Thursday, June 21st 2018 @ 11:48:44 AM
Script : /forums/external.php?type=RSS2&forumids=200
Referrer :
IP Address : 34.209.102.89
Username :
Classname : vB_Database_MySQLi
MySQL Version :
Server : 50.22.50.218
User Agent :


Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 5948
#1 catch_db_error() called in on line
#2 mysqli_real_connect() called in [path]/includes/class_core.php on line 1351
#3 vB_Database_MySQLi->db_connect() called in [path]/includes/class_core.php on line 280
#4 vB_Database->connect() called in [path]/includes/init.php on line 213
#5 require_once([path]/includes/init.php) called in [path]/includes/class_bootstrap.php on line 101
#6 vB_Bootstrap->init() called in [path]/includes/class_bootstrap.php on line 72
#7 vB_Bootstrap->bootstrap() called in [path]/global.php on line 26
#8 require_once([path]/global.php) called in [path]/external.php on line 54
#9 require([path]/external.php) called in [path]/dbseo.php on line 434

 

[Infopro]

Do you have CSF installed on that server?

 

[RobNH]

CSF?

 

[Infopro]

It's the most popular firewall for cPanel Powered servers:
cPanel App Catalog :: ConfigServer Security and Firewall

It can be configured to help prevent this sort of thing.

If you don't have it installed, you should.

More info here:
How to Configure Your Firewall for cPanel Services - cPanel Knowledge Base - cPanel Documentation

 

[RobNH]

I assume you mean ConfigServer? I'm not sure if I do or not. If it's not automatically installed with cPanel and WHM, then chances are, no, I don't have it installed. I've been blocking the IP ranges via .htaccess

 

[Infopro]

It's not installed with cPanel, root user needs to install and configure it manually.

You'll be happy you did.