SQL Error

Introduction to the forum software and its feature. You can use this for test postings. This is not a boating forum
sraab928
Posts: 55
Joined: Sat Oct 17, 2015 7:44 am
Location: Merritt Island Florida

SQL Error

Postby sraab928 » Thu Nov 28, 2019 7:35 am

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.
Scott
1971 Boston Whaler Outrage 21 - under restoration
1974 Boston Whaler Revenge 21

jimh
Posts: 11672
Joined: Fri Oct 09, 2015 12:25 pm
Location: Michigan, Lower Peninsula
Contact:

Re: SQL Error

Postby jimh » Thu Nov 28, 2019 9:19 am

The error is caused by bots. I am working on a solution.

biggiefl
Posts: 897
Joined: Thu Jul 11, 2019 1:31 pm
Location: south Tampa Bay area
Contact:

Re: SQL Error

Postby biggiefl » Tue Feb 04, 2020 1:11 pm

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?
On my 24th Whaler. Currently in the stable: 86 18' Outrage, 81 13' Sport(original owner), 87 11' Sport, 69 Squall(for sale cheap).

jimh
Posts: 11672
Joined: Fri Oct 09, 2015 12:25 pm
Location: Michigan, Lower Peninsula
Contact:

Re: SQL Error

Postby jimh » Fri Dec 10, 2021 12:28 pm

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.