# 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.friedr...@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.friedr...@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:na...@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@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.friedr...@univie.ac.at
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
--
DI (FH) Michael Friedrich
michael.friedr...@univie.ac.at
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
--
DI (FH) Michael Friedrich
michael.friedr...@univie.ac.at
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
------------------------------------------------------------------------------
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@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
