Skip to content

Instantly share code, notes, and snippets.

View songpon's full-sized avatar

Songpon Phusing songpon

12 followers · 21 following
View GitHub Profile
@songpon
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
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
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
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
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
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
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
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
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
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