its' a problem when creating tables
/usr/local/share/bacula/make_sqlite3_tables
When create table the permission are set to user root and group bacula
ls -ll
-rw-r----- 1 root bacula 49152 Apr 18 15:20 bacula.db
I have changed tto user bacula and group bacula and restarted bacula director.
I prepare to submit a bug report to this port to freebsd
Thank's all for atention
Giancarlo Rubio
2007/4/18, C M Reinehr <[EMAIL PROTECTED]>:
> 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
>
--
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
