Snort 1.9.0 Postgresql problems and a walkaround ?

[Kirill Alder-Ponazdyr <lists () codeangels com>]

Greetings,

This was posted to the list just few days ago, but so far no answers are here yet, we are getting the following error 
when starting snort with PgSQL output plugin for the first time:

database: postgresql_error: ERROR:  ExecAppend: Fail to add null value in not null attribute last_cid

database: Problem obtaining SENSOR ID (sid) from snort->sensor

This is defenately not the rights problem since we have tried the same with DB superuser.

Anyone has an idea ? I was able to temporary solve the problem by removing NOT NULL @ last_cid at the DB init SQL, but 
do not know what effect this would have on a long term operation.

Please advise.

Best Regards

Kirill

-----------------
Kirill Alder-Ponazdyr
SGI / SUN UNIX Consultant
Codeangels Solutions

Phone : +41 43 844 90 10
Fax   : +41 43 844 90 12
Mobile: +41 79 370 89 30 




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