[Snort-devel] last_cid in new database scheme v106

Ian Macdonald secsnortdev at ...1490...
Fri Sep 13 09:28:06 EDT 2002

I thought you could do sequences using the auto_increment in mysql
----- Original Message -----
From: "Roman Danyliw" <roman at ...49...>
To: "Kreimendahl, Chad J" <Chad.Kreimendahl at ...1167...>
Cc: "Dirk Geschke" <dirk at ...972...>;
<snort-devel at lists.sourceforge.net>
Sent: Wednesday, September 11, 2002 3:16 PM
Subject: RE: [Snort-devel] last_cid in new database scheme v106

> "Most databases" is the key phrase here.  MySQL, by far the most popular
> database logging configuration, does not support explicit sequences.  For
> this reason, there is the addition sensor.cid field.
> Furthermore, it would be the introduction of a sequence (which internally
> keep state identical to what is achieved by the sensor.last_cid), not the
> elimination of the composite primary that would prevent the CID collision
> problem.

More information about the Snort-devel mailing list