I am getting some errors on my sourcebans page: http://www.joinsng.com/bans
Anyone know how I could fix this?
Thank you.
Sourcebans web errors
-
ren3gade
- This is my homepage
- Posts: 87
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Tue Jun 05, 2012 5:43 pm
- Location: USA
Re: Sourcebans web errors
you need to run
FLUSH HOSTS;
as a query(not sure if you can do it, might need to be mysql root). You could also try running "mysqladmin flush-hosts" from SSH.
For a permanent fix:
raise max_connect_errors to something stupidly high in the my.ini file(must be changed by NFO if the SQL server is on their web hosting, we use 10000.
The sourcebans for gmod is coded poorly, and makes a TON of these errors. We cron a php script to run the flush hosts every hour.
you can temporarily set max_connect_errors through a query like this:
SET GLOBAL max_connect_errors=10000;
FLUSH HOSTS;
as a query(not sure if you can do it, might need to be mysql root). You could also try running "mysqladmin flush-hosts" from SSH.
For a permanent fix:
raise max_connect_errors to something stupidly high in the my.ini file(must be changed by NFO if the SQL server is on their web hosting, we use 10000.
The sourcebans for gmod is coded poorly, and makes a TON of these errors. We cron a php script to run the flush hosts every hour.
you can temporarily set max_connect_errors through a query like this:
SET GLOBAL max_connect_errors=10000;
Not a NFO employee
Re: Sourcebans web errors
You need to change the Sourcebans installation on your webhosting to connect to the MySQL server at "localhost" and not "hosted18.nfoservers.com".