That is very strange if restarting bacula-dir doesn't show the new file. Moreover, bconsole's query command opens the file every time you invoke it, so there is nothing that you need to do to reload it.
Maybe you had a syntax error in the file? E.g. there was no description line beginning with a colon. Did you edit the file on the same machine as the bacula-dir? If not, maybe there is some network filesystem caching problem that makes the changes invisible? __Martin >>>>> On Thu, 6 Dec 2018 10:21:27 +0000, Christopher Sluman said: > > Hi, > > Thanks for the reply, yes it is definitely the correct query file as that is > where I was able to make a change which eventually showed up in the query > menu. I have just added an extra query to the file, but stopping bacula-dir, > bacula-fd, bacula-sd then restarting and running command “reload” from > bconsole does not show the new query. > > Regards, > Chris Sluman > IT Technician > Structural Genomics Consortium > University of Oxford > Old Road Campus Research Building > Roosevelt Drive > Oxford > OX3 7DQ > > T: 01865 617577 > > [SGC] > [NDM] > > From: Wanderlei Huttel <wanderleihut...@gmail.com> > Sent: 05 December 2018 17:50 > To: Christopher Sluman <christopher.slu...@sgc.ox.ac.uk> > Cc: bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Changing and reloading query.sql > > Hello Chris > > Are you sure you are using the correct query file? > I am running bacula 9.2.2 and do not need to reload bconsole. I only access > the bconsole again and run the command query > > Best regards > > Wanderlei Hüttel > http://www.bacula.com.br<http://www.bacula.com.br/> > > > Em qua, 5 de dez de 2018 às 09:57, Christopher Sluman > <christopher.slu...@sgc.ox.ac.uk<mailto:christopher.slu...@sgc.ox.ac.uk>> > escreveu: > Hi, > > We are running Bacula 9.0.2 and I’m struggling to get /etc/bacula/query.sql > to reload after I’ve made changes. A simple reload from bconsole doesn’t > work. I also tried stopping all bacula services, without success. The only > thing that worked was when I had to stop mysqld as well (due to a separate > issue). Is there a way to change and reload query.sql without stopping mysql? > > Regards, > Chris Sluman > IT Technician > Structural Genomics Consortium > University of Oxford > Old Road Campus Research Building > Roosevelt Drive > Oxford > OX3 7DQ > > T: 01865 617577 > > [SGC] > [NDM] > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net<mailto:Bacula-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/bacula-users _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
