Re: database plugin failing to start

[Jens Krabbenhoeft <tschenz-snort-users () noris net>]

Hi,

> > database: postgresql_error: ERROR:  ExecAppend: Fail to add null value in not
> > null attribute last_cid
> http://marc.theaimsgroup.com/?l=snort-users&m=103593278617526&w=2

I found the posting I was searching for before:
http://marc.theaimsgroup.com/?l=snort-users&m=103473343622287&w=2

QUOTE (Roman Danyliw):

--- SNIP --- 
There is a bug in PostgreSQL logging with the release version v1.9.0.
An update of spo_database.c from CVS will fix this issue.

OR Executing the following SQL could also provide a temporary fixs:

psql> INSERT INTO sensor (sid, hostname, last_cid) VALUES (1, 'your
sensor name', 1);
--- SNIP --- 

HTH,
        Jens


-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing 
your web site with SSL, click here to get a FREE TRIAL of a Thawte 
Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
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