I had the same issue with my install as well.
I ended up just retyping the password for the mysql login and it seemed
to work.
I used a password with just letters and numbers because I did find a few
characters didn't work in the password field.
Emilio Scalise wrote:
It could be a special character problem.
I noticed that if you have password with symbols as @ / & inside the
password opsview has problems.
Is that you case?
2010/5/5 Yitzhak Bar Geva <[email protected]>:
Hi,
I'm a newbie with OpsView. Everything seems to have been installed OK. Menus
work fine. So do the default tests on the only machine defined, localhost.
Three tests however keep reporting failures, the MySQL tests
It gives:
"(Return code of 255 is out of bounds)" on the MySQL DB performance test
"Access denied for user 'opsview'@'localhost' (using password: YES)" on the
MySQL Status test
and "(Return code of 255 is out of bounds)" on the MySQL DB Connections test
Here are the three relevant scripts with their arguments as shown on the
Opsview Service Check > List page (password "x"ed out):
MySQL DB Connections:
check_mysql_performance -H $HOSTADDRESS$ -u opsview -p xxxxxx --perfdata
Connections,Max_used_connections
MySQL DB Performance:
check_mysql_performance -H $HOSTADDRESS$ -u opsview -p xxxxxx --perfdata
Com_select,Created_tmp_disk_tables,Created_tmp_tables,Slow_queries,Select_full_join,Select_full_range_join,Select_range_check,Select_scan,Sort_merge_passes,Sort_range,Sort_rows,Sort_scan
MySQL Status:
check_mysql -H $HOSTADDRESS$ -u opsview -p xxxxxx -d opsview
I have tried executing the scripts manually from the command line. If run as
user "nagios", the script runs with no permission problems, but gives an
error,
like this:
$ /usr/local/nagios/libexec/check_mysql_performance -H localhost -u opsview
-p xxxxxx --perfdata Connections,Max_used_connections
MYSQL_PERFORMANCE UNKNOWN - Couldn't see last state
When run manually as user nagios, the status check runs OK:
/usr/local/nagios/libexec/check_mysql -H localhost -u opsview -p xxxxxx -d
opsview
Uptime: 4294964525 Threads: 34 Questions: 20782 Slow queries: 0 Opens:
1217 Flush tables: 1 Open tables: 191 Queries per second avg: 0.0
Since it appears I am having a permissions problem, I'm asking:
As which system user do the scripts run? and What is mis-configured?
Thank you very much,
Yitzhak
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
