Re: Prelude PostgreSQL Support

Hi,

Le jeudi 31 janvier 2008 à 04:01 -0500, Ilya Kogan a écrit :
> Hi,
> 
>      I'm trying to setup Prelude to use PostgreSQL and am receiving the
> following error:
> 
> 31 Jan 01:52:53 (process:32374) WARNING: could not insert message into
> database: ERROR:  type "e" does not exist.
> 
> It seems that prelude is trying to execute the following query:
> 
> INSERT INTO Prelude_AdditionalData (_parent_type, _message_ident,_index, 
> type, meaning, data) VALUES('H', 3, 0, 'string', 'Analyzer status', 
> E'starting');
> 
> I've been using PostgreSQL for quite a bit but I don't know it nearly as
> well as I'd like so I'm not aware of the particular syntax at
> "E'starting'". My PostgreSQL version is 7.4.19 and I'm using
> prelude-manager 0.9.10. I rebuilt libpreludedb tonight (as it didn't
> have PostgreSQL support) so thats quite new as well. I also created the
> database tonight with the pgsql.sql file and the _format table has
> "14.7" as the version. The error happens as soon as prelude-manager
> starts up as it looks like its trying to record itself starting. If I
> restart a log monitor it starts spewing that error for what seems like
> forever. Heres the startup and query log:

A fix for this issue was checked in the SVN repository:
https://trac.prelude-ids.org/changeset/10144

The patch is available here:
https://trac.prelude-ids.org/changeset/10144?format=diff&new=10144


Could you please report whether this solve your problem?

Regards,

-- 
Yoann Vandoorselaere | Responsable R&D / CTO | PreludeIDS Technologies
Tel: +33 (0)8 70 70 21 58                  Fax: +33(0)4 78 42 21 58
http://www.prelude-ids.com

_______________________________________________
Prelude-user site list
[email protected]
http://www.prelude-ids.org/mailman/listinfo/prelude-user