'max_connections_per_hour'
 

Hello,
We have a few servers sharing the same database for amxbans, and we are constantly getting this error:
[amxbans_main.amxx] [AMXBans] Message: User 'DB USERNAME' has exceeded the 'max_connections_per_hour' resource (current value: 500) (1226)

I have contacted host, but I'm pretty sure they will take some time to respond, and I was wondering whether it is a plugin issue, and if not, do you have any hostings in mind that doesn't have this limitation?
Thanks in advance and I'm really sorry if this is not the right board.

Re: 'max_connections_per_hour'
 

The plugin requires connecting to the database so it's not really a plugin issue.

This is not related to HLDS so this is not the correct place to post this. It would probably only fit in the Off-Topic section.

Re: 'max_connections_per_hour'
 

amxbans it's full of errors and outdated, everyone is using freshbans or litebans 1.3 nowdays, give it a try, At the moment, it's more functional than amxbans, there will be support and updates

Re: 'max_connections_per_hour'
 

I am getting this error along with the other one.
Now, im not sure whether the first error is causing the second one, the second one causing the first one, or not related to each other.

Re: 'max_connections_per_hour'
 

did you create amxbans database with all privilegies? i never got erros like that, i see it happens with missing tables when people install on free website and don't have all privilegies and some tables are not created

Re: 'max_connections_per_hour'
 

about max_connection ploblem, it's a resource limit that your host as put in place so you may have to upgrade your plan, has nothing to do with plugins

Re: 'max_connections_per_hour'
 

Well, we are running almost all game databases on that host, and only amxbans are giving the error, meaning it is constantly connecting/disconnecting from the MySQL server. Now I asked whether those connections were usual, or whether there was another error causing it to reconnect so many times.

Due to the limitation, I am running it on a MySQL server hosted on a VPS, and I havent given all privileges to the amxbans user, as a matter of fact, I havent even given 1/3 of the permissions and it is working fine. What I am unsure about is whether amx_sql_table was set to the wrong value (amx_sql_table "banlist") or whether it was the limitation causing the error.
However, I moved the database and changed the amx_sql_table to "admins" at the same time, so I never got to know which is causing what. However, if needed, I will change that cvar back to "bans" just to test it.

Re: 'max_connections_per_hour'
 

500 per hour?
It's like less than 9 per minute...

I guess it's a user level setting. If you can't modify it, just setup different users for each game server.

Re: 'max_connections_per_hour'
 

Increase the max_user_connection value.

Will help you in giving the no of connections you have set. Increase the number of connections. Max connections can be more than 16000 I guess, it all depends on your CPU, no of threads It can handle etc.

max_user_connections is a dynamic variable, which means you can directly run this query. You do not have to shutdown mysql.

Re: 'max_connections_per_hour'
 

It is already set to 0, the issue is with "max_connections_per_hour". However i am running it on a VPS for now.