[sinblaster]

I have an issue with some errors I cant work them out, anyone able to shed any light please?

L 08/21/2011 - 06:56:10: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/21/2011 - 06:56:10: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/21/2011 - 06:56:10: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 08/21/2011 - 06:56:11: [admin-sql-threaded.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Its a linux server running latest stable meta, sourcemod and latest dev sdkhooks2. It "HAD" eventscripts" now gone.

cheers

[8088]

Which distribution? Make sure MySQL (mysqld) is running and the socket exists.

[Excel Gamers]

Could you explain more, what do you mean by which distribution. And yes MySQL is running, what do you mean by the socket exists?

Thanks you for your response

[8088]

On which Linux distribution is mysqld running? As in Debian, Ubuntu, CentOS, Fedora, et cetera. And can you show the part of my.cnf (usually in /etc/mysql/) where it says

[mysqld]
socket = ...

[Zephyrus]

http://forums.alliedmods.net/showthread.php?p=526903

[sinblaster]

Originally Posted by 8088 On which Linux distribution is mysqld running? As in Debian, Ubuntu, CentOS, Fedora, et cetera. And can you show the part of my.cnf (usually in /etc/mysql/) where it says [mysqld] socket = ...

He'll need to ask his game server host.

@Zephyrus Thanks mate, I actually tried all suggestions mentioned on that post for excel and none worked.

[tigerox]

try this quick fix...

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

[CapITanJAC]

Originally Posted by tigerox try this quick fix... Ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

thank you, you are a life saver!

[kamild1996]

Since this is the first thread that appears when searching for that error in context of SourceMod, I'm going to drop my quick solution here.

If both your MySQL and game servers are on one box and you're getting this message - make sure you're using the same exact hostname as defined in the my.cnf file, as the "bind_address" variable. If it's set to 127.0.0.1, using localhost won't work (and probably the other way around)!

[OSWO]

apt-get install lib32z1