-
problem module ToMerlindb_Mysql
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'"
, 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'"
[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'"
, 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'"
how i resolve it??
Thanks
Andrea
-
Administrator
Re: problem module ToMerlindb_Mysql
Hi,
which version of Nina and Shinken do you use?
thx
Andreas
-
Re: problem module ToMerlindb_Mysql
hi,
thx for reply i'm using ninja 1.1.0 and shinken 0.8.1
-
Re: problem module ToMerlindb_Mysql
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
-
Re: problem module ToMerlindb_Mysql
could you pease fill an issue on the bugtracker : https://github.com/naparuba/shinken/...pen&page=1
Thanx
-
Administrator
Re: problem module ToMerlindb_Mysql
-
Re: problem module ToMerlindb_Mysql
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules