Hello folks,
I've been trying to use Shinken with Centreon 2 as it is actually
"wired" with a NdoDB over MySQL by default, and I also needed to
produce a PoC of Shinken with a DB broker. For sure Centreon is still
attractive for my boss...
So, I configured the broker to connect to a Centreon - ndo - db that
resides on an other VM.
I could verify a simple command line connection with the user centreon.
But now, when looking at the broker' logs, I can see Database
integrity Warning returned by the remote MySQL DB.
Ok, staying positive, I can say the broker' conf is good, but I'm
worrying about the do-ability of the solution. Please let me know if
you have some clue :)
Here comes an extract of the broker o' log :
{code}[CODE]
IOError: [Errno 2] No such file or directory:
'/usr/local/shinken/var/archives/nagios-01-14-2011-
00.log'
/usr/lib/python2.6/site-packages/Shinken-0.4-py2.6.egg/shinken/db_mysql.py:58:
Warning: Out of ra
nge value adjusted for column 'last_command_check' at row 1
self.db_cursor.execute(query)
/usr/lib/python2.6/site-packages/Shinken-0.4-py2.6.egg/shinken/db_mysql.py:58:
Warning: Out of ra
nge value adjusted for column 'last_log_rotation' at row 1
self.db_cursor.execute(query)
[MysqlDB] Warning : a query raise an integrity error : INSERT INTO
nagios_contacts (instance_id , alias , contact_object_id ,
host_notifications_enabled , pager_address ,
service_notifications_enabled , email_address , contact_id ) VALUES
('2' , 'none' , '2' , '1' , 'none' , '1' , 'napar...@gmail.com' , '2'
), (1062, "Duplicate entry '2' for key 1")
[MysqlDB] Warning : a query raise an integrity error : INSERT INTO
nagios_contactgroups (contactgroup_id , instance_id , config_type ,
alias , contactgroup_object_id ) VALUES ('1' , '2' , '0' , 'admins' ,
'1' ), (1062, "Duplicate entry '1' for key 1")
[MysqlDB] Warning : a query raise an integrity error : INSERT INTO
nagios_hostgroups (instance_id , alias , config_type , hostgroup_id ,
hostgroup_object_id ) VALUES ('2' , 'Serveurs de la bulle M' , '0' ,
'1' , '75' ), (1062, "Duplicate entry '1' for key 1")
[/CODE]{code}
Regards,
Tanguy von Stebut
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Shinken-devel mailing list
Shinken-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/shinken-devel
