[CrazyChoco]

Hello, as i got an new VPS server i reached one problem. MySQL, it won't work. I added my GM, all plugins with .so etc and correctly but the MySQL, just make a turnoff... I tried to recompile with BlueG R7, but same occured, "Unknown". Any ideas? I can explain it even more if nessary

[Jikesh]

Make sure you install mysql on your VPS.
Using something like:
yum install mysql - for Centos.

Can you show us the error?

[CrazyChoco]

Theee isnt showing up any errors, but as i tested all other plugins each by each it ended with mysql, ill maybe reinstall it, thanks for the comment

[Mark™]

Post your server_log here.

[mSlat3r]

Did you setup your MYSQL database?

[CrazyChoco]

This is my changelog:

Quote:

---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3e, ©2005-2012 SA-MP Team [21:11:06] filterscripts = "" (string) [21:11:06] [21:11:06] Server Plugins [21:11:06] -------------- [21:11:06] Loading plugin: streamer.so [21:11:06] *** Streamer Plugin v2.5 by Incognito loaded *** [21:11:06] Loaded. [21:11:06] Loading plugin: mysql.so [21:11:06] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory) [21:11:06] Loading plugin: sscanf.so [21:11:06] [21:11:06] =============================== [21:11:06] sscanf plugin loaded. [21:11:06] © 2009 Alex "******" Cole [21:11:06] =============================== [21:11:06] Loaded. [21:11:06] Loading plugin: irc.so [21:11:06] *** IRC Plugin v1.3.6 by Incognito loaded *** [21:11:06] Loaded. [21:11:06] Loaded 3 plugins. [21:11:06] [21:11:06] Filterscripts [21:11:06] --------------- [21:11:06] Loaded 0 filterscripts. [21:11:06] Script[gamemodes/lvrcr.amx]: Run time error 19: "File or function is not found" [21:11:06] Number of vehicle models: 0

And i'm using VPS, CentOs 6

[CrossUSAAF]

Make sure your MySQL details are correctly. Have you tried to re-compile your game mode with latest includes and are you using plugins?

[CrazyChoco]

Yes, but i was more thinking on this
[21:11:06] Loading plugin: mysql.so
[21:11:06] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
Any solution there?

[CrossUSAAF]

Okay, may you try this out?

Quote:

1. We then navigated to the SAMP Servers folder then into the /plugins folder. Using the ldd command we can see that mysql.so file is missing a library and the mysql.so file does not have the correct permissions. root@308882 [/home/plaproje/.gameservers/samp_0/plugins]# ldd mysql.so ldd: warning: you do not have execution permission for `./mysql.so' libmysqlclient_r.so.15 => not found libpthread.so.0 => /lib/libpthread.so.0 (0xb7f4b000) libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7e60000) libm.so.6 => /lib/libm.so.6 (0xb7e36000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7e17000) libc.so.6 => /lib/libc.so.6 (0xb 2. We got libmysqlclient_r.so.15 and moved it to the /usr/lib folder not LIB64 as the LIB64 only supports 64 bit classes and this is a 32 bit class. 3. We then ran the process LDCONFIG via command line to create the necessary links and cache to the most recent shared libraries. 4. We needed to change the permissions for the mysql.so file in the plugins folder as well to have the execute bit set for the file. chmod +x mysql.so. 5. We then navigated to the SAMP Servers folder in the /plugins folder. Using the ldd command we can see that mysql.so file is not there and working. root@308882 [/home/plaproje/.gameservers/samp_0/plugins]# ldd mysql.so libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0xb7d69000) libpthread.so.0 => /lib/libpthread.so.0 (0xb7d4e000) libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7c63000) libm.so.6 => /lib/libm.so.6 (0xb7c39000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7c1a000) libc.so.6 => /lib/libc.so.6 (0xb7a8a000) libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7a5a000) libnsl.so.1 => /lib/libnsl.so.1 (0xb7a3f000) /lib/ld-linux.so.2 (0xb7ee7000) libfreebl3.so => /lib/libfreebl3.so (0xb79f0000) libdl.so.2 => /lib/libdl.so.2 (0xb79ea000)

Or, have you tried to install with these commands in below?

yum install gcc
yum install gpp
yum install mysql

Thank you.

[CrazyChoco]

Wait, shall i do this through mysql or?