help with mysql stuff
#1

Hello,i have mysql script,its moderntopia edit,citywide or something,and i have prob with it,im trying to run the script in bought host,but it wont work,it will show unknown gamemode,its linux host,i have the plugins sampmysql written and stuff,anyone know the prob?
Reply
#2

Do you acctualy have mysql on ur host?
Reply
#3

Yeah,i have
Reply
#4

Check your server_log.txt if the plugins load.
Reply
#5

with windows mysql plugin:

Код:
###################[ Beginning first 1000 lines from log ]##############

[Sun Apr 4 00:51:06 2010] Launching server with the following commandline:
# /home/gta090/.gameservers/samp_0/samp03svr +exec server.cfg


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3a R3, ©2005-2009 SA-MP Team

[00:51:06] gamemode1 = "" (string)
[00:51:06] gamemode2 = "" (string)
[00:51:06] gamemode3 = "" (string)
[00:51:06] filterscripts = "" (string)
[00:51:06] 
[00:51:06] Server Plugins
[00:51:06] --------------
[00:51:06] Loading plugin: sampmysql
[00:51:06]  Failed (plugins/sampmysql: cannot open shared object file: No such file or directory)
[00:51:06] Loaded 0 plugins.

[00:51:06] 
[00:51:06] Filter Scripts
[00:51:06] ---------------
[00:51:06]  Loaded 0 filter scripts.

[00:51:06] Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found"
[00:51:06] Number of vehicle models: 0


###################[ End of log ]#########################
with linux plugin:

Код:
###################[ Beginning first 1000 lines from log ]##############

[Sun Apr 4 00:52:04 2010] Launching server with the following commandline:
# /home/gta090/.gameservers/samp_0/samp03svr +exec server.cfg


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3a R3, ©2005-2009 SA-MP Team

[00:52:04] gamemode1 = "" (string)
[00:52:04] gamemode2 = "" (string)
[00:52:04] gamemode3 = "" (string)
[00:52:04] filterscripts = "" (string)
[00:52:04] 
[00:52:04] Server Plugins
[00:52:04] --------------
[00:52:04] Loading plugin: sampmysql.so
[00:52:04] 
/*************************************************/
/* SAMP-MySQL v0.15 Plugin loaded successfully ! */
/*************************************************/

[00:52:04]  Loaded.
[00:52:04] Loaded 1 plugins.

[00:52:04] 
[00:52:04] Filter Scripts
[00:52:04] ---------------
[00:52:04]  Loaded 0 filter scripts.

[00:52:04] MYSQL: Attempting to connect to server...
[00:52:04] 
Connection to MySQL database: Failed !
[00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[00:52:04] Error in mysql_select_db: MySQL server has gone away
[00:52:04] MYSQL: Connection error, retrying...
[00:52:04] 
Connection to MySQL database: Failed !
[00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[00:52:04] Error in mysql_select_db: MySQL server has gone away
[00:52:04] MYSQL: Could not reconnect to server, terminating server...
[00:52:04] MYSQL: Connection seems dead, retrying...
[00:52:04] MYSQL: Attempting to connect to server...
[00:52:04] 
Connection to MySQL database: Failed !
[00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[00:52:04] Error in mysql_select_db: MySQL server has gone away
[00:52:04] MYSQL: Connection error, retrying...
[00:52:04] 
Connection to MySQL database: Failed !
[00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[00:52:04] Error in mysql_select_db: MySQL server has gone away
[00:52:04] MYSQL: Could not reconnect to server, terminating server...
[00:52:04] MYSQL: Could not reconnect to server, terminating server...
[00:52:04] Error in mysql_query: MySQL server has gone away
[00:52:04] Error in mysql_store_result: MySQL server has gone away


###################[ End of log ]#########################
Reply
#6

BUMP!
Reply
#7

You didn't even configure the script or setup the MySQL database, therefore you are unable to connect to it.
Reply
#8

i did setup the mysql database,i added tables,and i changed the mysql host,db,pw etc in script,what more?
Reply
#9

BUMP!
Reply
#10

BUMP~!!!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)