We have a client that requires lower_case_table_names=1 in their mysqld
configuration. When I try to run a job, I get the following output:
*run
A job name must be specified.
The defined Job resources are:
1: clientdb1
2: BackupCatalog
3: Monitoring
4: RestoreFiles
Select Job resource (1-4): 1
Run Backup job
JobName: clientdb1
FileSet: Full Set
Level: Incremental
Client: clientdb1-fd
Storage: File
Pool: Default
When: 2005-12-28 11:17:57
Priority: 10
OK to run? (yes/mod/no): yes
Job failed.
You have messages.
*m
28-Dec 11:17 clientdb1-dir: clientdb1.2005-12-28_11.17.58 Fatal error:
sql_create.c:91 sql_create.c:91 insert INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('clientdb1.2005-12-28_11.17.58','clientdb1','B','I','C','2005-12-28
11:17:57',1135786677) failed:
Field 'ClientId' doesn't have a default value
28-Dec 11:17 clientdb1-dir: sql_create.c:91 INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('clientdb1.2005-12-28_11.17.58','clientdb1','B','I','C','2005-12-28
11:17:57',1135786677)
28-Dec 11:17 clientdb1-dir: clientdb1.2005-12-28_11.17.58 Fatal error:
sql_create.c:93 Create DB Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('clientdb1.2005-12-28_11.17.58','clientdb1','B','I','C','2005-12-28
11:17:57',1135786677) failed. ERR=Field 'ClientId' doesn't have a default value
The errors don't necessarily point directly to the case difference, but it's the
only thing that's different on this machine from all our other directors. Is
this MySQL setting just something that Bacula can't deal with, or is there a
config option I'm missing that would let us work around this?
Thanks in advance!
-Brian
--
I live in the United States of America, where we are gradually coming to
understand that nothing we do is ever our fault, especially if it is really
stupid.
--Dave Barry, "The Tide is high and other household problems"
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
