AlliedModders - Weird SQL issues on server start.

AlliedModders (https://forums.alliedmods.net/index.php)

- Store (https://forums.alliedmods.net/forumdisplay.php?f=157)

- - Weird SQL issues on server start. (https://forums.alliedmods.net/showthread.php?t=210001)

Weird SQL issues on server start.

I've got everything set up properly....I think. Here's the entry in my databases.cfg:

Code:

    "store"

    {

        "driver"            "mysql"

        "host"                "localhost"

        "database"            "abrandnewday_store"

        "user"                "abrandnewday"

        "password"            "passwordgoeshere"

    }

And here's the errors I'm getting.

Code:

L 03/04/2013 - 22:39:35: SourceMod error session started

L 03/04/2013 - 22:39:35: Info (map "ctf_2fort") (file "errors_20130304.log")

L 03/04/2013 - 22:39:35: [store/store-logging.smx] Connection to SQL database has failed, Reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 03/04/2013 - 22:39:35: [store/store-logging.smx] Connection to SQL database has failed, Reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 03/04/2013 - 22:39:35: [store/store-logging.smx] Connection to SQL database has failed, Reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 03/04/2013 - 22:39:35: [store/store-logging.smx] Connection to SQL database has failed, Reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 03/04/2013 - 22:39:35: [store/store-logging.smx] Connection to SQL database has failed, Reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 03/04/2013 - 22:39:35: [SM] Plugin encountered error 25: Call was aborted

L 03/04/2013 - 22:39:35: [SM] Native "SetFailState" reported: PLUGIN STOPPED - Reason: reconnect counter reached max - PLUGIN STOPPED

L 03/04/2013 - 22:39:35: [SM] Displaying call stack trace for plugin "store/store-backend.smx":

L 03/04/2013 - 22:39:35: [SM]   [0]  Line 1523, C:\Users\Alon\Documents\GitHub\store\scripting\store-backend.sp::T_ConnectSQLCallback()

L 03/04/2013 - 22:39:39: Error log file session closed.

Re: Weird SQL issues on server start.

Try to change localhost to 127.0.0.1. Sometimes it works.

Re: Weird SQL issues on server start.

Quote:

Originally Posted by alongub (Post 1906780)

Try to change localhost to 127.0.0.1. Sometimes it works.

Ah! That's what worked AGES ago when I was having issues with the item drop logger!

I'll give that a try!

EDIT: Nope :(

Code:

L 03/04/2013 - 22:56:55: [store/store-logging.smx] Connection to SQL database has failed, Reason: [2003]: Can't connect to MySQL server on '127.0.0.1' (111)

Re: Weird SQL issues on server start.

Quote:

Originally Posted by alongub (Post 1906789)

http://stackoverflow.com/questions/5...-mysql-sock-38

I'll read that over. I'm using PHPMyAdmin, by the way. Not having any issues with SourceBans or the TF2 Item Drop Logger though...

Ohh, and I don't have access to this "sudo" thing, as I'm not the "owner" of the bloody thing :P Far as I know, everything is installed and running correctly.

Re: Weird SQL issues on server start.

Ok, so there's nothing I can do with any advice from that page you linked me to. I don't have access to any of that stuff, but my host has informed me that yes, SQL is running. Everything is working as it's supposed to, except for this thing, for some reason.

*head-desk*

I'm gonna continue Googling around though, see if I can find anything on these forums that might help...

EDIT: Found out how I solved the same issue I had with SourceBans by looking back at my old posts. Turns out, I had the exact same errors in my logs, but the way I solved those issues were by CHMODing things, whereas this....doesn't seem like CHMODing can/will fix anything....

Re: Weird SQL issues on server start.

I think I'm onto something. I asked my host what the server IP is, and I tried using it instead of localhost or 127.0.0.1

Got a new error:

L 03/05/2013 - 00:07:12: [store/store-logging.smx] Connection to SQL database has failed, Reason: [1045]: Access denied for user 'abrandnewday'@'ip address here' (using password: YES)

Now to see how to fix this.

Re: Weird SQL issues on server start.

are you positive your username is simply "abrandnewday"?
i noticed your DB is prefixed with "abrandnewday" but your username isnt prefixed with anything.

that stands out to me because ALL my DB's AND Usernames are automatically prefixed the same...Basically, I would have no choice but to have the username be "abrandnewday_abrandnewday". The error you copied generally implies an incorrect username or password.

Re: Weird SQL issues on server start.

If the GameServer is not on the same machine as the DB-Server, make sure that you have enabled external access.

I got the "cannot connect through socket" error in my SourceBans installation some time ago.
This fixed the problem (on debian):

Code:

ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

Re: Weird SQL issues on server start.

No, my username isn't prefixed. And my host looked into the setup, and was able to enable the usage of .htaccess for me (which was another issue originally, but it works now), and he also fixed the SQL issues.

Now, I go into testing mode on a blank slate server to see how this works :D