access denied for sql db.

Post Reply
blank {grnla 1nc}
New to forums
New to forums
Posts: 3
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Sat Nov 09, 2013 11:20 am

access denied for sql db.

Post by blank {grnla 1nc} »

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.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: access denied for sql db.

Post by soja »

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
blank {grnla 1nc}
New to forums
New to forums
Posts: 3
Joined: Sat Nov 09, 2013 11:20 am

Re: access denied for sql db.

Post by blank {grnla 1nc} »

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.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: access denied for sql db.

Post by soja »

Code: Select all

"default"
{
"driver" "default"
"host" "granola.site.nfoservers.com"
"database" "granola_bot"
"user" "granola"
"pass" " ********"
//"timeout" "0"
"port" "3306"
}
That specifies the default database for plugins to use. It is usually recommended to make a new entry for each plugin.

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
blank {grnla 1nc}
New to forums
New to forums
Posts: 3
Joined: Sat Nov 09, 2013 11:20 am

Re: access denied for sql db.

Post by blank {grnla 1nc} »

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.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: access denied for sql db.

Post by soja »

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!
Not a NFO employee
User avatar
Edge100x
Founder
Founder
Posts: 12945
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: access denied for sql db.

Post by Edge100x »

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.
Post Reply