Going batty!
I have diligently followed the instructions in the FAQ for changing
passwords, as per:
How do I change MySQL passwords post installation?
1. Stop opsview and opsview-web daemons
2. Edit passwords in opsview.conf
3. Change passwords in MySQL
mysql -p -u <root user>
USE mysql;
UPDATE user SET password=PASSWORD("newpass") WHERE user="opsview";
UPDATE user SET password=PASSWORD("newpass") WHERE user="odw";
UPDATE user SET password=PASSWORD("newpass") WHERE user="nagios";
FLUSH PRIVILEGES;
4. Run ''/etc/init.d/rc.opsview gen_config'' (which will regenerate
the Opsview configuration files and then restart opsview daemons
automatically)
5. Restart the opsview-web daemon
Fine and dandy.
When I manually run one of the MySQL polling scripts as user nagios and
place the correct password in the command line, such as:
/usr/local/nagios/libexec/check_mysql_performance -H localhost -u opsview -p
xxxx --perfdata Connections,Max_used_connections
it works fine and I get:
MYSQL_PERFORMANCE OK - All parameters OK | Connections=0.213004484304933;;
Max_used_connections=24;;
but when I run it through the web interface, I get things like:
Access denied for user 'opsview'@'localhost' (using password: YES)
or
(Return code of 255 is out of bounds)
I think it's using the word PASSWORD as in the script and not overriding it
with the paswords I gave in opsview.conf
How can I debug this???
Thanks
_______________________________________________
Opsview-users mailing list
Opsview-users@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-users
