Rasqlinsert question

[Leif Tishendorf]

Yeah, John was right.  I thought I had rerun it without the '-s -record' 
option, but I clearly hadn't.  It's working fine now.

-Leif

On 01/12/2012 01:47 PM, Carter Bullard wrote:
> 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
>>>