Sorry opsview.conf wasn't attached. Here it is now. On Tue, Jun 8, 2010 at 6:34 PM, Yitzhak Bar Geva <yitzha...@gmail.com>wrote:
> 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.
> >
> >
>
>
opsview.conf
Description: Binary data
_______________________________________________ Opsview-users mailing list Opsview-users@lists.opsview.org http://lists.opsview.org/lists/listinfo/opsview-users
