Problem With nagios with mysql

[Anthony Costa]

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 '' 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 10163 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20040727/639c4e64/attachment.bin>