I went to the link you provided, but couldn't find any script. What did you have in mind?
I did a fresh installation based on Centos 5.5 in a VirtualBox VM. Again
followed the instructions and am getting errors as shown in the the attached
screenshot.
Here's a check I ran manually from the command line as user nagios:
[nag...@ybgcentos55 ~]$ /usr/local/nagios/libexec/
check_mysql_performance -H localhost -u opsview -p 5215 --perfdata
Connections,Max_used_connections
MYSQL_PERFORMANCE UNKNOWN - Couldn't see last state
[nag...@ybgcentos55 ~]$ /usr/local/nagios/libexec/check_mysql_performance -H
localhost -u opsview -p 5215 --perfdata Connections,Max_used_connections
MYSQL_PERFORMANCE OK - All parameters OK | Connections=0.666666666666667;;
Max_used_connections=7;;
and here's the check as defined in opsview:
check_mysql_performance -H $HOSTADDRESS$ -u opsview -p changeme --perfdata
Connections,Max_used_connections
Copy of opsview.conf is attached
How do I chase these errors? I'd love to use Opsview.
Thanks,
Yitzhak
On 2010-06-03 16:01, Duncan Ferguson wrote:
>
> On 30 May 2010, at 16:05, Yitzhak Bar Geva wrote:
>
> > 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???
>
> How is the check defined in Opsview?
>
> I do have a task to write a wrapper for this opsview check to ensure it
picks up passwords in opsview.conf - at the moment it uses what is given as
a parameter or no password
>
> https://secure.opsera.com/jira/browse/OPS-1158
>
> Duncs
>
>
>
>
>
>
> Global Headquarters: Unit 69 Suttons Business Park | Reading | Berkshire |
RG6 1AZ | UK
>
> UK: +44 (0) 845 057 7887
> USA: +1 866 879 9184
> Fax: +44 (0) 1189 074 071
> email: tom.call...@???
> Skype: tom.callway
> Web: www.opsview.com
>
> This e-mail is confidential, intended only for the named recipient(s)
above and may contain information that is privileged and confidential. If
you receive this message in error, or are not the named recipient(s), please
notify the sender at the phone number above, do not copy this message, do
not disclose its contents to anyone, and delete this e-mail message from
your computer. Although we routinely screens for viruses, addressees should
scan this e-mail and any attachments for viruses. Opsera makes no
representation or warranty as to the absence of viruses in this e-mail or
any attachments.
>
>
<<attachment: Opsview_errs.jpg>>
opsview.conf
Description: Binary data
_______________________________________________ Opsview-users mailing list Opsview-users@lists.opsview.org http://lists.opsview.org/lists/listinfo/opsview-users
