nagios with Mysql

[Morris, Patrick]

> -----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: Tuesday, July 03, 2007 10:05 PM
> To: Morris, Patrick
> Cc: nagios-users at lists.sourceforge.net
> Subject: Re: [Nagios-users] nagios with Mysql
> 
> 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.

What version of MySQL are you building it with? I'd have to be a pretty
old version not to support the "ENINE=MyISAM" option.



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