Re: 1.9.0 and PostgreSQL weirdness

["Roman Danyliw" <roman () danyliw com>]

Derek,

> 1) in response to a message I saw in the archives about 1.9.0 not
> starting up correctly because it can't determine it's sensor ID, I had
> to modify the PostgreSQL DB schema such that "last_cid" would allow NULL
> values.  

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);

Roman


-------------------------------------------------------
This sf.net email is sponsored by: viaVerio will pay you up to
$1,000 for every account that you consolidate with us.
http://ad.doubleclick.net/clk;4749864;7604308;v?
http://www.viaverio.com/consolidator/osdn.cfm
_______________________________________________
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