SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Help Archive

 
 
Thread Tools Display Modes
Old 03/08/2011, 01:16 PM   #1
Ivan_Pantovic
Banned
 
Join Date: Apr 2010
Location: Belgrade, Serbia
Posts: 370
Reputation: 26
Default Can't connect to local MySQL server through socket '/tmp/mysql.sock'

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!
Ivan_Pantovic is offline  
Old 03/08/2011, 01:29 PM   #2
linuxthefish
High-roller
 
linuxthefish's Avatar
 
Join Date: Dec 2010
Location: Al-Dunya
Posts: 2,945
Reputation: 687
Default Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Your MySQL server is down or not installed.
__________________
linuxthefish is offline  
Old 03/08/2011, 01:36 PM   #3
Ivan_Pantovic
Banned
 
Join Date: Apr 2010
Location: Belgrade, Serbia
Posts: 370
Reputation: 26
Default Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Quote:
Originally Posted by linuxthefish View Post
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.
Ivan_Pantovic is offline  
Old 03/08/2011, 01:41 PM   #4
Patrik356b
Gangsta
 
Patrik356b's Avatar
 
Join Date: Mar 2008
Location: Sweden
Posts: 659
Reputation: 24
Default Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

How about checking the mysql settings ?
Patrik356b is offline  
Old 03/08/2011, 01:50 PM   #5
Ivan_Pantovic
Banned
 
Join Date: Apr 2010
Location: Belgrade, Serbia
Posts: 370
Reputation: 26
Default Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Quote:
Originally Posted by Patrik356b View Post
How about checking the mysql settings ?
Which one :P?
Ivan_Pantovic is offline  
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Connect Nonameman Scripting Help 7 19/04/2012 07:42 PM
MySQL don't connect exDDDD Help Archive 1 05/01/2011 04:30 PM
[MYSQL]Connect bug or...? [SF]Bamdude37 Help Archive 13 30/08/2010 08:45 PM
Cannot connect to mysql server Blekk Help Archive 1 22/01/2010 11:53 AM
[Help] Can't Connect With my server [MYSQL?] Sergio_team Help Archive 2 20/09/2009 06:07 AM


All times are GMT. The time now is 05:54 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.