Anthony Wyatt wrote:
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
<snip>
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
Hi Anthony,
I am using Bacula under FreeBSD 5.3 and 5.4, but connecting to MySQL.
Just an uneducated guess: is Bacula connecting to the database as the
same user that you use on the command line?
Have a look at the Catalog { ... } section of your bacula-dir.conf.
Rowdy
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
