[Bacula-users] Bacula problem with Sqlite

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

Re: [Bacula-users] Bacula problem with Sqlite

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

Re: [Bacula-users] Bacula problem with Sqlite

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

Re: [Bacula-users] Bacula problem with Sqlite

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

Re: [Bacula-users] Bacula problem with Sqlite

# 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:00.03

Re: [Bacula-users] Bacula problem with Sqlite

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

Re: [Bacula-users] Bacula problem with Sqlite

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 /var/db and

Re: [Bacula-users] Bacula problem with Sqlite

-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 permissions of

Re: [Bacula-users] Bacula problem with Sqlite

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

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

Re: [Bacula-users] Bacula problem with Sqlite

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

Re: [Bacula-users] Bacula problem with Sqlite

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