Issue with tailwatchd failing after upgrading MySQL

JonSimmonds

Registered
Apr 24, 2005
3
0
151
Leeds, UK
Hi

I have done some searching for other threads, found 2 good ones (http://forums.cpanel.net/f34/tailwatchd-failed-my-mail-120141.html & http://forums.cpanel.net/f5/tailwatchd-failing-161813.html) 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

Code:
Cron <[email protected]> /usr/bin/test -x /usr/local/cpanel/bin/tail-check && /usr/local/cpanel/bin/tail-check

Notification => [email protected] via EMAIL [level => 1]
Notification => [email protected] 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 <[email protected]> /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

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
Hi

I have done some searching for other threads, found 2 good ones (http://forums.cpanel.net/f34/tailwatchd-failed-my-mail-120141.html & http://forums.cpanel.net/f5/tailwatchd-failing-161813.html) 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

Code:
Cron <[email protected]> /usr/bin/test -x /usr/local/cpanel/bin/tail-check && /usr/local/cpanel/bin/tail-check

Notification => [email protected] via EMAIL [level => 1]
Notification => [email protected] 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 <[email protected]> /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:
Code:
# /scripts/mysqlup --force --verbose
# /scripts/restartsrv_tailwatchd
To gather more information, please let us know the output from the following commands:
Code:
# 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:
Code:
# /scripts/perlinstaller DBD::mysql
If the above command does not help, please try it with the force option:
Code:
# /scripts/perlinstaller --force DBD::mysql
To test for successful resolution, please run the following command to see if any errors are reported:
Code:
# /scripts/update_db_cache
 

JonSimmonds

Registered
Apr 24, 2005
3
0
151
Leeds, UK
Hi

WHM version is 11.28.64

in response to your questions
Code:
[email protected] [/home/myuser]# /scripts/mysqlup --force --verbose
Updates for âmysqlâMYSQLUPâneverâ

[email protected] [/home/myuser]]# /scripts/restartsrv_tailwatchd
[email protected] [/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
Code:
[email protected] [/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
[email protected] [/home/myuser]#

[email protected] [/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
[email protected] [/home/myuser]#

Code:
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
[email protected] [/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

Code:
[email protected] [/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.
[email protected] [/home/myuser]#

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

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
Hi

WHM version is 11.28.64

in response to your questions
Code:
[email protected] [/home/myuser]# /scripts/mysqlup --force --verbose
Updates for âmysqlâMYSQLUPâneverâ

[email protected] [/home/myuser]]# /scripts/restartsrv_tailwatchd
[email protected] [/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:
Code:
# grep "^MYSQLUP=" /etc/cpupdate.conf
MYSQLUP=inherit
Code:
[email protected] [/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
[email protected] [/home/myuser]#

[email protected] [/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
[email protected] [/home/myuser]#
The old MySQL-bench RPM can be removed after the upgrade to MySQL 5.1:
Code:
# 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.

Code:
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
[email protected] [/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

Code:
[email protected] [/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.
[email protected] [/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

Registered
Apr 24, 2005
3
0
151
Leeds, UK
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

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
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:
Code:
# cat /etc/cpupdate.conf
 

sehh

Well-Known Member
Feb 11, 2006
579
5
168
Europe
Guys, sorry to open a new thread. I'm having the same problem as described above.

running /scripts/update_db_cache returns:

Code:
Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/XSLoader.pm line 71.
 at /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/DBD/mysql.pm line 15.
Compilation failed in require at /scripts/update_db_cache line 26.
BEGIN failed--compilation aborted at /scripts/update_db_cache line 26.
Same for apache's modules that use mysql.so.

I tried mysqlup --force but that didn't help. I also tried perinstaller --force DBD::mysql but that didn't do anything as well.

Any help would be appreciated.

Thank you.