php script to monitor OTRS queue size from SNMP
Tuesday, February 18th, 2014 Posted in Linux, MySQL, PHP & PW | No Comments »最近公司上线OTRS,感觉还不错,顾问居然还给了数据库的结构图,闲下来就写了这个php脚本给Opsview用来监控OTRS支持队列的大小。别问我为什么用php...因为我实在是不会pel.... 测试环境: DISTRIB_ID=Ubuntu DISTRIB_RELEASE=12.04 DISTRIB_CODENAME=precise DISTRIB_DESCRIPTION="Ubuntu 12.04.4 LTS" 废话不说,先帖脚本: #!/usr/bin/php <?php # Tomas Tang on 18/02/2014 # Check the OTRS support queue size # Disable error report error_reporting(0); # get arguments $procname = $argv[0]; $queuename = $argv[1]; $warnlevel = $argv[2]; $critilevel = $argv[3]; # keep it for future develop #$QUEUE = array( # ...
Error: /usr/bin/mysqlcheck doesn’t support multiple contradicting commands.
Wednesday, February 12th, 2014 Posted in MySQL, troubleshooting | No Comments »MySQL 5.5对比MySQL 5.0和5.1改变还真不少,就连我以前常用的修复表命令到了5.5时代居然都不能用了。。。 /usr/bin/mysqlcheck --check --auto-repair --optimize --all-databases 一运行就给我报: Error: /usr/bin/mysqlcheck doesn't support multiple contradicting commands. 而且这个错误在Google里面都好像没有太多的答案,最好在一个阿拉伯文的论坛里面找到了解决方案:其实只要去掉--check就好了 /usr/bin/mysqlcheck --auto-repair --optimize --all-databases