ok i have no idea why this wont work but i cant get my gameservers to sync with mysql db. here is my database.cfg
"Databases"
{
"psstats"
{
"driver" "mysql"
"host" "granola.stats-ps3.nfoservers.com"
"database" "granola"
"user" "granola"
"pass" "*******"
//"timeout" "0"
"port" "3306"
}
"driver_default" "mysql"
// When specifying "host", you may use an IP address, a hostname, or a socket file path
"default"
{
"driver" "default"
"host" "granola.site.nfoservers.com"
"database" "granola_bot"
"user" "granola"
"pass" " ********"
//"timeout" "0"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}
passwords removed for security
but every time the servers try to connect to the db i get
13:34:22 [sql-admin-manager.smx] Could not connect to database: [1045]: Access denied for user 'granolavsh'@'c-66-151-244-244.internap-dallas.nfoservers.com' (using password: YES)
13:34:22 [SM] Could not connect to the database.
it is the same for all three of my servers and dbs ive made sure to check the box for ext connections in the control panel but still no access. i am able to access thru php but thats it.
ive been able to create tables with the sql scripts from sourcemod but cant get the servers to connect and i have no idea what ive done wrong. any and all help with this would be greatly appreciated as this has been the thorn in my side for about 3 months or so.
access denied for sql db.
-
- New to forums
- Posts: 3
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Sat Nov 09, 2013 11:20 am
Re: access denied for sql db.
Is this error from the same server as the databases.cfg is taken from? It is saying user granolavsh denied but you specified user granola in the config. Also i would advise against using default, create a new one(i think the documentation said use "admins").
Not a NFO employee
-
- New to forums
- Posts: 3
- Joined: Sat Nov 09, 2013 11:20 am
Re: access denied for sql db.
i must have grabbed the error log from the second server but i get the same error message but with the correct username for the database.cfg
19:49:18 [sql-admin-manager.smx] Could not connect to database: [1045]: Access denied for user 'granola'@'c-66-151-244-244.internap-dallas.nfoservers.com' (using password: YES)
19:49:18 [SM] Could not connect to the database.
and by not using default do you mean the driver or what exactly?
thank you for the help and your time.
19:49:18 [sql-admin-manager.smx] Could not connect to database: [1045]: Access denied for user 'granola'@'c-66-151-244-244.internap-dallas.nfoservers.com' (using password: YES)
19:49:18 [SM] Could not connect to the database.
and by not using default do you mean the driver or what exactly?
thank you for the help and your time.
Re: access denied for sql db.
Code: Select all
"default"
{
"driver" "default"
"host" "granola.site.nfoservers.com"
"database" "granola_bot"
"user" "granola"
"pass" " ********"
//"timeout" "0"
"port" "3306"
}
So for example change to:
Code: Select all
"admins"
{
"driver" "default"
"host" "granola.site.nfoservers.com"
"database" "granola_bot"
"user" "granola"
"pass" " ********"
//"timeout" "0"
"port" "3306"
}
Not a NFO employee
-
- New to forums
- Posts: 3
- Joined: Sat Nov 09, 2013 11:20 am
Re: access denied for sql db.
decided to test with a non nfo db and no problems with access there everything works great so problem solved for now. thank you for all your help and time with this.
Re: access denied for sql db.
Ok, probably just an additional security measure taken by Nfo we didn't catch. Glad you are up and running.
If you need anything else please ask!
If you need anything else please ask!
Not a NFO employee
Re: access denied for sql db.
We don't restrict MySQL connections from game servers. From the error, the password or username was likely invalid, but running a repair on the database in question would also be advisable, just to make sure that all permissions are correct.