RE: Problem with Snort 1.9.0 and PostgreSQL

[Johan Sunnerstig <Johan.Sunnerstig () netgiro com>]

Thanks, this solved my problem.
Well actually I kinda FUBAR'ed the database and had to reinstall it, but I
simply changed the create_postgresql script instead, and it works fine now.

Thanks a bunch :)

Johan

-----Original Message-----
From: Peter Erickson [mailto:redlamb () redlamb net]
Sent: den 10 december 2002 04:44
To: Snort Users (E-mail)
Subject: Re: [Snort-users] Problem with Snort 1.9.0 and PostgreSQL


I also ran into this problem when I setup snort last week. After looking at
the create_pstgresql script that comes with Snort, I found the problem. When
the script creates the sensor table, it defines one of the fields (last_cid)
to be 'NOT NULL'. When snort runs for the first time, it tries to add a null
value into this field which causes the program to exit. In order to fix it,
I dropped the sensor table and recreated it by hand omitting the 'NOT NULL'
keyword.

I hope this helps. Good luck.

The create statement I used was:

CREATE TABLE sensor ( sid         SERIAL,
                      hostname    TEXT,
                      interface   TEXT,
                      filter      TEXT,
                      detail      INT2,
                      encoding    INT2,
                      last_cid    INT8,
                      PRIMARY KEY (sid));

On Mon, Dec 09, 2002 at 06:37:27PM -0600, m0use said:
> On Tue, 10 Dec 2002 06:57:59 +0800, Semerjian, Ohanes wrote
> > when u say this not permissions issue which permissions u mean....! 
> > if u mean file then thats not what I'm trying to say. Any database 
> > has it own permissions and they r different from file permission and 
> > it dose not mater even if u were root. U still need to grant the 
> > root a database permission.
>
> FYI recompiling from CVS fixed it.  It used the same database no problem.
I'm
> very curious what the problem was since no permissions on the database
were
> changed.  Since i'm not going to use postgres after all on this project it
was
> really an excercise.  But hey everyones gotta have a hobby.
>
>
> m0use
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Snort-users mailing list
> Snort-users () lists sourceforge net
> Go to this URL to change user options or unsubscribe:
> https://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users

-- 
Peter Erickson
redlamb () redlamb net
GPGKey: 0xD267D827


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users


-------------------------------------------------------
This sf.net email is sponsored by:
With Great Power, Comes Great Responsibility 
Learn to use your power at OSDN's High Performance Computing Channel
http://hpc.devchannel.org/
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users