Bug#290760: followup on mysql-related nagios bugs

[sean finney]

hi folks,

i believe the issues with nagios-mysql (ie FROM_UNIXTIME) have been
resolved for some time, so unless i hear back from you that you're
still having trouble with the latest versions of nagios/mysql
i will close these bugs in a week's time.


thanks to all for their help,
sean

-- 


signature.asc
Description: Digital signature

Bug#290760: nagios-mysql could not read host and service status information

[Carl T. Miller]

Package: nagios-mysql
Version: 2:1.3-0+pre6

Since upgrading nagios-mysql a couple of weeks ago nagios runs
and sends email notices, but clicking for a Tactical Overview
presents the error could not read host and service status
information.

To resolve this, I verified everything, and there were no
errors in the config files.  MySQL was running and the tables
were being updated.  So I uninstalled everything and started
from scratch.

Now everything is configured correctly, and all the services
are running correctly, yet I still get the error message.
I ran /etc/nagios/check_nagios_db from a shell prompt just
to see the output.  It said: Nagios problem: no process
identifier found in the database.  That error comes from the
test if (!$status{nagios_pid}).




-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Bug#290760: More about the error

[Carl T. Miller]

I did some more digging and discovered this line in /var/log/syslog:

Error: Could not insert/update status record for program in table
'programstatus' of database 'nagios'

The user [EMAIL PROTECTED] has USAGE permissions globally and
ALL PRIVILEGES in the database nagios.

Is it possible this is a problem with mysql?



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Bug#290760:

[Roy Bonser]

See bug 289762 for more info. There is a problem with mysql-server.
  --Roy

--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Bug#290760: [Pkg-nagios-devel] Bug#290760: More about the error

[sean finney]

On Sun, Jan 16, 2005 at 10:17:56AM -0500, Carl T. Miller wrote:
 I did some more digging and discovered this line in /var/log/syslog:
 
 Error: Could not insert/update status record for program in table
 'programstatus' of database 'nagios'
 
 The user [EMAIL PROTECTED] has USAGE permissions globally and
 ALL PRIVILEGES in the database nagios.
 
 Is it possible this is a problem with mysql?

yup.  see #289762.


sean

-- 


signature.asc
Description: Digital signature