Thanks. I am able to fix that. But now 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... ** Updating table nagios_dbversion Done!
How can I fix it now? Is it just a warning message or an error ? Thanks - LK -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 05, 2007 10:28 PM To: Lokesh Khanna; [EMAIL PROTECTED] Cc: nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] nagios with Mysql 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 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 05, 2007 4:23 PM To: [EMAIL PROTECTED] Cc: nagios-users@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:[EMAIL PROTECTED] Sent: Wednesday, July 04, 2007 6:35 AM To: Lokesh Khanna Cc: nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] nagios with Mysql > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:nagios-users- > [EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, July 03, 2007 10:05 PM > To: Morris, Patrick > Cc: nagios-users@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@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@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