[JustinEdw]

Ok, usually I have no problems with this kind of stuff but I am totally stumped on this.

I setup a database in cpanel for sourcemod, executed all the appropriate .sql files to set it up, and I went to remote mysql and added my gameserver ip address: 208.167.234.173 to the remote access list.

Then I edited my databases config file for sourcemod like this.

 "Databases"
{
    "driver_default"        "mysql"
    
    "default"
    {
        "driver"            "mysql"
        "host"            "69.61.121.2"
        "database"      "kkoclan_sourcemod"
        "user"             "kkoclan_sourcem"
        "pass"            "******"
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }
}

Moved the admin-sql-threaded.smx & sql-admin-manager.smx to the plugins folder. Once I connected I tryed adding using a command and as soon as I do the server freezes up and I get this in the logs.

L 07/30/2008 - 05:49:20: [sql-admin-manager.smx] Could not connect to database: [2003]: Can't connect to MySQL server on '69.61.121.2' (110)
L 07/30/2008 - 05:49:20: [admin-sql-threaded.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on '69.61.121.2' (110)

I have tryed everything but I cannot seem to figure this out. Only thing I can think of is somehow I got the wrong ip address setup in remote mysql connection.

[JustinEdw]

Ok I narrowed this down to I must have the wrong server ip in the access list. Unfortunately I rent a server from a sever company so I have no idea what other ip address are on the box or which one Sourcemod is using to try and connect to mysql. Does anyone know how to get sourcemod to tell which ip its trying to use?

[msleeper]

Tell your company to use an access line such as:

GRANT ALL PRIVILEGES ON (database name).* TO (database login)@'%' IDENTIFIED BY '(database password)';

They will either do it or ask you what the hell you are trying to do, in which case you should just tell them you are trying to access MySQL remotely. You would be surprised how helpful hosting companies are if you are truthful to them!

[JustinEdw]

Yeah, They basically told me they do not support remote connection to mysql, and they can't help me. Anyone know a good webhosting company that does?

[JProReTaRD]

surftown