Issue with tailwatchd failing after upgrading MySQL

[JonSimmonds]

Hi

I have done some searching for other threads, found 2 good ones (http://forums.cpanel.net/f34/tailwat...il-120141.html & tailwatchd failing) but none of the advice offered seams to have helped in my situation.

I have had these issues since I upgraded apache from 2.0 to 2.2 and mysql from 5.0.91 - 5.1.51) - upgraded using the script to upgrade mysql in the whm web interface and apache via easy apache. (Php was also upgraded from 5.3.x to 5.3.4 (forgot what subversion))

I am getting the following emails sent from cron jobs which have obviously gone wrong

Cron <root@myhost> /usr/bin/test -x /usr/local/cpanel/bin/tail-check && /usr/local/cpanel/bin/tail-check

Notification => myemail@email.com via EMAIL [level => 1]
Notification => mypager@email.com via PAGER [level => 1]



tailwatchd on myhost.domain.com failed

tailwatchd failed @ Tue Jan 11 17:35:01 2011. A restart was attempted automagically.
Service Check Method: [check command] tailwatchd is not running



Cron <root@myhost> /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache

Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
Compilation failed in require at /scripts/update_db_cache line 23.
BEGIN failed--compilation aborted at /scripts/update_db_cache line 23.

Have forced a upcp to no joy, any suggestions?

[cPanelDon]

Hi

I have done some searching for other threads, found 2 good ones (http://forums.cpanel.net/f34/tailwat...il-120141.html & tailwatchd failing) but none of the advice offered seams to have helped in my situation.

I have had these issues since I upgraded apache from 2.0 to 2.2 and mysql from 5.0.91 - 5.1.51) - upgraded using the script to upgrade mysql in the whm web interface and apache via easy apache. (Php was also upgraded from 5.3.x to 5.3.4 (forgot what subversion))

I am getting the following emails sent from cron jobs which have obviously gone wrong

Cron <root@myhost> /usr/bin/test -x /usr/local/cpanel/bin/tail-check && /usr/local/cpanel/bin/tail-check

Notification => myemail@email.com via EMAIL [level => 1]
Notification => mypager@email.com via PAGER [level => 1]



tailwatchd on myhost.domain.com failed

tailwatchd failed @ Tue Jan 11 17:35:01 2011. A restart was attempted automagically.
Service Check Method: [check command] tailwatchd is not running



Cron <root@myhost> /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache

Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
Compilation failed in require at /scripts/update_db_cache line 23.
BEGIN failed--compilation aborted at /scripts/update_db_cache line 23.

Have forced a upcp to no joy, any suggestions?

What is your version of cPanel&WHM?

To confirm, was a forced MySQL update ("mysqlup") also performed, (per my earlier reply in one of the related forum threads)?

If you still see any errors mentioning MySQL or DBD::mysql please try running the following:

# /scripts/mysqlup --force --verbose
# /scripts/restartsrv_tailwatchd

To gather more information, please let us know the output from the following commands:

# stat /usr/lib64/libmysqlclient.so* /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so
# rpm -qa --qf "%{name}-%{version}-%{release}.%{arch}\n" | grep -i mysql | sort

Please try the following command to ensure the "DBD::mysql" Perl module is installed:

# /scripts/perlinstaller DBD::mysql

If the above command does not help, please try it with the force option:

# /scripts/perlinstaller --force DBD::mysql

To test for successful resolution, please run the following command to see if any errors are reported:

# /scripts/update_db_cache

[JonSimmonds]

Hi

WHM version is 11.28.64

in response to your questions

root@myhost [/home/myuser]# /scripts/mysqlup --force --verbose
Updates for âmysqlâMYSQLUPâneverâ

root@myhost [/home/myuser]]# /scripts/restartsrv_tailwatchd
root@myhost [/home/myuser]]#

Not sure why the â's are there in the response from mysqlup (for some reason putty has "is set to â€" as its title in windows) , no error messages from the restartsrv_tailwatchd

root@myhost [/home/myuser]# stat /usr/lib64/libmysqlclient.so* /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so
  File: `/usr/lib64/libmysqlclient.so' -> `libmysqlclient.so.16.0.0'
  Size: 24              Blocks: 0          IO Block: 4096   symbolic link
Device: 801h/2049d      Inode: 278588      Links: 1
Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-10 23:21:05.000000000 +0000
Modify: 2011-01-09 12:42:57.000000000 +0000
Change: 2011-01-09 12:42:57.000000000 +0000
  File: `/usr/lib64/libmysqlclient.so.15' -> `libmysqlclient.so.16'
  Size: 20              Blocks: 0          IO Block: 4096   symbolic link
Device: 801h/2049d      Inode: 278723      Links: 1
Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2011-01-09 12:44:16.000000000 +0000
Change: 2011-01-09 12:44:16.000000000 +0000
  File: `/usr/lib64/libmysqlclient.so.16' -> `libmysqlclient.so.16.0.0'
  Size: 24              Blocks: 0          IO Block: 4096   symbolic link
Device: 801h/2049d      Inode: 278559      Links: 1
Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2011-01-09 12:42:57.000000000 +0000
Change: 2011-01-09 12:42:57.000000000 +0000
  File: `/usr/lib64/libmysqlclient.so.16.0.0'
  Size: 5391845         Blocks: 10560      IO Block: 4096   regular file
Device: 801h/2049d      Inode: 1540135     Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2010-09-28 21:11:22.000000000 +0100
Change: 2011-01-10 04:03:46.000000000 +0000
  File: `/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so'
  Size: 234338          Blocks: 472        IO Block: 4096   regular file
Device: 801h/2049d      Inode: 69877       Links: 1
Access: (0555/-r-xr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2011-01-05 22:17:18.000000000 +0000
Change: 2011-01-05 22:17:18.000000000 +0000
root@myhost [/home/myuser]#

root@myhost [/home/myuser]# rpm -qa --qf "%{name}-%{version}-%{release}.%{arch}\n" | grep -i mysql | sort
MySQL-bench-5.0.91-0.glibc23.x86_64
MySQL-client-5.1.51-0.glibc23.x86_64
MySQL-devel-5.1.51-0.glibc23.x86_64
MySQL-server-5.1.51-0.glibc23.x86_64
MySQL-shared-5.1.51-0.glibc23.x86_64
MySQL-test-5.1.51-0.glibc23.x86_64
root@myhost [/home/myuser]#

IO::Uncompress::Gunzip is up to date (2.033).
Compress::Zlib is up to date (2.033).
IO::Zlib is up to date (1.10).
Archive::Tar is up to date (1.76).
Archive::Zip is up to date (1.30).
Net::Cmd is up to date (2.29).
Net::FTP is up to date (2.77).
Term::ReadKey is up to date (2.30).
Term::ReadLine::Perl is up to date (1.0303).
YAML is up to date (0.72).
Parse::CPAN::Meta is up to date (1.40).
Text::Glob is up to date (0.08).
CPAN is up to date (1.9402).
File::Which is up to date (1.09).
DBD::mysql is up to date (4.018).
perlmod--Install done
root@myhost [/home/myuser]#

the perl installer produced alot of output, I assume the output above is sufficent to show what version of DBD::mysql there is

root@myhost [/home/myuser]# /scripts/update_db_cache
Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
 at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
Compilation failed in require at /scripts/update_db_cache line 23.
BEGIN failed--compilation aborted at /scripts/update_db_cache line 23.
root@myhost [/home/myuser]#

Thanks for taking the time to help, hope we can get this fixed!

[cPanelDon]

Hi

WHM version is 11.28.64

in response to your questions

root@myhost [/home/myuser]# /scripts/mysqlup --force --verbose
Updates for âmysqlâMYSQLUPâneverâ

root@myhost [/home/myuser]]# /scripts/restartsrv_tailwatchd
root@myhost [/home/myuser]]#

Not sure why the â's are there in the response from mysqlup (for some reason putty has "is set to â€" as its title in windows) , no error messages from the restartsrv_tailwatchd

The message from mysqlup appears to be caused by the MySQL update preference being set to "never" in /etc/cpupdate.conf as configured via WebHost Manager: WHM: Main >> Server Configuration >> Update Preferences (Update Config)

If the preference is changed to "inherit" that should allow mysqlup to proceed further; here is an example of what the updated entry would look like in /etc/cpupdate.conf:

# grep "^MYSQLUP=" /etc/cpupdate.conf
MYSQLUP=inherit

root@myhost [/home/myuser]# stat /usr/lib64/libmysqlclient.so* /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so
  File: `/usr/lib64/libmysqlclient.so' -> `libmysqlclient.so.16.0.0'
  Size: 24              Blocks: 0          IO Block: 4096   symbolic link
Device: 801h/2049d      Inode: 278588      Links: 1
Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-10 23:21:05.000000000 +0000
Modify: 2011-01-09 12:42:57.000000000 +0000
Change: 2011-01-09 12:42:57.000000000 +0000
  File: `/usr/lib64/libmysqlclient.so.15' -> `libmysqlclient.so.16'
  Size: 20              Blocks: 0          IO Block: 4096   symbolic link
Device: 801h/2049d      Inode: 278723      Links: 1
Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2011-01-09 12:44:16.000000000 +0000
Change: 2011-01-09 12:44:16.000000000 +0000
  File: `/usr/lib64/libmysqlclient.so.16' -> `libmysqlclient.so.16.0.0'
  Size: 24              Blocks: 0          IO Block: 4096   symbolic link
Device: 801h/2049d      Inode: 278559      Links: 1
Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2011-01-09 12:42:57.000000000 +0000
Change: 2011-01-09 12:42:57.000000000 +0000
  File: `/usr/lib64/libmysqlclient.so.16.0.0'
  Size: 5391845         Blocks: 10560      IO Block: 4096   regular file
Device: 801h/2049d      Inode: 1540135     Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2010-09-28 21:11:22.000000000 +0100
Change: 2011-01-10 04:03:46.000000000 +0000
  File: `/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so'
  Size: 234338          Blocks: 472        IO Block: 4096   regular file
Device: 801h/2049d      Inode: 69877       Links: 1
Access: (0555/-r-xr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2011-01-12 22:07:17.000000000 +0000
Modify: 2011-01-05 22:17:18.000000000 +0000
Change: 2011-01-05 22:17:18.000000000 +0000
root@myhost [/home/myuser]#

root@myhost [/home/myuser]# rpm -qa --qf "%{name}-%{version}-%{release}.%{arch}\n" | grep -i mysql | sort
MySQL-bench-5.0.91-0.glibc23.x86_64
MySQL-client-5.1.51-0.glibc23.x86_64
MySQL-devel-5.1.51-0.glibc23.x86_64
MySQL-server-5.1.51-0.glibc23.x86_64
MySQL-shared-5.1.51-0.glibc23.x86_64
MySQL-test-5.1.51-0.glibc23.x86_64
root@myhost [/home/myuser]#

The old MySQL-bench RPM can be removed after the upgrade to MySQL 5.1:

# yum remove MySQL-bench

We have internal case 38666 that is active for examining why the MySQL-bench RPM may be left installed when upgrading MySQL from version 5.0 to 5.1; however, I believe this symptom is not be directly related to original issue being discussed.

IO::Uncompress::Gunzip is up to date (2.033).
Compress::Zlib is up to date (2.033).
IO::Zlib is up to date (1.10).
Archive::Tar is up to date (1.76).
Archive::Zip is up to date (1.30).
Net::Cmd is up to date (2.29).
Net::FTP is up to date (2.77).
Term::ReadKey is up to date (2.30).
Term::ReadLine::Perl is up to date (1.0303).
YAML is up to date (0.72).
Parse::CPAN::Meta is up to date (1.40).
Text::Glob is up to date (0.08).
CPAN is up to date (1.9402).
File::Which is up to date (1.09).
DBD::mysql is up to date (4.018).
perlmod--Install done
root@myhost [/home/myuser]#

the perl installer produced alot of output, I assume the output above is sufficent to show what version of DBD::mysql there is

root@myhost [/home/myuser]# /scripts/update_db_cache
Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
 at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
Compilation failed in require at /scripts/update_db_cache line 23.
BEGIN failed--compilation aborted at /scripts/update_db_cache line 23.
root@myhost [/home/myuser]#

Thanks for taking the time to help, hope we can get this fixed!

If a forced MySQL update/reinstall does not alleviate the issue, I recommend submitting a support request so that we may assist with further, in-depth investigation; direct access will be needed to accurately diagnose and inspect the surrounding circumstances.

Please let me know your support ticket ID number when available.

[JonSimmonds]

Hi, setting mysql updates to inherit, then running the mysqlup script would appear to have fixed the problem. For reference in the WHM webinterface neither never or inherit was selected for the packages to upgrade.

Thank you for your help

[cPanelDon]

Hi, setting mysql updates to inherit, then running the mysqlup script would appear to have fixed the problem. For reference in the WHM webinterface neither never or inherit was selected for the packages to upgrade.

Thank you for your help

Thank you for the follow-up and confirmation of resolution.

If anyone else may experience similar difficulty, I would be curious to see the output of the following command before adjusting the MySQL update preference:

# cat /etc/cpupdate.conf

[cPanelDavidG]

Case 38666 was resolved in version 11.31.1.2. See if this is on your update tier yet by visiting Downloads - cPanel Inc.