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
#2

Reinstall MySQL plugin completely include version must match the version of the plugin.
Reply
#3

What do you mean by that? Can you be more specific and guide me? I am inexperienced with Linux.
Reply
#4

He said that you should upload the newest files of the MYSQL,
Such as the include and the plugin, The most to be in the same version to work properly.

Make sure the script supports the plugin you're using.
Reply
#5

I don't quite understand what you mean but what I did is I updated all plugins and include and I used mysql plugin R6 for windows and I tried to recompile my script and I get
Code:
C:\Users\k\Desktop\pawno\include\YSI\y_timers/impl.inc(93) : warning 219: local variable "time" shadows a variable at a preceding level
C:\Users\k\Desktop\samp037_svr_R2-1-1_win32\gamemodes\lvfreeroam.pwn(1008) : error 029: invalid expression, assumed zero
C:\Users\k\Desktop\samp037_svr_R2-1-1_win32\gamemodes\lvfreeroam.pwn(1008) : warning 215: expression has no effect
C:\Users\k\Desktop\samp037_svr_R2-1-1_win32\gamemodes\lvfreeroam.pwn(1008) : error 001: expected token: ";", but found "]"
C:\Users\k\Desktop\samp037_svr_R2-1-1_win32\gamemodes\lvfreeroam.pwn(1008) : error 029: invalid expression, assumed zero
C:\Users\k\Desktop\samp037_svr_R2-1-1_win32\gamemodes\lvfreeroam.pwn(1008) : fatal error 107: too many error messages on one line
How do I fix these? I have been trying all day and I fixed all the errors except these

Btw this is line 1008
Code:
	GetIP ([playerid], PlayerInfo[playerid][Lastlogin], PlayerInfo[playerid][Timeplayed], PlayerInfo[playerid][Timeplayed][1], PlayerInfo[playerid][Timeplayed][2], PlayerInfo[playerid][Score], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths], PlayerInfo[playerid][Skin], PlayerInfo[playerid][Money], PlayerInfo[playerid][Admin], PlayerInfo[playerid][ID]) ;
Reply
#6

Quote:
Originally Posted by hery6
View Post
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
http://stackoverflow.com/questions/2...working-to-off
I hope this will work for you.
Reply
#7

Quote:
Originally Posted by muhsah007
View Post
I have no idea what that is but I am not gonna try it
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)