Hello, You need to be a bit more explicit about what is going on here. To the best of my knowledge Bacula does not use any temporary files other than what it writes the Working Directory. When Bacula is pruning, and during certain other operations, it will create temporary tables. It is my understanding that those temporary tables should go in the same file/directory as the catalog database itself.
It is possible that SQLite tries to write in some files, but if that is the case, you should specify which file/files. Bacula should *never* attempt to write in the directory from which it is started unless it is incorrectly configured, so making that directory writable is not a good idea. Now, if the user or the package creator makes the serious error of pointing the Working Directory to the same place where Bacula is stored, then you will definitely have a problem. On Wednesday 18 May 2005 11:26, [EMAIL PROTECTED] wrote: > Hello all, > > I experienced a crash (described hereafter) after editing the > bacula-dir.conf file. > > It seems that bacula-dir needs to write some temporary files when > examining/modifying its (sqlite) database . > > It tries to do so in the directory that was the current directory when the > bacula-dir daemon started. If that directory is not writable by Bacula, a > crash results. > > The scripts in my configuration (Mandrake) do not make sure that this is > the case : so if I start bacula-dir with the usual > service bacula-dir start > when I am in my home directory (not writable by Bacula), it won't work. > > cd'ing to a directory writable by bacula and restarting the bacula-dir > solves the problem. > > It would probably be a good idea to ensure that the temporary files > bacula-dir needs are written in the same directory as the sqlite bacula.db > itself. > > Should I submit a bug-report ? > > Cheers > -- Jean Marc > > > > ---------------------------- Message original ---------------------------- > Objet: [Bacula-users] sqlite crash in bacula-dir-1.36.2-1mdk > De: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Date: Mar 17 mai 2005 16:30 > À: bacula-users@lists.sourceforge.net > -------------------------------------------------------------------------- > > Hello all, > > On a fresh install of bacula, the following leads to a crash : > > - do some backup > - edit bacula-dir.conf to add some files > - restart bacula-dir > > results in this error (seen from bconsole): > > *status dir > Using default Catalog name=MyCatalog DB=bacula > Could not open database "bacula". > sqlite.c:151 Unable to open Database=/var/lib/bacula/bacula.db. > ERR=malformed database schema - unable to open a temporary database file > for storing temporary tables > > The only way out is to recreate the database. > > I don't see any permissions problems. The directory /var/lib/bacula > belongs to the user bacula. /tmp and /var/tmp are writable by bacula. > > I cannot setdebug without getting that same error. > > If I use sqlite to see what's in the bacula.db, I see the database "main" > which is in the normal place (/var/lib/bacula) and > 1 temp /var/tmp/sqlite_qVfam9PKLi9Sfu1 > > /var/tmp has this permissions (same as /tmp) > drwxrwx-wt 2 root adm > and there is no file /var/tmp/sqlite_qVfam9PKLi9Sfu1 > > Where on earth is bacula trying to create this temporary database ? And > which one ? > > My install : > > Linux Mandrake 10.1 > Bacula 1.36.2-1mdk from cooker > > What beats me is that as long as I do not change bacula-dir.conf, I can do > as many backups as I want. I can stop/restart bacula-dir, all is OK. > > As soon as I change bacula-dir.conf, kaboom. > > Any hints ? > Thanks in advance > > -- Jean-Marc > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_idt12&alloc_id344&op=click > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_idt12&alloc_id344&opÌk > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_idt12&alloc_id344&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
