missing old MySql dependencies yum install (on MySql 5.5)

[Merv]

Hi, I got a CentOS 5.8 64bit with PHP5.4 MySql5.5, installed and maintained via DirectAdmin control panel scripts
(Linux 2.6.18-308.16.1.el5 #1 SMP Tue Oct 2 22:01:43 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux)

And I was trying to install ossec, but it needed an older libmysqlclient.so.15

I have these though:

Code: Select all

/usr/lib/mysql/libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.18

The errors I received:

Code: Select all

# yum install ossec-hids ossec-hids-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www7.atomicorp.com
 * base: centos.mirror.transip.nl
 * extras: centos.mirror.transip.nl
 * rpmforge: mirror.nl.leaseweb.net
 * updates: centos.mirror.transip.nl
Excluding Packages in global exclude list
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package ossec-hids.x86_64 0:2.6-16.el5.art set to be updated
--> Processing Dependency: inotify-tools for package: ossec-hids
---> Package ossec-hids-server.x86_64 0:2.6-16.el5.art set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: ossec-hids-server
--> Processing Dependency: perl-DBD-SQLite for package: ossec-hids-server
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: ossec-hids-server
--> Running transaction check
---> Package inotify-tools.x86_64 0:3.13-1.el5.rf set to be updated
---> Package ossec-hids-server.x86_64 0:2.6-16.el5.art set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: ossec-hids-server
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: ossec-hids-server
---> Package perl-DBD-SQLite.x86_64 0:1.14-7.el5.art set to be updated
--> Finished Dependency Resolution[color=#FF0000]
ossec-hids-server-2.6-16.el5.art.x86_64 from atomic has depsolving problems
  --> Missing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by package ossec-hids-server-2.6-16.el5.art.x86_64 (atomic)
ossec-hids-server-2.6-16.el5.art.x86_64 from atomic has depsolving problems
  --> Missing Dependency: libmysqlclient.so.15()(64bit) is needed by package ossec-hids-server-2.6-16.el5.art.x86_64 (atomic)
Error: Missing Dependency: libmysqlclient.so.15()(64bit) is needed by package ossec-hids-server-2.6-16.el5.art.x86_64 (atomic)
Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by package ossec-hids-server-2.6-16.el5.art.x86_64 (atomic)[/color]
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

I have seen a few related threads on this forum, but they were so old, that I figured I would start a new one, with PHP 5.4 and MySql 5.5.


Does ossec support newer MySql clients ?
And what can I do, while keeping the PHP and MySql running and installed via install/update scripts provided and recommended by the control panel, ?

[scott]

You need the 5.0 client library. The package is called mysqlclient15

[Merv]

I added an .so.15 file:

Code: Select all

# wget... from directadmin file server
# chmod 755 /usr/lib64/libmysqlclient.so.15
# ldconfig

These 3 commands were advised by directadmin in the past, when their pannel didn't support newer MySql.

I now have these libraries:

# ls -l /usr/lib64/*mysql*
/usr/lib64/libmysqlclient_r.so -> libmysqlclient.so
/usr/lib64/libmysqlclient_r.so.18 -> libmysqlclient.so
/usr/lib64/libmysqlclient_r.so.18.0.0 -> libmysqlclient.so
/usr/lib64/libmysqlclient.so -> libmysqlclient.so.18
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
/usr/lib64/libmysqlclient.so.18.0.0

And #yum install ossec-hids ossec-hids-server still shows the same error about the missing dependency.

Is it in the wrong directory ?
Does it need a 32bit version ?
Does it need a few symbolic links to point towards the /usr/lib64/libmysqlclient.so.15 file ?


Thanks

[mikeshinn]

You need to install that package, not the shared object.

[breun]

Just run this:

Code: Select all

# yum install mysqlclient15

RPM package dependencies can only be satisfied by stuff provided by other RPM packages.

[Merv]

Just run this:

Code: Select all

# yum install mysqlclient15

RPM package dependencies can only be satisfied by stuff provided by other RPM packages.

Thanks for the command.

What does it do exactly ?
Will it change existing configuration files ?

PS, what is the ETA on supporting the latest MySql ?
(5.0 is from 2003 you know )

[breun]

Just run this:

Code: Select all

# yum install mysqlclient15

RPM package dependencies can only be satisfied by stuff provided by other RPM packages.

Thanks for the command.

What does it do exactly ?

It installs the mysqlclient15 package from the Atomic repository (unless you've configured another yum repository that carries a package called mysqlclient15 and carries a newer version, but that's unlikely). It installs the libmysqlclient.so.15 and libmysqlclient_r.so.15 library files, with some docs and a config file for ldconfig.

Will it change existing configuration files ?

No.

PS, what is the ETA on supporting the latest MySql ?

The Atomic repository is currently distributing MySQL 5.5.

(5.0 is from 2003 you know )

Well yeah, CentOS 5 was also released a couple of years ago and enterprise Linux distributions tend to stick with versions and mostly backport security fixes. See Red Hat's Backporting Security Fixes for more info on this.

If you want the latest version of something, you'll have to go with a different type of Linux distribution (which usually has a way shorter support cycle), use third party repositories that carry the versions you require or package them yourself.

I prefer using supported, stable software over bleeding edge versions with all the latest and greatest bugs.

[scott]

Just to add to breuns great info, for those not aware CentOS is a copy of Red Hat Enterprise Linux. The only difference is that centos removes all the redhat trademarks, and re-packages their software. The support policies (consistent api's, backporting, eol dates, etc) are the same as Redhats.

[Highland]

I plug it every chance I get...

remove php-mysql and install php-mysqlnd and you never have to fool with mysqlclientXX again

[breun]

That's only for PHP code using MySQL though, so not really relevant in this case, because it's OSSEC that needs mysqlclient15 as it is compiled against CentOS 5's default MySQL client library.

(And php-mysqlnd doesn't support the old-style MySQL passwords which might be still in use on a server, so you might actually break some things when upgrading to php-mysqlnd and not testing thoroughly.)

[Merv]

Thanks breun for your answer on the so.15 package.
I feel more at ease trying to yum install that package.

One thing that gets me confused though, is that you mentioned ossec comes with MySql 5.5.
Am I trying to install an older version of ossec, due to having a CentOS 5.x OS ?
Or did I completely miss the message

[breun]

One thing that gets me confused though, is that you mentioned ossec comes with MySql 5.5.
Am I trying to install an older version of ossec, due to having a CentOS 5.x OS ?
Or did I completely miss the message

OSSEC doesn't really come with its own version of MySQL. The Atomic yum repository has MySQL 5.5 packages, but you're free to decide for yourself if you keep using the CentOS 5 MySQL 5.0.x packages or if you upgrade to the Atomic MySQL 5.5.x packages. OSSEC will work with either version of MySQL, but indeed needs the separate libmysqlclient15 package with the MySQL 5.0.x client library if you're running MySQL 5.5.x as OSSEC is compiled against MySQL 5.0.x on CentOS 5.

[Merv]

OSSEC doesn't really come with its own version of MySQL. The Atomic yum repository has MySQL 5.5 packages, but you're free to decide for yourself if you keep using the CentOS 5 MySQL 5.0.x packages or if you upgrade to the Atomic MySQL 5.5.x packages. OSSEC will work with either version of MySQL, but indeed needs the separate libmysqlclient15 package with the MySQL 5.0.x client library if you're running MySQL 5.5.x as OSSEC is compiled against MySQL 5.0.x on CentOS 5.

So instead of doing the yum install, I could rpm+build ossec, making it use the current running MySql version ?

[breun]

I guess you could, but I don't see the point of taking the hard route and doing custom builds for every update yourself.