RE: [Perfparse-users] perfparse mysql: access denied

[Cook, G. <GW...@ma...>]

Run 'perfparse --help' to see all of the options. Then try adding the
user/pass/db/host on the command line and see if that works.

Next, change the db password to 'nagios' in the perfparse.cfg and see if
that works. If so, then the password is not being read from the config
for some reason and the default 'nagios' pass is being used.

Also, if there are any funny characters in your password (!,%,$,etc.) in
the perfparse.cfg, try escaping them with a backslash.

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)

per...@li... wrote:
> i've setup nagios 1.2 and perfparse (latest) on a
> whitebox3/x86. nagios is
> working well but perfparse seems to have a problem with mysql.
> mysql4 is installed from mysql.com srpm.
>=20
> user created & perfparse.conf checked:
> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
> REFERENCES ON nagiosperf.* TO nagiosperf@whitebox IDENTIFIED
> BY 'password';
>=20
> but
> # /opt/nagios/bin/perfparse -r
> /opt/nagios/bin/perfparse:
> Error: Could not connect to MySQL database 'nagiosperf' on host
> '127.0.0.1' using username 'nagiosperf' and password 'n:
> Access denied for user: 'nagiosperf@whitebox' (Using password: YES)
>=20
> i suppose perfparse always displays nagios as password.
> problem is with
> mysql, i connect without problem and with the real password
> which is in
> conf file.
>=20
> is there any way to get more details on mysql connection ?
>=20
> thanks
> Regards
>=20
> 		Julien


Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)