Could you please enable SQL query logging, and report the error logs here ?

You can do this by editing the [idmef_database] section in the prewikka.conf configuration file, adding:

log: /tmp/prewikka.log

I believe you're right, because there was one agent incorrectly added. But there's no option anywere to remove agents, and i didn't find any solutions to remove it directly.

The traceback now is the same:
Traceback (most recent call last):
File "/usr/lib/python2.6/site-packages/prewikka/Core.py", line 333, in process
getattr(view_object, view["handler"])()
File "/usr/lib/python2.6/site-packages/prewikka/views/sensor.py", line 115, in render
analyzerid = analyzer_path[-1]
IndexError: list index out of range

I have an access to pgsql directly, so please tell me the right place to look for misconfigured agent?

Anyway, prewikka should not lock up on this issue. :-)

The Show Must go on, Yoann.

Traceback (most recent call last):
File "/usr/lib/python2.6/site-packages/prewikka/Core.py", line 333, in process
getattr(view_object, view["handler"])()
File "/usr/lib/python2.6/site-packages/prewikka/views/sensor.py", line 114, in render
analyzer = self.env.idmef_db.getAnalyzer(analyzerid)
File "/usr/lib/python2.6/site-packages/prewikka/IDMEFDatabase.py", line 539, in getAnalyzer
analyzerd[column] = analyzer[column]
TypeError: 'NoneType' object is unsubscriptable

Thanks for the quick feedback,

On line 526, immediately after:

        for analyzer in heartbeat["analyzer"]:

Could you please insert:

            print "A=", analyzer
            print "N=", analyzer["name"]
            print "I=", analyzer["analyzerid"]

And provides the prewikka-httpd output?

We will continue tomorrow, Yoann. Thanks for your support!


Traceback (most recent call last):
File "/usr/lib/python2.6/site-packages/prewikka/Core.py", line 333, in process
getattr(view_object, view["handler"])()
File "/usr/lib/python2.6/site-packages/prewikka/views/sensor.py", line 114, in render
analyzer = self.env.idmef_db.getAnalyzer(analyzerid)
File "/usr/lib/python2.6/site-packages/prewikka/IDMEFDatabase.py", line 542, in getAnalyzer
analyzerd[column] = analyzer[column]
TypeError: 'NoneType' object is unsubscriptable

I haven't any *.tmpl files. Cannot apply patch correctly.

spbsec02 templates # pwd
/usr/lib/python2.6/site-packages/prewikka/templates
spbsec02 templates # ls -l
total 364
-rw-r--r-- 1 root root 17386 May 15 17:33 About.py
-rw-r--r-- 1 root root 69668 May 15 17:33 AlertListing.py
-rw-r--r-- 1 root root 15392 May 15 17:33 ClassicLayout.py
-rw-r--r-- 1 root root  5314 May 15 17:33 Command.py
-rw-r--r-- 1 root root 11105 May 15 17:33 ErrorTemplate.py
-rw-r--r-- 1 root root 15985 May 15 17:33 FilterEdition.py
-rw-r--r-- 1 root root  6703 May 15 17:33 HTMLDocument.py
-rw-r--r-- 1 root root  9888 May 15 17:33 HeartbeatAnalyze.py
-rw-r--r-- 1 root root 13817 May 15 17:33 HeartbeatListing.py
-rw-r--r-- 1 root root  7908 May 15 17:33 LoginPasswordForm.py
-rw-r--r-- 1 root root  8503 May 15 17:33 MessageDetails.py
-rw-r--r-- 1 root root 37675 May 15 17:33 MessageListing.py
-rw-r--r-- 1 root root 15901 May 15 17:33 MessageSummary.py
-rw-r--r-- 1 root root  7879 May 15 17:33 PropertiesChangeForm.py
-rw-r--r-- 1 root root  5478 May 15 17:33 SensorAlertListing.py
-rw-r--r-- 1 root root  5504 May 15 17:33 SensorHeartbeatListing.py
-rw-r--r-- 1 root root 30105 May 15 17:33 SensorListing.py
-rw-r--r-- 1 root root  7182 May 15 17:33 TopLayout.py
-rw-r--r-- 1 root root  9337 May 15 17:33 UserListing.py
-rw-r--r-- 1 root root 16593 May 15 17:33 UserSettings.py
-rw-r--r-- 1 root root     0 Mar  4  2008 __init__.py
-rw-r--r-- 1 root root  7891 May 15 17:33 utils.py

Vitaly Tskhovrebov wrote:

I haven't any *.tmpl files. Cannot apply patch correctly.

You should apply the patch on top of a Prewikka-0.9.14 source tree, then run:

python setup.py install

So that the patched source base is installed.

Vitaly Tskhovrebov wrote:

Ok, i've got a picture of some misconfigured analyzers. How to remove them?

preludedb-admin delete heartbeat "type=mysql user=prelude pass=prelude name=prelude" --criteria '! heartbeat.analyzer.analyzerid'

Note: do this only for heartbeat. Doing it for alert will delete LML events.
Note