Re: [Prelude Hybrid IDS] #308: Incorrect information in file: './prelude/Prelude_Alert.frm' (was: Help Prelude-manager)

#308: Incorrect information in file: './prelude/Prelude_Alert.frm'
-----------------------------------+----------------------------------------
 Reporter:  [email protected]  |        Owner:                        
     Type:  enhancement            |       Status:  new                   
 Priority:  high                   |    Milestone:  Prelude-Manager 0.9.15
Component:  prelude-manager        |      Version:  0.9                   
 Severity:  critical               |   Resolution:                        
 Keywords:                         |  
-----------------------------------+----------------------------------------

Old description:

> Actually my Prelude-manager is down. I tried started the process but i
> have an error. The Prewikka show:
>
> Preikka internal errorIncorrect infoation i file:
> './prelude/Prelude_Alert.frm' Traceback (most recent call last): File
> "/usr/lib/python2.4/site-packages/prewikka/Core.py", line 333, in process
> getattr(view_object, view["handler"])() File "/usr/lib/python2.4/site-
> packages/prewikka/views/alertlisting.py", line 1111, in render total =
> self._setMessages(criteria) File "/usr/lib/python2.4/site-
> packages/prewikka/views/alertlisting.py", line 1067, in _setMessages
> return self._setAggregatedMessagesNoValues(criteria, ag_s, ag_t, ag_c,
> ag_a) File "/usr/lib/python2.4/site-
> packages/prewikka/views/alertlisting.py", line 935, in
> _setAggregatedMessagesNoValues results =
> self.env.idmef_db.getValues(selection, criteria) File "/usr/lib/python2.4
> /site-packages/prewikka/IDMEFDatabase.py", line 465, in getValues result
> = preludedb_get_values2(self._db, my_selection, criteria, distinct,
> limit, offset)PreludeDBError: Incorrect information in file:
> './prelude/Prelude_Alert.frm'The process mysqld and apache2 is up but the
> prelude-manager have an error.
>
> I dont understand because yesterday the Consola Prelude was ok.
>
> When i try up the prelude-manager this is the message: prelude-manager22
> Aug 11:19:14 (process:3837) INFO: Subscribing Normalize to active
> decoding plugins.. sudo /etc/init.d/prelude-manager stopStopping prelude-
> manager: prelude-manager apparently not running.$ sudo /etc/init.d
> /prelude-manager startStarting prelude-manager : prelude-manager22 Aug
> 11:20:34 (process:3879) INFO: Subscribing Normalize to active decoding
> plugins.
>
> Please, anyone can help me with this case?

New description:

 Actually my Prelude-manager is down. I tried started the process but i
 have an error. The Prewikka show:

 {{{
 File "/usr/lib/python2.4/site-packages/prewikka/IDMEFDatabase.py", line
 465, in getValues result = preludedb_get_values2(self._db, my_selection,
 criteria, distinct, limit, offset)PreludeDBError: Incorrect information in
 file: './prelude/Prelude_Alert.frm'The process mysqld and apache2 is up
 but the prelude-manager have an error.
 }}}

 I dont understand because yesterday the Consola Prelude was ok.

 When i try up the prelude-manager this is the message: prelude-manager
 {{{
 22 Aug 11:19:14 (process:3837) INFO: Subscribing Normalize to active
 decoding plugins.. sudo /etc/init.d/prelude-manager stopStopping prelude-
 manager: prelude-manager apparently not running.$ sudo /etc/init.d
 /prelude-manager startStarting prelude-manager : prelude-manager22 Aug
 11:20:34 (process:3879) INFO: Subscribing Normalize to active decoding
 plugins.
 }}}}

 Please, anyone can help me with this case?

--

Comment(by yoann):

 This does not look like related to the Prelude-Manager error. This is a
 MySQL specific error that usually happen after an InnoDB configuration
 change that is incompatible with the current InnoDB database settings. Did
 you changed your database configuration recently?

-- 
Ticket URL: <https://trac.prelude-ids.org/ticket/308#comment:1>
Prelude Hybrid IDS <http://www.prelude-ids.org>
The Prelude Hybrid Intrusion Detection System suite
_______________________________________________
Prelude-devel site list
[email protected]
http://lists.prelude-ids.org/mailman/listinfo/prelude-devel