MYSQL Issue on Ubuntu - Printable Version

MYSQL Issue on Ubuntu - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MYSQL Issue on Ubuntu (/showthread.php?tid=610736)

MYSQL Issue on Ubuntu - TheMafien - 27.06.2016

My server works perfectly fine on my windows machine, but as soon as I upload it to my ubuntu server it fails to start, the issue seems to come with mysql although I have the latest .so file compiled and set-up in my config.
It says a a bunch of mysql functions arent registered.
Can anyone help?
Thanks.

Re: MYSQL Issue on Ubuntu - long76 - 27.06.2016

try linux version https://github.com/pBlueG/SA-MP-MySQL/releases, if dont help check all plugins or use CrashDetect(https://github.com/Zeex/samp-plugin-...etect/releases), NativeChecher(https://sampforum.blast.hk/showthread.php?tid=249226)

Re: MYSQL Issue on Ubuntu - TheMafien - 27.06.2016

Quote:

Originally Posted by long76

try linux version https://github.com/pBlueG/SA-MP-MySQL/releases, if dont help check all plugins or use CrashDetect(https://github.com/Zeex/samp-plugin-...etect/releases), NativeChecher(https://sampforum.blast.hk/showthread.php?tid=249226)

Nope, still dosent work. Using crash detect and native checker this is the error I am getting
[15:52:47] Error: Function not registered: 'mysql_tquery'
[15:52:47] Error: Function not registered: 'mysql_escape_string'
[15:52:47] Error: Function not registered: 'cache_get_data'
[15:52:47] Error: Function not registered: 'cache_get_field_content'
[15:52:47] Error: Function not registered: 'mysql_stat'
[15:52:47] Error: Function not registered: 'mysql_log'
[15:52:47] Error: Function not registered: 'mysql_connect'
[15:52:47] Error: Function not registered: 'mysql_errno'
[15:52:47] Error: Function not registered: 'mysql_close'
[15:52:47] Error: Function not registered: 'cache_get_row'
[15:52:47] Error: Function not registered: 'cache_insert_id'
[15:52:47] Error: Function not registered: 'cache_affected_rows'
[15:52:47] Script[gamemodes/NLRP.amx]: Run time error 19: "File or function is not found"
[15:52:47] Number of vehicle models: 0

Re: MYSQL Issue on Ubuntu - Spmn - 27.06.2016

Post the entire log.

Re: MYSQL Issue on Ubuntu - xPhantom - 27.06.2016

You're not using the correct MySQL plugin that goes with your script. I would recommend going into your pawno folder includes, go to a_mysql.inc (open it with notepad) and the version should say what it is on top of the include file. You cannot use the latest mysql plugin on an outdated script.

Re: MYSQL Issue on Ubuntu - BlackBank - 27.06.2016

How does your 'plugins' line look in the server.cfg?

Re: MYSQL Issue on Ubuntu - Spmn - 28.06.2016

Quote:

Originally Posted by xPhantom

You're not using the correct MySQL plugin that goes with your script. I would recommend going into your pawno folder includes, go to a_mysql.inc (open it with notepad) and the version should say what it is on top of the include file. You cannot use the latest mysql plugin on an outdated script.

His script is probably compatible with the latest MySQL plugin since it's using functions like: mysql_tquery or mysql_(NOT REAL_)escape_string

Re: MYSQL Issue on Ubuntu - [cS]Owain - 02.07.2016

Try using mysql_static.so instead of mysql.so provided in the download file where you downloaded it from. Dont forget to change it to mysql_static.so in server.cfg!