Database Error Message

[Bruce1952]

Hi All,

Using version 1.58a on linux server 8.1 php.

I am getting this error message:
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1203] User zen158dba already has more than 'max_user_connections' active connections in /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/Connector.php:70 Stack trace: #0 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/Connector.php(70): PDO->__construct() #1 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection() #2 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection() #3 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect() #4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}() #5 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(1064): call_user_func() #6 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo() #7 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo() #8 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect() #9 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}() #10 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #11 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run() #12 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select() #13 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect() #14 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #15 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns() #16 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get() #17 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels() #18 /home/xxxx/outdoorking.com.au/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get() #19 /home/xxxx/outdoorking.com.au/includes/application_top.php(213): Zencart\PluginManager\PluginManager->getInstalledPlugins() #20 /home/xxxx/outdoorking.com.au/index.php(25): require('/home/a1ntacdk3...') #21 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1203] User zen158dba already has more than 'max_user_connections' active connections (SQL: select * from `plugin_control` where (`status` = 1)) in /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php:712 Stack trace: #0 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #1 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run() #2 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select() #3 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect() #4 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get() #7 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels() #8 /home/xxxx/outdoorking.com.au/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get() #9 /home/xxxx/outdoorking.com.au/includes/application_top.php(213): Zencart\PluginManager\PluginManager->getInstalledPlugins() #10 /home/xxxx/outdoorking.com.au/index.php(25): require('/home/a1ntacdk3...') #11 {main} thrown in /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php on line 712

Any help to point me in the right direction would be appreciated becaus this is the second time it has happened and eventuall fixes itself for some reason unknown to me.

Also how can I get the error message not to show on the site. It is allowing everyone to see what file locations.

[dbltoe]

Hi All,

Using version 1.58a on linux server 8.1 php.

I am getting this error message:
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1203] User zen158dba already has more than 'max_user_connections' active connections in

The max_user_connections global system variable in MySQL limits the number of simultaneous connections that a single account can make. The default value is 151, but it can be changed to a larger value to support more connections.

You will need to get with your hosting company to see if it is correctly set and if they are wiling to set it higher.

This is not a common occurrance and can be a sign that you are going through a Denial of Service (DOS) attack.

Go into your Who's Online and set Exclude Spiders? and Admin both to No. Then, set the Updating to 5s.

If you don't see a large number of Spiders or other IP addresses see what your host can do for you.

[Bruce1952]

This is the only spider showing on the list and I have heard that it can be a bad one to have:

Session ID:
Host: ec2-47-128-54-25.ap-southeast-1.compute.amazonaws.com
User Agent: Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; [email protected])

Can I stop it and if so how please

[dbltoe]

You can add lat9's Access Blocker and manually enter the IP address(es).

https://www.zen-cart.com/downloads.php?do=file&id=2237

[torvista]

https://www.zen-cart.com/showthread....er_connections

You need to review the access logs for that period, sometimes it is a spider/user agent you can block (I had to do some at .htaccess level), other times an ip.
It happens irregularly.

[lat9]

You can add lat9's Access Blocker and manually enter the IP address(es).

https://www.zen-cart.com/downloads.php?do=file&id=2237

Access Blocker simply blocks access to Zen Cart functions (e.g. creating an account or sending a -- most likely SPAM -- contact-us message).

The plugin doesn't address the root-cause of the "too many connections" issue (an overactive bot or a DDoS attack); that needs to be dealt with at a server level, i.e. in the .htaccess file.

[Bruce1952]

Access Blocker simply blocks access to Zen Cart functions (e.g. creating an account or sending a -- most likely SPAM -- contact-us message).

The plugin doesn't address the root-cause of the "too many connections" issue (an overactive bot or a DDoS attack); that needs to be dealt with at a server level, i.e. in the .htaccess file.

What code do I need to put into the htaccess file please

[torvista]

At the start of the file, where e.g. Anthill|Seekport is the list of multiple user agents to block, separated by the pipe.

RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} ^.*(Anthill|Seekport).*$ [NC]
RewriteRule .* - [F,L]


Note that having multiple "RewriteEngine On" in the file is not a problem.

[mprough]

RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} Bytedance [NC]
RewriteRule .* - [F,L]
RewriteCond %{HTTP_USER_AGENT} Bytespider [NC]
RewriteRule .* - [F,L]

Add this to your htaccess to block them. Blocking by IP is not very effective as these China IPs are spawned faster than they can be blocked.

~Melanie