firnsy / barnyard2

Barnyard2 is a dedicated spooler for Snort's unified2 binary output format.
GNU General Public License v2.0
344 stars 190 forks source link

timestamp resolution #197

Open Amir-Teshome opened 8 years ago

Amir-Teshome commented 8 years ago

In mysql database the timestamp is stored until seconds (milliseconds are discarded). I'm using a mysql version capable of storing fractional seconds (> version 5.6).

while running in batch (or one-shot) mode mili-seconds are printed to the console. But in the database milliseconds are discarded. I did an update on the schema of the event table ( changed the datatype of timestamp from DATETIME to DATETIME(6) to support 6 digit precision ) but still milliseconds are not stored, Any help is appreciated

Thank you