Perl CPAN DBD::mysql error “FAILED–Further testing stopped” after upgrading Watch MySQL (XSLoader.pm, libmysqlclient.so)

cPanel/WHM WatchMySQL Plugin

I recently ran into an issue with Perl connecting to MySQL after upgrading a plugin for cPanel/WHM called Watch MySQL. After going through the logs files I determined the error was with a missing dependency file XSLoader.pm and libmysqlclient.so. The problem actually ended up being that those files were not installed because the Perl CPAN upgrade for DBD::mysql failed. After some research it was actually very easy to fix …

The specific errors I was receiving were similar to the errors below.  Specifically this was the error in the logs from Watch MySQL:

So that error above told me there was a problem with the DBD::mysql module.  So the next step was to attempt and manually upgrade/install the Perl CPAN DBD::mysql module.  Logged in a root shell you would need to execute these commands below:

First log into a CPAN shell:

Next attempt to install DBD::mysql:

That command above will attempt to install the DBD::mysql module.  Chances are it will throw and error and not complete.  This is the specific error I was seeing below:

 

So what that’s telling me is that the installer attempted to do testing by connecting to MySQL but was unable to, and thus ended in an error and exited the install process.

Now you have two options here, you can try and figure out why the install process was unable to connect to MySQL to do testing, and chances are it has something to do with this line from the installer log:

As you can see the installer clearly shows and specifies the requirements for running  make test which is actually being called during the installation process.  So you could build from source and specify all of these options, or skip the testing, run this command below to force the installation:

First, exit from CPAN shell:

Next type in this command to force install DBD::mysql:

 

Using the above command to force the installation bypassed the testing and installed all modules and libs required.  After that I had no problem using Watch MySQL or anything else connecting to MySQL using perl.

Profit!

Myles

Orlando, FL

Did this post help you?

Give back and rate it for me!

Related Posts