okisanjp’s gists

okisanjp / gist:9652cd1fcb53444ffbfc

Created July 15, 2014 11:39

Windows8.1 SublimeTest2の設定ディレクトリをDropboxに

mklink /D "C:\Users\USERNAME\AppData\Roaming\Sublime Text 2" "C:\Users\USERNAME\Dropbox\settings\Library\Application Support\Sublime Text 2"

okisanjp / chef-solo-cook-multihost.sh

Created July 10, 2014 02:16

chef-solo cookを複数サイトに実行

hosts="hostname1 hostname2" && for host in $hosts; do knife solo cook USERNAME@$host; done

okisanjp / gist:11363552

Created April 28, 2014 06:47

Node.js + npm.request -> Leftronic Sparkgraph

	var request = require('request');
	var data = {
	"accessKey": "ACCESSKEY",
	"streamName": "test_sparkline",
	"point": [{
	"number": 40,
	"timestamp": Math.floor((new Date)/1000)
	}]
	}

okisanjp / gist:8431277

Last active January 3, 2016 07:39

zabbixagent：rootで動かす設定を入れ忘れちゃった環境で、AllowRoot設定などを入れて再起動するワンライナー。設定部分は適宜調整。

ZAB_SERVER="ZABBIX_SERVER_FQDN" && echo -e "Server=$ZAB_SERVER\nServerActive=$ZAB_SERVER\nHostnameItem=system.hostname\nInclude=/etc/zabbix/zabbix_agentd.d/\nEnableRemoteCommands=1\nLogRemoteCommands=1\nAllowRoot=1\nLogFile=/var/log/zabbix/zabbix_agentd.log\nLogFileSize=0\nTimeout=30\n" > /etc/zabbix/zabbix_agentd.conf && /etc/init.d/zabbix-agent restart && /sbin/chkconfig zabbix-agent on

okisanjp / gist:7953760

Created December 13, 2013 23:55

Zabbix：MySQLレプリケーション遅延秒数

system.run[mysql -uUSERNAME -pPASSWORD -e'SHOW SLAVE STATUS\G' | grep "Seconds_Behind_Master" | awk {'print $2'}]

okisanjp / gist:7744658

Last active December 29, 2015 23:39

Zabbix MySQL Slaveのレプリケーション進捗率簡易版

UserParameter=mysql.repl_rate,EXEC=`mysql -e'SHOW SLAVE STATUS\G' | grep "Exec_Master_Log_Pos" | awk {'print $2'}` && READ=`mysql -e'SHOW SLAVE STATUS\G' | grep "Read_Master_Log_Pos" | awk {'print $2'}` && echo "scale=2; $EXEC / $READ" | bc

okisanjp / gist:7686822

Last active December 29, 2015 14:49

一行に1つずつIPアドレスが書いてあるファイルを読み込んで国コード毎に集計。php geoipが使えるようになってることが前提

	<?php
	$filename = "ip.txt";
	$data = fopen($filename,'r');
	$result = array();
	while (!feof($data)){
	$ip = fgets($data);
	if($ip){
	$code = @geoip_country_code_by_name($ip);
	if(!isset($result[$code])){
	$result[$code] = 0;

okisanjp / gist:7465900

Last active December 28, 2015 07:39

CentOSにzabbix-agent2.0を入れるときの作業用ひな形。実際には&&で全部つなげてワンライナーにして使います。 confは新しく作り直してるので入れておきたいオプションがあれば適宜追加で。 RHEL5/6系ならi386でもx86_64でも使えるはず。

	OS_VER="5"
	OS_TYPE="x86_64"
	ZAB_VER="2.0.9"
	ZAB_SERVER="ZABBIX_SERVER_IP_OR_FQDN"
	rpm -ivh http://repo.zabbix.com/zabbix/2.0/rhel/$OS_VER/$OS_TYPE/zabbix-$ZAB_VER-1.el$OS_VER.$OS_TYPE.rpm http://repo.zabbix.com/zabbix/2.0/rhel/$OS_VER/$OS_TYPE/zabbix-agent-$ZAB_VER-1.el$OS_VER.$OS_TYPE.rpm
	mv /etc/zabbix/zabbix_agentd.conf /etc/zabbix/zabbix_agentd.conf.org
	echo -e "Server=$ZAB_SERVER\nServerActive=$ZAB_SERVER\nHostnameItem=system.hostname\nInclude=/etc/zabbix/zabbix_agentd.d/\nEnableRemoteCommands=1\nLogRemoteCommands=1\nAllowRoot=1\nLogFile=/var/log/zabbix/zabbix_agentd.log
	\nLogFileSize=0\n" > /etc/zabbix/zabbix_agentd.conf
	/etc/init.d/zabbix-agent start
	/sbin/chkconfig zabbix-agent on

okisanjp okisanjp