Raised This Month: $32 Target: $400
 8% 

MySQL Error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Werewolf_UK
AlliedModders Donor
Join Date: Oct 2010
Location: United Kingdom
Old 06-25-2016 , 14:34   MySQL Error
Reply With Quote #1

I keep getting the following two errors, and I'm not sure if they are connected or not.

This is the first error:


And this is the second:
Code:
L 06/25/2016 - 04:23:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
L 06/25/2016 - 04:31:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
L 06/25/2016 - 04:32:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
L 06/25/2016 - 04:33:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
Ignore the exact plugin for this as I get the same error with other plugins that use MYSQL. I just used this one as an example.

The end result is that my server admins randomly keep losing access to their powers because Sourcebans stops recognising them as admins. I do have them all set in the admin.cfg as a backup, but that also seems to fail.

I *think* Sourcebans is still blocking banned players, but I haven't actually seen any banned players trying to connect.

I am quite frankly out of my depth with this error. I'm not sure if its 1 issue causing the 2 errors, or if they are unrelated. I don't know where to start trying to fix either of these issues, so could someone help me figure this out?
__________________

Last edited by Werewolf_UK; 06-25-2016 at 14:35.
Werewolf_UK is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 06-26-2016 , 11:26   Re: MySQL Error
Reply With Quote #2

Quote:
Originally Posted by sgt_phsco View Post
And this is the second:
Code:
L 06/25/2016 - 04:23:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
L 06/25/2016 - 04:31:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
L 06/25/2016 - 04:32:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
L 06/25/2016 - 04:33:17: [custom-chatcolors-mysql.smx] Unable to connect to database. Falling back to saved values. [1203]: User c1109956_servers already has more than 'max_user_connections' active connections
Ignore the exact plugin for this as I get the same error with other plugins that use MYSQL. I just used this one as an example.
That error is very self explanatory:

If the MySQL user "c1109956_servers" is allowed to have 5 concurrent connections to the MySQL database server, and you try to connect with 10 different game servers, you will already have 10 concurrent connections there, and therefore you are being blocked.

You will have to talk to your provider (...of the MySQL database) for more assistance on that one.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].
DarkDeviL is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:11.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode