[kooch]

I'm trying to get SQL Admin setup with SourceMod 1.02 and cant get it to connect to my MySql DB on a remote server.

My Databases.cfg is as follows:

"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}


"Admins"
{
"driver" "mysql"
"host" "1.1.1.1"
"database" "admindb"
"user" "user"
"pass" "password"
//"timeout" "0"
"port" "3306"
}


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

I substitute the appropriate username, password, and ip for the remote server where necessary. But when I run sm_create_adm_tables from HLSW I get "Could not connect to database: [2002]: Cant connect to local MySql server through socket '/tmp/mysql.sock' (2)" On the remote host I granted my gameserver IP as a host to the DB to ensure it could communicate without issue, and granted the user All Privileges to the DB. Any help is appreciated.

[MoggieX]

Try changing

PHP Code:

"driver_default" "mysql" 


To

PHP Code:

"driver_default" "Admins" 


And try again.

Matt

[kooch]

Nope. Still can't connect.

[MoggieX]

Originally Posted by kooch Nope. Still can't connect.

Hmmm... what I quoted before was a load of *****ks.

This is what I would do..

Ask the provider to allow the database user to accept connections from any IP (%) for a short while, then use an application such as NaviCat (see Lite version http://www.navicat.com/download.html here ) and confirm the details work (new connection in the top menu, enter details and press Test).

Once happy that they are valid, scrap the "Admins" section and stick wit the default connection data and try again.

If you have phpMyAdmin access, run the .sql script through that, if not use the NaviCat application.

Once you have done this, add/change to a different config as required and try again.

Then once happy, let your provider know and try again with the restricted IP access to the database.

Also take a few minutes to read this:
http://wiki.alliedmods.net/SQL_Admin...ceMod%29#MySQL

SQL Admins works, we use it as we have so many members and would not be able to cope without it!

Matt