On Sat, Sep 03, 2011 at 04:08:28PM +0200, Marcus Krackowizer wrote: [...] > I am getting the following error message when trying to run a backup job. It > seems that Bacula is trying to log into MySQL as a root user but I don't > believe I've specified this anywhere. Is anyone aware what I've done to > trigger this error? A wild guess follows below.
[...] > 01-Sep 18:39 bacula-dir JobId 39: shell command: run BeforeJob > "/usr/libexec/bacula/make_catalog_backup.pl MyCatalog" This script runs something like mysqldump --defaults-file=/var/spool/bacula/.my.cnf ... to actually create the file containing the database dump to be consumed by Bacula. > 01-Sep 18:39 bacula-dir JobId 39: BeforeJob: Warning: World-writable config > file '/var/spool/bacula/.my.cnf' is ignored mysqldump rightfully refuses to read the file to which anyway can write anything. > 01-Sep 18:39 bacula-dir JobId 39: BeforeJob: mysqldump: Got error: 1045: > Access denied for user 'root'@'localhost' (using password: NO) when trying > to connect Since mysqdump had no other resources to get the credentials to be used when connecting to the database from, it used the credentials of the process itself. Supposedly your bacula-fd instance is running using the root account, hence this attempt to authenticate as root@localhost without a password. [...] ------------------------------------------------------------------------------ Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management solution at an even better price-free! And you'll get a free "Love Thy Logs" t-shirt when you download Logger. Secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsisghtdev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
