All,
Running Bacula 3. on Solaris 10 x86. I'm setting up some Copy jobs using the Selection Type = SQLQuery. When I try to test the config file I get the error:
bacula@backup_svr: bacula-dir -t -c /opt/csw/etc/bacula/bacula-dir.conf
24-Nov 01:51 bacula-dir: ERROR TERMINATION at lex.c:270
Config token too long, file: /opt/csw/etc/bacula/bacula-dir_jobs.conf, line 757, begins at line 756
My SQLQuery is actually 2 queries on the same line. It works fine in MySQL and I need 2 queries to select jobs from 2 pools in the same Copy Job. Here is the SQL statement
select distinct Job.JobId,Job.Name from Job,Pool where Pool.Name = 'FS-Incremental_Pool' and Pool.PoolId = Job.PoolId and Job.Type = 'B' and Job.JobStatus in ('T','W') and Job.jobBytes > 0 and Job.StartTime > date_sub(current_timestamp(),interval 7 day) and Job.StartTime < current_timestamp() order by Job.StartTime; select distinct Job.JobId,Job.Name from Job,Pool where Pool.Name = 'FS-Full_Pool' and Pool.PoolId = Job.PoolId and Job.Type = 'B' and Job.JobStatus in ('T','W') and Job.jobBytes > 0 and Job.StartTime > date_sub(current_timestamp(),interval 7 day) and Job.StartTime < current_timestamp() order by Job.StartTime;
This is the only method I can use as the other methods for selecting Job ID's for Copying don't fit my environment. I'd prefer not to split the copying of Incrementals and Fulls into different Jobs.
Thanks,
Shon
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
