Problems - 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: Problems (/showthread.php?tid=390574)
+- 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: Problems (/showthread.php?tid=390574)
Problems - CrazyChoco - 06.11.2012
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
Re: Problems - Jikesh - 07.11.2012
Make sure you install mysql on your VPS.
Using something like:
yum install mysql - for Centos.
Can you show us the error?
Re: Problems - CrazyChoco - 07.11.2012
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
Re: Problems - Mark™ - 07.11.2012
Post your server_log here.
Re: Problems - mSlat3r - 07.11.2012
Did you setup your MYSQL database?
Re: Problems - CrazyChoco - 07.11.2012
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 |
Re: Problems - CrossUSAAF - 07.11.2012
Make sure your MySQL details are correctly. Have you tried to re-compile your game mode with latest includes and are you using plugins?
Re: Problems - CrazyChoco - 07.11.2012
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?
Re: Problems - CrossUSAAF - 07.11.2012
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) |
yum install gcc
yum install gpp
yum install mysql
Thank you.
Re: Problems - CrazyChoco - 07.11.2012
Wait, shall i do this through mysql or?