[Snort-devel] patch for doc/create_postgresql

Frank Knobbe fknobbe at ...337...
Thu Apr 24 14:44:07 EDT 2003


Uhm, yeah, I had posted that not too long ago (along with a patch for
the doc).

However, you have overlooked a typo on an index. Check my diff below.

Regards,
Frank



On Thu, 2003-04-24 at 15:53, Thomas Kotzian wrote:
> 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...
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Snort-devel mailing list
> Snort-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/snort-devel
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresfix.diff
Type: text/x-patch
Size: 2128 bytes
Desc: not available
URL: <https://lists.snort.org/pipermail/snort-devel/attachments/20030424/4aa4c7b8/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 187 bytes
Desc: This is a digitally signed message part
URL: <https://lists.snort.org/pipermail/snort-devel/attachments/20030424/4aa4c7b8/attachment.sig>


More information about the Snort-devel mailing list