[Snort-devel] patch for doc/create_postgresql

Thomas Kotzian thomasko321d at ...1649...
Thu Apr 24 14:13:11 EDT 2003


i made a package for snort 2.0.0 for MacOSX and found the following 
problem:

for postgresql 7.3.2 i had to patch the create_postgresql file in doc:


--- snort/doc/create_postgresql.orig    2003-04-24 22:46:56.000000000 
+0200
+++ snort/doc/create_postgresql 2003-04-24 22:47:34.000000000 +0200
@@ -21,7 +21,7 @@
  -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 
02111-1307, USA.

  CREATE TABLE schema ( vseq        INT4     NOT NULL,
-                      ctime       DATETIME NOT NULL,
+                      ctime       TIMESTAMP NOT NULL,
                        PRIMARY KEY (vseq));
  INSERT INTO schema  (vseq, ctime) VALUES ('106', now());

@@ -57,7 +57,7 @@
  CREATE TABLE event  ( sid        INT4 NOT NULL,
                        cid        INT8 NOT NULL,
                        signature   INT4 NOT NULL,
-                      timestamp   DATETIME NOT NULL,
+                      timestamp   TIMESTAMP NOT NULL,
                        PRIMARY KEY (sid,cid));
  CREATE INDEX signature_idx ON event (signature);
  CREATE INDEX timestamp_idx ON event (timestamp);

postgresql 7.3.2 does not recognize the type datetime - only timestamp.

bye, thomas
--
thomas kotzian, thomas.kotzian at ...1649...





More information about the Snort-devel mailing list