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
[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
Sent: Tuesday, July 03, 2007 10:49 PM
To: Lokesh Khanna
Cc: [EMAIL PROTECTED]; nagios-users@lists.sourceforge.net
Subject: Re: [Nagios-users] nagios with Mysql
Hi lokesh.khanna!
On Tue, 03 Jul 2007, [EMAIL PROTECTED] 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@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
