Upgrade to MySQL 5.5.x and problem with perl-DBD-mysql perl-DBI

[ditto]

Previous I have installed perl-DBD-mysql and perl-DBI using yum command like this:

yum install perl-DBD-mysql perl-DBI

The above per modules is required for running MovableType (http://www.movabletype.org/documentation/installation/setting-up-your-database.html) sites on server.

Today I upgraded MySQL from 5.1.61 to 5.5.21, after that MovableType sites does not work anymore and give this error on login page:

install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted. Compilation failed in require

So in order to try to fix it, I removed perl-DBD-mysql and perl-DBI so that I could reinstall it:

yum remove perl-DBD-mysql perl-DBI

Then I try to reinstall it using yum, but get these errorrs:

[root@server ~]# yum install perl-DBD-mysql perl-DBI
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror01.th.ifl.net
 * extras: mirror01.th.ifl.net
 * updates: mirror01.th.ifl.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution
[B]Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (base)
           Requires: libmysqlclient.so.16()(64bit)
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (base)
           Requires: libmysqlclient.so.16(libmysqlclient_16)(64bit)[/B]
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

So it seems that I get the error after upgrade to MySQL 5.5.x:

Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (base)
           Requires: libmysqlclient.so.16()(64bit)
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (base)
           Requires: libmysqlclient.so.16(libmysqlclient_16)(64bit)

Anybody know how to fix this? Is Custombuild version of MySQL 5.5.21 not compatible with perl-DBD-mysql and perl-DBI?

 

[ditto]

I fixed it by installing cpan [1]. However I am still afraid that the upgrade to mysql 5.5.x is still not correct because of above error related to "libmysqlclient.so.16".

1:

yum install cpan
cpan DBI
cpan DBD::mysql

 

[sych]

Even after 3 years this is the same way to fix this error.
Thanks.

In my case, I was getting the following error:

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t ........................... ok
t/05dbcreate.t ....................... Bailout called. Further testing stopped: ERROR: Access denied for user 'root'@'localhost' (using password: NO)
FAILED--Further testing stopped: ERROR: Access denied for user 'root'@'localhost' (using password: NO)
make: *** [test_dynamic] Error 255
CAPTTOFU/DBD-mysql-4.029.tar.gz
/usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports CAPTTOFU/DBD-mysql-4.029.tar.gz
Warning (usually harmless): 'YAML' not installed, will not store persistent state
Running make install
make test had returned bad status, won't install without force

This is not actually an error, but the warning that a test has failed. To force install without testing:

# cpan -fi DBD::mysql