Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
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 rootbacula 49152 Apr 18 15:20 bacula.db I have changed tto user bacula and group bacula and restarted bacula director. I

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
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" f

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
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,

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
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

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Giancarlo Rubio wrote: > 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-x2 baculabacula512 Apr 18 11:26 bacula >> What are the permi

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
Running as root bacula works good. It's a bug on bacula?? 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-x2 baculabacula512 Apr 18 11:26 bacula > > What are the permissions of /va

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote: > # ls -ll /var/db/|grep bacula > drwxr-xr-x2 baculabacula512 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 w

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
# ls -ll /var/db/|grep bacula drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula 2007/4/18, C M Reinehr <[EMAIL PROTECTED]>: > On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote: > > See > > > > # ps axu|grep bacula > > bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote: > See > > # ps axu|grep bacula > bacula48990 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/s

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
See # ps axu|grep bacula bacula48990 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 bacula49009 0.0 0

Re: [Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread C M Reinehr
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 > (

[Bacula-users] Bacula problem with Sqlite

2007-04-18 Thread Giancarlo Rubio
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