NDO Utilities install NDO database error for NDO Util 1.3.1
Michael Friedrich
michael.friedrich at univie.ac.at
Fri Jun 19 16:11:28 CEST 2009
# 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
More information about the Users
mailing list