Page 1 of 1

SQL Error

Posted: Thu Nov 28, 2019 7:35 am
by sraab928
Ive received this error a few times over the past week when selecting to view "new posts" in the "quick links" - Its always referencing the same user - Thought you would like to know.


SQL ERROR [ mysql4 ]

User 'jimh_bb1' has exceeded the 'max_user_connections' resource (current value: 30) [1226]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Re: SQL Error

Posted: Thu Nov 28, 2019 9:19 am
by jimh
The error is caused by bots. I am working on a solution.

Re: SQL Error

Posted: Tue Feb 04, 2020 1:11 pm
by biggiefl
It is getting much worse Jim. It takes me a half dozen tries to open a thread. When I post a reply it does it too and then I lose the content. Any updates?

Re: SQL Error

Posted: Fri Dec 10, 2021 12:28 pm
by jimh
This now rather old thread reminded my of the battles I was having with promiscuous bots from China attacking the website. To combat this I decided to modify my hosting arrangement to include use of HTTPS and to be behind a firewall. The firewall provides the ability to eliminate geographic regions from accessing the website. China and Russian are blocked, as they are the source of most of these promiscuous bot attacks. That is the good part. The bad part is my cost for hosting more or less tripled.