R: R: configuration tool

[Marco Borsani]

I agree, because I have No problem if I install nagiosql in the MySQL server.

 

I already add a couple of user with grant as follow:

 

On MySQL Server

MySQL> create user root@<ip-nagiosserver> ;

MySQL> grant all on mysql.* to root@’<ip-nagiosserver>' identified by 'password';

MySQL> grant all on db_nagiosql_v3.* to root@’<ip-nagiosserver>' identified by 'password';

MySQL> flush privileges ;

 

but I still received :



 

 

 

 

 

 

 

Da: Giorgio Zarrelli [mailto:zarrelli at linux.it] 
Inviato: giovedì 17 novembre 2011 12:38
A: Marco Borsani
Cc: Nagios Users List
Oggetto: Re: R: [Nagios-users] configuration tool

 

It's just a MySQL right access problem. Please, describe what you are doing, step by step, so we can debug and help  you.

 

As a first hint I suggest you to create on mysql db a user ''root'@'yournagiosqlwebserverip' Würth a GRANT ALL ON *.*  

 

Then on mysql server issue a 'flush privileges'

 

Then, ho on with nagiosql installation and at the end remote from mysql server the root'@'yournagiosqlwebserverip' and flush again the privileges.


Ciao,

 

Giorgio


Il giorno 17/nov/2011, alle ore 12:21, "Marco Borsani" <m.borsani at it.net> ha scritto:

Now , web pages are ok.

 

Have anybody  installed nagiosql and MySQL in different hosts ?

 

I think to install nagiosql in the same server than Nagios and keeping MySQL DB in the other … but I have some grant problem (“Access denied for user root at ip-address” during the creation of NagiosQL MySQL user).

 

Marco

 

Da: Giorgio Zarrelli [mailto:zarrelli at linux.it] 
Inviato: martedì 15 novembre 2011 11:43
A: Nagios Users List
Cc: NAGIOS
Oggetto: Re: [Nagios-users] configuration tool

 

I use NagioSQL and it supports remote configuration.

Ciao,

 

Giorgio


Il giorno 15/nov/2011, alle ore 10:08, "Marco Borsani" <m.borsani at it.net> ha scritto:

Hi all

 

I am using following configurations:

 

Site A:  2 server in cluster – node “1” running nagios 3.3.1 (and NSCA), node “2” running mysql

Site B:  2 server in cluster – node “1” running nagios 3.3.1 (send info with send_nsca to site A), node “2” running mysql

Site C:  2 server in cluster – node “1” running nagios 3.3.1 (send info with send_nsca to site A), node “2” running mysql

 

I’d like to use one of the configuration tool (one on each site , or one for all the sites…it will depend if it is possible), but I am not sure that “NConf”, “NagiosQL”, etc. can support this configuration.

For example, I read that “NConf” require Nagios Core and Mysql both in the same server, is it true ?

 

May you give me any info?

 

regards

 

Marco Borsani

Unix and Monitoring Sysadmin

Technical Operations Dpt.

tel: +39 010 4310115

fax: +39 02 30130311

cell: +39 329 5953944

ITnet Srl

Società con socio unico

Direzione e Coordinamento di …

 

------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1

_______________________________________________
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111117/c666272c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 48306 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111117/c666272c/attachment.jpg>
-------------- next part --------------
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
-------------- 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