I just spent a day and a half troubleshooting a puzzling backup failure
that at first APPEARED to be a failure of mydumper, a fast third-party
MySQL dump tool. After upgrading my kernel from 3.11.4 to 3.12.4, all
of my DB backup jobs began failing. The error message indicated that
mydumper was failing to connect to the DB as root@localhost, and, oddly,
was failing because it was NOT using the password. At no time did any
problem with any other Bacula job appear, which made it appear that it
was mydumper that was suddenly failing.
The recommended setup, for security reasons, for both mysqldump and
mydumper is to read user/password credentials from [mysqldump] and
[mydumper] tags in /root/.my.cnf. This avoids putting the passwords on
the command line where they may be visible in ps. What I found was that
for some reason, mydumper had suddenly stopped reading its credentials
from that file, only when run from a Bacula RunBeforeJob script. From
the command line, it still worked perfectly.
To cut a long story short, what eventually solved the problem was to
recompile Bacula under the 3.12.* kernel, then restart the Director.
The DB dumps immediately started working again.
So, if you upgrade to kernel 3.12, and your DB dumps suddenly start
failing with "Unable to connect (Using password: No)" errors, it's not
your dump tool that's failing. Recompile Bacula, restart the Director,
and you should be all set.
--
Phil Stracchino
Babylon Communications
phils AT caerllewys DOT net
phil AT co.ordinate DOT org
Landline: 603.293.8485
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
