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 ph...@caerllewys.net p...@co.ordinate.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-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
