Problem with Nagios & MySQL

[Mark Gillett]

Hi ,

Did you create the databases from the scripts in the /xdata/contrib/
directory in the distribution ?

Regards,

Mark


-----Original Message-----
From: nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net]On Behalf Of Marc
Powell
Sent: Friday, September 20, 2002 8:52 PM
To: Jarbas Peixoto Junior - DATAPREVGO;
nagios-users at lists.sourceforge.net
Subject: RE: [Nagios-users] Problem with Nagios & MySQL


Did you make the appropriate changes to resource.cfg and cgi.cfg?

Marc

> -----Original Message-----
> From: Jarbas Peixoto Junior - DATAPREVGO
> [mailto:jarbas.peixoto at go.previdenciasocial.gov.br]
> Sent: Friday, September 20, 2002 2:06 PM
> To: nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] Problem with Nagios & MySQL
>
> When I install NAGIOS without using MySQL everything it usually works.
> Trying to install with the support to MySQL obtains:
>
> [root at lxgod002 nagios-1.0b6] #it configure --with-mysql-comments
> --with-mysql-extinfo --with-mysql-retention --with-mysql-downtime
> ....
> * * * Configuration summary for nagios 1.0b6 09-15-2002 * * *:
>
>  General Options:
>  -------------------------
>         Nagios user/group: nagios,nagios
>        Command user/group: nagios,nagios
>             Embedded Perl:  in the
>         Install ${prefix}: /usr/local/nagios
>                 Lock cribs:  ${prefix}/var/nagios.lock
>            Init directory:  /etc/rc.d/init.d
>
>  Web Interface Options:
>  ------------------------
>                  HTML URL:  http://localhost/nagios /
>                   CGI URL:  http://localhost/nagios/cgi-bin /
>  TRACEROUTE (USED BY WAP): /USR/SBIN/TRACEROUTE
>
>  External Data Routines:
>  ------------------------
>               Status data:  Default (text file)
>               Object data:  Template-based (text file)
>              Comment data:  Database (MySQL)
>             Downtime data:  Database (MySQL)
>            Retention data:  Database (MySQL)
>           Peformance data:  Default (external commands)
>        Extended info data:  Database (MySQL)
>
>
> Review the options above for accuracy.  If they look okay,
> type ' make all' to compile the main program and CGIs.
>
> [root at lxgod002 nagios-1.0b6] #
> [root at lxgod002 nagios-1.0b6] #make all
> [root at lxgod002 nagios-1.0b6] #make install
> [root at lxgod002 nagios-1.0b6] #make install-init
> [root at lxgod002 nagios-1.0b6] #make install-commandmode
> [root at lxgod002 nagios-1.0b6] #make install-config
> [root at lxgod002 nagios-1.0b6] #cd
> .
> .
> .
> [root at lxgod002 init.d] #. /nagios start
> Starting network monitor: nagios
>   PID TTY TIME CMD
>  7349?        00:00:00 nagios
> [root at lxgod002 init.d] #
>
> Everything was accomplished following the constant orientations in the
> manuals, however in the file
> /usr/local/nagios/var/nagios.log have:
>
> [1032541538] Error: Could not connect to MySQL database '' on host ''
> using
> username '' and password ''. Retention data will not be processed or
> saved!
>
> [1032541538] Error: Could not connect to MySQL database '' on host ''
> using
> username '' and password '' for comment data!
> [1032541538] Error: Could not connect to MySQL database '' on host ''
> using
> username '' and password '' for downtime it data!
>
> BD was already created (nagios) in MySQL, the tables were created
> following
> the contrib/database/create_mysql, access was given to the user (nagios),
> and everything more.
>
> What can acontecento be?
> I point out that without MySQL everything usually works.
>
> Forced to all by any idea!
>
>             _  ______________________________  _
>            / )|     Jarbas Peixoto Júnior    |( \
>           / / |    Analista Téc. Informação  | \ \
>         _( (_ |  _    (0xx62) 501-2245    _  | _) )_
>        (((\ \)|_/ )______________________( \_|(/ /)))
>        (\ \  \_/ /                        \ \_/ ////)
>         \    \\ /    Linuxuser: 198445     \ //    /
>          \    _/                            \_    /
>          /   /  Dataprev - Goiânia - BRASIL   \   \
>         /___/                    ´´´           \___\
>                                 (o o)
> -----------------------------oOO-(_)-OOo-----------------------------
> Eu apóio o Software Livre
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf