Mysql problem - Printable Version

Mysql problem - 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: Mysql problem (/showthread.php?tid=662103)

Mysql problem - JohnRastion - 23.12.2018

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

Re: Mysql problem - Deken - 23.12.2018

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

Re: Mysql problem - JohnRastion - 23.12.2018

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

Re: Mysql problem - Deken - 23.12.2018

oh i think that error can be uploading to file you maybe put wrong name of specific database?

Re: Mysql problem - Deken - 23.12.2018

oh see this it found no connection to database
update crashdetect plugin

Re: Mysql problem - GamerSize - 23.12.2018

Код:

 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

Re: Mysql problem - JohnRastion - 23.12.2018

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

Re: Mysql problem - JohnRastion - 23.12.2018

Quote:

Originally Posted by Deken

oh see this it found no connection to database
update crashdetect plugin

I'll do it thanks man