Strange MySQL problem, can't seem to figure out

[Balestra, Roberto]

In your sample you use password nagios but in your cfg file used password 'password'.
If this is not an example this may be your problem.
Bye
	Roberto

> -----Original Message-----
> From: Kris Dahl [mailto:krislists at sledge-hammer.net]
> Sent: mercoledì 11 dicembre 2002 10.25
> To: nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] Strange MySQL problem, can't seem to 
> figure out
> 
> 
> I've compiled in support, and configured resource.cfg and 
> cgi.cfg with the
> proper hostname, port, database, username, password, etc
> 
> Ran the contrib/database/create_mysql, and verified that the 
> tables are
> there.
> 
>     [root at vodka database]# mysql -u nagios -p nagios
>     mysql> show tables;
>     +------------------+
>     | Tables_in_nagios |
>     +------------------+
>     | hostcomments     |
>     | hostdowntime     |
>     | hostextinfo      |
>     | hostretention    |
>     | hoststatus       |
>     | programretention |
>     | programstatus    |
>     | servicecomments  |
>     | servicedowntime  |
>     | serviceextinfo   |
>     | serviceretention |
>     | servicestatus    |
>     +------------------+
>     12 rows in set (0.00 sec)
> 
> 
> And the 'pre-flight' check (nagios -v) comes back with 0 
> errors, 0 warnings
> (well not the first time, but it does now :)).
> 
>     [root at vodka etc]# /usr/local/nagios/bin/nagios -v
> /usr/local/nagios/etc/nagios.cfg
>     Total Warnings: 0
>     Total Errors:   0
> 
> 
> Yet I'm getting the following error(s)
> 
>     [root at vodka etc]# /usr/local/nagios/bin/nagios
> /usr/local/nagios/etc/nagios.cfg
> 
>     Nagios 1.0
> 
>     Nagios 1.0 starting... (PID=25132)
>     Error: Could not read program retention data from table 
> programretention
>     Error: Could not read host retention data from table hostretention
>     Error: Could not read service retention data from table 
> serviceretention
>     Error: Could not lock status data tables in database ''
>     Error: Could not lock status data tables in database ''
>     Error: Could not lock status data tables in database ''
>     Error: Could not lock status data tables in database ''
>     ...
>     Error: Could not lock status data tables in database ''
> 
> 
> What is strange is that (according to what I've read in the 
> lists, etc.) is
> that it seems like its not really getting the MySQL 
> configurtion from the
> resource.cfg.  It shoul dbe saying something like
>     "Error: Could not lock status data tables in database 'nagios'"
> right?
> 
> Here is a snippet of my resource.cfg file
> 
> xrddb_host=localhost
> xrddb_port=3306
> xrddb_database=nagios
> xrddb_username=nagios
> xrddb_password=password
> xrddb_optimize_data=1
> 
> 
> Anyone have any ideas?
> 
> Thanks!
> 
> -k
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:
> With Great Power, Comes Great Responsibility 
> Learn to use your power at OSDN's High Performance Computing Channel
> http://hpc.devchannel.org/
> _______________________________________________
> 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:
With Great Power, Comes Great Responsibility 
Learn to use your power at OSDN's High Performance Computing Channel
http://hpc.devchannel.org/