MySQL timing out for website but game servers are fine.

[Xer0n_]

I am running sourcebans and just recently the website has not been able to connect to the database. The rest of my databases (3) that are running on the same machine have no issue. I have submitted a ticket to NFO and I have been directed here to seek assistance. My game server connects and reads/writes with no issue and using an external program allows me to connect as well with no issue. Just the website is timing out to the database, and I have no idea why.

http://tehbuildbox.com/bans/index.php

I have included the link above if you wish to see the error youself, I did get a corruption error within my external SQL program but have performed a repair using the NFO system and a manual repair using HeidiSQL with no resolution.

/* SQL Error (1548): Cannot load from mysql.proc. The table is probably corrupted */

04:10:02 [09/27/14 04:10:02][SourceBans.lua] |TBB| Xer0n_ has joined, and they are a Senior Admins!

That is evidence that the SQL database is communicating with my 5 Garry's Mod servers using Sourcebans.

Thanks,
Xer0n_

TBB Founder

[Xer0n_]

Yeah, so.. it works now this can be deleted/closed.

[Edge100x]

At one point last week, one of our webhosting machines had blocked its own (external) IP address as part of anti-DDoS measures related to a site being flooded out. If your Sourcebans page was misconfigured to connect to the external IP address instead of "localhost", that may be related to what happened to you.

For anything that connects to a local database, make sure to use "localhost".