Rasqlinsert question

[John Gerth]

I think the error is due to  "-s -record" below.
What follows "-s" should be field names which exist in the table schema
and IIRC, that's not part of the rasql defaults
--
John Gerth      gerth at graphics.stanford.edu  Gates 378   (650) 725-3273

On 1/12/12 10:17 AM, Leif Tishendorf wrote:
> Howdy All,
> 
> I'm using the following to insert into sql:
> 
> rasqlinsert -M cache -m saddr daddr dport -s -record -R /var/log/argus/2012/01/10/ -w mysql://argus@localhost/argus/table_%Y_%m_%d -M time 1d
> 
> but it starts outputting a whole lot of the error:
> 
> rasqlinsert[21490]: 2012-01-12 10:14:08 mysql_real_query error Unknown column 'record' in 'field list'
> rasqlinsert[21490]: 2012-01-12 10:14:08 mysql_real_query error Unknown column 'record' in 'field list'
> rasqlinsert[21490]: 2012-01-12 10:14:08 mysql_real_query error Unknown column 'record' in 'field list'
> rasqlinsert[21490]: 2012-01-12 10:14:08 mysql_real_query error Unknown column 'record' in 'field list'
> rasqlinsert[21490]: 2012-01-12 10:14:08 mysql_real_query error Unknown column 'record' in 'field list'
> 
> It does seem to be inserting records, but I was wondering if anyone had any ideas?
> 
> Thanks,
> 
> --Leif
>