[Plugin] [REL] MySQL Plugin (Now on github!)

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
Reply

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)

Host are at ServerFFS,
anyone know how I can fix this and where I should put the libmysqlclient.so.15 under?
Reply

Put in your server directory

Btw, my server is crashing on using mysql_fetch_field_row. It's just used as normal.
Reply

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

Anyone please?
Reply

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
Reply

I'm getting the following error:
Код:
Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so))
Help please? It's really urgent!

EDIT: Problem fixed, turns out I needed to re-download the plugin (version was probably outdated).
Reply

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
Reply

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?
Reply

Small question:
If i use threaded query's, and on gmx, when all player data needs to be saved - will it work alright?
Reply

OnPlayerDisconnect is called all properly when the server is having a gamemode restart (gmx)!
Reply

Quote:
Originally Posted by AndreT
Посмотреть сообщение
OnPlayerDisconnect is called all properly when the server is having a gamemode restart (gmx)!
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"
Reply

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.
Reply

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
Now I can't start my server or SVN
Код:
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
In fact, I can't start a lot of stuff
Код:
apt-get
apt-get: error while loading shared libraries: libapt-pkg.so.3: cannot open shared object file: No such file or directory
What the hell happened?
Reply

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 =[[[
Reply

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"
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 ;\
Reply

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 ;\
Sorry, I didn't have time to check all pages.
pawn Код:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
    if(errorid==CR_SERVER_LOST) mysql_query(query,resultid,extraid);
}
This fixed it, I think i need to do checking if the query failed to much times, to stop it from repeating from itself..
Reply

I have it too.
Reply

Quote:
Originally Posted by wups
Посмотреть сообщение
Sorry, I didn't have time to check all pages.
pawn Код:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
    if(errorid==CR_SERVER_LOST) mysql_query(query,resultid,extraid);
}
This fixed it, I think i need to do checking if the query failed to much times, to stop it from repeating from itself..
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)
Reply

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)
Yeah, i'm having problems in a live server.
Reply

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))
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)