[Snort-users] Fw: DATETIME Data Type? Snort & Acid Intrusion Dectection Packages broken with 7.3.2 Release]

Jason snort-users at ...2977...
Wed Apr 16 12:08:02 EDT 2003


Edit the create_postgresql file, and change DATETIME to TIMESTAMP (I think
there are 4 places to edit it), also if your using acid, grep for DATETIME
through the acid files and change those too.  That worked for me, however
I still have the issue of not being able to archive using postgresql and
acid, but thats another issue


From: David Benham [mailto:dcb at ...8904...]
Sent: Wednesday, April 16, 2003 1:12 PM
To: snort-users at lists.sourceforge.net
Subject: [Snort-users] Fw: DATETIME Data Type? Snort & Acid Intrusion
Dectection Packages broken with 7.3.2 Release


Create_postgresql contrib script fails with Postgresql 7.3.2 - see below.

----- Original Message -----
From: dcb at ...8904... <mailto:dcb at ...8904...>
To: pgsql-general at ...8905... <mailto:pgsql-general at ...8905...>  
Sent: Wednesday, April 16, 2003 10:02 AM
Subject: DATETIME Data Type? Snort & Acid Intrusion Dectection Packages
broken with 7.3.2 Release

I've been using Postgresql 7.2, Snort, & Acid as our intrusion detection
package.  Recently, I attempted upgrade to Postgresql 7.3.2.  The database
schema generation scripts provided with both Snort & Acid include a
"DATETIME" data type.   These same scripts worked with earlier versions
Postgresql, but fail with 7.3.2.

I can find no evidence that Postgresql ever supported a DATETIME data
type..... yet the schema scripts executed without error in earlier
releases. The scripts do not use "CREATE TYPE" to create a DATETIME data
type.  I see no evidence it's been dropped in looking at the build/release
history.

Anybody have any idea what's going on here?  Has support for a "DATETIME"
data type been dropped?  Current Snort & Acid schema require a DATETIME
data type, and reference it in the database generation scripts.  So, both
those products now fail with Postgresql.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.snort.org/pipermail/snort-users/attachments/20030416/abbb0e5c/attachment.html>


More information about the Snort-users mailing list