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

Threaded Mode
Mysql problem
JohnRastion
Little Clucker
**
Posts: 43
Threads: 7
Joined: Jun 2017
Reputation: 0
#1

23.12.2018, 18:00
Hello, i'm facing a problem while using a roleplay gamemode.
when i try to start my server, it won't and i got this message in server_log.
PHP код:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[13:59:22] 
[13:59:22] Server Plugins
[13:59:22] --------------
[13:59:22]  Loading plugin: crashdetect.so
[13:59:22]   CrashDetect v4.12 is OK.
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: audio.so
[13:59:22]   Failed (plugins/audio.so: cannot open shared object file: No such file or directory)
[13:59:22]  Loading plugin: sscanf.so
[13:59:22] 
[13:59:22]  ===============================
[13:59:22]       sscanf plugin loaded.     
[13:59:22]          Version:  2.8.2        
[13:59:22]    (c) 2012 Alex "******" Cole  
[13:59:22]  ===============================
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: streamer.so
[13:59:22] 
*** Streamer Plugin v2.9.1 by Incognito loaded ***
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: mysql_static.so
[13:59:22]  >> plugin.mysql: R39-6 successfully loaded.
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: SKY.so
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: pawncmd.so
[13:59:22] Pawn.CMD plugin v3.1.4 by urShadow loaded
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: whirlpool.so
[13:59:22]  
[13:59:22]  ==================
[13:59:22]  
[13:59:22]   Whirlpool loaded
[13:59:22]  
[13:59:22]  ==================
[13:59:22]  
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: regex.so
[13:59:22] 
[13:59:22] ______________________________________
[13:59:22]  Regular Expression Plugin v0.2.1 loaded
[13:59:22] ______________________________________
[13:59:22]  By: Fro (c) Copyright <TBG> 2009-2011
[13:59:22] ______________________________________
[13:59:22]   Loaded.
[13:59:22]  Loading plugin: YSF.so
[13:59:22] ARRAY_ConsoleCommands: 8196920
[13:59:22] 
[13:59:22]  ===============================
[13:59:22]         YSF - kurta999's version R19 loaded
[13:59:22]    © 2008 Alex "******" Cole - © 2010 - 2016 kurta999
[13:59:22]     Server version: 0.3.7 R2-1
[13:59:22]     Operating System: Linux
[13:59:22]     Built on: Mar 13 2017 at 00:24:15
[13:59:22]  ===============================
[13:59:22]   Loaded.
[13:59:22]  Loaded 9 plugins.
[13:59:22] 
[13:59:22] Filterscripts
[13:59:22] ---------------
[13:59:22]   Loading filterscript 'AntiFlood.amx'...
[13:59:22]   Unable to load filterscript 'AntiFlood.amx'.
[13:59:22]   Loading filterscript 'PoliceFlash.amx'...
[13:59:22]   Unable to load filterscript 'PoliceFlash.amx'.
[13:59:22]   Loaded 0 filterscripts.
[13:59:22] OnScriptInit 1
[13:59:22]  
[13:59:22]  
[13:59:22]  
[13:59:22]  ======================================= 
[13:59:22]  |                                     | 
[13:59:22]  |        YSI version 1.06.0002        | 
[13:59:22]  |        By Alex "******" Cole        | 
[13:59:22]  |                                     | 
[13:59:22]  ======================================= 
[13:59:22]  
[13:59:22] OnScriptInit 2
[13:59:22] OnScriptInit 3
[13:59:22] Iter_OnGameModeInit start: 1000
[13:59:22] Get shit on by Anti-DeAMX
[13:59:22] [ERROR] - Unable to establish a connection with the MySQL server...
[13:59:22] Iter_OnGameModeInit: first
[13:59:22] OnScriptInit 4
[13:59:22] Number of vehicle models: 0
[13:59:22] --- Server Shutting Down.
[13:59:22] 
[13:59:22]  ===============================
[13:59:22]      sscanf plugin unloaded.    
[13:59:22]  ===============================
[13:59:22] 
*** Streamer Plugin v2.9.1 by Incognito unloaded ***
[13:59:22] plugin.mysql: Unloading plugin...
[13:59:22] plugin.mysql: Plugin unloaded.
[13:59:22] Pawn.CMD plugin v3.1.4 by urShadow unloaded
[13:59:22]  
[13:59:22]  ====================
[13:59:22]  
[13:59:22]   Whirlpool unloaded
[13:59:22]  
[13:59:22]  ====================
[13:59:22]  
[13:59:22] 
[13:59:22] ______________________________________
[13:59:22]  Regular Expression Plugin v0.2.1 unloaded
[13:59:22] ______________________________________
[13:59:22] 
[13:59:22]  ==============
[13:59:22]   YSF - kurta999's version R19 unloaded
[13:59:22]  ============== 
I got this error when i use mysql_static.so, and when i use mysql.so, i got this error.
PHP код:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[13:58:02] 
[13:58:02] Server Plugins
[13:58:02] --------------
[13:58:02]  Loading plugin: crashdetect.so
[13:58:02]   CrashDetect v4.12 is OK.
[13:58:02]   Loaded.
[13:58:02]  Loading plugin: audio.so
[13:58:02]   Failed (plugins/audio.so: cannot open shared object file: No such file or directory)
[13:58:02]  Loading plugin: sscanf.so
[13:58:02] 
[13:58:02]  ===============================
[13:58:02]       sscanf plugin loaded.     
[13:58:02]          Version:  2.8.2        
[13:58:02]    (c) 2012 Alex "******" Cole  
[13:58:02]  ===============================
[13:58:02]   Loaded.
[13:58:02]  Loading plugin: streamer.so
[13:58:02] 
*** Streamer Plugin v2.9.1 by Incognito loaded ***
[13:58:02]   Loaded.
[13:58:02]  Loading plugin: mysql.so
[13:58:02]   Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)
[13:58:02]  Loading plugin: SKY.so
[13:58:02]   Loaded.
[13:58:02]  Loading plugin: pawncmd.so
[13:58:02] Pawn.CMD plugin v3.1.4 by urShadow loaded
[13:58:02]   Loaded.
[13:58:02]  Loading plugin: whirlpool.so
[13:58:02]  
[13:58:02]  ==================
[13:58:02]  
[13:58:02]   Whirlpool loaded
[13:58:02]  
[13:58:02]  ==================
[13:58:02]  
[13:58:02]   Loaded.
[13:58:02]  Loading plugin: regex.so
[13:58:02] 
[13:58:02] ______________________________________
[13:58:02]  Regular Expression Plugin v0.2.1 loaded
[13:58:02] ______________________________________
[13:58:02]  By: Fro (c) Copyright <TBG> 2009-2011
[13:58:02] ______________________________________
[13:58:02]   Loaded.
[13:58:02]  Loading plugin: YSF.so
[13:58:02] ARRAY_ConsoleCommands: 8196920
[13:58:02] 
[13:58:02]  ===============================
[13:58:02]         YSF - kurta999's version R19 loaded
[13:58:02]    © 2008 Alex "******" Cole - © 2010 - 2016 kurta999
[13:58:02]     Server version: 0.3.7 R2-1
[13:58:02]     Operating System: Linux
[13:58:02]     Built on: Mar 13 2017 at 00:24:15
[13:58:02]  ===============================
[13:58:02]   Loaded.
[13:58:02]  Loaded 8 plugins.
[13:58:02] 
[13:58:02] Filterscripts
[13:58:02] ---------------
[13:58:02]   Loading filterscript 'AntiFlood.amx'...
[13:58:02]   Unable to load filterscript 'AntiFlood.amx'.
[13:58:02]   Loading filterscript 'PoliceFlash.amx'...
[13:58:02]   Unable to load filterscript 'PoliceFlash.amx'.
[13:58:02]   Loaded 0 filterscripts.
[13:58:03] [debug] Run time error 19: "File or function is not found"
[13:58:03] [debug]  mysql_format
[13:58:03] [debug]  mysql_tquery
[13:58:03] [debug]  cache_insert_id
[13:58:03] [debug]  mysql_escape_string
[13:58:03] [debug]  cache_get_data
[13:58:03] [debug]  cache_get_field_content
[13:58:03] [debug]  cache_get_field_content_int
[13:58:03] [debug]  cache_get_field_content_float
[13:58:03] [debug]  mysql_unprocessed_queries
[13:58:03] [debug]  cache_get_row_count
[13:58:03] [debug]  cache_get_row_int
[13:58:03] [debug]  cache_affected_rows
[13:58:03] [debug]  cache_get_row
[13:58:03] [debug]  mysql_connect
[13:58:03] [debug]  mysql_errno
[13:58:03] [debug]  mysql_close
[13:58:03] [debug] Run time error 19: "File or function is not found"
[13:58:03] [debug]  mysql_format
[13:58:03] [debug]  mysql_tquery
[13:58:03] [debug]  cache_insert_id
[13:58:03] [debug]  mysql_escape_string
[13:58:03] [debug]  cache_get_data
[13:58:03] [debug]  cache_get_field_content
[13:58:03] [debug]  cache_get_field_content_int
[13:58:03] [debug]  cache_get_field_content_float
[13:58:03] [debug]  mysql_unprocessed_queries
[13:58:03] [debug]  cache_get_row_count
[13:58:03] [debug]  cache_get_row_int
[13:58:03] [debug]  cache_affected_rows
[13:58:03] [debug]  cache_get_row
[13:58:03] [debug]  mysql_connect
[13:58:03] [debug]  mysql_errno
[13:58:03] [debug]  mysql_close
[13:58:03] Script[gamemodes/RLRP.amx]: Run time error 19: "File or function is not found"
[13:58:03] Number of vehicle models: 0
[13:58:03] New version of CrashDetect is available for download (4.13) 
PS: I'm using centos 7 as host
Find
Reply
Deken
Little Clucker
**
Posts: 48
Threads: 15
Joined: Nov 2017
Reputation: 0
#2

23.12.2018, 18:04
you dont have mysql data base created if you want to use that server go to mysql site using xampp and make database with name like it
Find
Reply
JohnRastion
Little Clucker
**
Posts: 43
Threads: 7
Joined: Jun 2017
Reputation: 0
#3

23.12.2018, 18:06
Quote:
Originally Posted by Deken
Посмотреть сообщение
you dont have mysql data base created if you want to use that server go to mysql site using xampp and make database with name like it
Thanks for replying, well could you be more specific, cause i already assigned mysql db to my host account, and i uploaded .sql file so i don't think the problem from phpmyadmin
Find
Reply
Deken
Little Clucker
**
Posts: 48
Threads: 15
Joined: Nov 2017
Reputation: 0
#4

23.12.2018, 18:27
oh i think that error can be uploading to file you maybe put wrong name of specific database?
Find
Reply
Deken
Little Clucker
**
Posts: 48
Threads: 15
Joined: Nov 2017
Reputation: 0
#5

23.12.2018, 18:34
oh see this it found no connection to database
update crashdetect plugin
Find
Reply
GamerSize
Little Clucker
**
Posts: 8
Threads: 3
Joined: Jun 2018
Reputation: 0
#6

23.12.2018, 18:56
Код:
 Failed (plugins/audio.so: cannot open shared object file: No such file or directory)
and

Код:
Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)
go download libmysqlclient.so and audio.so ...

errors 2x
Find
Reply
JohnRastion
Little Clucker
**
Posts: 43
Threads: 7
Joined: Jun 2017
Reputation: 0
#7

23.12.2018, 19:06
Quote:
Originally Posted by GamerSize
Посмотреть сообщение
Код:
 Failed (plugins/audio.so: cannot open shared object file: No such file or directory)
and

Код:
Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)
go download libmysqlclient.so and audio.so ...

errors 2x
Thanks budy i'll do it right now
Find
Reply
JohnRastion
Little Clucker
**
Posts: 43
Threads: 7
Joined: Jun 2017
Reputation: 0
#8

23.12.2018, 19:09
Quote:
Originally Posted by Deken
Посмотреть сообщение
oh see this it found no connection to database
update crashdetect plugin
I'll do it thanks man
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