[Snort-users] Fw: DATETIME Data Type? Snort & Acid Intrusion Dectection Packages broken with 7.3.2 Release]
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
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...
More information about the Snort-users