[L4DHelp]

To get mine working, I added my game server I.P with a wildcard.

217.163.26.%

[DevilsReject]

i just cant get it to connect also in the ingame menu when i type rank or top10 nothing happens and my stats page does not get updated i think i have to config my databases file correctly.
i beleive i dont have it config'd right

[DevilsReject]

can you pm me your config for the database file without your private info? so i can see a working set up

[msleeper]

Originally Posted by DevilsReject it allowed i had the wrong ip at first for my server the right ip is 209.59.180.114 try to connect now i cannot get this to work at all

Is 209.59.180.114 the IP address of your game server or your MySQL server? You need to use the IP of your MySQL server.

EDIT
Well at least this IP address works, but either my IP is invalid or the info you gave me is wrong. But MySQL does live at this IP.

msleeper@shell:~$ mysql -u(username) -p -h209.59.180.114
Enter password: 
ERROR 1045 (28000): Access denied for user '(username)'@'msleeper.com' (using password: YES)

Did you restart the server after you updated the database.cfg like I said to?

[DevilsReject]

yes i did restart the server.
the ip 209.59.180.114 is the ip of my database
208.167.243.76 is the ip of my game server.

[msleeper]

What is the grant line that you used to create the user (assuming you did so from command line), or what is the host that you used when adding the user? As L4DHelp said, you may need to use the % wildcard for the last octet of the IP, and don't forget to add your game server IP to any firewall whitelists on the MySQL machine.

[DevilsReject]

the server my database is on uses cpanel i created the database though cpanel

[msleeper]

That's out of my territory then, I've never used Cpanel.

[DevilsReject]

my database is fine all i need help on is getting this to connect i need the proper set up for the database.cfg file thats all in cpanel you connect to the database the same way.
i dont have the database file set up right

[msleeper]

Originally Posted by DevilsReject my database is fine all i need help on is getting this to connect i need the proper set up for the database.cfg file thats all in cpanel you connect to the database the same way. i dont have the database file set up right

Aside from the IP being wrong, the last one you PM'd me looks correct.

"Databases"
{
    "driver_default" "mysql"

    "default"
    {
        "driver" "mysql"
        "host" "208.167.243.76"
        "database" "your_db"
        "user" "your_user"
        "pass" "your_pass"
        //"timeout" "0"
        //"port" "21"
    }

    "storage-local"
    {
        "driver" "sqlite"
        "database" "sourcemod-local"
    }

    "clientprefs"
    {
        "driver" "mysql"
        "host" "208.167.243.76"
        "database" "your_db"
        "user" "your_user"
        "pass" "your_pass"
        //"timeout" "0"
        //"port" "21"
    }

    "l4dstats"
    {
        "driver" "mysql"
        "host" "208.167.243.76"
        "database" "your_db"
        "user" "your_user"
        "pass" "your_pass"
    }
}