NDO Utilities install NDO database error for NDO Util 1.3.1

[Michael Friedrich]

# mysql -u root -p

 >> open database shell

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 'nagios'@'localhost' IDENTIFIED BY 
'nagios' 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 `nagios` ;

>> creates the database called nagios needed for ndo (you have to set those params in ndo2db.cfg)

GRANT ALL PRIVILEGES ON `nagios` . * TO 'nagios'@'localhost';

>> grants insert, create, delete, select, update, etc sql privileges for user nagios (forgot to replace that too), onto the database nagios


quit

 >> leave mysql shell


# mysql -u root -p nagios < mysql.sql

 >> -u root -p <-- login with user root
 >> nagios <-- import to which database
 >> < mysql.sql <-- file where the database definitions, table 
definitions are within create statements, those will be imported into 
the database


And cocnernign your db layout - yep, it's the nagios db.

Kind regards,
Michael



Natalie Aloi wrote the following on 19.06.2009 15:40:
> 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.*
>  
> see snipet below:
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | cactidb            |
> | mysql              |
> | nagios             |
> | test               |
> +--------------------+
> 5 rows in set (0.00 sec)
>  
>
>     -----Original Message-----
>     *From:* Michael Friedrich [mailto:michael.friedrich at univie.ac.at]
>     *Sent:* Friday, June 19, 2009 09:13 AM
>     *To:* 'Natalie Aloi'
>     *Cc:* 'Nagios Users Mail-list'
>     *Subject:* Re: [Nagios-users] NDO Utilities install NDO database
>     error for NDO Util 1.3.1
>
>     That's just what I told you with these commands.
>
>     For what I've seen from your dirlisting, you have afile called
>     "mysql.sql"
>
>     So after these steps you should have your datebase created and
>     waiting for input.
>
>     Kind regards,
>     Michael
>
>     Natalie Aloi wrote the following on 19.06.2009 15:02:
>>     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?
>>      
>>     Natalie
>>
>>         -----Original Message-----
>>         *From:* Michael Friedrich [mailto:michael.friedrich at univie.ac.at]
>>         *Sent:* Friday, June 19, 2009 05:47 AM
>>         *To:* 'Natalie Aloi'
>>         *Cc:* 'Nagios Users Mail-list'
>>         *Subject:* Re: [Nagios-users] NDO Utilities install NDO
>>         database error for NDO Util 1.3.1
>>
>>         Hi,
>>
>>         if it helps do the following:
>>
>>         # mysql -u root -p
>>
>>         CREATE USER 'nagios'@'localhost' IDENTIFIED BY 'nagios';
>>
>>         GRANT USAGE ON * . * TO 'nagios'@'localhost' IDENTIFIED BY 
>>         '<nagios>' 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 `nagios` ;
>>
>>         GRANT ALL PRIVILEGES ON `nagios` . * TO '<dbuser>'@'localhost';
>>
>>         quit
>>
>>         # mysql -u root -p nagios < mysql.sql
>>
>>         Kind regards,
>>         Michael
>>
>>
>>
>>         Natalie Aloi wrote the following on 18.06.2009 22:50:
>>>         Thanks for the reply Marc...
>>>          
>>>         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
>>>          
>>>         Natalie 
>>>         On Jun 17, 2009, at 11:09 AM, Natalie Aloi wrote:
>>>
>>>         > Hello I am attempting to install NDO Utils - I am at the
>>>         Create NDO
>>>         > Database section...except I don't have this installdb file
>>>         in my db
>>>         > directory I have what is below:
>>>         > as you can see I am installing ndoutils 1.3.1 since I am
>>>         using
>>>         > nagios 2.11
>>>         >
>>>
>>>         1.3.1 is almost 2.5 years out-of-date. You're following
>>>         instructions
>>>         for 1.4b7; is there a reason you're not installing that more
>>>         recent
>>>         version?
>>>         Network Operations Center Manager
>>>         Experis Data Center LLC
>>>         8209 Valley Pike
>>>         PO Box 535
>>>         Middletown,VA 22645
>>>         phone:540-869-8702
>>>         cell:240-988-3267
>>>         fax:540-869-8710
>>>         e-mail:naloi at experisdatacenters.com
>>>
>>>
>>>         ------------------------------------------------------------------------
>>>
>>>         ------------------------------------------------------------------------------
>>>         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.
>>>         http://p.sf.net/sfu/businessobjects
>>>
>>>         ------------------------------------------------------------------------
>>>
>>>         _______________________________________________
>>>         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
>>
>>         -- 
>>         DI (FH) Michael Friedrich
>>         michael.friedrich at univie.ac.at
>>         Tel: +43 1 4277 14359
>>
>>         Vienna University Computer Center
>>         Universitaetsstrasse 7 
>>         A-1010 Vienna, Austria  
>>
>
>     -- 
>     DI (FH) Michael Friedrich
>     michael.friedrich at univie.ac.at
>     Tel: +43 1 4277 14359
>
>     Vienna University Computer Center
>     Universitaetsstrasse 7 
>     A-1010 Vienna, Austria  
>               
>

-- 
DI (FH) Michael Friedrich
michael.friedrich at univie.ac.at
Tel: +43 1 4277 14359

Vienna University Computer Center
Universitaetsstrasse 7 
A-1010 Vienna, Austria  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090619/a20e36bf/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
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.
http://p.sf.net/sfu/businessobjects
-------------- next part --------------
_______________________________________________
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