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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 03 July 2007 13:19 To: [EMAIL PROTECTED] Cc: nagios-users@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:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 11:15 PM To: Lokesh Khanna Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql On Mon, 02 Jul 2007, [EMAIL PROTECTED] 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@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@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
