Mysql Problems with server
#1

I have a gamemode that I had someone make for me and it uses mysql to store passwords and other info/stats.In the server_log.txt its says
Code:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[11:16:56] 
[11:16:56] Server Plugins
[11:16:56] --------------
[11:16:56]  Loading plugin: mysql_static.so
[11:16:56]  >> plugin.mysql: R39-5 successfully loaded.
[11:16:56]   Loaded.
[11:16:56]  Loading plugin: Whirlpool.so
[11:16:56]  
[11:16:56]  ==================
[11:16:56]  
[11:16:56]   Whirlpool loaded
[11:16:56]  
[11:16:56]  ==================
[11:16:56]  
[11:16:56]   Loaded.
[11:16:56]  Loading plugin: sscanf.so
[11:16:56] 

[11:16:56]  ===============================

[11:16:56]       sscanf plugin loaded.     

[11:16:56]          Version:  2.8.1        

[11:16:56]    © 2012 Alex "Y_Less" Cole  

[11:16:56]  ===============================

[11:16:56]   Loaded.
[11:16:56]  Loading plugin: CTime.so
[11:16:56]  
 » CTime Library Plugin For Pawn v0.1.0 - Copyright © 2011 RyDeR` 
 
[11:16:56]   Loaded.
[11:16:56]  Loading plugin: nativechecker.so
[11:16:56]   Loaded.
[11:16:56]  Loaded 5 plugins.

[11:16:56] 
[11:16:56] Filterscripts
[11:16:56] ---------------
[11:16:56]   Loading filterscript 'base.amx'...
[11:16:56] 
--Base FS loaded.

[11:16:56]   Loading filterscript 'gl_actions.amx'...
[11:16:56]   Loading filterscript 'gl_property.amx'...
[11:16:56] 
-----------------------------------
[11:16:56] Grand Larceny Property Filterscript		
[11:16:56] -----------------------------------

[11:16:56]   Loading filterscript 'gl_realtime.amx'...
[11:16:56]   Loaded 4 filterscripts.

[11:16:56]  
[11:16:56]  
[11:16:56]  
[11:16:56]  ======================================= 
[11:16:56]  |                                     | 
[11:16:56]  |        YSI version 4.00.0001        | 
[11:16:56]  |        By Alex "Y_Less" Cole        | 
[11:16:56]  |                                     | 
[11:16:56]  ======================================= 
[11:16:56]  
[11:16:56] Loading Gamemode...
[11:16:56] MYSQL: Successfully connected to database on handle 1!
[11:16:56] INIT: Gamemode loaded in 0 milisecond
[11:16:56] Reading File: blank
[11:16:56] Reading File: properties/houses.txt
[11:16:56] Reading File: properties/businesses.txt
[11:16:56] Reading File: properties/banks.txt
[11:16:56] Reading File: properties/police.txt
[11:16:56] 
----------------------------------
[11:16:56]  Las Venturas Freeroam v1.0a loaded! 
[11:16:56] ----------------------------------

[11:16:56] Number of vehicle models: 0
[11:16:59] --- Server Shutting Down.
[11:16:59] plugin.mysql: Unloading plugin...
[11:16:59] plugin.mysql: Plugin unloaded.
[11:16:59]  
[11:16:59]  ====================
[11:16:59]  
[11:16:59]   Whirlpool unloaded
[11:16:59]  
[11:16:59]  ====================
[11:16:59]  
[11:16:59] 

[11:16:59]  ===============================

[11:16:59]      sscanf plugin unloaded.    

[11:16:59]  ===============================
But then, in mysql_log.txt, this is what it says
Code:
[11:16:56] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[11:16:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:16:56] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[11:16:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:16:56] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[11:16:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:16:56] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[11:16:59] [DEBUG] mysql_close - connection: 1
[11:16:59] [WARNING] CMySQLConnection::Disconnect - no connection available
[11:16:59] [WARNING] CMySQLConnection::Disconnect - no connection available
[11:16:59] [WARNING] CMySQLConnection::Disconnect - no connection available
[11:16:59] [WARNING] CMySQLConnection::Disconnect - no connection available
[11:16:59] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
Any idea how to fix this? In the gamemode file, 100% confirm the information is right and the user that I created has full previleges over the database. I am using a Linux VPS with CentOs 6.8 64bit.Btw, Mysql is 100% working because I have smf forums set up at www.woofygaming.online and it is able to connect just fine
Reply


Messages In This Thread
Mysql Problems with server - by hery6 - 05.07.2016, 15:22
Re: Mysql Problems with server - by SecDet - 05.07.2016, 21:59
Re: Mysql Problems with server - by hery6 - 06.07.2016, 05:01
Re: Mysql Problems with server - by darkhunter332 - 06.07.2016, 05:19
Re: Mysql Problems with server - by hery6 - 06.07.2016, 12:56
Re: Mysql Problems with server - by muhsah007 - 06.07.2016, 15:18
Re: Mysql Problems with server - by hery6 - 06.07.2016, 17:28

Forum Jump:


Users browsing this thread: 1 Guest(s)