Rasqlinsert question

[Carter Bullard]

Hey Leif,
John is right, the "-s -record" is the culprit, but it should work so definately a bug.  Does this happen all the time or only after it shifts to a new time based table ?

Do you have a RA_FIELD_SPECIFIER set in your .rarc.  If yes, what is it ?

All seems to be working, schema establishment, etc.... But the query development is still adding the "record" blob to the end.  I'll look to see what is up.

Also, any chance this still generates the error if you drop the table completely, and then re-run the command.

Carter


On Jan 12, 2012, at 3:08 PM, John Gerth <gerth at graphics.stanford.edu> wrote:

> 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
>>