Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Can't connect to local MySQL server through socket '/tmp/mysql.sock' - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (/showthread.php?tid=273818)

Can't connect to local MySQL server through socket '/tmp/mysql.sock' - Ivan_Pantovic - 03.08.2011

Hello everyone, I really need help with this asap. My server is down and people are waiting for it to get up :P.
Anyways. I decided to move from GStylezzz's plugin to StrickenKid's since i found out that StrickenKid's one is a lot more faster. I did everything like it said in the tutorial, and on windows it works fine. But when I go on Linux, I get server log full of this:

Code:

23:27:34] 
[23:27:34] Server Plugins
[23:27:34] --------------
[23:27:34]  Loading plugin: mysql.so
[23:27:34]  SA:MP MySQL Plugin v2.1.1 Loaded.
[23:27:34]   Loaded.
[23:27:34]  Loading plugin: streamer.so
[23:27:34] [MySQL] Thread running. Threadsafe: Yes.
[23:27:34] 

*** Streamer Plugin v2.5.2 by Incognito loaded ***

[23:27:34]   Loaded.
[23:27:34]  Loaded 2 plugins.

[23:27:34] 
[23:27:34] Ban list
[23:27:34] --------
[23:27:34]  Loaded: samp.ban
[23:27:34] 
[23:27:34] 
[23:27:34] Filter Scripts
[23:27:34] ---------------
[23:27:34]   Loaded 0 filter scripts.

[23:27:34] [MySQL] Error (0): Failed to connect. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MYSQL]: Loading bans from MYSQL (from samp).
[23:27:34] [MySQL] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[23:27:34] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
And so on

And mysql log full of this:

Code:

[Wed Aug  3 00:09:15 2011] -------------------------
[Wed Aug  3 00:09:15 2011]      Logging Started
[Wed Aug  3 00:09:15 2011] -------------------------
[Wed Aug  3 00:09:15 2011] Error (0): Failed to connect. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_query called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_query called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_query called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
[Wed Aug  3 00:09:15 2011] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
And so on.

The script is fine, since it works on windows and I didn't make mistakes with big and small letters.

Linux OS: CentOS
ControlPanels: vePortal and Kloxo (if it helps :P)
Mysq mysql plugin by StrickenKid

Please help asap.

Thank you!

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' - linuxthefish - 03.08.2011

Your MySQL server is down or not installed.

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' - Ivan_Pantovic - 03.08.2011

Quote:

Originally Posted by linuxthefish

Your MySQL server is down or not installed.

It's not, I used it before on other plugin + forums and UCP (that are on the same database) are working fine :S.

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' - Patrik356b - 03.08.2011

How about checking the mysql settings ?

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' - Ivan_Pantovic - 03.08.2011

Quote:

Originally Posted by Patrik356b

How about checking the mysql settings ?

Which one :P?