MySQL problem - 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 problem (
/showthread.php?tid=646331)
MySQL on Linux problem -
Parallex - 15.12.2017
Код:
Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
Which results in:
Код:
Error: Function not registered: 'mysql_function_query'
Error: Function not registered: 'mysql_real_escape_string'
Error: Function not registered: 'mysql_affected_rows'
Error: Function not registered: 'cache_get_data'
Error: Function not registered: 'cache_get_row'
Error: Function not registered: 'mysql_insert_id'
Error: Function not registered: 'cache_get_field'
Error: Function not registered: 'mysql_debug'
Error: Function not registered: 'enable_mutex'
Error: Function not registered: 'mysql_connect'
Error: Function not registered: 'mysql_close'
Error: Function not registered: 'mysql_ping'
Run time error 19: "File or function is not found"
The script is using MySQL R7; yes, I know that's old, but I would like to fix this error without upgrading to a newer one as I would have to change a lot of stuff in the script. The script is working fine on Windows, the only problem is with the Linux Host I have been provided with.
I have compiled the script with R7 and the plugin in the Plugins directory of the host is also R7. Moreover, I have also tried running mysql_static.so as a replacement for this problem, however, that does not work with R7. Is there a static for R7 that would be a replacement for this problem? Other than that, I'm willing to do anything else to in order to make this work.
Re: MySQL problem -
WarZ - 15.12.2017
if you are using vps(your own vps) then try to install libmysqlclient_r.so.16
how mysql_static didnt work with you
..
try to load nativechecker and crashdetect plugins
Re: MySQL problem -
Parallex - 15.12.2017
Quote:
Originally Posted by WarZ
if you are using vps(your own vps) then try to install libmysqlclient_r.so.16
how mysql_static didnt work with you ..
try to load nativechecker and crashdetect plugins
|
Both of those plugins (nativechecker and crashdetect are installed). By using mysql_static, this error is gone however the Run Time Error 19 and the other functional MySQL stuff persists (probably due to the fact that the mysql_static.so is a different version than the MySQL which script uses (R7)). As I said before, is there a static version available for R7?
Код:
[04:35:24] Loading plugin: crashdetect.so
[04:35:24] crashdetect v4.8.4 is OK.
[04:35:24] Loaded.
[04:35:24] Loading plugin: nativechecker.so
[04:35:24] Loaded.
And also, I'm using Open Game Panel host.
Re: MySQL problem -
Logic_ - 15.12.2017
Nope, either upgrade the script to R39 or R41 or just sit back on your ass and wait till you get your problem fixed.
Re: MySQL problem -
Parallex - 15.12.2017
Quote:
Originally Posted by Logic_
Nope, either upgrade the script to R39 or R41 or just sit back on your ass and wait till you get your problem fixed.
|
Well, I'm sure there's another way around it.
Re: MySQL problem -
Parallex - 15.12.2017
Fixed, upgraded.