Error when snort logs to mysql

[Pranav Lal <pranav.lal () gmail com>]

Hi all,

I am running the following configuration
snort=2.4.3-ODBC
mysql=5.0.17.
OS=Windows XP professional sp2
I am getting the following error when I run snort
The default logging mode is now PCAP, use "-K ascii" to activate
the old default logging mode.
database: mysql_error: Incorrect datetime value: '2005-12-23 
11:27:56.000+-05' f
or column 'timestamp' at row 1
SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '1', '1', 
'2005
-12-23 11:27:56.000+-05')
database: mysql_error: Incorrect datetime value: '2005-12-23 
11:27:56.001+-05' f
or column 'timestamp' at row 1
SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '2', '2', 
'2005
-12-23 11:27:56.001+-05')
database: mysql_error: Incorrect datetime value: '2005-12-23 
11:27:59.000+-05' f
or column 'timestamp' at row 1
SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '3', '3', 
'2005
-12-23 11:27:59.000+-05')
database: mysql_error: Incorrect datetime value: '2005-12-23 
11:27:59.018+-05' f
or column 'timestamp' at row 1

Any one any thoughts?
Pranav


---------------------------------------------------------------------------
EARN A MASTER OF SCIENCE IN INFORMATION ASSURANCE - ONLINE
The Norwich University program offers unparalleled Infosec management 
education and the case study affords you unmatched consulting experience. 
Tailor your education to your own professional goals with degree 
customizations including Emergency Management, Business Continuity Planning, 
Computer Emergency Response Teams, and Digital Investigations. 

http://www.msia.norwich.edu/secfocus
----------------------------------------------------------------------------