如何使用cacti脚本批量添加主机

yvgoodman

　　使用脚本添加的时候遇到下面的错误。
　　
　　
　　[iyunv@SJSWT44-122 cli]# php -q add_device.php --description='user1.db' --ip='user1.db.d.xiaonei.com' --template=11
PHP Notice:  Use of undefined constant E_DEPRECATED - assumed 'E_DEPRECATED' in /usr/local/apache/htdocs/cacti/include/global.php on line 181

ERROR: Invalid snmp version (0)
　　
　　
　　
　　本来想着暴力的去修改数据库，后来查看了add_device.php脚本之后发现脚本读取了一些配置文件，所以还是悠着点比较好。
　　于是在脚本里面搜索了一下Invalid snmp version，发现了使用add_device.php添加的时候不允许snmp_ver等于0，但是手工添加的实际上是允许0存在的，^_^于是只好修改一下代码了（注释掉）
　　/* process snmp informationif ($snmp_ver != &quot;1&quot; && $snmp_ver != &quot;2&quot; && $snmp_ver != &quot;3&quot;) {echo &quot;ERROR: Invalid snmp version ($snmp_ver)/n&quot;;exit(1);}else{if ($snmp_port <= 1 || $snmp_port > 65534) {echo &quot;ERROR: Invalid port.  Valid values are from 1-65534/n&quot;;exit(1);}if ($snmp_timeout <= 0 || $snmp_timeout > 20000) {echo &quot;ERROR: Invalid timeout.  Valid values are from 1 to 20000/n&quot;;exit(1);}}*//* community/user/password verificationif ($snmp_ver == &quot;1&quot; || $snmp_ver == &quot;2&quot;) {/* snmp community can be blank }else{if ($snmp_username == &quot;&quot; || $snmp_password == &quot;&quot;) {echo &quot;ERROR: When using snmpv3 you must supply an username and password/n&quot;;exit(1);}}*/
　　下面是我的批量添加脚本，大概思路：①从存放所有服务器信息的主机中获取主机信息②将每一个主机添加到cacti中③从cacti的数据库中获取刚添加的主机host-id④添加graphs(需要提前知道相应graph的id，因为是批量添加，这部分信息应该是固定的)⑤将主机添加到tree中
　　#!/usr/bin/pythonimport MySQLdbimport subprocessconn=MySQLdb.connect(host='**',port=3306,user='**',passwd='**',db='**',charset='utf8')cursor=conn.cursor()cursor.execute(&quot;select id,ip,port from db limit 2,10&quot;)hosts=cursor.fetchall()cacti_conn=MySQLdb.connect(host=&quot;**&quot;,port=3306,user='**',passwd='**',db='cacti')cacti_cursor=cacti_conn.cursor()for host in hosts:db_id=host[0]ip=host[1]port=host[2]###add_devicesp_add_host=subprocess.Popen([&quot;php&quot;,&quot;-q&quot;,&quot;/usr/local/apache/htdocs/cacti/cli/add_device.php&quot;,&quot;--description=%s:%s&quot;%(ip,port),&quot;--ip=%s&quot;%ip,/&quot;--template=11&quot;],shell=False,stdout=subprocess.PIPE,stderr=subprocess.PIPE)print sp_add_host.stdout.read()print sp_add_host.stdout.read()###add_graphcacti_cursor.execute(&quot;select id from host where description='%s:%s'&quot;%(ip,port))host_id_set=cacti_cursor.fetchone()if host_id_set is None:print &quot;%s:%s host add failed&quot;%(ip,port)continuehost_id=host_id_set[0]for graph_id in range(81,97):if graph_id not in [84,85,89]:sp_add_graph=subprocess.Popen([&quot;php&quot;,&quot;-q&quot;,&quot;/usr/local/apache/htdocs/cacti/cli/add_graphs.php&quot;,&quot;--host-id=%s&quot;%host_id,&quot;--graph-type=cg&quot;,/&quot;--graph-template-id=%s&quot;%graph_id,&quot;--input-fields=db_id=%s&quot;%db_id],shell=False,stdout=subprocess.PIPE,stderr=subprocess.PIPE)print sp_add_graph.stdout.read()print sp_add_graph.stdout.read()##add_treesp_add_tree=subprocess.Popen([&quot;php&quot;,&quot;-q&quot;,&quot;/usr/local/apache/htdocs/cacti/cli/add_tree.php&quot;,&quot;--type=node&quot;,&quot;--node-type=host&quot;,&quot;--tree-id=6&quot;,&quot;--host-id=%s&quot;%host_id],/shell=False,stdout=subprocess.PIPE,stderr=subprocess.PIPE)print sp_add_tree.stdout.read()print sp_add_tree.stdout.read()cacti_cursor.close()cacti_conn.close()cursor.close()conn.close()