1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Need Help With MysQl Server!
danish007
Huge Clucker
****
Posts: 445
Threads: 108
Joined: Apr 2014
Reputation: 0
#1

03.07.2014, 09:10
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
i've Added Plugin MysQl.so
Server Works On My Computer But When iStart On Host - Lunux - Fractal-Hub or Any Other Host Its Not Starting!
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

03.07.2014, 09:17
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.
Find
Reply
danish007
Huge Clucker
****
Posts: 445
Threads: 108
Joined: Apr 2014
Reputation: 0
#3

03.07.2014, 09:27
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
Find
Reply
Stevo127
Huge Clucker
***
Posts: 221
Threads: 8
Joined: Aug 2008
Reputation: 0
#4

03.07.2014, 09:29
Are you using the correct MySQL plugin that matches the mysql include you are using for the GameMode?
Find
Reply
danish007
Huge Clucker
****
Posts: 445
Threads: 108
Joined: Apr 2014
Reputation: 0
#5

03.07.2014, 09:30
ofc b/c when i start server on my computer it works!
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#6

03.07.2014, 09:31
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
Find
Reply
danish007
Huge Clucker
****
Posts: 445
Threads: 108
Joined: Apr 2014
Reputation: 0
#7

03.07.2014, 09:37
Код:
----------
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
when i chnage the mysql.so plugin! it appears!
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#8

03.07.2014, 09:47
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.
Find
Reply
danish007
Huge Clucker
****
Posts: 445
Threads: 108
Joined: Apr 2014
Reputation: 0
#9

03.07.2014, 09:54
You Said
Quote:

The gamemode uses mysql plugin R6 by BlueG and you loaded the one by StrickenKid.
but its working on my computer?

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
Find
Reply
danish007
Huge Clucker
****
Posts: 445
Threads: 108
Joined: Apr 2014
Reputation: 0
#10

03.07.2014, 10:08
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!
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help