MYSQL Plugins dont work since some days

[mazdarx8]

Hello,

first sorry for my bad english.

Overview:
Extern database
2x Rootserver

On my first rootserver I dont have this problems. On my first rootserver there are running same plugins, configs etc,. like on my 2nd rootserver.

On my second rootserver, plugins which mysql dont work anymore:

Example error log on my 2nd root:
Unable to initiate database connection. ([1042]: Can't get hostname for your address)
On my first root no error logs.

sm exts list (2nd root):
[13] MySQL-DBI (1.7.3-dev+5280): MySQL driver implementation for DBI
Looks fine..


Restarted mysql, restarted 2nd rootserver.. no positive effect..

[Bacardi]

ip address or domain address ?

[mazdarx8]

database.cfg:

"store"
{
"driver" "mysql"
"host" "IPADRESS"
"database" "name"
"user" "name"
"pass" "passwd"
//"timeout" "0"
//"port" "0"
}

like on Root A (where its working)

[Neuro Toxin]

I used to get this on shared hosting. Might be the same issue.

The host had multiple NICs / ips.

I would add the game servers ip to the remote mysql hosts in cpanel to allow the connection.

All fine.

The host then forced all mysql client connections to use another NIC.

It was effectively impossible to troubleshoot why the connection is refused to the mysql server until i realised the error message had another ip.

Oh. Add that to the mysql remote list. Bang done.

A couple of times the host had to flush the mysql server because of bans.

[DarkDeviL]

Look at this stuff (https://forums.alliedmods.net/showthread.php?p=2410049#post2410049), on the server housing your MySQL server.

And make sure there is a valid reverse DNS (PTR<->A record combination must match in both directions) on the server housing your game server, talk to your ISP for more information.