[Pkg-nagios-devel] Bug#311695: Rather difficult to reproduce

Don Armstrong Don Armstrong <don@debian.org>, 311695@bugs.debian.org
Thu, 2 Jun 2005 21:25:03 -0700

[Just to reiterate what we discussed on IRC for those following along
at home.]

On Fri, 03 Jun 2005, Andres Salomon wrote:
> Nope; nagios's resource.cfg was totally unconfigured. What I suspect
> (I can tell you for sure tomorrow, when I'm at work) is that one of
> the default mysql users (the '' user) was not removed; so, nagios
> could connect with user '', and no password. Just doing a fresh
> mysql-server install and a nagios-mysql install gets me:
> Jun  2 23:56:10 spiral nagios: Error: Could not lock status data tables
> in database ''
> Jun  2 23:56:40 spiral last message repeated 2 times
> Jun  2 23:57:40 spiral last message repeated 4 times
> Same type of error, though not nearly as frequently.

You couldn't get this unless you allow a blank user to connect to
mysql, which isn't the default configuration of mysql-server.
> Only if you've modified the mysql.user table to not accept a blank user.

By default, the only users are 'root' and 'debian-sys-maint'.

Don Armstrong

"A one-question geek test. If you get the joke, you're a geek: Seen on
a California license plate on a VW Beetle: 'FEATURE'..."
 -- Joshua D. Wachs - Natural Intelligence, Inc.

http://www.donarmstrong.com              http://rzlab.ucr.edu