cacti troubleshoot

locate /*/cli  |grep cacti |grep -v 'mysql\|share'

cd /var/lib/cacti/cli

php analyze_database.php
php rebuild_poller_cache.php
php repair_database.php --form --force
php repair_templates.php --execute
php structure_rra_paths.php --proceed


discovery:
php -q findhosts.php -d -f

fix spine error
vim /etc/php.ini↓
memory_limit = 2048M
log_warnings=2
max_allowed_packet = 48M
connect_timeout = 30
max_connections = 3000

fix “date(): It is not safe to rely on the system's timezone settings…”
vim /etc/php.ini
date.timezone = America/New_York

Validation error when adding cacti host to the graphs tree
vim /usr/share/cacti/host.php +179
replace
input_validate_input_number(get_request_var_post('drp_action'));
with
input_validate_input_regex(get_request_var_post('drp_action'), "^([a-zA-Z0-9_]+)$");
service httpd restart