Songpon Phusing songpon

Digital Transform Consultant

songpon / firewall.sh

Created February 17, 2017 15:40

	#!/bin/bash

	echo "Stopping firewall and allowing everyone..."
	iptables -F
	iptables -X
	iptables -t nat -F

songpon / install-pyenv-and-python3.6.0.sh

Created February 17, 2017 16:29

	#!/bin/bash

	# install vim .bash
	git clone https://github.com/amix/vimrc.git ~/.vim_runtime
	sh ~/.vim_runtime/install_awesome_vimrc.sh

songpon / psql-kill-process.sql

Created March 2, 2017 05:40

postresql kill all process

	SELECT
	pg_terminate_backend(pid)
	FROM
	pg_stat_activity
	WHERE
	-- don't kill my own connection!
	pid <> pg_backend_pid()
	-- don't kill the connections to other databases
	AND datname = 'database_name'
	;

songpon / install-java-8-ubuntu.sh

Last active May 12, 2017 03:48

	sudo add-apt-repository -y ppa:webupd8team/java && sudo apt-get update
	sudo apt-get install oracle-java8-installer -y
	sudo apt install oracle-java8-set-default unzip -y

songpon / install-pentaho7-java8-ubuntu.sh

Created May 12, 2017 03:50


	sudo add-apt-repository -y ppa:webupd8team/java && sudo apt-get update
	sudo apt-get install oracle-java8-installer -y
	sudo apt install oracle-java8-set-default unzip -y
	cd /opt
	wget https://jaist.dl.sourceforge.net/project/pentaho/Business%20Intelligence%20Server/7.0/pentaho-server-ce-7.0.0.0-25.zip
	unzip pentaho-server-ce-7.0.0.0-25.zip

songpon / get_my_public_ip.sh

Created July 15, 2017 09:46

	#!/bin/bash
	dig TXT +short o-o.myaddr.l.google.com @ns1.google.com \| awk -F'"' '{ print $2}'

songpon / replace-file-pattern.sh

Created July 22, 2017 14:10

 !/bin/bash
 for f in *; do mv "$f" "`echo $f | sed s/search_str/replace_str/`"; done
 # example
 #for f in *; do mv "$f" "`echo $f | sed s/_NongZEZA@CtHts//`"; done

songpon / iptable-block-non-TH-SG.sh

Created September 1, 2017 08:03

	#!/bin/bash

	echo "Stopping firewall and allowing everyone..."
	iptables -F
	iptables -X
	iptables -t nat -F
	iptables -t nat -X
	iptables -t mangle -F
	iptables -t mangle -X
	iptables -P INPUT ACCEPT

songpon / setup-pyenv.sh

Created October 3, 2017 04:50

	#!/bin/bash

	# install vim .bash
	git clone https://github.com/amix/vimrc.git ~/.vim_runtime
	sh ~/.vim_runtime/install_awesome_vimrc.sh

	# install pyenv
	curl -L https://raw.githubusercontent.com/yyuu/pyenv-installer/master/bin/pyenv-installer \| bash

	# set to .bashrc

songpon / audio2video.sh

Created October 27, 2017 08:09

	#!/bin/bash

	image_name=$(od -A n -t d -N 1 /dev/urandom)


	#Replace unused string in caption ( extension dot)
	caption=$(echo $1 \| sed -r 's/_/ /g;s/\./ /g; s/mp3//gI; s/m4a//gI')

	convert -background black -size 800x480 -fill "#ff0080" -pointsize 72 -gravity center caption:"$caption" $image_name.png
	ffmpeg -loop 1 -r ntsc -i $image_name.png -i "$1" -c:a copy -c:v libx264 -preset fast -threads 0 -shortest "$1".mkv