The Groundwork Open Source Monitor Installation Guide mentions:
Step 6 - Network Configuration
1. MySQL uses the localhost entry in /etc/hosts. Make sure that the localhost entry looks like the example below.
Also, make sure that localhost is first after the IP address followed by localhost.localdomain. Replace
192.168.2.100 with the IP address of the system, and groundworkserver with the real Host name. Example:
groundworkserver.mycompany.com is the fully qualified domain name where the GroundWork Monitor server is
installed. Also, make sure TCP port 3306 is not blocked by your firewall rules. This port is for communication to the
MySQL server.
127.0.0.1 localhost localhost.localdomain
192.168.2.100 groundworkserver groundworkserver.mycompany.com
This requirement for an incorrect /etc/hosts format is wrong, if this only to deal with the bug in MySQL this should not be required by Groundwork Open Source Monitor.
To quote Gabor Gombas and Christoph Haas in the discussion on the Debian Devel mailing list about this issue with MySQL:
On Fri, Sep 23, 2005 at 08:01:05PM +0200, Christoph Haas wrote:
> It appears like MySQL does that. It seems to check the IP address of the
> connecting client to find the permissions in it's internal `users`
> table. So it sees "127.0.0.1" and looks up "localhost.localdomain" which
> it cannot find since it expects "localhost".
Well, I don't think it's MySQL that expects "localhost", it's more like
you have added users in the form of "
user@localhost" instead of
"
[email protected]". These two forms are _not_ the same as far
as MySQL is concerned.
Ok, after a quick googling I found that this bug has already been
reported for MySQL:
http://bugs.mysql.com/11822 and is fixed in MySQL
5.0.11. So if it bothers you, you should upgrade.
http://lists.debian.org/debian-devel/2005/09/msg01149.html
Since Groundwork Open Source Monitor requires MySQL >= 5.0.18, this MySQL bug should not be an issue.
Unless other components of Groundwork Open Source Monitor require the /etc/hosts file to be in this incorrect format, the user should not be required to change his /etc/hosts file to an incorrect format.
Bug
Standard
NAME
hosts - The static table lookup for host names
SYNOPSIS
/etc/hosts
DESCRIPTION
This manual page describes the format of the /etc/hosts file. This file is a simple text file that associates IP addresses
with hostnames, one line per IP address. For each host a single line should be present with the following information:
IP_address canonical_hostname aliases
Fields of the entry are separated by any number of blanks and/or tab characters. Text from a "#" character until the end
of the line is a comment, and is ignored. Host names may contain only alphanumeric characters, minus signs ("-"), and
periods ("."). They must begin with an alphabetic character and end with an alphanumeric character. Aliases provide for
name changes, alternate spellings, shorter hostnames, or generic hostnames (for example, localhost). The format of the
host table is described in RFC 952.
[...]