Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
We happend to change SNMP name since the change of the snmp name it stopped populating graphs. The RRDTool seems to be working fine but i am not getting any graphs.
MySQL error 145 means the table has crashed. The cacti technical support page show any issues? Run the database repair script in your /cacti/cli/ folder.
the Technical support does not show any errors. but this is what the techincal support page looks like. The Graphs are still showing -1 and -1 #J and it is not displaying anything.
Date Wed, 11 Jul 2012 10:22:00 -0500
Cacti Version 0.8.7g
Cacti OS win32
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.2.x
Hosts 185
Graphs 1308
Data Sources Script/Command: 18
SNMP: 232
SNMP Query: 990
Script Query - Script Server: 90
Total: 1330
Poller Information
Interval 60
Type cmd.php
Items Action[0]: 2208
Action[1]: 13
Action[2]: 166
Total: 2387
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:9.3436 Method:cmd.php Processes:1 Threads:N/A Hosts:186 HostsPerProcess:186 DataSources:29 RRDsProcessed:16
PHP Information
PHP Version 5.2.14
PHP OS WINNT
PHP uname Windows NT Server name 6.1 build 7601
PHP SNMP Installed
max_execution_time 300
memory_limit 128M
MySQL Table Information
Name Rows Engine Collation Check Status
cdef 8 MyISAM latin1_swedish_ci OK
cdef_items 22 MyISAM latin1_swedish_ci OK
colors 104 MyISAM latin1_swedish_ci OK
data_input 11 MyISAM latin1_swedish_ci OK
data_input_data 15314 MyISAM latin1_swedish_ci OK
data_input_fields 44 MyISAM latin1_swedish_ci OK
data_local 1326 MyISAM latin1_swedish_ci OK
data_template 47 MyISAM latin1_swedish_ci OK
data_template_data 1378 MyISAM latin1_swedish_ci OK
data_template_data_rra 5742 MyISAM latin1_swedish_ci OK
data_template_rrd 2521 MyISAM latin1_swedish_ci OK
graph_local 1308 MyISAM latin1_swedish_ci OK
graph_template_input 137 MyISAM latin1_swedish_ci OK
graph_template_input_defs 498 MyISAM latin1_swedish_ci OK
graph_templates 48 MyISAM latin1_swedish_ci OK
graph_templates_gprint 3 MyISAM latin1_swedish_ci OK
graph_templates_graph 1360 MyISAM latin1_swedish_ci OK
graph_templates_item 10076 MyISAM latin1_swedish_ci OK
graph_tree 7 MyISAM latin1_swedish_ci OK
graph_tree_items 145 MyISAM latin1_swedish_ci OK
host 185 MyISAM latin1_swedish_ci OK
host_graph 237 MyISAM latin1_swedish_ci OK
host_snmp_cache 17275 MyISAM latin1_swedish_ci OK
host_snmp_query 269 MyISAM latin1_swedish_ci OK
host_template 7 MyISAM latin1_swedish_ci OK
host_template_graph 17 MyISAM latin1_swedish_ci OK
host_template_snmp_query 14 MyISAM latin1_swedish_ci OK
plugin_config 0 MyISAM latin1_swedish_ci OK
plugin_db_changes 0 MyISAM latin1_swedish_ci OK
plugin_hooks 2 MyISAM latin1_swedish_ci OK
plugin_realms 1 MyISAM latin1_swedish_ci OK
poller 0 MyISAM latin1_swedish_ci OK
poller_command 0 MyISAM latin1_swedish_ci OK
poller_item 2387 MyISAM latin1_swedish_ci OK
poller_output 0 MyISAM latin1_swedish_ci OK
poller_reindex 269 MyISAM latin1_swedish_ci OK
poller_time 2 MyISAM latin1_swedish_ci OK
reportit_cache_measurands 0 MyISAM latin1_swedish_ci OK
reportit_cache_reports 0 MyISAM latin1_swedish_ci OK
reportit_cache_variables 0 MyISAM latin1_swedish_ci OK
reportit_data_items 0 MyISAM latin1_swedish_ci OK
reportit_data_source_items 0 MyISAM latin1_swedish_ci OK
reportit_measurands 0 MyISAM latin1_swedish_ci OK
reportit_presets 0 MyISAM latin1_swedish_ci OK
reportit_recipients 0 MyISAM latin1_swedish_ci OK
reportit_reports 0 MyISAM latin1_swedish_ci OK
reportit_rvars 0 MyISAM latin1_swedish_ci OK
reportit_templates 0 MyISAM latin1_swedish_ci OK
reportit_variables 0 MyISAM latin1_swedish_ci OK
rra 5 MyISAM latin1_swedish_ci OK
rra_cf 10 MyISAM latin1_swedish_ci OK
settings 99 MyISAM latin1_swedish_ci OK
settings_graphs 45 MyISAM latin1_swedish_ci OK
settings_tree 0 MyISAM latin1_swedish_ci OK
snmp_query 10 MyISAM latin1_swedish_ci OK
snmp_query_graph 25 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd 102 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd_sv 60 MyISAM latin1_swedish_ci OK
snmp_query_graph_sv 41 MyISAM latin1_swedish_ci OK
user_auth 1 MyISAM latin1_swedish_ci OK
user_auth_perms 0 MyISAM latin1_swedish_ci OK
user_auth_realm 17 MyISAM latin1_swedish_ci OK
user_log 108 MyISAM latin1_swedish_ci OK
version 1 MyISAM latin1_swedish_ci OK
PHP Module Information
bcmath
--------------------------------------------------------------------------------
Directive Local Value Master Value
cgi.check_shebang_line 1 1
cgi.fix_pathinfo 1 1
cgi.force_redirect 0 0
cgi.nph 0 0
cgi.redirect_status_env no value no value
cgi.rfc2616_headers 0 0
fastcgi.impersonate 1 1
fastcgi.logging 0 0
COM support enabled
DCOM support disabled
.Net support enabled
Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value
date
--------------------------------------------------------------------------------
date/time support enabled
"Olson" Timezone Database Version 2010.9
Timezone Database internal
Default timezone America/Chicago
Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value
dom
--------------------------------------------------------------------------------
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.7.7
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled
GD Support enabled
GD Version bundled (2.0.34 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.1.9
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
iconv support enabled
iconv implementation "libiconv"
iconv library version 1.11
Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1
LDAP Support enabled
RCS Version $Id: ldap.c 293036 2010-01-03 09:23:27Z sebastian $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 0
libXML support active
libXML Version 2.7.7
libXML streams enabled
mysql
--------------------------------------------------------------------------------
MySQL Support enabled
Active Persistent Links 1
Active Links 1
Client API version 5.0.51a
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32
Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_cursortype Static cursor Static cursor
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited
Session Support enabled
Registered save handlers files user
Registered serializer handlers php php_binary wddx
Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_httponly Off Off
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name Cacti PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\php\sessiondata C:\php\sessiondata
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0
standard
--------------------------------------------------------------------------------
Regex Library Bundled library enabled
Dynamic Library Support enabled
Internal Sendmail Support for Windows enabled
Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value
1) After running the repair script, the MySQL Table Information should be clean -- which it is.
2) you do realize you cannot simply change the polling interval from 5 to 1 min without extra configuration, right? I strongly recommend you stick with 5 min until you fully understand how cacti operates. http://docs.cacti.net/ has more details.
I changed the settings to 5 minutes and i am going to see if it starts polling again. I do understand how the cacti works but why is it still not showing any graphs? if everything is clean. it is working now. i see graphs coming threw.
LAST:"Current\:%8.0lf" \