nagios with Mysql

[lokesh.khanna at accelonafrica.com]

Hi Patrick

I upgraded mysql on my system yesterday. New version is -
mysql  Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686) using readline
5.0

But now I am getting below error message 

DBI connect('database=nagios;host=localhost','nagiosuser',...) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at ./installdb line 41

How can I resolve this problem? Which version of Mysql should I use?

Thanks - LK

-----Original Message-----
From: Morris, Patrick [mailto:patrick.morris at hp.com] 
Sent: Wednesday, July 04, 2007 6:35 AM
To: Lokesh Khanna
Cc: nagios-users at lists.sourceforge.net
Subject: RE: [Nagios-users] nagios with Mysql

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