Re: Database Error Message
Quote:
Originally Posted by
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
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.
Re: Database Error Message
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
Re: Database Error Message
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
Re: Database Error Message
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.
Re: Database Error Message
Quote:
Originally Posted by
dbltoe
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.
Re: Database Error Message
Quote:
Originally Posted by
lat9
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
Re: Database Error Message
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.
Re: Database Error Message
Code:
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
