problem with broker when connect ToMerlindb_Mysql

[longnh8x]

Hi All i have installed ninja and shinken with Merlindb.
When i check log in "brokerd.log":
The first: [1321007718] [broker-1] [broker-1] Warning : The mod ToMerlindb_Mysql raise an exception: (1054, "Unknown column 'check_flapping_recovery_notifitication&#0 39; in 'field list'&quot, I'm tagging it to restart later
I changed column in tables host and service check_flapping__recovery_notification in check_flapping_recovery_notifi and all hosts and services, it 's ok.

But after the error has appeared:
[1328602364] [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

I can't find 'module_type'. How I resolve it???
I used merlin-0.9.0 and shinken-0.8.1

[
2012-02-07 00:11:45,605 [1328602305] [broker-1] Trying to init module : ToMerlindb_Mysql

2012-02-07 00:12:32,917 [1328602352] [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

2012-02-07 00:12:32,918 [1328602352] [broker-1] [broker-1] Exception type : <class '_mysql_exceptions.OperationalError'& gt;

2012-02-07 00:12:32,918 [1328602352] [broker-1] Back trace of this kill: Traceback (most recent call last):
File "/opt/shinken/shinken/daemons/brokerdaemon.py", line 239, in manage_brok
mod.manage_brok(b)
File "/opt/shinken/shinken/modules/merlindb_broker/merlindb_broker.py", line 475, in manage_brok
self.db_backend.execute_query(q)
File "/opt/shinken/shinken/db_mysql.py", line 61, in execute_query
self.db_cursor.execute(query)
File "/usr/lib/pymodules/python2.7/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.7/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'module_type' in 'field list'&quot

]

Thanks.

[Seb-Solon]

Hi,

It sounds like a bug I think . We haven't got lots of feedbacks in this module

Maybe you have to create the field (I don't know if it's possible :P). Maybe I'll try to install a MerlinDb.

[longnh8x]

Thanks for your answer. I try ínstall merlin many times but nothing.
Everybody, have any idea ?

[Seb-Solon]

Bug reported at : https://github.com/naparuba/shinken/issues/167

[Seb-Solon]

Hi,

Is the bug still occuring? I've tried to install merlindb and I had no errors