Skip to main content

Posts

Showing posts from October, 2016

Nagios - Service Group Summary ERROR

We were working on nagios and found that after our migration, service group summary was not working. You might get below error on the screen and the solution is similar for both issues. Problem 1. Error is Could not open CGI config file '/usr/local/nagios/etc/cgi.cfg' for reading Problem 2. Nagios: It appears as though you do not have permission to view information for any of the hosts you requested… Solution. Update the /usr/local/nagios/etc/cgi.cfg to below configuration, and restart nagios service. # MODIFIED default_statusmap_layout=6 # UNMODIFIED action_url_target=_blank authorized_for_all_host_commands=nagiosadmin authorized_for_all_hosts=nagiosadmin authorized_for_all_service_commands=nagiosadmin authorized_for_all_services=nagiosadmin authorized_for_configuration_information=nagiosadmin authorized_for_system_commands=nagiosadmin authorized_for_system_information=nagiosadmin default_statuswrl_layout=4 escape_html_tags=1 lock_author_names=1 main_confi

Zabbix History Table Clean Up

Zabbix history table gets really big, and if you are in a situation where you want to clean it up. Then we can do so, using the below steps. Stop zabbix server. Take table backup - just in case. Create a temporary table. Update the temporary table with data required, upto a specific date using epoch . Move old table to a different table name. Move updated (new temporary) table to original table which needs to be cleaned-up. Drop the old table. (Optional) Restart Zabbix Since this is not offical procedure, but it has worked for me so use it at your own risk. Here is another post which will help is reducing the size of history tables - http://zabbixzone.com/zabbix/history-and-trends/ Zabbix Version : Zabbix v2.4 Make sure MySql 5.1 is set with InnoDB as innodb_file_per_table=ON Step 1 Stop the Zabbix server sudo service zabbix-server stop Script. echo "------------------------------------------" echo " 1. Stopping Zabbix Server &quo