<html><DIV><FONT face=Verdana color=#0000ff size=2>hmmm ok maybe I am a little confused because the first part of the "how to" creates a database using these same commands you listed...Is the NDO database name nagios? I also did the GRANT ALL on nagios.*</FONT></DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV>
<DIV><FONT color=#0000ff size=2>see snipet below:</FONT></DIV>
<DIV>mysql> show databases;<BR>+--------------------+<BR>| Database |<BR>+--------------------+<BR>| information_schema |<BR>| cactidb |<BR>| mysql |<BR>| nagios |<BR>| test |<BR>+--------------------+<BR>5 rows in set (0.00 sec)</DIV>
<DIV> </DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Michael Friedrich [mailto:michael.friedrich@univie.ac.at]<BR><B>Sent:</B> Friday, June 19, 2009 09:13 AM<BR><B>To:</B> 'Natalie Aloi'<BR><B>Cc:</B> 'Nagios Users Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDO Utilities install NDO database error for NDO Util 1.3.1<BR><BR></FONT>
<TABLE class="" id=201179 height=400 width="100%" bgColor=#ffffff border=0 text="#000000">
<TBODY>
<TR>
<TD class="" vAlign=top width="100%"><TT>That's just what I told you with these commands.<BR><BR>For what I've seen from your dirlisting, you have afile called "mysql.sql"<BR><BR>So after these steps you should have your datebase created and waiting for input.<BR><BR>Kind regards,<BR>Michael<BR></TT><BR>Natalie Aloi wrote the following on 19.06.2009 15:02:
<BLOCKQUOTE cite=mid:W158703147941821245416545@webmail31 type="cite">
<DIV><FONT face=Verdana color=#0000ff size=2>Thanks, I did that without a problem, but when I got to the section about creating the NDO database I am supposed to run a script called installdb which doesn't exist...Do you know how to create the NDO Database and the tables?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff size=2>Natalie</FONT></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,255) 2px solid; MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Michael Friedrich [<A class=moz-txt-link-freetext href="mailto:michael.friedrich@univie.ac.at" target=_blank>mailto:michael.friedrich@univie.ac.at</A>]<BR><B>Sent:</B> Friday, June 19, 2009 05:47 AM<BR><B>To:</B> 'Natalie Aloi'<BR><B>Cc:</B> 'Nagios Users Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDO Utilities install NDO database error for NDO Util 1.3.1<BR><BR></FONT>
<TABLE class="" id=201179 height=400 width="100%" bgColor=#ffffff border=0 text="#000000">
<TBODY>
<TR>
<TD class="" vAlign=top width="100%"><TT>Hi,<BR><BR>if it helps do the following:<BR><BR># mysql -u root -p<BR></TT><PRE wrap=""><TT>CREATE USER 'nagios'@'localhost' IDENTIFIED BY 'nagios';
GRANT USAGE ON * . * TO '</TT><TT><TT>nagios</TT></TT><TT>'@'localhost' IDENTIFIED BY
'<</TT><TT><TT>nagios</TT></TT><TT>>' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `</TT><TT><TT>nagios</TT></TT><TT>` ;
GRANT ALL PRIVILEGES ON `</TT><TT><TT>nagios</TT></TT><TT>` . * TO '<dbuser>'@'localhost';</TT></PRE><TT>quit<BR><BR># mysql -u root -p nagios < mysql.sql<BR><BR>Kind regards,<BR>Michael<BR></TT><TT><BR><BR><BR>Natalie Aloi wrote the following on 18.06.2009 22:50:</TT>
<BLOCKQUOTE cite=mid:W58194263074791245358241@webmail33 type="cite">
<TABLE class="" id=201179 height=400 width="100%" bgColor=#ffffff border=0>
<TBODY>
<TR>
<TD class="" vAlign=top width="100%">
<DIV><TT><FONT size=2><FONT size=1>Thanks for the reply Marc...</FONT></FONT></TT></DIV>
<DIV> </DIV>
<DIV><TT><FONT size=1>I am using ver 2.11 Nagios the most recent version of ndo utils said I had to have a higher version of nagios to use (2.5?) which is why I selected 1.3.1 </FONT></TT></DIV>
<DIV> </DIV>
<DIV><TT><FONT size=1>Natalie</FONT> </TT></DIV>
<DIV><TT><FONT size=2><FONT size=1>On Jun 17, 2009, at 11:09 AM, Natalie Aloi wrote:<BR><BR>> Hello I am attempting to install NDO Utils - I am at the Create NDO <BR>> Database section...except I don't have this installdb file in my db <BR>> directory I have what is below:<BR>> as you can see I am installing ndoutils 1.3.1 since I am using <BR>> nagios 2.11<BR>><BR><BR>1.3.1 is almost 2.5 years out-of-date. You're following instructions <BR>for 1.4b7; is there a reason you're not installing that more recent <BR>version?</FONT><BR></FONT></TT></DIV><TT>Network Operations Center Manager <BR>Experis Data Center LLC <BR>8209 Valley Pike <BR>PO Box 535 <BR>Middletown,VA 22645 <BR>phone:540-869-8702 <BR>cell:240-988-3267 <BR>fax:540-869-8710 <BR><A class=moz-txt-link-abbreviated href="mailto:e-mail:naloi@experisdatacenters.com" target=_blank mce_href="mailto:e-mail:naloi@experisdatacenters.com" moz-do-not-send="true">e-mail:naloi@experisdatacenters.com</A> </TT></TD></TR></TBODY></TABLE><PRE wrap=""><TT>
</TT><HR width="90%" SIZE=4><TT>
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
<A class=moz-txt-link-freetext href="http://p.sf.net/sfu/businessobjects" target=_blank mce_href="http://p.sf.net/sfu/businessobjects" moz-do-not-send="true">http://p.sf.net/sfu/businessobjects</A></TT></PRE><PRE wrap=""><TT>
</TT><HR width="90%" SIZE=4><TT>
_______________________________________________
Nagios-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:Nagios-users@lists.sourceforge.net" target=_blank mce_href="mailto:Nagios-users@lists.sourceforge.net" moz-do-not-send="true">Nagios-users@lists.sourceforge.net</A>
<A class=moz-txt-link-freetext href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target=_blank mce_href="https://lists.sourceforge.net/lists/listinfo/nagios-users" moz-do-not-send="true">https://lists.sourceforge.net/lists/listinfo/nagios-users</A>
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null</TT></PRE></BLOCKQUOTE><TT><BR></TT><PRE class=moz-signature cols="72"><TT>--
DI (FH) Michael Friedrich
<A class=moz-txt-link-abbreviated href="mailto:michael.friedrich@univie.ac.at" target=_blank mce_href="mailto:michael.friedrich@univie.ac.at" moz-do-not-send="true">michael.friedrich@univie.ac.at</A>
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
</TT></PRE></TD></TR></TBODY></TABLE></BLOCKQUOTE></BLOCKQUOTE><BR><PRE class=moz-signature cols="72">--
DI (FH) Michael Friedrich
<A class=moz-txt-link-abbreviated href="mailto:michael.friedrich@univie.ac.at" target=_blank>michael.friedrich@univie.ac.at</A>
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
</PRE>
<BLOCKQUOTE></BLOCKQUOTE></TD></TR></TBODY>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></html>