Issue with tmysql (libmysqlclient.so.16: cannot open shared object file: No such file or directory)

Garry's Mod help & support
#1

I’ve had this issue for a while now with tmysql. My server has CentOS 6. Here is the error I get.

error loading module ‘tmysql’ from file ‘/home/gmod/srcds/orangebox/garrysmod/lua/includes/modules/gm_tmysql_linux.dll’:
libmysqlclient.so.16: cannot open shared object file: No such file or directory

I’ve been googling this error for a day now but can not simply find a solution into it. I have found few useful posts
http://www.facepunch.com/threads/1059858-Help-gm_tmysql-error?p=30299965&viewfull=1#post30299965
http://www.facepunch.com/threads/1059858?p=28133860&viewfull=1#post28133860

I’ve tried them both. I downloaded the libmysqlclient.a and made a symlink to it with name libmysqlclient.so.16, no changes.
I downloaded the files AzuiSleet gave, took them to my /usr/lib64 folder and ran LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib ; export LD_LIBRARY_PATH, this did not help either.

I have the gm_tmysql_linux.dll and libmysql.dll downloaded from here. http://gmodmodules.googlecode.com/svn/trunk/gm_tmysql3_boost/

Any help on what should I do?

#2

You need the boost libraries and the libmysqlclient16 libraries. You also haven’t mentioned whether you’re using 32 or 64-bit.

#3

I downloaded the boost libraries as told here.
http://www.facepunch.com/threads/1059858-Help-gm_tmysql-error?p=30299965&viewfull=1#post30299965

I have libmysqlclient.so.16 and libmysqlclient.a in my /usr/lib64/mysql, though.

I am using 64-bit system.

#4

I’m not sure if this only works for debian or ubuntu servers, but you could try this.


wget -c http://security.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.1/libmysqlclient16_5.1.41-3ubuntu12.7_i386.deb
mkdir mysql32
dpkg --extract libmysqlclient*deb mysql32
sudo mv mysql32/usr/lib/* /usr/lib32/
#5

CentOS doesn’t seem to be using the dpkg, so that is not helping.

#6

From what I’ve seen CentOS seems to be fairly incompatible with GMod’s portion of SRCDS. Did you put the two binaries in the same folder as srcds_run

#7

Okay, they were not in the same folder with srcds_run, I moved them there and now the error is this.

error loading module ‘tmysql’ from file ‘/home/gmod/srcds/orangebox/garrysmod/lua/includes/modules/gm_tmysql_linux.dll’:
libmysqlclient.so.16: wrong ELF class: ELFCLASS64

#8

are you on a 64 bit system or something?

#9

CentOS 6 64bit, yes.

#10

You can try this, http://dl.dropbox.com/u/5648925/tmp/libmysqlclient.so.zip

Not sure if it will work, and I can’t remember how I fixed this on my box, sorry :frowning:

#11

Thank you for all the help so far.

Even after downloading that and extracting it to the same folder with srcds_run, I get just slightly different error.

error loading module ‘tmysql’ from file ‘/home/gmod/srcds/orangebox/garrysmod/lua/includes/modules/gm_tmysql_linux.dll’:
./libmysqlclient.so.16: invalid ELF header

#12

Sorry for the delay, but I took these from my server, give them a shot (it’s also 64 bit) - http://dl.dropbox.com/u/5648925/tmp/from_my_server.zip

#13

All the errors are gone, at least. The gamemode just doesn’t seem to be connecting to the MySQL, but I believe that’s related to the gamemode itself.

Thank you for these.

#14

Sure thing, glad it’s working :smiley:

#15

I have mostly the same problems, I got to the point where it was saying ./libmysqlclient.so.16: invalid ELF header, then I tried your http://dl.dropbox.com/u/5648925/tmp/from_my_server.zip link, and now it loads up to the point where it tries to connect to a database, and then prints “Error connecting to DB:” and stops the srcds and restarts it, and will never connect

#16

From what I have read and heard, CentOS is highly incompatible with srcds as a whole. You get much better results with debian based Linux Distros like Ubuntu or just regular Debian.

#17

I seem to be having the same problem.

OS: ubuntu-11.10 64bit

Can anyone help me?

#18

what is the “same problem”

#19

Seems to be fixed now. Weird. I’ll let you know if I run into any more problems.