SA-MP Forums Archive
[Plugin] [REL] MySQL Plugin (Now on github!) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)



Re: [REL] MySQL Plugin R6-2 - 17/07/11 - мιη∂ѓяєαк - 29.07.2011

Quote:
Originally Posted by Friskius
Посмотреть сообщение
[13:35:25] Loading plugin: mysql.so
[13:35:25] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

How to fix? : ))
Do you have the libmysql.dll in the server folder ? [ The one with the samp-server.exe]


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Friskius - 29.07.2011

I use VPS with Debian 5 OS and in my folder is libmysqlclient.so.15


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - t33th4n - 29.07.2011

I got a problem

Status:
Windows XP x64 SP2
VC 2008 x64 installed - Foo - VC 2008 x86 redist needed.
.NET 2.0 x64 installed
v0.3c R2

1, Copied mysql.dll to /plugins folder
mysql.dll info (MD5 hash: 89605FD430CD62DFCD9252163394C43F)
2, Copied libmySQL.dll on side of server.cfg
libmySQL.dll info (MD5 hash: 087B044FC819A7BD819E80275217CD3A)
3, server.cfg modified with "plugins mysql" line

Result:
Код:
Server Plugins
--------------
 Loading plugin: mysql
  Failed.
 Loaded 0 plugins.
What did i do wrong? - Solved

Ps.: Would be good if plugin developer would sign the HASH codes with own name, and sign file with hash code CALL ME PARANOID!


AW: [REL] MySQL Plugin R6-2 - 17/07/11 - Dandimite - 30.07.2011

Loading plugin: mysql.so
Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

Server is Debian 5 Squeeze 64 Bit.

I have the libmysqlclient_r.so.16 in /usr/lib . But when i copy it to /usr/lib32 I get:

Loading plugin: mysql.so
Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64)

Any idea?


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - scott1 - 31.07.2011

I go an problem, i got this

Failed (libmysqlclient_r.so.16: cannot open shared object file: No such

but i don't see where download .16 i have only the .15


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Patrik356b - 31.07.2011

R6-2 doesn't work for me - it crashes randomly on some queries while others returns null

Switched back to R5 because of that


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - VIRUXE - 31.07.2011

Quote:
Originally Posted by scott1
Посмотреть сообщение
I go an problem, i got this

Failed (libmysqlclient_r.so.16: cannot open shared object file: No such

but i don't see where download .16 i have only the .15
I'm having the same problem!


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Whitetiger - 31.07.2011

Quote:
Originally Posted by Patrik356b
Посмотреть сообщение
R6-2 doesn't work for me - it crashes randomly on some queries while others returns null

Switched back to R5 because of that
This.


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - [NoV]LaZ - 31.07.2011

Quote:
Originally Posted by Patrik356b
Посмотреть сообщение
R6-2 doesn't work for me - it crashes randomly on some queries while others returns null

Switched back to R5 because of that
You might want to check your logs if you have then enabled.


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Friskius - 31.07.2011

Quote:
Originally Posted by scott1
Посмотреть сообщение
I go an problem, i got this

Failed (libmysqlclient_r.so.16: cannot open shared object file: No such

but i don't see where download .16 i have only the .15
Someone can say how to fix this ?


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Tudor23 - 31.07.2011

Same problem as scott1, Fiskius, etc.. -.-'


Re : Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Hip-hop - 01.08.2011

Quote:
Originally Posted by scott1
Посмотреть сообщение
I go an problem, i got this

Failed (libmysqlclient_r.so.16: cannot open shared object file: No such

but i don't see where download .16 i have only the .15
same problem


- MyLife - 01.08.2011

Nothing...

Fixed it with myself ^_^


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - nemesis- - 02.08.2011

The same has happened to me since the R4 days. No plugin crashes though mysql_affected_rows() returns null when there should be something. I can run one command, get null, then 3 seconds later run it again and get the value I was originally expecting.. though due to the randomness I haven't been able to get logged proof of it.


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - MA_proking - 02.08.2011

Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3c R4, ©2005-2011 SA-MP Team

[12:52:32] filterscripts = ""  (string)
[12:52:32] 
[12:52:32] Server Plugins
[12:52:32] --------------
[12:52:32]  Loading plugin: sscanf.so
[12:52:32] 

[12:52:32]  ===============================

[12:52:32]       sscanf plugin loaded.     

[12:52:32]    © 2009 Alex "Y_Less" Cole

[12:52:32]  ===============================

[12:52:32]   Loaded.
[12:52:32]  Loading plugin: irc.so
[12:52:32] 

*** IRC Plugin v1.4.2 by Incognito loaded ***

[12:52:32]   Loaded.
[12:52:32]  Loading plugin: mysql.so
[12:52:32]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[12:52:32]  Loaded 2 plugins.
keep showing this how to remove this


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Ork3n - 02.08.2011

Quote:
Originally Posted by MA_proking
Посмотреть сообщение
Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3c R4, ©2005-2011 SA-MP Team

[12:52:32] filterscripts = ""  (string)
[12:52:32] 
[12:52:32] Server Plugins
[12:52:32] --------------
[12:52:32]  Loading plugin: sscanf.so
[12:52:32] 

[12:52:32]  ===============================

[12:52:32]       sscanf plugin loaded.     

[12:52:32]    © 2009 Alex "Y_Less" Cole

[12:52:32]  ===============================

[12:52:32]   Loaded.
[12:52:32]  Loading plugin: irc.so
[12:52:32] 

*** IRC Plugin v1.4.2 by Incognito loaded ***

[12:52:32]   Loaded.
[12:52:32]  Loading plugin: mysql.so
[12:52:32]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[12:52:32]  Loaded 2 plugins.
keep showing this how to remove this
I have the same problem, I also lack the libmysqlclient_r.so.16, I have the libmysqlclient_r.so.15


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - t33th4n - 03.08.2011

Damn OMG, download one of these:
http://www.mysql.com/downloads/connector/c/#downloads
Get the files and links from Lib directory.

(And i'm not a linux pro)


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - xxmitsu - 03.08.2011

To all of you who get the "libmysqlclient_r.so: cannot open shared object file: No such file or directory)" error:

Have you tried using the static build for the specific distro that you're using (debian, centos, etc)?


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Ork3n - 03.08.2011

Hello, I have seen many and I would have my problem if anyone can help and also would help those who also have MySQL porblema

libmysqlclient_r.so.16
I'm using the plguins of strickenkid and the OS is CentOS 5.3


Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Donya - 03.08.2011

I have a small problem, sometimes when users attempt to login through a threaded query it just stops the server

pawn Код:
new lEscape[2][MAX_PLAYER_NAME],string[128];
        mysql_real_escape_string(Playername(playerid), lEscape[0]);
        mysql_real_escape_string(inputtext, lEscape[1]);
        format(string, 128, "SELECT * FROM `Accounts` WHERE `Username` = '%s' AND `Password` = '%s' LIMIT 0,1", lEscape[0], lEscape[1]);
        mysql_query_callback(playerid, string, "OnUserLogin");
log..
Код:
[16:02:06] >> mysql_real_escape_string( Connection handle: 1 )
[16:02:06] CMySQLHandler::EscapeString(vhhbjkl7); - Escaped 8 characters to vhhbjkl7.
[16:02:06] >> mysql_real_escape_string( Connection handle: 1 )
[16:02:06] CMySQLHandler::EscapeString(dfsdfdsfsdfsdfsdfsdfsdfsdfsf); - Escaped 28 characters to dfsdfdsfsdfsdfsdfsdfsdfsdfsf.
[16:02:06] >> mysql_query_callback( Connection handle: 1 )
[16:02:06] CMySQLHandler::Query("OnUserLogin") - Custom callback query with index 102 started (ExtraID: -1)
it just ends right there ^^