[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)
+- 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)
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
AW: [REL] MySQL Plugin R6-2 - 17/07/11 - Blowfish - 15.08.2011
Hey guys,
i still have problems with getting special chars / umlauts to work with this plugin.
I already tried to use mysql_set_charset, but it does not quite work.
It would be really great if someone could help me out, because this issue
is causing a lot of trouble on my server.
Thanks,
Blowfish
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - tony_fitto - 17.08.2011
Have a huge problem here, nothing like the problem you mention in the thread.
Quote:
|
Loading plugin: mysql.so [06:05:16] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory) |
anyone know how I can fix this and where I should put the libmysqlclient.so.15 under?
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Jochemd - 17.08.2011
Put in your server directory
Btw, my server is crashing on using mysql_fetch_field_row. It's just used as normal.
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Kyle - 19.08.2011
Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
Anyone please?
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Raimis_R - 19.08.2011
Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
How to fix it!!!!!
I'm trying to fix it 3h
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Sinner - 19.08.2011
I'm getting the following error:
Код:
Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so))
EDIT: Problem fixed, turns out I needed to re-download the plugin (version was probably outdated).
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Mr.GeEk - 19.08.2011
hello friends I have seen that many have the problem of Failed (libmysqlclient_r.so.16: can not open shared object file: No such file or directory)
to solve this should only copy files libmysqlclient_r.so.16 that brings xampp or appsever depends on use, must be copied to /usr/lib/ and then restart services and ready. sorry for my bad English xD
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Raimis_R - 20.08.2011
Quote:
|
Originally Posted by Mr.GeEk
 hello friends I have seen that many have the problem of Failed (libmysqlclient_r.so.16: can not open shared object file: No such file or directory)
to solve this should only copy files libmysqlclient_r.so.16 that brings xampp or appsever depends on use, must be copied to /usr/lib/ and then restart services and ready. sorry for my bad English xD |
Someone tried?
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - wups - 04.09.2011
Small question:
If i use threaded query's, and on gmx, when all player data needs to be saved - will it work alright?
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - AndreT - 04.09.2011
OnPlayerDisconnect is called all properly when the server is having a gamemode restart (gmx)!
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - wups - 04.09.2011
Quote:
|
Originally Posted by AndreT
OnPlayerDisconnect is called all properly when the server is having a gamemode restart (gmx)!
|
Anyway I keep getting errors "Error id 2013: Lost connection to MySQL server during query"
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - AndreT - 04.09.2011
It happens to me too sometimes, maybe like once an hour. But since you have the OnQueryError callback, you could easily detect if the error id is 2013 and if yes, then re-send the query if the connection has been re-established. I don't know if it is a good idea doing it directly in OnQueryError though.
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Lenny the Cup - 05.09.2011
I was trying to do this and I had to create the directory lib32 because it didn't exist. I moved the (4) files and the next thing I knew, lib32 contains all of this:
Код:
Mcrt1.o libmagic.so.1.0.0 Scrt1.o libmcheck.a X11 libmcrypt.so.4 apr-util-1 libmcrypt.so.4.4.8 apt libmemusage.so aspell-0.60 libmenu.so.5 cracklib_dict.hwm libmenu.so.5.5 cracklib_dict.pwd libmenuw.so.5 cracklib_dict.pwi libmenuw.so.5.5 crt1.o libmp.so.3 crti.o libmp.so.3.1.7 crtn.o libmysqlclient.so.15 elfutils libmysqlclient.so.15.0.0 games libmysqlclient_r.so.15 gcc libmysqlclient_r.so.15.0.0 gcc-lib libncurses.so.5 gconv libncurses.so.5.5 gcrt1.o libncursesw.so.5 gnupg libncursesw.so.5.5 hmaccalc libneon.so.25 httpd libneon.so.25.0.5 krb5 libnetsnmp.so.10 libBrokenLocale.a libnetsnmp.so.10.0.3 libBrokenLocale.so libnetsnmpagent.so.10 libX11.so.6 libnetsnmpagent.so.10.0.3 libX11.so.6.2.0 libnetsnmphelpers.so.10 libXau.so.6 libnetsnmphelpers.so.10.0.3 libXau.so.6.0.0 libnetsnmpmibs.so.10 libXdmcp.so.6 libnetsnmpmibs.so.10.0.3 libXdmcp.so.6.0.0 libnetsnmptrapd.so.10 libXpm.so.4 libnetsnmptrapd.so.10.0.3 libXpm.so.4.11.0 libnewt.so.0.52 libanl.a libnewt.so.0.52.1 libanl.so libnsl.a libapr-1.so.0 libnsl.so libapr-1.so.0.2.7 libnspr4.so libaprutil-1.so.0 libnss3.so libaprutil-1.so.0.2.7 libnss_compat.so libapt-pkg.so.3 libnss_dns.so libapt-pkg.so.3.0.0 libnss_files.so libasm-0.137.so libnss_hesiod.so libasm.so.1 libnss_nis.so libaspell.so.15 libnss_nisplus.so libaspell.so.15.1.3 libnss_winbind.so libbdevid.so.5.1.19.6 libnss_wins.so libbfd-2.17.50.0.6-14.el5.so libnssckbi.so libbind.so.4 libnssutil3.so libbind.so.4.1.2 libopcodes-2.17.50.0.6-14.el5.so libbind9.so.0 libpanel.so.5 libbind9.so.0.0.11 libpanel.so.5.5 libblkid.a libpanelw.so.5 libblkid.so libpanelw.so.5.5 libbsd-compat.a libpcprofile.so libbsd.a libpcrecpp.so.0 libbz2.so.1 libpcrecpp.so.0.0.0 libbz2.so.1.0.3 libpcreposix.so.0 libc.a libpcreposix.so.0.0.0 libc.so libpgtypes.so.2 libc_nonshared.a libpgtypes.so.2.1 libc_stubs.a libplc4.so libcidn.so libplds4.so libcom_err.a libpng.so.3 libcom_err.so libpng.so.3.10.0 libcrack.a libpng12.so.0 libcrack.so libpng12.so.0.10.0 libcrack.so.2 libpopt.a libcrack.so.2.8.0 libpopt.so libcrypt.a libpopt.so.0 libcrypt.so libpopt.so.0.0.0 libcrypto.a libpq.so.4 libcrypto.so libpq.so.4.1 libcups.so.2 libpspell.so.15 libcupsimage.so.2 libpspell.so.15.1.3 libcurl.so.3 libpthread.a libcurl.so.3.0.0 libpthread.so libdb-4.3.so libpthread_nonshared.a libdb_cxx-4.3.so libpython2.4.so libdes425.a libpython2.4.so.1.0 libdes425.so libreadline.so.5 libdes425.so.3 libreadline.so.5.1 libdes425.so.3.0 libresolv.a libdl.a libresolv.so libdl.so librpcsvc.a libdns.so.26 librpm-4.4.so libdns.so.26.0.2 librpmbuild-4.4.so libdw-0.137.so librpmdb-4.4.so libdw.so.1 librpmio-4.4.so libe2p.a librt.a libe2p.so librt.so libecpg.so.5 librtkaio.a libecpg.so.5.1 libsasl2.so.2 libecpg_compat.so.2 libsasl2.so.2.0.22 libecpg_compat.so.2.1 libselinux.a libelf-0.137.so libselinux.so libelf.so.1 libsemanage.so libext2fs.a libsensors.so.3 libext2fs.so libsensors.so.3.1.6 libfipscheck.so.1 libsepol.a libfipscheck.so.1.1.0 libsepol.so libfontconfig.so.1 libslang.so.2 libfontconfig.so.1.1.0 libslang.so.2.0.6 libform.so.5 libsmbclient.so.0 libform.so.5.5 libsmime3.so libformw.so.5 libsnmp.so.10 libformw.so.5.5 libsnmp.so.10.0.3 libfreebl3.chk libsoftokn3.chk libfreebl3.so libsoftokn3.so libfreetype.so.6 libsqlite3.so.0 libfreetype.so.6.3.10 libsqlite3.so.0.8.6 libfwparam.a libss.a libg.a libss.so libgcrypt.so.11 libssl.a libgcrypt.so.11.5.2 libssl.so libgd.so.2 libssl3.so libgd.so.2.0.0 libstdc++.so.6 libgdbm.so.2 libstdc++.so.6.0.8 libgdbm.so.2.0.0 libstunnel.so libgmp.so.3 libsvn_client-1.so.0 libgmp.so.3.3.3 libsvn_client-1.so.0.0.0 libgmpxx.so.3 libsvn_delta-1.so.0 libgmpxx.so.3.0.5 libsvn_delta-1.so.0.0.0 libgnutls-extra.so.13 libsvn_diff-1.so.0 libgnutls-extra.so.13.0.6 libsvn_diff-1.so.0.0.0 libgnutls-openssl.so.13 libsvn_fs-1.so.0 libgnutls-openssl.so.13.0.6 libsvn_fs-1.so.0.0.0 libgnutls.so.13 libsvn_fs_base-1.so.0 libgnutls.so.13.0.6 libsvn_fs_base-1.so.0.0.0 libgomp.so.1 libsvn_fs_fs-1.so.0 libgomp.so.1.0.0 libsvn_fs_fs-1.so.0.0.0 libgpg-error.so.0 libsvn_fs_util-1.so.0 libgpg-error.so.0.3.0 libsvn_fs_util-1.so.0.0.0 libgpm.so.1 libsvn_ra-1.so.0 libgpm.so.1.19.0 libsvn_ra-1.so.0.0.0 libgssapi_krb5.a libsvn_ra_dav-1.so.0 libgssapi_krb5.so libsvn_ra_dav-1.so.0.0.0 libgssapi_krb5.so.2 libsvn_ra_local-1.so.0 libgssapi_krb5.so.2.2 libsvn_ra_local-1.so.0.0.0 libgssrpc.a libsvn_ra_neon-1.so.0 libgssrpc.so libsvn_ra_neon-1.so.0.0.0 libgssrpc.so.4 libsvn_ra_svn-1.so.0 libgssrpc.so.4.0 libsvn_ra_svn-1.so.0.0.0 libhesiod.so.0 libsvn_repos-1.so.0 libhesiod.so.0.0.0 libsvn_repos-1.so.0.0.0 libhistory.so.5 libsvn_subr-1.so.0 libhistory.so.5.1 libsvn_subr-1.so.0.0.0 libidn.so.11 libsvn_swig_py-1.so.0 libidn.so.11.5.19 libsvn_swig_py-1.so.0.0.0 libieee.a libsvn_wc-1.so.0 libisc.so.15 libsvn_wc-1.so.0.0.0 libisc.so.15.0.2 libsysfs.so.2 libisccc.so.0 libsysfs.so.2.0.0 libisccc.so.0.2.3 libthread_db.so libisccfg.so.1 libtiff.so.3 libisccfg.so.1.0.10 libtiff.so.3.8.2 libiscsi.so libtiffxx.so.3 libiscsi.so.0 libtiffxx.so.3.8.2 libjpeg.so.62 libusb-0.1.so.4 libjpeg.so.62.0.0 libusb-0.1.so.4.4.4 libk5crypto.a libusbpp-0.1.so.4 libk5crypto.so libusbpp-0.1.so.4.4.4 libk5crypto.so.3 libuser libk5crypto.so.3.1 libuser.so.1 libkadm5clnt.a libuser.so.1.1.6 libkadm5clnt.so libutempter.so.0 libkadm5clnt.so.5 libutempter.so.1.1.4 libkadm5clnt.so.5.1 libutil.a libkadm5srv.a libutil.so libkadm5srv.so libuuid.a libkadm5srv.so.5 libuuid.so libkadm5srv.so.5.1 libwrap.a libkdb5.a libwrap.so libkdb5.so libxml2.so.2 libkdb5.so.4 libxml2.so.2.6.26 libkdb5.so.4.0 libz.a libkeyutils.so libz.so libkrb4.a libz.so.1 libkrb4.so libz.so.1.2.3 libkrb4.so.2 locale libkrb4.so.2.0 mail.help libkrb5.a mail.tildehelp libkrb5.so mysql libkrb5.so.3 mysql32 libkrb5.so.3.3 nss libkrb5support.a openssl libkrb5support.so perl5 libkrb5support.so.0 php libkrb5support.so.0.1 pkgconfig liblber-2.3.so.0 python2.4 liblber-2.3.so.0.2.31 rpm libldap-2.3.so.0 samba libldap-2.3.so.0.2.31 sasl libldap_r-2.3.so.0 sasl2 libldap_r-2.3.so.0.2.31 sendmail liblwres.so.9 sendmail.postfix liblwres.so.9.2.0 sendmail.sendmail libm.a sse2 libm.so tc libmagic.a tls libmagic.so yum-plugins libmagic.so.1
Код:
screen: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory svnserve: error while loading shared libraries: libsvn_repos-1.so.0: cannot open shared object file: No such file or directory
Код:
apt-get apt-get: error while loading shared libraries: libapt-pkg.so.3: cannot open shared object file: No such file or directory
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - ba200101 - 05.09.2011
I have a question ....
I use the same syntax updated 1000 document with the data but this plug-in 9 seconds with a time
In addition, when a plug-in with 0.5 seconds, there are ways to speed up the thing?
Because 9 seconds and 0.5 seconds too much difference =[[[
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Kar - 05.09.2011
Quote:
|
Originally Posted by AndreT
OnPlayerDisconnect is called all properly when the server is having a gamemode restart (gmx)!
|
Quote:
|
Originally Posted by wups
Ok, but then there will be a huge amount of threads running.
Anyway I keep getting errors "Error id 2013: Lost connection to MySQL server during query" |
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - wups - 06.09.2011
Quote:
|
Originally Posted by Kar
Look back at my previous posts, I said many times the threading is not fixed as BlueG said it was.. it still has bugs.. using normal queries fixed it.. I did tell kc about it directly on irc, he said it was a weird problem.. yet many users have the problem ;\
|
pawn Код:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
if(errorid==CR_SERVER_LOST) mysql_query(query,resultid,extraid);
}
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Lenny the Cup - 06.09.2011
I have it too.
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Kar - 06.09.2011
Quote:
|
Originally Posted by wups
Sorry, I didn't have time to check all pages.
pawn Код:
|
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - wups - 07.09.2011
Quote:
|
Originally Posted by Kar
I actually used that for my group system loading, but it would bugged after gmx and that came into play, but it bugged the queries in between the thread. if a query gets called while a thread is being processed, the query fails. that's annoying (no it doesn't always happen, but mostly)
|
Re: [REL] MySQL Plugin R6-2 - 17/07/11 - John_Cooper - 07.09.2011
This is the problem im getting Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by plugins/mysql_debian.so))