<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <meta name=Generator content="Microsoft Word 11 (filtered medium)">  <style>  </style> </head> <body lang=ES link=blue vlink=purple> <div class=Section1> The thing is this on my source of nagios and nagios-plugins did not came de dump of mysql and the weird thing is this message on nagios.log<o:p></o:p> <o:p> </o:p> [1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password ''. Status data will not be saved! <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password ''. Retention data will not be processed or saved! <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not re-connect to database server on host '' for statu <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>s data. I'll keep trying every 60 seconds... <?/bigger><?/bigger><?/fontfamily><o:p></o:p> Nagios is not taking the fileds of database on resources.cfg <o:p></o:p> <o:p> </o:p> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center tabindex=-1> </div> De: nagios-users-admin@lists.sourceforge.net [mailto:nagios-users-admin@lists.sourceforge.net] En nombre de Anthony Costa Enviado el: martes, 27 de julio de 2004 18:43 Para: nagios-users@lists.sourceforge.net Asunto: Re: [Nagios-users] Problem With nagios with mysql<o:p></o:p> </div> <o:p> </o:p> sorry about the confusion. in that case, if all that is set, i don't know what to tell you from here. could you include a dump of your mysql nagiosdb tables after expanding the nagios mysql template? ac; On Jul 28, 2004, at 12:04 AM, Manuel Alejandro Peña Sánchez wrote:<o:p></o:p> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger> <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger>Anthony: <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger> <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger> <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger>I have done that, the thing is that my nagios doesn’t recognize the mysql Server and i dont have a .deb o the dump of nagios database, I also have my database fields typed on my resources.cfg and my cgi.cfg. <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger> <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger>Does any have an idea?? <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger> <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger>Regards <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger> <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Arial><?color><?param 0000,0000,8080><?x-tad-bigger> <?/x-tad-bigger><?/color><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Tahoma><?x-tad-bigger>De:<?/x-tad-bigger><?/fontfamily><?fontfamily><?param Tahoma><?x-tad-bigger> nagios-users-admin@lists.sourceforge.net [mailto:nagios-users-admin@lists.sourceforge.net] <?x-tad-bigger><?/x-tad-bigger>En nombre de <?/x-tad-bigger><?x-tad-bigger>Anthony Costa <?/x-tad-bigger><?/fontfamily><?fontfamily><?param Tahoma><?x-tad-bigger>Enviado el:<?/x-tad-bigger><?/fontfamily><?fontfamily><?param Tahoma><?x-tad-bigger> martes, 27 de julio de 2004 14:51 <?/x-tad-bigger><?/fontfamily><?fontfamily><?param Tahoma><?x-tad-bigger>Para:<?/x-tad-bigger><?/fontfamily><?fontfamily><?param Tahoma><?x-tad-bigger> nagios-users@lists.sourceforge.net <?/x-tad-bigger><?/fontfamily><?fontfamily><?param Tahoma><?x-tad-bigger>Asunto:<?/x-tad-bigger><?/fontfamily><?fontfamily><?param Tahoma><?x-tad-bigger> Re: [Nagios-users] Problem With nagios with mysql <?/x-tad-bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>make sure you have mysql installed and running. <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>then what you want to do here is this ... first extract the table setup <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>into mysql using <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>zcat /usr/share/doc/nagios-mysql/create_mysql.sql.gz | mysql <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>-u root -p nagios <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>(the above file may be in a different place on your system, but a <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>then create your locks for the mysql user <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>GRANT LOCK TABLES ON nagios.* TO nagios@localhost IDENTIFIED <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>BY 'password'; <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON nagios.* TO <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>nagios@localhost; <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>then you're gonna need to edit your resource.cfg and cgi.cfg such that <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>each one of the database fields correspond to machine=localhost, <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>user=nagios, passwd=password specified above. <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>reboot and pray! <?/bigger><?/bigger><?/fontfamily><?fontfamily><?param Times New Roman><?bigger><?bigger>ac; <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>On Jul 27, 2004, at 7:11 PM, Manuel Alejandro Peña Sánchez wrote: <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>I compiled nagios with suport of mysql, this are my parameters of configure: <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>./configure --prefix=/usr/local/nagios --with-cgiurl=/cgi-bin --with-htmurl=/nagios --with-nagios-user=nagios --with-nagios-grp=nagios --with-mysql-lib=/usr/lib --with-mysql-inc=/usr/include/mysql --with-mysql-status --with-mysql-comments --with-mysql-extinfo --with-mysql-retention --with-mysql-downtime --with-mysql-xdata --libexecdir=/usr/local/nagios/libexec <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>The version of my nagios is 1.2 <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>And the problem that I have is that nagios.log sends me this output: <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Nagios 1.2 starting... (PID=18906) <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Finished daemonizing... (New PID=18907) <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password ''. Status data will not be saved! <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password ''. Retention data will not be processed or saved! <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not re-connect to database server on host '' for statu <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>s data. I'll keep trying every 60 seconds... <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password '' for comment data! <?/bigger><?/bigger><?/fontfamily><o:p></o:p> [1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password ''. Status data will not be saved! <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password ''. Retention data will not be processed or saved! <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not re-connect to database server on host '' for statu <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>s data. I'll keep trying every 60 seconds... <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password '' for comment data! <?/bigger><?/bigger><?/fontfamily><o:p></o:p> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941392] Error: Could not connect to MySQL database '' on host '' using user <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>name '' and password '' for downtime data! <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>And it starts but when it tries to check a host it doesn’t recognize any check program and sends this output: <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>[1090941492] HOST ALERT: linux1;DOWN;SOFT;9;CRITICAL - Plugin timed out after 10 <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> Seconds <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>And on some times it sends that nagios doesn’t found a check_xxx plugin, beside I have compiled also the nagios-plugins source. <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>May any one help me, also I want to know if any one have a dump of mysql tables for nagios. <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>Regards <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger> <?/bigger><?/bigger><?/fontfamily> <?fontfamily><?param Times New Roman><?bigger><?bigger>Manuel<o:p></o:p> <?/bigger><?/bigger><?/fontfamily></div> </body> </html>