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
