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:
bac...@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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
