Problem With nagios with mysql

[Anthony Costa]

On Wed, Jul 28, 2004 at 12:50:34AM -0500, Manuel Alejandro Pe?a S?nchez wrote:
> 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
> 
>  
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password ''.  Status data will not be saved!
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password ''.  Retention data will not be processed or saved!
> 
> [1090941392] Error: Could not re-connect to database server on host '' for
> statu
> 
> s data.  I'll keep trying every 60 seconds...
> 
> 
> 
> Nagios is not taking the fileds of database on resources.cfg 
> 
>  
> 
>   _____  
> 
> De: nagios-users-admin at lists.sourceforge.net
> [mailto:nagios-users-admin at lists.sourceforge.net] En nombre de Anthony Costa
> Enviado el: martes, 27 de julio de 2004 18:43
> Para: nagios-users at lists.sourceforge.net
> Asunto: Re: [Nagios-users] Problem With nagios with mysql
> 
>  
> 
> 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:
> 
>  
> 
> Anthony:
> 
>  
> 
>  
> 
> 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.
> 
>  
> 
> Does any have an idea??
> 
>  
> 
> Regards
> 
>  
> 
>  
> 
>  
> 
> 
> De: nagios-users-admin at lists.sourceforge.net
> [mailto:nagios-users-admin at lists.sourceforge.net] En nombre de Anthony Costa
> Enviado el: martes, 27 de julio de 2004 14:51
> Para: nagios-users at lists.sourceforge.net
> Asunto: Re: [Nagios-users] Problem With nagios with mysql
> 
>  
> 
> make sure you have mysql installed and running.
> 
> then what you want to do here is this ... first extract the table setup
> into mysql using
> zcat /usr/share/doc/nagios-mysql/create_mysql.sql.gz | mysql
> -u root -p nagios
> 
> (the above file may be in a different place on your system, but a
> then create your locks for the mysql user
> GRANT LOCK TABLES ON nagios.* TO nagios at localhost IDENTIFIED
> BY 'password';
> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON nagios.* TO
> nagios at localhost;
> 
> then you're gonna need to edit your resource.cfg and cgi.cfg such that
> each one of the database fields correspond to machine=localhost,
> user=nagios, passwd=password specified above.
> 
> reboot and pray!
> ac;
> 
> On Jul 27, 2004, at 7:11 PM, Manuel Alejandro Pe?a S?nchez wrote:
> 
> I compiled nagios with suport of mysql, this are my parameters of configure:
> 
>  
> 
> ./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
> 
>  
> 
> The version of my nagios is 1.2
> 
>  
> 
> And the problem that I have is that nagios.log sends me this output:
> 
>  
> 
> [1090941392] Nagios 1.2 starting... (PID=18906)
> 
> [1090941392] Finished daemonizing... (New PID=18907)
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password ''.  Status data will not be saved!
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password ''.  Retention data will not be processed or saved!
> 
> [1090941392] Error: Could not re-connect to database server on host '' for
> statu
> 
> s data.  I'll keep trying every 60 seconds...
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password '' for comment data!
> 
> 
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password ''.  Status data will not be saved!
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password ''.  Retention data will not be processed or saved!
> 
> [1090941392] Error: Could not re-connect to database server on host '' for
> statu
> 
> s data.  I'll keep trying every 60 seconds...
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password '' for comment data!
> 
> 
> 
> 
> [1090941392] Error: Could not connect to MySQL database '' on host '' using
> user
> 
> name '' and password '' for downtime data!
> 
>  
> 
> And it starts but when it tries to check a host it doesn?t recognize any
> check program and sends this output:
> 
>  
> 
> [1090941492] HOST ALERT: linux1;DOWN;SOFT;9;CRITICAL - Plugin timed out
> after 10
> 
>  Seconds
> 
>  
> 
> And on some times it sends that nagios doesn?t found a check_xxx plugin,
> beside I have compiled also the nagios-plugins source.
> 
>  
> 
> May any one help me, also I want to know if any one have a dump of mysql
> tables for nagios.
> 
>  
> 
> Regards
> 
>  
> 
> Manuel
> 
didn't you say that you had prepared mysql with the
nagios_mysql.sql.gz file i specified previously?

ac;


-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
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