[cold-serenity]

We bought a 2nd vps to handle all our webserver stuff for our clan. I set up lamp and everything is running fine locally. However, my gamesevers cannot connect to the database on the webservers mysql

L 07/04/2012 - 11:26:55: [sourcebans.smx] Database failure: [1045]: Access denie
d for user 'webservers'@'v-74-91-115-34.unman-vds.internap-chicago.nfoservers.co
m' (using password: YES). See FAQ: http://www.sourcebans.net/node/20
L 07/04/2012 - 11:26:55: [economy.smx] Connection to SQL database has failed, Re
ason: [1045]: Access denied for user 'gameservers'@'v-74-91-115-34.unman-vds.int
ernap-chicago.nfoservers.com' (using password: YES)

The above errors are what are shown on my gameservers trying to connect to our 2nd vps.

All the db settings are correct on the gameservers and the user accounts on the webserver have access to the database.

Any help is appreciated.

[YamiKaitou]

Your errors are clear, MySQL accounts 'webservers' and 'gameservers' do not have permission to connect to your MySQL Server from the IP 'v-74-91-115-34.unman-vds.internap-chicago.nfoservers.com'. Simply grant these 2 accounts permission to connect from this IP.

If you had read the FAQ the SourceBans error printed, you would have figured this out.