nagios with Mysql

[lokesh.khanna at accelonafrica.com]

I get below things in mysqld.lo

Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at

Thanks - Lokesh

-----Original Message-----
From: Giles Coochey [mailto:gcoochey at sapphire.gi] 
Sent: Tuesday, July 03, 2007 12:37 PM
To: Lokesh Khanna
Subject: RE: [Nagios-users] nagios with Mysql

Can you post the mysql error log perhaps?

Best regards
 
Giles Coochey
Technical Department
Sapphire Networks

-----Original Message-----
From: nagios-users-bounces at lists.sourceforge.net
[mailto:nagios-users-bounces at lists.sourceforge.net] On Behalf Of
lokesh.khanna at accelonafrica.com
Sent: 03 July 2007 13:19
To: patrick.morris at hp.com
Cc: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] nagios with Mysql

Thanks Patrick

I have compiled ngoutils but after all configuration, I get below error
on my log file. Not sure what mistake I am doing....


Jul  3 11:12:44 monitoring2 ndo2db: Error: mysql_query() failed for
'INSERT INTO nagios_timedevents SET instance_id='1', event_type='8',
queued_time=FROM_UNIXTIME(1183457564), queued_time_usec='195938',
scheduled_time=FROM_UNIXTIME(1183457574), recurring_event='1',
object_id='0' ON DUPLICATE KEY UPDATE instance_id='1', event_type='8',
queued_time=FROM_UNIXTIME(1183457564), queued_time_usec='195938',
scheduled_time=FROM_UNIXTIME(1183457574), recurring_event='1',
object_id='0''

Thanks - LK
-----Original Message-----
From: Patrick Morris [mailto:patrick.morris at hp.com] 
Sent: Monday, July 02, 2007 11:15 PM
To: Lokesh Khanna
Cc: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] nagios with Mysql

On Mon, 02 Jul 2007, lokesh.khanna at accelonafrica.com wrote:

> I have recently compiled nagios - 3.0.a5 on Enterprise 3.0 linux. I
> followed the instructions mentioned on
> http://nagios.sourceforge.net/docs/3_0/quickstart-fedora.html .
> 
> But I want to compile Nagios with Mysql. Can some one help me by
> providing a document on that.
> 
> I am not finding any url which has the document.

Nagios itself has no direct MySQL support to be compiled in.

ndoutils is an external add-on that provides some database support:

http://sourceforge.net/project/showfiles.php?group_id=26589

------------------------------------------------------------------------
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null