From owner-freebsd-questions@FreeBSD.ORG Sun Jul 31 07:46:45 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 23E0316A41F for ; Sun, 31 Jul 2005 07:46:45 +0000 (GMT) (envelope-from anthony_wyatt@hotmail.com) Received: from hotmail.com (bay104-f33.bay104.hotmail.com [65.54.175.43]) by mx1.FreeBSD.org (Postfix) with ESMTP id E1C1243D45 for ; Sun, 31 Jul 2005 07:46:44 +0000 (GMT) (envelope-from anthony_wyatt@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 31 Jul 2005 00:46:44 -0700 Message-ID: Received: from 65.54.175.200 by by104fd.bay104.hotmail.msn.com with HTTP; Sun, 31 Jul 2005 07:46:44 GMT X-Originating-IP: [59.167.58.11] X-Originating-Email: [anthony_wyatt@hotmail.com] X-Sender: anthony_wyatt@hotmail.com From: "Anthony Wyatt" To: freebsd-questions@freebsd.org Date: Sun, 31 Jul 2005 17:46:44 +1000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 31 Jul 2005 07:46:44.0854 (UTC) FILETIME=[FF7D5960:01C595A3] Subject: Bacula problems under 5.4 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 31 Jul 2005 07:46:45 -0000 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