On Wednesday 10 February 2010 20:18:22 Andreas Piesk wrote: > Hi list, > > while testing things using bat 5.0.0 i found one more sql which doesn't > work with sqlite3, please see bacula-sql.patch (contains all non-working > statements i've found so far). would changing all 'USING ()' to 'ON ()' > break things? > > i think i've asked some time ago, why bat has to be run as root. i don't > think it is necessary but maybe i'm wrong.
Bat does not need to be run as root, and I don't run it that way. > > to run bat as non-root i changed the console apps by adding FALLBACK=true > (see bacula-console.patch) to give the user the choice to run bat as root > or as non-root. > > /etc/bacula has 0750,root,bacula and bat.conf 0640,root,bacula. with the > FALLBACK non-root users can run bat if they're member of group bacula. > > does it sound reasonable? >From what I see and the little that I know, yes, it seems reasonable. Please discuss this with Scott -- thanks. Thanks for your patch. I will apply the parts that apply to bat. It is really too bad that SQLite3 has this bug. However, the solution is OK and does no harm and is a good way to work around their bug. If you have a few minutes, it might be worthwhile to file a bug report with www.sqlite.org on this subject. Best regards, Kern ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel