It's not permission problem for the user bacula see # su - bacula $ echo "teste" > /var/db/bacula/bacula.test (user have write permission on this folder) $ sqlite3 /var/db/bacula/bacula.db SQLite version 3.3.15 Enter ".help" for instructions sqlite> INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES ('gian.2007-04-18_09.11.45','gian','B','I','C','2007-04-18 09:11:42',1176898302); sqlite> select * from Job; 1|gian.2007-04-18_09.11.45|gian|B|I|0|C|2007-04-18 09:11:42|0|0|0|1176898302|0|0|0|0|0|0|0|0|0|0|0 sqlite> .quit
User have write permission on bacula.db Giancarlo Rubio 2007/4/18, C M Reinehr <[EMAIL PROTECTED]>: > On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote: > > Running as root bacula works good. > > It's a bug on bacula?? > > No, it means that user/group bacula:bacula can not > access /var/db/bacula/bacula.db but user/group root:root can. So, as I said > earlier, you have a permissions problem somewhere along the path. > > cmr > > > 2007/4/18, C M Reinehr <[EMAIL PROTECTED]>: > > > On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote: > > > > # ls -ll /var/db/|grep bacula > > > > drwxr-xr-x 2 bacula bacula 512 Apr 18 11:26 bacula > > > > > > What are the permissions of /var/db and /var? > > > > > > Also, just as an experiment, you might reconfigure bacula-director to run > > > as root:root. If it works then you know it's a permissions/ownerwhip > > > problem somewhere. If not, then we're on the wrong track and need to take > > > a closer look at bacula.db. > > > > > > HTH > > > > > > cmr > > > > > > > 2007/4/18, C M Reinehr <[EMAIL PROTECTED]>: > > > > > On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote: > > > > > > See > > > > > > > > > > > > # ps axu|grep bacula > > > > > > bacula 48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03 > > > > > > /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/ > > > > > > root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03 > > > > > > /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca > > > > > > bacula 49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04 > > > > > > /usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l > > > > > > root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01 > > > > > > grep bacula > > > > > > > > > > > > > > > > > > # ls -l /var/db/bacula/bacula.db > > > > > > -rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26 > > > > > > /var/db/bacula/bacula.db > > > > > > > > > > What are the permissions & ownership of the directories along the > > > > > path to bacula.db (var, db, bacula)? > > > > > > > > > > cmr > > > > > > > > > > > 2007/4/18, C M Reinehr <[EMAIL PROTECTED]>: > > > > > > > On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote: > > > > > > > > Hi all, > > > > > > > > > > > > > > > > I have instaled Bacula on Freebsd 6.2. When i try to run job i > > > > > > > > get an error > > > > > > > > > > > > > > > > Job failed. > > > > > > > > 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal > > > > > > > > error: sql_create.c:520 sql_create.c:520 insert INSERT INTO > > > > > > > > Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES > > > > > > > > ('gian-fd','',1,2592000,15552000) failed: > > > > > > > > attempt to write a readonly database > > > > > > > > 18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO > > > > > > > > Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES > > > > > > > > ('gian-fd','',1,2592000,15552000) > > > > > > > > 18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error: > > > > > > > > sql_create.c:522 Create DB Client record INSERT INTO Client > > > > > > > > (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES > > > > > > > > ('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write > > > > > > > > a readonly database > > > > > > > > > > > > > > > > The owner of bacula.db is bacula user, and have write and read > > > > > > > > permission. > > > > > > > > > > > > > > > > I found a similar user report about this problem > > > > > > > > (http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but > > > > > > > > no solution at this moment. > > > > > > > > > > > > > > > > Is a FreeBSD problem on sqlite?? Have anyone running bacula on > > > > > > > > FreeBSD? > > > > > > > > > > > > > > > > Thanks > > > > > > > > > > > > > > Almost certainly a user or permissions problem. How is > > > > > > > bacula-director configured to run with regard to user & group? > > > > > > > I'll bet it is not the same as the owner/group of bacula.db. > > > > > > > > > > > > > > Cheers! > > > > > > > > > > > > > > cmr > > > > > > > -- > > > > > > > Debian 'Etch' - Registered Linux User #241964 > > > > > > > -------- > > > > > > > "More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC > > > > > > > > > > > > > > ----------------------------------------------------------------- > > > > > > >---- ---- This SF.net email is sponsored by DB2 Express > > > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > > > http://sourceforge.net/powerbar/db2/ > > > > > > > _______________________________________________ > > > > > > > Bacula-users mailing list > > > > > > > Bacula-users@lists.sourceforge.net > > > > > > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > > > > > > -- > > > > > Debian 'Etch' - Registered Linux User #241964 > > > > > -------- > > > > > "More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC > > > > > > > > > > --------------------------------------------------------------------- > > > > >---- This SF.net email is sponsored by DB2 Express > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > http://sourceforge.net/powerbar/db2/ > > > > > _______________________________________________ > > > > > Bacula-users mailing list > > > > > Bacula-users@lists.sourceforge.net > > > > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > > -- > > > Debian 'Etch' - Registered Linux User #241964 > > > -------- > > > "More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC > > > > > > ------------------------------------------------------------------------- > > > This SF.net email is sponsored by DB2 Express > > > Download DB2 Express C - the FREE version of DB2 express and take > > > control of your XML. No limits. Just data. Click to get it now. > > > http://sourceforge.net/powerbar/db2/ > > > _______________________________________________ > > > Bacula-users mailing list > > > Bacula-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- > Debian 'Etch' - Registered Linux User #241964 > -------- > "More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Giancarlo Rubio (041) 9192-5042 ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users