注册 | 登录 忘记密码？ 51cto首页 | 博客 | 论坛 | 招聘
热点文章 利用手机和电池实现反地心..
　帮助
做绿色IT人，赢百元礼品卡 　7月5日线下沙龙报名中:两小时搞定负载均衡 博主的更多文章>>

对CACTI数据库结构的一点分析

2007-10-13 21:10:06
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://dannyyuan.blog.51cto.com/212520/46080
因为我的需要主要是根据主机名和数据类型来取相关RRA数据，所以对一些关系不大的部分就没作进一步分析。就我需求而言，以下的几个表是很重要的被用于定位RRA文件路径（连文件名）：
host        主机名表，主要字段：id, hostname
data_local  数据源表，主要字段：id, data_template_id, host_id, snmp_query_id, snmp_index
data_template 数据模板表， 主要字段：id
data_template_data 数据源信息表，主要字段：id, local_data_id, data_template_id, data_input_id, data_source_path, name_cache
其中host表的id与data_local表的host_id关联，data_local表和data_tempate_data表的data_template_id与data_template的id关联；data_template_data表的local_data_id和data_local表的id关联。
基于上述信息可以查到任意一个给定主机的所有RRA文件信息（data_tempate_data表的data_source_path字段）。
不过要查给定一种数据类型的数据，还需要进一步的约束条件。这里要分几种情况来分析：
第一种，类似CPU/LoadAverage等对应MIBII库限定OID数据类型的情况：
新引进以下一个表来继续分析：
data_input_data     查询输入数据信息表，主要字段：data_template_data_id，value
其中的value字段就是用来存储数据类型所对应OID的。用其data_template_data_id与data_template_data表的id关联即可实现该约束的加强。
 
第二种，用data_query方法和XML文件定义来实现数据模板的数据类型的情况：
需新引进以下一个表来继续分析：
snmp_query_graph_rrd 数据源查询字段表， 主要字段：data_template_id，snmp_field_name。
其中的snmp_field_name字段就是用来存储数据类型相关SNMP的NODE DESCRIPTION的，用其data_template_id和data_template_data表的data_template_id关联，即可实现该约束的加强。
 
第三种，这是第二种情况的延伸，即data_query方法是属于index类的（即返回多列数据，由返回列的描述字段来自扩展数据源）。
用data_local表的snmp_index或data_template_data的name_cache来实现该约束的加强。

本文出自 “守望者的技术日记和六味生活” 博客，请务必保留此出处http://dannyyuan.blog.51cto.com/212520/46080



上一篇 Linux小点滴　　下一篇 RRDTOOL使用说明



    文章评论
 <<   1   2   3   >>   页数 ( 1/3 )  
2007-10-14 21:14:49
先看一下，抄一下

2007-10-18 15:17:48
博主，写一套cacti的入门教程嘛，谢谢！

2007-12-29 09:24:35
兄弟,我能否请教关于cacti的问题呢?

我的图从前天开始不更新了,我debug了一下,发现debug时查数据库的 poller_item表rrd_next_step字段,系统要求是<= 0 的,所以我那些没有更新的图,我查出来都是这个字段>0 的有一千多条,那么就有一千多张图没有更新了!请问知道为什么原因吗?

2008-01-01 15:07:01
这种情况我没有碰到，你可以检查是不是<=的情况就更新正常了。
如果是，就好办了。
如果不是，说明是别的原因。
元旦后等国内服务器起来我也查查。

2008-01-06 21:57:33
我在数据库手工设置为0,但没一会儿,又被更新为一个很大的数字了!不知道为什么?

博主是否有MSN,或者gmail,方便我们沟通!

我的MSN : myfreeke@hotmail

2008-01-09 02:33:28
经查过代码，通常更新正常时，该值不会被更新，也不会有什么意义，也就是说不会有什么作用。不是说大于零的就会忽略。
我初步猜测，可能你的目标节点在给定时间没有更新到结果，所以该step会被更新成一个很大的值。
正常的，该字段总是初始的0。

2008-01-09 04:35:37
我又进一步作了测试：我把正常的节点的rrd_next_step改成很大的一个值，还是能正常更新的。说明我的思路是对的。

2008-01-09 14:58:09
但是我在被控端使用一个脚本查的数据库得到两个数字,再在被控端自定义一个OID,然后cacti通过OID取到这两个值,画出图来,现在就是只能画一个图,本应该cacti去取同一台服务器上的这两个值是同时的,并且手工get是没有问题的,都可以很快取到数字;

[root@test bin]# ./spine --verbosity=5 87 87
SPINE: Using spine config file [../etc/spine.conf]
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_webroot''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_cactilog''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The path_php_server variable is /usr/local/apache/htdocs/cacti/script_server.php
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The path_cactilog variable is /usr/local/apache/htdocs/cacti/log/cacti.log
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_destination''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The log_destination variable is 2 (BOTH)
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 500
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The threads variable is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 2
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The script timeout is 25
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 87 AND 87 LIMIT 1'
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: StartHost='87', EndHost='87', TotalPHPScripts='0'
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
12/28/2007 06:27:38 PM - SPINE: Poller[0] Version 0.8.7b starting
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
12/28/2007 06:27:38 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.1.2
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.1.2
12/28/2007 06:27:38 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 87 AND 87 ORDER BY id'
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 AND rrd_next_step < 0 GROUP BY snmp_port'
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context FROM poller_item WHERE host_id=0 and rrd_next_step <=0 ORDER by snmp_port'
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=0'
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=0'
12/28/2007 06:27:38 PM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
12/28/2007 06:27:38 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, snmp_timeout, max_oids, availability_method, ping_method, ping_port, ping_timeout, ping_retries, status, status_event_count, status_fail_date, status_rec_date, status_last_error, min_time, max_time, cur_time, avg_time, total_polls, failed_polls, availability FROM host WHERE id=87'
12/28/2007 06:27:39 PM - SPINE: Poller[0] Host[87] PING Result: ICMP: Host is Alive
12/28/2007 06:27:39 PM - SPINE: Poller[0] Host[87] SNMP Result: SNMP not performed due to setting or ping result
12/28/2007 06:27:39 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE host SET status='3', status_event_count='0', status_fail_date='0000-00-00 00:00:00', status_rec_date='0000-00-00 00:00:00', status_last_error='', min_time='0.286510', max_time='324.828980', cur_time='157.536485', avg_time='33.773758', total_polls='10114', failed_polls='0', availability='100.0000' WHERE id='87''
12/28/2007 06:27:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=87'
12/28/2007 06:27:39 PM - SPINE: Poller[0] Host[87] Host has no information for recache.
12/28/2007 06:27:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=87 AND rrd_next_step < 0 GROUP BY snmp_port'
12/28/2007 06:27:39 PM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context FROM poller_item WHERE host_id=87 and rrd_next_step <=0 ORDER by snmp_port'
12/28/2007 06:27:39 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=87'
12/28/2007 06:27:39 PM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=87'
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1798] SNMP: v2: 10.16.10.1, dsname: Total_Currentcalls, oid: .1.3.6.1.2.1.1.3000.75.101.1, value: 742
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1799] SNMP: v2: 10.16.10.1, dsname: OnlineuserNAT, oid: .1.3.6.1.2.1.1.3000.76.101.2, value: 10828
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1800] SNMP: v2: 10.16.10.1, dsname: OnlineuserTotal, oid: .1.3.6.1.2.1.1.3000.76.101.1, value: 19481
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1801] SNMP: v2: 10.16.10.1, dsname: satcom, oid: .1.3.6.1.2.1.1.3000.94.101.2, value: 0
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1802] SNMP: v2: 10.16.10.1, dsname: satcom, oid: .1.3.6.1.2.1.1.3000.94.101.1, value: 0
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1803] SNMP: v2: 10.16.10.1, dsname: ShandongGW, oid: .1.3.6.1.2.1.1.3000.77.101.2, value: 21
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1804] SNMP: v2: 10.16.10.1, dsname: ShandongGWTotalca, oid: .1.3.6.1.2.1.1.3000.77.101.1, value: 21
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1805] SNMP: v2: 10.16.10.1, dsname: shenzhenweitong, oid: .1.3.6.1.2.1.1.3000.88.101.2, value: 45
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1806] SNMP: v2: 10.16.10.1, dsname: shenzhenweitong, oid: .1.3.6.1.2.1.1.3000.88.101.1, value: 46
12/28/2007 06:27:48 PM - SPINE: Poller[0] Host[87] DS[1807] SNMP: v2: 10.16.10.1, dsname: shenzhenweitong2, oid: .1.3.6.1.2.1.1.3000.89.101.2, value: 27
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1808] SNMP: v2: 10.16.10.1, dsname: shenzhenweitong2, oid: .1.3.6.1.2.1.1.3000.89.101.1, value: 28
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1809] SNMP: v2: 10.16.10.1, dsname: Xian_PRI, oid: .1.3.6.1.2.1.1.3000.90.101.2, value: 0
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1810] SNMP: v2: 10.16.10.1, dsname: Xian_PRI, oid: .1.3.6.1.2.1.1.3000.90.101.1, value: 0
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1811] SNMP: v2: 10.16.10.1, dsname: Xian_PRI_EN, oid: .1.3.6.1.2.1.1.3000.93.101.2, value: 0
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1812] SNMP: v2: 10.16.10.1, dsname: Xian_PRI_EN, oid: .1.3.6.1.2.1.1.3000.93.101.1, value: 0
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1813] SNMP: v2: 10.16.10.1, dsname: Xian_SS7, oid: .1.3.6.1.2.1.1.3000.91.101.2, value: 93
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1814] SNMP: v2: 10.16.10.1, dsname: Xian_SS7, oid: .1.3.6.1.2.1.1.3000.91.101.1, value: 94
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1815] WARNING: Result from SNMP not valid. Partial Result: ...
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1815] SNMP: v2: 10.16.10.1, dsname: Xian_SS7_EN, oid: .1.3.6.1.2.1.1.3000.92.101.2, value: U
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1816] WARNING: Result from SNMP not valid. Partial Result: /usr/local/mrtg/Xian...
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1816] SNMP: v2: 10.16.10.1, dsname: Xian_SS7_EN, oid: .1.3.6.1.2.1.1.3000.92.101.1, value: U
12/28/2007 06:27:52 PM - SPINE: Poller[0] Host[87] DS[1817] SNMP: v2: 10.16.10.1, dsname: Zhengzhou18, oid: .1.3.6.1.2.1.1.3000.78.101.2, value: 51
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1818] SNMP: v2: 10.16.10.1, dsname: Zhengzhou18, oid: .1.3.6.1.2.1.1.3000.78.101.1, value: 51
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1819] SNMP: v2: 10.16.10.1, dsname: Zhengzhou21, oid: .1.3.6.1.2.1.1.3000.79.101.2, value: 49
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1820] SNMP: v2: 10.16.10.1, dsname: Zhengzhou21, oid: .1.3.6.1.2.1.1.3000.79.101.1, value: 48
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1821] SNMP: v2: 10.16.10.1, dsname: Zhengzhou22, oid: .1.3.6.1.2.1.1.3000.80.101.2, value: 40
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1822] SNMP: v2: 10.16.10.1, dsname: Zhengzhou22, oid: .1.3.6.1.2.1.1.3000.80.101.1, value: 40
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1823] SNMP: v2: 10.16.10.1, dsname: Zhengzhou23, oid: .1.3.6.1.2.1.1.3000.81.101.2, value: 21
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1824] SNMP: v2: 10.16.10.1, dsname: Zhengzhou23, oid: .1.3.6.1.2.1.1.3000.81.101.1, value: 21
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1825] SNMP: v2: 10.16.10.1, dsname: Zhengzhou24, oid: .1.3.6.1.2.1.1.3000.82.101.2, value: 50
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1826] SNMP: v2: 10.16.10.1, dsname: Zhengzhou24, oid: .1.3.6.1.2.1.1.3000.82.101.1, value: 50
12/28/2007 06:27:56 PM - SPINE: Poller[0] Host[87] DS[1827] SNMP: v2: 10.16.10.1, dsname: Zhengzhou25, oid: .1.3.6.1.2.1.1.3000.83.101.2, value: 43
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DS[1828] SNMP: v2: 10.16.10.1, dsname: Zhengzhou25, oid: .1.3.6.1.2.1.1.3000.83.101.1, value: 43
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DS[1829] SNMP: v2: 10.16.10.1, dsname: Zhengzhou26, oid: .1.3.6.1.2.1.1.3000.84.101.2, value: 52
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DS[1830] SNMP: v2: 10.16.10.1, dsname: Zhengzhou26, oid: .1.3.6.1.2.1.1.3000.84.101.1, value: 51
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DS[1831] SNMP: v2: 10.16.10.1, dsname: Zhengzhou27, oid: .1.3.6.1.2.1.1.3000.85.101.2, value: 46
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DS[1832] SNMP: v2: 10.16.10.1, dsname: Zhengzhou27, oid: .1.3.6.1.2.1.1.3000.85.101.1, value: 46
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DS[1833] SNMP: v2: 10.16.10.1, dsname: Zhengzhou28, oid: .1.3.6.1.2.1.1.3000.86.101.2, value: 36
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DS[1834] SNMP: v2: 10.16.10.1, dsname: Zhengzhou28, oid: .1.3.6.1.2.1.1.3000.86.101.1, value: 37
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: SQL:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (1798,'Total_Currentcalls','2007-12-28 18:27:38','742'),(1799,'OnlineuserNAT','2007-12-28 18:27:38','10828'),(1800,'OnlineuserTotal','2007-12-28 18:27:38','19481'),(1801,'satcom','2007-12-28 18:27:38','0'),(1802,'satcom','2007-12-28 18:27:38','0'),(1803,'ShandongGW','2007-12-28 18:27:38','21'),(1804,'ShandongGWTotalca','2007-12-28 18:27:38','21'),(1805,'shenzhenweitong','2007-12-28 18:27:38','45'),(1806,'shenzhenweitong','2007-12-28 18:27:38','46'),(1807,'shenzhenweitong2','2007-12-28 18:27:38','27'),(1808,'shenzhenweitong2','2007-12-28 18:27:38','28'),(1809,'Xian_PRI','2007-12-28 18:27:38','0'),(1810,'Xian_PRI','2007-12-28 18:27:38','0'),(1811,'Xian_PRI_EN','2007-12-28 18:27:38','0'),(1812,'Xian_PRI_EN','2007-12-28 18:27:38','0'),(1813,'Xian_SS7','2007-12-28 18:27:38','93'),(1814,'Xian_SS7','2007-12-28 18:27:38','94'),(1815,'Xian_SS7_EN','2007-12-28 18:27:38','U'),(1816,'Xian_SS7_EN','2007-12-28 18:27:38','U'),(1817,'Zhengzhou18','2007'
12/28/2007 06:28:00 PM - SPINE: Poller[0] Host[87] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: SQL:'replace into settings (name,value) values ('date',NOW())'
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: SQL:'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
12/28/2007 06:28:00 PM - SPINE: Poller[0] SPINE: Net-SNMP API Shutdown Completed
12/28/2007 06:28:00 PM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
12/28/2007 06:28:00 PM - SPINE: Poller[0] Time: 21.9418 s, Threads: 1, Hosts: 2
[root@test bin]#

2008-01-09 16:55:23
正常可以出图的OID:
mysql> select * from poller_item where arg1=".1.3.6.1.2.1.1.3000.75.101.1" \G;
*************************** 1. row ***************************
    local_data_id: 1798
      poller_id: 0
        host_id: 87
        action: 0
        hostname: 10.16.10.1
    snmp_community: public
    snmp_version: 2
    snmp_username:
    snmp_password:
snmp_auth_protocol: MD5
snmp_priv_passphrase:
snmp_priv_protocol: DES
    snmp_context:
      snmp_port: 161
    snmp_timeout: 5000
        rrd_name: Total_Currentcalls
        rrd_path: /var/monitor/cacti/rra/two_gw_call_monitor_total_currentcalls_1798.rrd
        rrd_num: 1
        rrd_step: 300
    rrd_next_step: 0
          arg1: .1.3.6.1.2.1.1.3000.75.101.1
          arg2:
          arg3:
*************************** 2. row ***************************
    local_data_id: 2805
      poller_id: 0
        host_id: 153
        action: 0
        hostname: 10.16.10.2
    snmp_community: publicmrtg
    snmp_version: 2
    snmp_username:
    snmp_password:
snmp_auth_protocol: MD5
snmp_priv_passphrase:
snmp_priv_protocol: DES
    snmp_context:
      snmp_port: 161
    snmp_timeout: 500
        rrd_name: Total_Currentcalls
        rrd_path: /var/monitor/cacti/rra/one_callonlineuser_total_currentcalls_2805.rrd
        rrd_num: 1
        rrd_step: 300
    rrd_next_step: 0
          arg1: .1.3.6.1.2.1.1.3000.75.101.1
          arg2:
          arg3:
2 rows in set (0.01 sec)

ERROR:
No query specified


不正常的OID,查出来的SQL结果:
mysql> select * from poller_item where arg1=".1.3.6.1.2.1.1.3000.75.101.2" \G;
*************************** 1. row ***************************
    local_data_id: 1797
      poller_id: 0
        host_id: 87
        action: 0
        hostname: 10.16.10.1
    snmp_community: public
    snmp_version: 2
    snmp_username:
    snmp_password:
snmp_auth_protocol: MD5
snmp_priv_passphrase:
snmp_priv_protocol: DES
    snmp_context:
      snmp_port: 161
    snmp_timeout: 5000
        rrd_name: Connected
        rrd_path: /var/monitor/cacti/rra/two_gw_call_monitor_connected_1797.rrd
        rrd_num: 1
        rrd_step: 10
    rrd_next_step: 8354107
          arg1: .1.3.6.1.2.1.1.3000.75.101.2
          arg2:
          arg3:
*************************** 2. row ***************************
    local_data_id: 2804
      poller_id: 0
        host_id: 153
        action: 0
        hostname: 10.16.10.2
    snmp_community: publicmrtg
    snmp_version: 2
    snmp_username:
    snmp_password:
snmp_auth_protocol: MD5
snmp_priv_passphrase:
snmp_priv_protocol: DES
    snmp_context:
      snmp_port: 161
    snmp_timeout: 500
        rrd_name: Connected
        rrd_path: /var/monitor/cacti/rra/one_callonlineuser_connected_2804.rrd
        rrd_num: 1
        rrd_step: 10
    rrd_next_step: 8354107
          arg1: .1.3.6.1.2.1.1.3000.75.101.2
          arg2:
          arg3:
2 rows in set (0.00 sec)

2008-01-10 05:40:03
你看看rra库文件有数据吗？

 <<   1   2   3   >>   页数 ( 1/3 )  

发表评论

昵   称：
验证码： 　点击图片可刷新验证码　　博客过2级，无需填写验证码
内   容：