SQL Connection Errors

This is where it's all going on. One can ask for advice or general information or simply chew the fat about fishing tackle, tips, and locations.
User avatar
Bobber
Diamond Participant
Diamond Participant
Posts: 3182
Joined: Mon Sep 30, 2002 10:40 am
Location: Stittsville, Ontario
Contact:

Re: SQL Connection Errors

Post by Bobber »

unmanaged wrote:Pretty sure you can block BOTS...

http://www.thesitewizard.com/apache/blo ... cess.shtml
Yeah, I do that already.....the challenge is that every IP Address is different all the time it seems. I do it by both IP Address and Bot Name..... works up until the point a new IP address is used......good times. :evil:
Rob Atkinson
Site Admin (retired)
User avatar
JasonT
Participant
Participant
Posts: 69
Joined: Tue Nov 06, 2007 3:36 pm

Re: SQL Connection Errors

Post by JasonT »

randomly getting this error again

General Error
SQL ERROR [ mysqli ]

User ratkinson already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
If you want to block whole countries that really don't need to be on the site for example china or eastern europe, you can easily do this with your HTACCESS file.
Go to this site and select the countries to block, it will generate the code for you to insert into your HTACCESS file.
http://ipinfodb.com/ip_country_block.php

as I posted earlier you can also rectify the maximum user limit by following the instructions I posted earlier.
User avatar
lape0019
Gold Participant
Gold Participant
Posts: 1817
Joined: Fri May 10, 2013 8:54 am

Re: SQL Connection Errors

Post by lape0019 »

Just a heads up,

I am gettin the exceeding 75000 error at least 3 times a day still. It's still way better than it was though.
User avatar
Bobber
Diamond Participant
Diamond Participant
Posts: 3182
Joined: Mon Sep 30, 2002 10:40 am
Location: Stittsville, Ontario
Contact:

Re: SQL Connection Errors

Post by Bobber »

JasonT wrote:randomly getting this error again

General Error
SQL ERROR [ mysqli ]

User ratkinson already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
If you want to block whole countries that really don't need to be on the site for example china or eastern europe, you can easily do this with your HTACCESS file.
Go to this site and select the countries to block, it will generate the code for you to insert into your HTACCESS file.
http://ipinfodb.com/ip_country_block.php

as I posted earlier you can also rectify the maximum user limit by following the instructions I posted earlier.
Thanks Jason, I'll check that out for sure. Now from your earlier post, I don't have access to the my.cnf file....it's on the host's server and they have this restricted...I don't think I can overwrite it.
Rob Atkinson
Site Admin (retired)
User avatar
JasonT
Participant
Participant
Posts: 69
Joined: Tue Nov 06, 2007 3:36 pm

Re: SQL Connection Errors

Post by JasonT »

depending on your traffic, it may be advantageous to upgrade your hosting or change it entirely.

I use cacloud.com a Canadian cloud hosting company.

The rates are excellent and the best part is you can manage the entire server and site yourself.
The are also quick to respond to any issues and questions you may have for setting anything up.

I find that the Flexible Cloud Nodes 2 package ($49/m) is perfect for my needs and if you need more it takes a few minutes to upgrade to the next level and your good to go.

:ugeek:
User avatar
almontefisher
Diamond Participant
Diamond Participant
Posts: 2971
Joined: Tue Oct 17, 2006 3:08 pm
Location: Carleton Place

Re: SQL Connection Errors

Post by almontefisher »

Who let the !@#$ squirrells back in again. Got it about 15 times this morning already Rob. I have a shotty we can use to get them out of here.
Fishing isn't a matter of life and death....
It's much more important.

ORWL
User avatar
cprince
Diamond Participant
Diamond Participant
Posts: 2612
Joined: Sat Sep 13, 2008 7:43 pm
Location: Québabwe
Contact:

Re: SQL Connection Errors

Post by cprince »

Same here Ally!

Must have got 25 of them today...

Craig
User avatar
Bobber
Diamond Participant
Diamond Participant
Posts: 3182
Joined: Mon Sep 30, 2002 10:40 am
Location: Stittsville, Ontario
Contact:

Re: SQL Connection Errors

Post by Bobber »

cprince wrote:Same here Ally!

Must have got 25 of them today...

Craig
Yeah I know.....seems they are relentless. I need to manually block IP addressess regularly now...What a pain. I'll continue to do so when we get these errors.
Rob Atkinson
Site Admin (retired)
Post Reply