On 4/27/21 1:52 PM, Steven A. Falco wrote: > On 4/27/21 5:14 AM, Paul Howarth wrote: >> On Sun, 25 Apr 2021 11:17:49 -0400 >> "Steven A. Falco" <stevenfalco@xxxxxxxxx> wrote: >>> Are there any additional instructions on how to update the bacula >>> database? >> >> Normally I would use /usr/libexec/bacula/update_mysql_tables but I >> found in this case that it didn't work because it was trying to drop an >> index from a table that didn't already exist (the index, not the >> table). > > Thanks for the reply. I turned out to be able to run: > > /usr/libexec/bacula/update_bacula_tables > > I'm using postgresql, and the script did manage to update the > database. And as you say, it took a long time. > > Then, I was getting failures from bacula that it couldn't insert into > the File area, and I found that I additionally had to re-run: > > grant_bacula_privileges > > Once I did that, it all started working. Thank you for this! I too am using postgresql and I also had simply ran /usr/libexec/bacula/update_bacula_tables. Things looked ok until I tried a test restore: Building directory tree for JobId(s) 15256,15739,15762 ... Query failed: DECLARE _bac_cursor CURSOR FOR SELECT Path.Path, T1.Filename, T1.FileIndex, T1.JobId, LStat, DeltaSeq FROM ( SELECT DISTINCT ON (Filename, PathId, DeltaSeq) JobTDate, JobId, FileId, FileIndex, PathId, Filename, LStat , DeltaSeq FROM (SELECT FileId, JobId, PathId, Filename, FileIndex, LStat ,DeltaSeq FROM File WHERE JobId IN (15256,15739,15762) UNION ALL SELECT File.FileId, File.JobId, PathId, Filename, File.FileIndex, LStat , DeltaSeq FROM BaseFiles JOIN File USING (FileId) WHERE BaseFiles.JobId IN (15256,15739,15762) ) AS T JOIN Job USING (JobId) ORDER BY Filename, PathId, DeltaSeq, JobTDate DESC ) AS T1 JOIN Path ON (Path.PathId = T1.PathId) WHERE FileIndex > 0 ORDER BY T1.JobTDate, FileIndex ASC: ERR=ERROR: permission denied for table file However, once I ran /usr/libexec/bacula/grant_bacula_privilege, that problem was solved. From what I can see, everything is working fine now. John Florian _______________________________________________ devel mailing list -- devel@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to devel-leave@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/devel@xxxxxxxxxxxxxxxxxxxxxxx Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure
