nagios with Mysql

[lokesh.khanna at accelonafrica.com]

Hi

I have dropped nagios DB which I created and trying to re create again. 

When I execute installdb script for tables creation,  I get below error

DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist
at ./installdb line 51.
** Creating tables for version 1.4b4
     Using mysql.sql for installation...
ERROR 1064 at line 19: You have an error in your SQL syntax near
'ENGINE=MyISAM COMMENT='Current and historical host and service
acknowledgements'' at line 15
Installation from mysql.sql failed at ./installdb line 59.

If I remove 'ENGINE=MyISAM COMMENT='Current and historical host and
service acknowledgements from mysql.sql file, then I get no error and
tables get created. This is what I did earlier. 

I am not a DB person, so pl help me in understanding what is wrong. As
per my current my.cnf , I have below mentioned values there

[root at monitoring2 db]# cat /etc/my.cnf
[mysqld]
skip-innodb
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
     
[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Thanks - LK
-----Original Message-----
From: Patrick Morris [mailto:patrick.morris at hp.com] 
Sent: Tuesday, July 03, 2007 10:49 PM
To: Lokesh Khanna
Cc: gcoochey at sapphire.gi; nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] nagios with Mysql

Hi lokesh.khanna!

On Tue, 03 Jul 2007, lokesh.khanna at accelonafrica.com wrote:

> 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

At the risk of stating the obvious, it sounds like your problem, and the
fix for it, are described in that error message.

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