[Noris]

linux Ubuntu 14.2 32 bits, Linux VPS. Just got whirpool.so loaded. Tried using mysql_static.so , No work

Quote:

SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [25/05/2016 10:40:47] [25/05/2016 10:40:47] Server Plugins [25/05/2016 10:40:47] -------------- [25/05/2016 10:40:47] Loading plugin: crashdetect.so [25/05/2016 10:40:47] CrashDetect v4.13.1 is OK. [25/05/2016 10:40:47] Loaded. [25/05/2016 10:40:47] Loading plugin: streamer.so [25/05/2016 10:40:47] *** Streamer Plugin v2.6.1 by Incognito loaded *** [25/05/2016 10:40:47] Loaded. [25/05/2016 10:40:47] Loading plugin: sscanf.so [25/05/2016 10:40:47] [25/05/2016 10:40:47] =============================== [25/05/2016 10:40:47] sscanf plugin loaded. [25/05/2016 10:40:47] Version: 2.8.1 [25/05/2016 10:40:47] © 2012 Alex "******" Cole [25/05/2016 10:40:47] =============================== [25/05/2016 10:40:47] Loaded. [25/05/2016 10:40:47] Loading plugin: mysql.so [25/05/2016 10:40:47] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory) [25/05/2016 10:40:47] Loading plugin: Whirlpool.so [25/05/2016 10:40:47] Failed (plugins/Whirlpool.so: cannot open shared object file: No such file or directory) [25/05/2016 10:40:47] Loaded 3 plugins. [25/05/2016 10:40:52] [25/05/2016 10:40:52] Filterscripts [25/05/2016 10:40:52] --------------- [25/05/2016 10:40:52] Loading filterscript 'yom_buttons.amx'... [25/05/2016 10:40:52] Loading filterscript 'anims.amx'... [25/05/2016 10:40:52] Loaded 2 filterscripts. [25/05/2016 10:40:52] [debug] Run time error 19: "File or function is not found" [25/05/2016 10:40:52] [debug] mysql_query [25/05/2016 10:40:52] [debug] mysql_real_escape_string [25/05/2016 10:40:52] [debug] mysql_connect [25/05/2016 10:40:52] [debug] mysql_debug [25/05/2016 10:40:52] [debug] mysql_store_result [25/05/2016 10:40:52] [debug] mysql_fetch_int [25/05/2016 10:40:52] [debug] mysql_free_result [25/05/2016 10:40:52] [debug] mysql_num_rows [25/05/2016 10:40:52] [debug] WP_Hash [25/05/2016 10:40:52] [debug] mysql_fetch_row_format [25/05/2016 10:40:52] [debug] mysql_retrieve_row [25/05/2016 10:40:52] [debug] mysql_fetch_field_row [25/05/2016 10:40:52] [debug] mysql_insert_id [25/05/2016 10:40:52] [debug] Run time error 19: "File or function is not found" [25/05/2016 10:40:52] [debug] mysql_query [25/05/2016 10:40:52] [debug] mysql_real_escape_string [25/05/2016 10:40:52] [debug] mysql_connect [25/05/2016 10:40:52] [debug] mysql_debug [25/05/2016 10:40:52] [debug] mysql_store_result [25/05/2016 10:40:52] [debug] mysql_fetch_int [25/05/2016 10:40:52] [debug] mysql_free_result [25/05/2016 10:40:52] [debug] mysql_num_rows [25/05/2016 10:40:52] [debug] WP_Hash [25/05/2016 10:40:52] [debug] mysql_fetch_row_format [25/05/2016 10:40:52] [debug] mysql_retrieve_row [25/05/2016 10:40:52] [debug] mysql_fetch_field_row [25/05/2016 10:40:52] [debug] mysql_insert_id [25/05/2016 10:40:52] Script[gamemodes/Stratum.amx]: Run time error 19: "File or function is not found" [25/05/2016 10:40:52] Number of vehicle models: 0 [25/05/2016 10:41:19] --- Server Shutting Down. [25/05/2016 10:41:19] [debug] Run time error 19: "File or function is not found" [25/05/2016 10:41:19] [debug] mysql_query [25/05/2016 10:41:19] [debug] mysql_real_escape_string [25/05/2016 10:41:19] [debug] mysql_connect [25/05/2016 10:41:19] [debug] mysql_debug [25/05/2016 10:41:19] [debug] mysql_store_result [25/05/2016 10:41:19] [debug] mysql_fetch_int [25/05/2016 10:41:19] [debug] mysql_free_result [25/05/2016 10:41:19] [debug] mysql_num_rows [25/05/2016 10:41:19] [debug] WP_Hash [25/05/2016 10:41:19] [debug] mysql_fetch_row_format [25/05/2016 10:41:19] [debug] mysql_retrieve_row [25/05/2016 10:41:19] [debug] mysql_fetch_field_row [25/05/2016 10:41:19] [debug] mysql_insert_id [25/05/2016 10:41:19] *** Streamer Plugin v2.6.1 by Incognito unloaded *** [25/05/2016 10:41:19] [25/05/2016 10:41:19] =============================== [25/05/2016 10:41:19] sscanf plugin unloaded. [25/05/2016 10:41:19] ===============================

Just did this
cd /lib
wget http://blackbirdhost.tk/libmysqlclient_r.so.16
cd/lib32
wget http://blackbirdhost.tk/libmysqlclient_r.so.16
cd /usr/lib
wget http://blackbirdhost.tk/libmysqlclient_r.so.16
cd /usr/lib32
wget http://blackbirdhost.tk/libmysqlclient_r.so.16

and got this

Quote:

Failed (/lib/libmysqlclient_r.so.16: invalid ELF header)

New log

EDIT: i get this log when i try to run mysql_static.so

Quote:

SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [25/05/2016 11:00:44] [25/05/2016 11:00:44] Server Plugins [25/05/2016 11:00:44] -------------- [25/05/2016 11:00:44] Loading plugin: crashdetect.so [25/05/2016 11:00:44] CrashDetect v4.13.1 is OK. [25/05/2016 11:00:44] Loaded. [25/05/2016 11:00:44] Loading plugin: streamer.so [25/05/2016 11:00:44] *** Streamer Plugin v2.6.1 by Incognito loaded *** [25/05/2016 11:00:44] Loaded. [25/05/2016 11:00:44] Loading plugin: sscanf.so [25/05/2016 11:00:44] [25/05/2016 11:00:44] =============================== [25/05/2016 11:00:44] sscanf plugin loaded. [25/05/2016 11:00:44] Version: 2.8.1 [25/05/2016 11:00:44] © 2012 Alex "******" Cole [25/05/2016 11:00:44] =============================== [25/05/2016 11:00:44] Loaded. [25/05/2016 11:00:44] Loading plugin: mysql_static.so [25/05/2016 11:00:44] >> plugin.mysql: R33 successfully loaded. [25/05/2016 11:00:44] Loaded. [25/05/2016 11:00:44] Loading plugin: whirlpool.so [25/05/2016 11:00:44] [25/05/2016 11:00:44] ================== [25/05/2016 11:00:44] [25/05/2016 11:00:44] Whirlpool loaded [25/05/2016 11:00:44] [25/05/2016 11:00:44] ================== [25/05/2016 11:00:44] [25/05/2016 11:00:44] Loaded. [25/05/2016 11:00:44] Loaded 5 plugins. [25/05/2016 11:00:49] [25/05/2016 11:00:49] Filterscripts [25/05/2016 11:00:49] --------------- [25/05/2016 11:00:49] Loading filterscript 'yom_buttons.amx'... [25/05/2016 11:00:49] Loading filterscript 'anims.amx'... [25/05/2016 11:00:49] Loaded 2 filterscripts. [25/05/2016 11:00:49] [debug] Run time error 19: "File or function is not found" [25/05/2016 11:00:49] [debug] mysql_real_escape_string [25/05/2016 11:00:49] [debug] mysql_debug [25/05/2016 11:00:49] [debug] mysql_store_result [25/05/2016 11:00:49] [debug] mysql_fetch_int [25/05/2016 11:00:49] [debug] mysql_free_result [25/05/2016 11:00:49] [debug] mysql_num_rows [25/05/2016 11:00:49] [debug] mysql_fetch_row_format [25/05/2016 11:00:49] [debug] mysql_retrieve_row [25/05/2016 11:00:49] [debug] mysql_fetch_field_row [25/05/2016 11:00:49] [debug] mysql_insert_id [25/05/2016 11:00:49] [debug] Run time error 19: "File or function is not found" [25/05/2016 11:00:49] [debug] mysql_real_escape_string [25/05/2016 11:00:49] [debug] mysql_debug [25/05/2016 11:00:49] [debug] mysql_store_result [25/05/2016 11:00:49] [debug] mysql_fetch_int [25/05/2016 11:00:49] [debug] mysql_free_result [25/05/2016 11:00:49] [debug] mysql_num_rows [25/05/2016 11:00:49] [debug] mysql_fetch_row_format [25/05/2016 11:00:49] [debug] mysql_retrieve_row [25/05/2016 11:00:49] [debug] mysql_fetch_field_row [25/05/2016 11:00:49] [debug] mysql_insert_id [25/05/2016 11:00:49] Script[gamemodes/Stratum.amx]: Run time error 19: "File or function is not found" [25/05/2016 11:00:49] Number of vehicle models: 0

Help

Libmysqlclient.r.so.16 of death!?

I have tried all tutorial, no work im on ubuntu 14.02 32 bits

NOW I GET THIS!
[25/05/2016 11:44:19] Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64)

Anyone? i tried searching ****** thousand time i didnt find libmysql for 32 bits

[DRIFT_HUNTER]

Wrong discussion (again...someone already posted linux os related problem in pawn discussion forum)

Anyway, avoid downloading packages with wget or anything like that unless you need/want to compile them yourself, if you do so keep track so you can uninstall them if you need. Instead use some of package manager (for example apt-get that comes by default).

You installed mysql server but not mysql client (you need it to connect to mysql server)

Code:

sudo apt-get update
sudo apt-get install mysql-client

[Amunra]

Your Include already added ?

[Noris]

Quote:

Originally Posted by DRIFT_HUNTER Wrong discussion (again...someone already posted linux os related problem in pawn discussion forum) Anyway, avoid downloading packages with wget or anything like that unless you need/want to compile them yourself, if you do so keep track so you can uninstall them if you need. Instead use some of package manager (for example apt-get that comes by default). You installed mysql server but not mysql client (you need it to connect to mysql server) Code: sudo apt-get update sudo apt-get install mysql-client

Didn't worked. Should I try getting libmysqlclient_r.so.16 for Ubuntu 14.0 32 bits? Where and how ?

I've got libmysqlclient r so 16 and put it on /lib directory but it gives me this error on server_log.txt

So I'm sure I downloaded the wrong compatibility libmysql which is only working on x64 Ubuntu 14, So I need libmysqlclient_r.so.16 for 32 bits Ubuntu, Thanks!!!

25/05/2016 11:44:19] Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64)

Quote:

Originally Posted by Noris Didn't worked. Should I try getting libmysqlclient_r.so.16 for Ubuntu 14.0 32 bits? Where and how ? I've got libmysqlclient r so 16 and put it on /lib directory but it gives me this error on server_log.txt So I'm sure I downloaded the wrong compatibility libmysql which is only working on x64 Ubuntu 14, So I need libmysqlclient_r.so.16 for 32 bits Ubuntu, Thanks!!! 25/05/2016 11:44:19] Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64)

Quote:

Originally Posted by Amunra Your Include already added ?

Would be very grateful if you can clarify that for me. Thanks in advance

[DRIFT_HUNTER]

Quote:

Originally Posted by Noris Didn't worked. Should I try getting libmysqlclient_r.so.16 for Ubuntu 14.0 32 bits? Where and how ? I've got libmysqlclient r so 16 and put it on /lib directory but it gives me this error on server_log.txt So I'm sure I downloaded the wrong compatibility libmysql which is only working on x64 Ubuntu 14, So I need libmysqlclient_r.so.16 for 32 bits Ubuntu, Thanks!!! 25/05/2016 11:44:19] Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64)

Well i dont think i can be much help except what i already posted.
Since you mentioned that you are on 32bit try forcing 32bit (but it actually should be by default)

Code:

sudo apt-get install mysql-client:i368

If that also does not work chmod that file to 755

[Noris]

Quote:

Originally Posted by DRIFT_HUNTER Well i dont think i can be much help except what i already posted. Since you mentioned that you are on 32bit try forcing 32bit (but it actually should be by default) Code: sudo apt-get install mysql-client:i368 If that also does not work chmod that file to 755

Hello , i just tried what you say on previous and here's what i get

Code:

root@vpsstratumrpcom:~# sudo apt-get install mysql-client
E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?

[Sublime]

Quote:

Originally Posted by DRIFT_HUNTER Well i dont think i can be much help except what i already posted. Since you mentioned that you are on 32bit try forcing 32bit (but it actually should be by default) Code: sudo apt-get install mysql-client:i368 If that also does not work chmod that file to 755

why do you want to chmod a file, let alone a plugin (that only needs to be read) to 755?



group/other do no need permission to 'execute' a plugin.

a far better option would be 644



other than owner (use ls -l filename to find file owner), group/other only get read permissions. which is pretty ok and safe enough.

follow this quote

Quote:

Originally Posted by Jake187 download and install this repo http://dev.mysql.com/downloads/repo/apt/ when you install the 5.6 mySQL venison you can use apt-get install libmysqlclient16 and many others and this is the only official repo from MySQL themselves and will include all the latest updates.

--------------

Quote:

Originally Posted by Noris Hello , i just tried what you say on previous and here's what i get Code: root@vpsstratumrpcom:~# sudo apt-get install mysql-client E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable) E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?

try and kill apt(-get) if it's running under background process

ps aux | grep apt
kill processidofapt

if it's persistent, then try kill -9 or kill -KILL

just wait out for a while n then do ^ if your earlier apt-get cmd still wont work

[Noris]

Quote:

Originally Posted by Sublime why do you want to chmod a file, let alone a plugin (that only needs to be read) to 755? group/other do no need permission to 'execute' a plugin. a far better option would be 644 other than owner (use ls -l filename to find file owner), group/other only get read permissions. which is pretty ok and safe enough. follow this quote -------------- try and kill apt(-get) if it's running under background process ps aux | grep apt kill processidofapt if it's persistent, then try kill -9 or kill -KILL just wait out for a while n then do ^ if your earlier apt-get cmd still wont work

Hello, thanks for it, I ran DRIF_HUNTER's command, but i get this

Code:

root@vpsstratumrpcom:~# sudo apt-get install mysql-client:i368
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package mysql-client
root@vpsstratumrpcom:~#

I also tried running
apt-get install libmysqlclient16

But i get this

Code:

root@vpsstratumrpcom:~# sudo apt-get install libmysqlclient16
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package libmysqlclient16
root@vpsstratumrpcom:~#

What is the other way?

[Sublime]

Quote:

Originally Posted by Noris Hello, What are the steps to install those repo?

http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

Quote:

Originally Posted by Noris EDIT: Hello, I wonder what is the mean of this? [25/05/2016 15:07:27] Loading plugin: mysql.so [25/05/2016 15:07:27] Failed (/usr/lib/libmysqlclient_r.so.16: file too short) This happens after i put libmysqlclient_r.so.16 in /usr/lib , /lib

probably corrupted file, remove the file in both directories asap and follow the link above this message

[Noris]

I can't install those repo, Can anyone help me?

Help.

[ev0lution]

Libmysqlclient 16 is no longer supported. Recompile your plugin so that it uses the latest version (18) or upgrade to a newer precompiled plugin.

[Noris]

So, I can't get libmysqlclient 16 anymore?

Someone help me?

[ev0lution]

Quote:

Originally Posted by Noris So, I can't get libmysqlclient 16 anymore?

That's correct, it's not available for Ubuntu 14.

[Noris]

Quote:

Originally Posted by ev0lution That's correct, it's not available for Ubuntu 14.

On what OS its available?

CentOS?
Debian?

What the fuck

25/05/2016 11:44:19] Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64)

Ubuntu 14.04 32bits!

[ev0lution]

You have the 64-bit version of the library and you're running a 32-bit program (and operating system).

[xPhantom]

You should really keep this issue under one thread, shouldn't spam it. As ev0 mentioned, you can't use 64bit libaries with 32 bit.

[Noris]

There is no libmysqlclient r so 16 for 32 bit

Someone give me the libmysqlclient 16 again for 64 bits?!

[ev0lution]

There is no libmysqlclient16 for Ubuntu 14.04, 32 or 64 bit. Upgrade your plugin to the latest version which uses libmysqlclient18, which is available for Ubuntu.

[Noris]

Quote:

Originally Posted by ev0lution There is no libmysqlclient16 for Ubuntu 14.04, 32 or 64 bit. Upgrade your plugin to the latest version which uses libmysqlclient18, which is available for Ubuntu.

What OS its available then?

Debian, centos? or what!

[ev0lution]

Quote:

Originally Posted by Noris What OS its available then? Debian, centos? or what!

No, sorry, I didn't mean to imply that it's available for another OS. The library has been updated. Every new OS's package management system will carry the latest version.

In the same way that Windows 1 is useless and not stocked by retail stores anymore - nothing is built for Windows 1, and nothing is built for libmysqlclient16. Except your MySQL plugin, which is now something like three years old. You need to upgrade.