Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 31 Jul 2005 17:46:44 +1000
From:      "Anthony Wyatt" <anthony_wyatt@hotmail.com>
To:        freebsd-questions@freebsd.org
Subject:   Bacula problems under 5.4
Message-ID:  <BAY104-F3304986AFFF64D3FC085BA94C00@phx.gbl>

next in thread | raw e-mail | index | archive | help
Dear All,
            I had bacula running on my Freebsd 5.3 system.

            I have upgraded my system to FreeBSD 5.4 and installed bacula 
from the ports tree. When I attempt to run a job I get the following error:

*run
Using default Catalog name=MyCatalog DB=bacula
A job name must be specified.
The defined Job resources are:
     1: Client1
     2: BackupCatalog
     3: RestoreFiles
Select Job resource (1-3): 1
Run Backup job
JobName:  Client1
FileSet:  Full Set
Level:    Incremental
Client:   fastsrv-fd
Storage:  File
Pool:     Default
When:     2005-07-31 17:12:39
Priority: 10
OK to run? (yes/mod/no): yes
Job failed.
You have messages.
*messages
31-Jul 17:12 fastsrv-dir: Client1.2005-07-31_17.12.42 Fatal error: 
sql_create.c:91 sql_create.c:91 insert INSERT INTO Job 
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES 
('Client1.2005-07-31_17.12.42','Client1','B','I','C','2005-07-31 
17:12:39',1122793959) failed:
attempt to write a readonly database
31-Jul 17:12 fastsrv-dir: sql_create.c:91 INSERT INTO Job 
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES 
('Client1.2005-07-31_17.12.42','Client1','B','I','C','2005-07-31 
17:12:39',1122793959)
31-Jul 17:12 fastsrv-dir: Client1.2005-07-31_17.12.42 Fatal error: 
sql_create.c:93 Create DB Job record INSERT INTO Job 
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES 
('Client1.2005-07-31_17.12.42','Client1','B','I','C','2005-07-31 
17:12:39',1122793959) failed. ERR=attempt to write a readonly database
*

            I can’t find any information on the sqlite page about making a 
database readonly (or how to turn this feature off).
            I have checked the file permissions and they are correct.
            I can perform this INSERT from the sqlite command line tool but 
not from the bconsole sqlquery option.

            Has anyone seen this problem before? I’m using the sqlite2 and 
the bacula-server from the ports tree.

Thanks,
Anthony





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BAY104-F3304986AFFF64D3FC085BA94C00>