Nagios-MySQL Locking Issues?

[Andreas Ericsson]

William R. Lorenz wrote:
> Greetings,
> 
> When starting NAGIOS, it doesn't seem that it's able to lock the tables 
> correctly and write status information to the database.  Specifically:
> 
>   Nagios 1.2 starting... (PID=12131)
>   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 ''
> 

Could not lock status data tables in database ''
means you haven't specified a database. It's no wonder nagios can't 
update things in the (void *)0 database.

Anyways. Database support has been removed in nagios 2.0, so you might 
want to drop it as well.

> I've even tried granting NAGIOS global access in MySQL, and this doesn't 
> seem to help.  Is there something obvious I'm missing here?  I'd greatly 
> appreciate any ideas you guys might have.  Thanks, in advance.
> 
> --          _ __ __ ___ _| | William R. Lorenz <wrl at express.org> \ V  V 
> / '_| | http://www.express.org/~wrl/ ; "Every revolution was first
>  \./\./|_| |_| a thought in one man's mind." - Ralph Waldo Emerson
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when 
> reporting any issue. ::: Messages without supporting info will risk 
> being sent to /dev/null
> 

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Lead Developer


-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null