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

[Ben C. <Be...@cl...>]

Have a go at this:

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
REFERENCES ON nagiosperf.* TO nagiosperf@localhost IDENTIFIED BY 'password';

Or

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
REFERENCES ON nagiosperf.* TO nagiosperf@"127.0.0.1" IDENTIFIED BY 
'password';

Or

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
REFERENCES ON nagiosperf.* TO nagiosperf@"192.168.1.%" IDENTIFIED BY 
'password';

(Where 192.168.1.% represents your lan, change accordingly.)

Or all of them together.

Ben


Julien TOUCHE 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.
> 
> user created & perfparse.conf checked:
> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
> REFERENCES ON nagiosperf.* TO nagiosperf@whitebox IDENTIFIED BY 'password';
> 
> 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)
> 
> 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.
> 
> is there any way to get more details on mysql connection ?
> 
> thanks
> Regards
> 
>         Julien
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>