cacti 中查询MySQL数据库占用磁盘大小并返回的php修改了，但在cacti中配置了模板，可以在device中创建表格并且可以生成data source的条目，但始终没有返回数据 不知道是什么问题，暂时没有办法解决。 尝试过用script query 和script_server的方式，由于还是不了解也不知道是对cacti的了解不够还是什么原因 始终没有返回值
哪位大神给指点下
贴这里记录下，因为之前通过snmpwalk的方式进行制作模板已经成功，没办法用自定义mib的方式进行实现吧，后面再分享
data query中引用的xml文件
<interface> <name>get mysql databases</name> <script_path>|path_php_binary| -q |path_cacti|/scripts/flashapp_mysql_space.php</script_path> <arg_prepend>|host_hostname|</arg_prepend> <arg_index>index</arg_index> <arg_query>query</arg_query> <arg_get>get</arg_get> <arg_num_indexes>num_index</arg_num_indexes> <output_delimeter>:</output_delimeter> <index_order>hrDataBasesIndex</index_order> <index_order_type>numeric</index_order_type> <index_title_format>|chosen_order_field|</index_title_format> <fields> <hrDataBasesIndex> <name>DataBasesIndex</name> <direction>input</direction> <query_name>index</query_name> </hrDataBasesIndex> <hrDataBasesDescr> <name>Description</name> <direction>input</direction> <query_name>desc</query_name> </hrDataBasesDescr> <hrDataBasesSize> <name>Total Size</name> <direction>output</direction> <query_name>space</query_name> </hrDataBasesSize> </fields> </interface>
对应的php查询文件也做了修改调整了 参数 和输出方法 <?php /* * flashapp_mysql_space.php * ------------------------------------------------- * enable cacti to read mysql database size * Originally by tongyuan at flashapp dot cn - 2013/12/24 * * usage: * flashapp_mysql_space.php db_host <index|num_nidex> * flashapp_mysql_spqce.php db_host query index|desc * flashapp_mysql_spqce.php db_host get space database_name * * mysql user must have permissions to do this. * give myuser /show databases/ and /select/ permissions . * * examle: * grant select,process,super,show databases on *.* * to monitor@'192.168.11.0/255.255.255.0' identified by 'monitor'; * */ $debug=0; // if ($_SERVER["argc"] != 5 ){ // echo "Error. Wrong parameter count or paramenter wrong .n"; // echo "Usage: " . $_SERVER["argv"][0] ; // echo " <dbhost> <dbuser> <dbpasswd> <cmd>nn"; // echo "cmd : index|num_index|get nnn"; // exit(1); // } $host = $_SERVER["argv"][1]; //default user and password is monitor $username = "monitor"; $password = "monitor"; //get all dabase name and count,expect system database. if ($_SERVER["argc"] >= 3 ) { $cmd=$_SERVER["argv"][2]; if (@mysql_connect($host,$username,$password)) { $alldataBase = @mysql_query("show databases"); $dataBaseNum = 0; $dataBase=array(); while ($row=@mysql_fetch_array($alldataBase)) { if ( $row[0] != "information_schema" && $row[0] != "mysql" && $row[0] != "performance_schema" && $row[0] != "test" ) { $dataBase[]=$row[0]; $dataBaseNum =1; } } if ($debug) {echo "all dataBase Number is :";print_r($dataBaseNum);echo "n";} if ($debug) {echo "all dataBase is :";print_r($dataBase);echo "n";} // output index if ($cmd == 'index') { foreach ($dataBase as $d){echo $d."n";} exit(0); } // output index_number if ($cmd == "num_index" ) { echo $dataBaseNum . "n";} if ($cmd == "query" || $cmd =="get" ) { $arg=$_SERVER["argv"][3]; // get databses space if ($dataBaseNum == 0) {exit(0) ; } foreach ($dataBase as $row){ $resault=@mysql_query("select sum(DATA_LENGTH) sum(INDEX_LENGTH) from information_schema.tables where table_schema='".$row."'"); $space=@mysql_fetch_row($resault)[0]; $dataBaseSpace[] = $space?$space:"0"; } /*DEBUG*/if ($debug) {echo "All dataBase space is :";print_r($dataBaseSpace);echo "n";} // output database space if ($cmd == "query" && ($arg == "index" || $arg == "desc")) { foreach ($dataBase as $key => $value) { echo $value . ":" .$value . "n"; } exit(0); } if ($cmd == "get" && $arg == "space") { $get_database=$_SERVER["argv"][4]; foreach ($dataBase as $key => $value) { if ($value == $get_database){ echo $dataBaseSpace[$key]; } } } } } else { die("Can't connected to Server!n"); } } ?>
相关文件xml和php文件下载：
免费下载地址在 http://linux.linuxidc.com/
用户名与密码都是www.linuxidc.com
具体下载目录在 /2014年资料/1月/2日/Cacti 中查询MySQL数据库占用磁盘大小并返回的php修改了
下载方法见 http://www.linuxidc.com/Linux/2013-07/87684.htm
