On Wednesday 18 April 2007 11:34, Giancarlo Rubio wrote:
> 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
This makes a very good argument that it is _not_ a permission problem, but on
the other hand, it is very unlikely to be a bug in bacula. (Since I am not
running FreeBSD anything I say at this point is a guess.) This certainly
looks similar to the problem report that you indicated at the beginning of
this thread and could be some kind of weird problem owing to a combination of
FreeBSD, Sqlite3 & Bacula.
To the best of my knowledge there is no built-in database security in Sqlite.
If you have write permission on the file you have write permission on the
database.
Let's make one more test before we shout "bug". Please set the permissions on
bacula.db to 666 (read/write for all) and see what happens.
And, while we're at it. What version of Bacula and FreeBSD are you using? Is
Bacula from a package or did you roll your own?
Cheers!
cmr
> 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
--
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
