problem module ToMerlindb_Mysql

[andreas5489]

Hi All i have installed ninja and shinken following all the instructions but shinken works as it should while in ninja i can login but it doesn't populate.
i think there is a problem with the module ToMerlindb_Mysql because in the log nagios.log i see this:

Unauthorized - 192 bytes in 0.008 second response time
[1321007718] [broker-1] [broker-1] Warning : The mod ToMerlindb_Mysql raise an exception: (1054, "Unknown column 'check_flapping_recovery_notifi' in 'field list'&quot, I'm tagging it to restart later
[1321007718] [broker-1] [broker-1] Exception type : <class '_mysql_exceptions.OperationalError'& gt;
[1321007718] [broker-1] Back trace of this kill: Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/shinken/daemons/brokerdaemon.py", line 239, in manage_brok
mod.manage_brok(b)
File "/usr/local/lib/python2.6/dist-packages/shinken/modules/merlindb_broker/merlindb_broker.py", line 475, in manage_brok
self.db_backend.execute_query(q)
File "/usr/local/lib/python2.6/dist-packages/shinken/db_mysql.py", line 61, in execute_query
self.db_cursor.execute(query)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'check_flapping_recovery_notifi' in 'field list'&quot

[1321007719] [broker-1] Trying to init module : ToMerlindb_Mysql
[1321007718] SERVICE NOTIFICATION: admin;192.168.250.16;Http;WARNING;notify-service-by-email;HTTP WARNING: HTTP/1.1 401 Unauthorized - 192 bytes in 0.008 second response time
[1321007719] [broker-1] [broker-1] Warning : The mod ToMerlindb_Mysql raise an exception: (1054, "Unknown column 'module_type' in 'field list'&quot, I'm tagging it to restart later
[1321007719] [broker-1] [broker-1] Exception type : <class '_mysql_exceptions.OperationalError'& gt;
[1321007719] [broker-1] Back trace of this kill: Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/shinken/daemons/brokerdaemon.py", line 239, in manage_brok
mod.manage_brok(b)
File "/usr/local/lib/python2.6/dist-packages/shinken/modules/merlindb_broker/merlindb_broker.py", line 475, in manage_brok
self.db_backend.execute_query(q)
File "/usr/local/lib/python2.6/dist-packages/shinken/db_mysql.py", line 61, in execute_query
self.db_cursor.execute(query)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'module_type' in 'field list'&quot


how i resolve it??
Thanks
Andrea

[Frescha]

Hi,
which version of Nina and Shinken do you use?

thx
Andreas

[andreas5489]

hi,

thx for reply i'm using ninja 1.1.0 and shinken 0.8.1

[andreas5489]

seems solved i changed column in tables host and service check_flapping__recovery_notification in check_flapping_recovery_notifi and all hosts and services appeared in ninja

[dguenault]

could you pease fill an issue on the bugtracker : https://github.com/naparuba/shinken/...pen&page=1

Thanx

[Frescha]

https://github.com/naparuba/shinken/issues/75

[dguenault]

thank's ! ;D