<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt># mysql -u root -p<br>
<br>
>> open database shell<br>
<br>
</tt>
<pre wrap=""><tt>CREATE USER 'nagios'@'localhost' IDENTIFIED BY 'nagios';
>> creates the user nagios with localhost (where it will coem from) and is identified by password '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 ;
>> there was a typo by myself, identified by has to be the passwword with '<' and '>'
this grants usage on the database
CREATE DATABASE IF NOT EXISTS `</tt><tt><tt>nagios</tt></tt><tt>` ;
>> creates the database called nagios needed for ndo (you have to set those params in ndo2db.cfg)
GRANT ALL PRIVILEGES ON `</tt><tt><tt>nagios</tt></tt><tt>` . * TO 'nagios'@'localhost';
>> grants insert, create, delete, select, update, etc sql privileges for user nagios (forgot to replace that too), onto the database nagios
</tt></pre>
<tt>quit<br>
<br>
>> leave mysql shell<br>
<br>
<br>
# mysql -u root -p nagios < mysql.sql<br>
<br>
>> -u root -p <-- login with user root<br>
>> nagios <-- import to which database<br>
>> < mysql.sql <-- file where the database definitions,
table definitions are within create statements, those will be imported
into the database<br>
<br>
<br>
And cocnernign your db layout - yep, it's the nagios db.<br>
<br>
Kind regards,<br>
Michael<br>
<br>
<br>
</tt><br>
Natalie Aloi wrote the following on 19.06.2009 15:40:
<blockquote cite="mid:W1750567325221245418812@webmail42" type="cite">
<div><font color="#0000ff" face="Verdana" 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> </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="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; 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">mailto:michael.friedrich@univie.ac.at</a>]<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" text="#000000" bgcolor="#ffffff"
border="0" height="400" width="100%">
<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 color="#0000ff" face="Verdana" 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="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;"><font
face="Tahoma" size="2">-----Original Message-----<br>
<b>From:</b> Michael Friedrich [<a moz-do-not-send="true"
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" text="#000000"
bgcolor="#ffffff" border="0" height="400" width="100%">
<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" bgcolor="#ffffff"
border="0" height="400" width="100%">
<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 size="4" width="90%"><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 size="4" width="90%"><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 moz-do-not-send="true" 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>
</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">michael.friedrich@univie.ac.at</a>
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
</pre>
</body>
</html>