Re: Snort 1.9.0 - Postgresql

["Albert E. Whale" <aewhale () ABS-CompTech com>]

Eli Stair wrote:

> On Tue, 05 Nov 2002 13:21:15 -0500
> "Albert E. Whale" <aewhale () ABS-CompTech com> wrote:
>
> >  I am installing Snort-1.9.0 and Postgresql 7.2.12-1mdk, running on
> > Linux Mandrake 8.2.
> >
> > With the Database (seemingly) configured and the users added to the
> > system, I cannot get the snort process to connect to the Database.  My
> > Snort Startup error is:
> >
> > FATAL ERROR: database: Connection to database 'snort'
> > failed
>
> Have you done a "psql -U {snortuser} {snortdatabase}" to verify that you
> can in fact access the database you created with the user you created?
> You may also have to edit your pg_hba.conf to allow TCP/IP connections
> with "postgresql.conf:tcpip_socket = true" if you haven't done so, and
> allow user authentication with the stanzas as the end of the file.
>
> /eli

Thanks Eli,

By the time this arrive I have completed the above, and found the Next
Problem.  I get this error message in version 1.9.0 and 1.9.0-beta6.

Nov  5 14:44:17 access3 snort: database: postgresql_error:
ERROR:  ExecAppend: Fail to add null value in not null
attribute last_cid
Nov  5 14:44:17 access3 snort: database: Problem obtaining
SENSOR ID (sid) from postgresql->snort->sensor

I have sent this to Roman (per his request in the followup error messages),
but I have not heard anything back yet.  Any suggestions?

--
Albert E. Whale - CISSP
http://www.abs-comptech.com
----------------------------------------------------------------------
ABS Computer Technology, Inc. - ESM, Computer & Networking Specialists
Sr. Security, Network, and Systems Consultant
Board of Directors - InfraGard - Pittsburgh, PA




-------------------------------------------------------
This sf.net email is sponsored by: See the NEW Palm 
Tungsten T handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
_______________________________________________
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