Skip to content

Instantly share code, notes, and snippets.

View benoitjpnet's full-sized avatar
🇯🇵
Working from home

Benoit benoitjpnet

🇯🇵
Working from home
View GitHub Profile
@benoitjpnet
benoitjpnet / repairmysql.sh
Created July 9, 2014 09:38
Check for crashed MySQL table in syslog and launch a repair.
#!/bin/bash
tables=$(grep crashed /var/log/syslog | grep -Eo \'\./.*\' --color=auto | sed s#\'./## | sed s#\'## | uniq | tr -s '\n' ' ')
for tableC in $tables; do
db=${tableC%/*}
table=${tableC#*/}
mysqlcheck --auto-repair --check $db $table
done
grep '"POST ' access.log | grep -ve cron -e login -e admin -e xmlrpc -e trackback -e comment -e 404
@benoitjpnet
benoitjpnet / POSTSuspect.sh
Created October 20, 2014 13:46
Search for suspects POST in apache.log (often attacks)
grep -Eo '"POST .*.php' access.log | grep -ve cron -e login -e admin -e xmlrpc -e trackback -e comment -e 404 | sort -u
@benoitjpnet
benoitjpnet / check_http_many.sh
Last active August 29, 2015 14:11
Nagios wrapper for check_http and other http related checks.
#!/bin/bash
result=/tmp/nagios.check_http_many.result
trap "rm ${result}*" EXIT
warning=false
critical=false
check_state() {
if [[ $1 -eq 0 ]]; then

convert google takeout archive for location history from kml to gpx and split file into one per day

gpsbabel -i kml -f Location\ History.kml -o gpx -F out.gpx
gpsbabel -t -i gpx -f out.gpx -x track,merge,pack,split,title="ACTIVE LOG # %Y%m%d" -o gpx -F split.gpx
python2 gpxsplitter.py split.gpx