<html><head></head><body bgcolor="#FFFFFF"><div>It's just a MySQL right access problem. Please, describe what you are doing, step by step, so we can debug and help you.</div><div><br></div><div>As a first hint I suggest you to create on mysql db a user ''root'@'yournagiosqlwebserverip' Würth a GRANT ALL ON *.* </div><div><br></div><div>Then on mysql server issue a 'flush privileges'</div><div><br></div><div>Then, ho on with nagiosql installation and at the end remote from mysql server the root'@'yournagiosqlwebserverip' and flush again the privileges.</div><div><br>Ciao,<div><br></div><div>Giorgio</div></div><div><br>Il giorno 17/nov/2011, alle ore 12:21, "Marco Borsani" <<a href="mailto:m.borsani@it.net">m.borsani@it.net</a>> ha scritto:<br><br></div><div></div><blockquote type="cite"><div><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.StileMessaggioDiPostaElettronica17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.StileMessaggioDiPostaElettronica18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 2.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--><div class="WordSection1"><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D">Now , web pages are ok.<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D">Have anybody installed nagiosql and MySQL in different hosts ?<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D">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@ip-address” during the creation of NagiosQL MySQL user).<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D">Marco<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D"><o:p> </o:p></span></p><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif";mso-fareast-language:IT">Da:</span></b><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif";mso-fareast-language:IT"> Giorgio Zarrelli [mailto:zarrelli@linux.it] <br><b>Inviato:</b> martedì 15 novembre 2011 11:43<br><b>A:</b> Nagios Users List<br><b>Cc:</b> NAGIOS<br><b>Oggetto:</b> Re: [Nagios-users] configuration tool<o:p></o:p></span></p></div></div><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal">I use NagioSQL and it supports remote configuration.<br><br>Ciao,<o:p></o:p></p><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">Giorgio<o:p></o:p></p></div></div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>Il giorno 15/nov/2011, alle ore 10:08, "Marco Borsani" <<a href="mailto:m.borsani@it.net">m.borsani@it.net</a>> ha scritto:<o:p></o:p></p></div><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><p class="MsoNormal">Hi all<o:p></o:p></p><p class="MsoNormal"> <o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">I am using following configurations:</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">Site A: 2 server in cluster – node “1” running nagios 3.3.1 (and NSCA), node “2” running mysql</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">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</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">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</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">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.</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">For example, I read that “NConf” require Nagios Core and Mysql both in the same server, is it true ?</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">May you give me any info?</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB">regards</span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:9.0pt;font-family:"Arial","sans-serif";mso-fareast-language:IT">Marco Borsani</span><o:p></o:p></p><p class="MsoNormal"><b><span lang="EN-GB" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#FFC000;mso-fareast-language:IT">Unix and Monitoring Sysadmin</span></b><o:p></o:p></p><p class="MsoNormal"><b><span lang="EN-GB" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#FFC000;mso-fareast-language:IT">Technical Operations Dpt.</span></b><o:p></o:p></p><p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";mso-fareast-language:IT">tel: +39 010 4310115</span><o:p></o:p></p><p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";mso-fareast-language:IT">fax: +39 02 30130311</span><o:p></o:p></p><p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";mso-fareast-language:IT">cell: +39 329 5953944</span><o:p></o:p></p><p class="MsoNormal"><span style="font-size:7.0pt;font-family:"Arial","sans-serif";mso-fareast-language:IT">ITnet Srl</span><o:p></o:p></p><p class="MsoNormal"><span style="font-size:7.0pt;font-family:"Arial","sans-serif";mso-fareast-language:IT">Società con socio unico</span><o:p></o:p></p><p class="MsoNormal"><span style="font-size:7.0pt;font-family:"Arial","sans-serif";mso-fareast-language:IT">Direzione e Coordinamento di …</span><o:p></o:p></p><p class="MsoNormal"> <o:p></o:p></p></div></blockquote><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:IT">------------------------------------------------------------------------------<br>RSA(R) Conference 2012<br>Save $700 by Nov 18<br>Register now<br><a href="http://p.sf.net/sfu/rsa-sfdev2dev1">http://p.sf.net/sfu/rsa-sfdev2dev1</a><o:p></o:p></span></p></div></blockquote><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:IT">_______________________________________________<br>Nagios-users mailing list<br><a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a><br><a href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><br>::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. <br>::: Messages without supporting info will risk being sent to /dev/null<o:p></o:p></span></p></div></blockquote></div></div></blockquote></body></html>