rasqlinsert only filling in about 1500 rows?

[Carter Bullard]

Hey Chance,
What are the command-line arguments that you are using?

Sounds like you are running rasqlinsert() in a mode where the database
table is sync'd with the internal cache state of rasqlinsert().  Means  
that when
rasqlinsert() timesout a flow and deletes its internal cache entry, it  
DELETES
the entry in the database table as well.

Are you using the "-M cache" option?
Keys are specified using the "-m option".
You can have rasqlinsert() generate an autoid field in the schema by  
specifying
it with a "-s +autoid" like command line option.

Carter

On Oct 14, 2009, at 3:54 PM, Chance Carroll wrote:

> I have Argus and radium setup and happily logging away our traffic,  
> but I'm having problems with rasqlinsert, when trying to capture  
> live data it starts replacing rows, the total row rarely rises above  
> 1700, and can decrease down to 1100. Also, the table does not show a  
> primary key, could that be part of the problem? Is it possible to  
> set an auto-incrementing key through rasqlinsert?
>
>
> Thanks,
> Chance





-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3815 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20091014/b2c04bb9/attachment.bin>