[SOLVED] new centos box centos 6

brianm · Post by **brianm** » 2012/03/26 18:42:36

Hi,

Well the time came to get a new Centos box running....the old one had Centos 4.8 and out of date mysql and php.

So far so good.....until the last application was being migrated.

This app is a C program that uses mysql via mysqlclient.

I get the following error when I try to run it.

./message: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory

doing an rpm check I see no mysqlclient---even tho the system admin interface says it is enabled and running.

[root@localhost parse]# rpm -ql mysql
/usr/bin/msql2mysql
/usr/bin/my_print_defaults
/usr/bin/mysql
/usr/bin/mysql_config
/usr/bin/mysql_find_rows
/usr/bin/mysql_waitpid
/usr/bin/mysqlaccess
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqlimport
/usr/bin/mysqlshow
/usr/bin/mysqlslap
/usr/lib/mysql/mysql_config
/usr/lib/mysql/mysqlbug
/usr/share/doc/mysql-5.1.61
/usr/share/doc/mysql-5.1.61/COPYING
/usr/share/doc/mysql-5.1.61/README
/usr/share/doc/mysql-5.1.61/README.mysql-docs
/usr/share/doc/mysql-5.1.61/README.mysql-license
/usr/share/man/man1/my_print_defaults.1.gz
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_config.1.gz
/usr/share/man/man1/mysql_find_rows.1.gz
/usr/share/man/man1/mysql_waitpid.1.gz
/usr/share/man/man1/mysqlaccess.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysqlslap.1.gz

How do I get it working? Need more information let me know.

Thanks

pschaff · Post by **pschaff** » 2012/03/26 21:33:38

CentOS-6 has libmysqlclient.so.16 from mysql-libs. The program needs to be recompiled on CentOS-6 to use the proper shared libraries.

YBellefeuille · Post by **YBellefeuille** » 2012/03/26 21:36:55

Please see Installing Software.

[code][root@localhost ~]# yum provides libmysqlclient\*
Loaded plugins: downloadonly, fastestmirror, presto, priorities, refresh-
: packagekit, verify
Loading mirror speeds from cached hostfile
* base: mirror.science.uottawa.ca
* centosplus: mirror.science.uottawa.ca
* extras: mirror.science.uottawa.ca
* fasttrack: mirror.science.uottawa.ca
* updates: mirror.science.uottawa.ca
2133 packages excluded due to repository priority protections
mysql-libs-5.1.52-1.el6_0.1.x86_64 : The shared libraries required for MySQL
: clients
Repo : base
Matched from:
Other : libmysqlclient.so.16(libmysqlclient_16)(64bit)
Other : libmysqlclient_r.so.16()(64bit)
Other : libmysqlclient_r.so.16(libmysqlclient_16)(64bit)
Other : libmysqlclient.so.16()(64bit)[/code]

This isn't the specific version you asked about; I assume [b]yum update[/b] will fix that.

Edit: I see that [b]pschaff[/b] answered just before I did, but I'll leave my post since it explains how to use [b]yum provides[/b].

brianm · Post by **brianm** » 2012/03/30 01:45:59

thanks guys.

I do recall NOW having to compile this beast the first time many years ago.

when I do the

./configure --with-mysql it tells me that it cannot find the compiler in the $path.

how can I fix this?

I see there is one on board.

Thanks again

pschaff · Post by **pschaff** » 2012/03/30 01:58:57

Not sure without the exact error message, but if a compiler is missing then[code]yum groupinstall "Development tools"[/code]is worth a shot.

brianm · Post by **brianm** » 2012/04/06 17:58:17

Thanks again.

I installed the c compiler and things then went fine.

yum install gcc

pschaff · Post by **pschaff** » 2012/04/06 18:08:10

You are welcome. Thanks for reporting back. Marking this thread [SOLVED] for posterity.

CentOS