Strange MySQL problem, can't seem to figure out

[Kris Dahl]

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/