Need Help With MysQl Server! - 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)
+--- Thread: Need Help With MysQl Server! (/showthread.php?tid=523650)
+- 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)
+--- Thread: Need Help With MysQl Server! (/showthread.php?tid=523650)
Need Help With MysQl Server! - danish007 - 03.07.2014
Hello, Today i Host MysQl Server On Linux - Fractal-Hub.Com
I've Uploaded All Things Correct But When i Start Server.
Error is!
Код:
Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R2, ©2005-2014 SA-MP Team [09:31:48] filterscripts = "" (string) [09:31:48] [09:31:48] Server Plugins [09:31:48] -------------- [09:31:48] Loading plugin: mysql.so [09:31:48] SA:MP MySQL Plugin v2.1.1 Loaded. [09:31:48] Loaded. [09:31:48] Loading plugin: streamer.so [09:31:48] *** Streamer Plugin v2.6.1 by Incognito loaded *** [09:31:48] Loaded. [09:31:48] Loading plugin: sscanf.so [09:31:48] [09:31:48] =============================== [09:31:48] sscanf plugin loaded. [09:31:48] © 2009 Alex "******" Cole [09:31:48] 0.3d-R2 500 Players "dnee" [09:31:48] =============================== [09:31:48] Loaded. [09:31:48] Loaded 3 plugins. [09:31:48] [MySQL] Thread running. Threadsafe: Yes. [09:31:49] [09:31:49] Filterscripts [09:31:49] --------------- [09:31:49] Loaded 0 filterscripts. [09:31:51] Script[gamemodes/Cops&Robbers.amx]: Run time error 19: "File or function is not found" [09:31:52] Number of vehicle models: 0
Server Works On My Computer But When iStart On Host - Lunux - Fractal-Hub or Any Other Host Its Not Starting!
Re: Need Help With MysQl Server! - Konstantinos - 03.07.2014
Load nativechecker plugin (must be last in plugins line [in server.cfg]), run the server and post the server log.
By the way, upldate streamer and sscanf plugins to their latest version.
Re: Need Help With MysQl Server! - danish007 - 03.07.2014
I GOt This When i Added Nativechecker!
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R2, ©2005-2014 SA-MP Team [09:56:32] filterscripts = "" (string) [09:56:32] [09:56:32] Server Plugins [09:56:32] -------------- [09:56:32] Loading plugin: mysql.so [09:56:32] SA:MP MySQL Plugin v2.1.1 Loaded. [09:56:32] Loaded. [09:56:32] Loading plugin: streamer.so [09:56:32] *** Streamer Plugin v2.6.1 by Incognito loaded *** [09:56:32] Loaded. [09:56:32] Loading plugin: sscanf.so [09:56:32] [09:56:32] =============================== [09:56:32] sscanf plugin loaded. [09:56:32] © 2009 Alex "******" Cole [09:56:32] 0.3d-R2 500 Players "dnee" [09:56:32] =============================== [09:56:32] Loaded. [09:56:32] Loading plugin: nativechecker.so [09:56:32] Loaded. [09:56:32] Loaded 4 plugins. [09:56:32] [MySQL] Thread running. Threadsafe: Yes. [09:56:33] [09:56:33] Filterscripts [09:56:33] --------------- [09:56:33] Loaded 0 filterscripts. [09:56:35] Error: Function not registered: 'mysql_debug' [09:56:35] Error: Function not registered: 'mysql_retrieve_row' [09:56:35] Error: Function not registered: 'mysql_fetch_field_row' [09:56:35] Script[gamemodes/Cops&Robbers.amx]: Run time error 19: "File or function is not found" [09:56:35] Number of vehicle models: 0
Re: Need Help With MysQl Server! - Stevo127 - 03.07.2014
Are you using the correct MySQL plugin that matches the mysql include you are using for the GameMode?
Re: Need Help With MysQl Server! - danish007 - 03.07.2014
ofc b/c when i start server on my computer it works!
Re: Need Help With MysQl Server! - Konstantinos - 03.07.2014
Wrong mysql plugin. The gamemode uses mysql plugin R6 by BlueG and you loaded the one by StrickenKid.
Once again - you should update the plugins streamer and ssscanf and also consider of switching to R39-2 (threaded queries) because using non-threaded queries is not that good.
If you're interested, here some stuff:
tutorial about threaded queries: https://sampforum.blast.hk/showthread.php?tid=337810
example script: https://github.com/pBlueG/SA-MP-MySQ...stem-cache.pwn
wiki R33+ (for mysql): https://sampwiki.blast.hk/wiki/MySQL/R33
downloads of the latest versions: https://github.com/pBlueG/SA-MP-MySQL/releases
Re: Need Help With MysQl Server! - danish007 - 03.07.2014
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R2, ©2005-2014 SA-MP Team [09:56:32] filterscripts = "" (string) [09:56:32] [09:56:32] Server Plugins [09:56:32] -------------- [09:56:32] Loading plugin: mysql.so [09:56:32] SA:MP MySQL Plugin v2.1.1 Loaded. [09:56:32] Loaded. [09:56:32] Loading plugin: streamer.so [09:56:32] *** Streamer Plugin v2.6.1 by Incognito loaded *** [09:56:32] Loaded. [09:56:32] Loading plugin: sscanf.so [09:56:32] [09:56:32] =============================== [09:56:32] sscanf plugin loaded. [09:56:32] © 2009 Alex "******" Cole [09:56:32] 0.3d-R2 500 Players "dnee" [09:56:32] =============================== [09:56:32] Loaded. [09:56:32] Loading plugin: nativechecker.so [09:56:32] Loaded. [09:56:32] Loaded 4 plugins. [09:56:32] [MySQL] Thread running. Threadsafe: Yes. [09:56:33] [09:56:33] Filterscripts [09:56:33] --------------- [09:56:33] Loaded 0 filterscripts. [09:56:35] Error: Function not registered: 'mysql_debug' [09:56:35] Error: Function not registered: 'mysql_retrieve_row' [09:56:35] Error: Function not registered: 'mysql_fetch_field_row' [09:56:35] Script[gamemodes/Cops&Robbers.amx]: Run time error 19: "File or function is not found" [09:56:35] Number of vehicle models: 0 ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R2, ©2005-2014 SA-MP Team [10:06:24] filterscripts = "" (string) [10:06:24] [10:06:24] Server Plugins [10:06:24] -------------- [10:06:24] Loading plugin: mysql.so [10:06:24] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference) [10:06:24] Loading plugin: streamer.so [10:06:24] *** Streamer Plugin v2.6.1 by Incognito loaded *** [10:06:24] Loaded. [10:06:24] Loading plugin: sscanf.so [10:06:24] [10:06:24] =============================== [10:06:24] sscanf plugin loaded. [10:06:24] © 2009 Alex "******" Cole [10:06:24] 0.3d-R2 500 Players "dnee" [10:06:24] =============================== [10:06:24] Loaded. [10:06:24] Loading plugin: nativechecker.so [10:06:24] Loaded. [10:06:24] Loaded 3 plugins. [10:06:24] [10:06:24] Filterscripts [10:06:24] --------------- [10:06:24] Loaded 0 filterscripts. [10:06:26] Error: Function not registered: 'mysql_query' [10:06:26] Error: Function not registered: 'mysql_debug' [10:06:26] Error: Function not registered: 'mysql_store_result' [10:06:26] Error: Function not registered: 'mysql_num_rows' [10:06:26] Error: Function not registered: 'mysql_retrieve_row' [10:06:26] Error: Function not registered: 'mysql_fetch_field_row' [10:06:26] Error: Function not registered: 'mysql_free_result' [10:06:26] Error: Function not registered: 'mysql_real_escape_string' [10:06:26] Error: Function not registered: 'mysql_connect' [10:06:26] Error: Function not registered: 'mysql_ping' [10:06:26] Script[gamemodes/Cops&Robbers.amx]: Run time error 19: "File or function is not found" [10:06:26] Number of vehicle models: 0
Re: Need Help With MysQl Server! - Konstantinos - 03.07.2014
The gamemode uses R6. If you decide to update the plugin to the latest version, you'll need to update the whole script for it to work (different functions and the way it loads data).
About the error:
Q: I get a Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16[...] error, is there any way to fix it?
A: That likely means that you are using a 64bit system and thus a 64bit libmysqlclient library. You'll have to use the static version of the plugin, the mysql_static.so.
Re: Need Help With MysQl Server! - danish007 - 03.07.2014
You Said
Quote:
|
The gamemode uses mysql plugin R6 by BlueG and you loaded the one by StrickenKid. |
gamemode uses blueg so if i load blueg plugin it will work?
can u tell me the correct download for my server. for fracta-hub.com
Re: Need Help With MysQl Server! - danish007 - 03.07.2014
wooahhh!
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R2, ©2005-2014 SA-MP Team [10:37:01] filterscripts = "" (string) [10:37:02] [10:37:02] Server Plugins [10:37:02] -------------- [10:37:02] Loading plugin: mysql.so [10:37:02] > MySQL plugin R6 successfully loaded. [10:37:02] Loaded. [10:37:02] Loading plugin: streamer.so [10:37:02] *** Streamer Plugin v2.6.1 by Incognito loaded *** [10:37:02] Loaded. [10:37:02] Loading plugin: sscanf.so [10:37:02] [10:37:02] =============================== [10:37:02] sscanf plugin loaded. [10:37:02] © 2009 Alex "******" Cole [10:37:02] 0.3d-R2 500 Players "dnee" [10:37:02] =============================== [10:37:02] Loaded. [10:37:02] Loading plugin: nativechecker.so [10:37:02] Loaded. [10:37:02] Loaded 4 plugins. [10:37:02] [10:37:02] Filterscripts [10:37:02] --------------- [10:37:02] Loaded 0 filterscripts. [10:37:04] [NPC's]: Connecting 13 NPC's With a Delay :P To Avoid From NPCs Attack! [10:37:05] [MYSQL]: Connection To `danish12_10847` Successful!