On Thu, 2005-03-24 at 12:07 -0400, Carlos Molina M. wrote: > Hi all, > I have runing bacula 1.32d version with no problem, well... I > re-install the server with fedora core 3 and when I try to run some > jobs, send me the next message... > > AZOG: RunBefore: /usr/bin/mysqldump: Got error: 1044: Access denied for > user: '@localhost' to database 'bacula' when selecting the database > AZOG: VRVS-Backup.2005-03-24_12.01.27 Fatal error: RunBeforeJob returned > non-zero status=2 >
mysqldump is trying to connect to your database server using no username or password. Because of this, mysql is not letting you connect. > the file call make_catalog_backup that I call in RunBefore have the > next: > #!/bin/sh > # > # This script dumps your Bacula catalog in ASCII format > # It works for either MySQL or SQLite > # > mt -f /dev/nst0 rewind > mt -f /dev/nst0 weof > > cd /etc/bacula/bin > rm -f bacula.sql > if test xsqlite = xmysql ; then > echo ".dump" | /usr/bin/sqlite bacula.db >bacula.sql > else > /usr/bin/mysqldump $* -f --opt bacula >bacula.sql > fi > the symbol $* after /usr/bin/mysqldump means that it is passing any arguments that you give to the wrapping script (make_catalog_backup) directly on to mysqldump. mysqldump --help that will show you a whole list of arguments and switches that you can use with mysqldump. The ones you probably want to use are: --user <username> (the user that mysqldump should use to connect to mysql) --password <password> (the password for user that you specified) so, in your RunBeforeJob directive, do something like this: RunBeforeJob = "/etc/bacula/scripts/make_catalog_backup --user bacula --password=yourfavoritepassword" Hope that helps, -davidc -- The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn. -Alvin Toffler ------------------------------------------------------- This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005 Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows Embedded(r) & Windows Mobile(tm) platforms, applications & content. Register by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
