nagios with Mysql

[Mark.Law at thomson.com]

Look in the documentation for OLD PASSWORD - you can fix this error by
updating the access password using an old style password.

Mark Law
Thomson Global Technology Infrastructure (TGTI)
(734) 913-3775  Phone
(734) 260-5740  Cell
(734) 913- 3500 Fax
mark.law at thomson.com


-----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: Thursday, July 05, 2007 4:23 PM
To: patrick.morris at hp.com
Cc: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] nagios with Mysql

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

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