Results 1 to 7 of 7

Thread: problem module ToMerlindb_Mysql

  1. #1
    Junior Member
    Join Date
    Nov 2011
    Posts
    3

    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'&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

  2. #2
    Administrator Frescha's Avatar
    Join Date
    May 2011
    Posts
    183

    Re: problem module ToMerlindb_Mysql

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

    thx
    Andreas

  3. #3
    Junior Member
    Join Date
    Nov 2011
    Posts
    3

    Re: problem module ToMerlindb_Mysql

    hi,

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

  4. #4
    Junior Member
    Join Date
    Nov 2011
    Posts
    3

    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

  5. #5
    Senior Member
    Join Date
    Oct 2011
    Posts
    139

    Re: problem module ToMerlindb_Mysql

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

    Thanx

  6. #6

  7. #7
    Senior Member
    Join Date
    Oct 2011
    Posts
    139

    Re: problem module ToMerlindb_Mysql

    thank's ! ;D

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •