簡單小小script

網路上除了爬蟲外, 也不外乎有一堆殭屍, 每天都以打攪別人為樂
一直直看到一堆scanner在掃22以外的port
雖然放著也不會怎樣…
看久了心情就不太美麗…

好吧寫個script來維護一下世界和平

請服用….XD

#!/bin/bash
today=`date '+%m%d%y'`

ben_fail_ssh () {
grep 'Failed password' /var/log/auth.log | grep sshd | grep -o '[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}' | sort | uniq | awk '{print $1}' | while read IP
do
  if [ "$IP" != "127.0.0.1" ] && [ "$IP" != "122.116.33.14" ] && [ "$IP" != "118.163.31.241" ] ; then
    /sbin/iptables -A INPUT -s $IP -j DROP
  fi
done

/sbin/iptables-save >/root/rule/iptables_"$today".rule
}

backup_rule () {
/sbin/iptables-save >/root/rule/iptables_"$today".rule
/bin/sed -i '/fail2ban/d' /root/rule/iptables_"$today".rule
/bin/cp /root/rule/iptables_"$today".rule /etc/iptables.ipv4
}

reset_fw () {
echo "
*filter
:INPUT ACCEPT [650:121885]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [688:83029]
:fail2ban-ssh - [0:0]
:fail2ban-ssh443 - [0:0]
-A INPUT -p tcp -m multiport --dports 443 -j fail2ban-ssh443
-A INPUT -p tcp -m multiport --dports 22 -j fail2ban-ssh
-A fail2ban-ssh -j RETURN
-A fail2ban-ssh443 -j RETURN
COMMIT" > default.rule
/sbin/iptables-restore < default.rule
rm default.rule
}

clean_rule () {
cat $1 | grep -o '[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}' | sort | uniq | awk '{print $1}' | while read IP
do
  if [ "$IP" != "127.0.0.1" ] && [ "$IP" != "122.116.33.14" ] && [ "$IP" != "118.163.31.241" ] ; then
    echo iptables -A INPUT -s $IP -j DROP
    /sbin/iptables -A INPUT -s $IP -j DROP
  fi
done
}

ben_fail_ssh
reset_fw
clean_rule /root/rule/iptables_"$today".rule
backup_rule

#!/bin/bash

today=`date '+%m%d%y'`

ben_fail_ssh () {

grep 'Failed password' /var/log/auth.log | grep sshd | grep -o '[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}' | sort | uniq | awk '{print $1}' | while read IP

if [ "$IP" != "127.0.0.1" ] && [ "$IP" != "122.116.33.14" ] && [ "$IP" != "118.163.31.241" ] ; then

/sbin/iptables -A INPUT -s $IP -j DROP

done

/sbin/iptables-save >/root/rule/iptables_"$today".rule

}

backup_rule () {

/sbin/iptables-save >/root/rule/iptables_"$today".rule

/bin/sed -i '/fail2ban/d' /root/rule/iptables_"$today".rule

/bin/cp /root/rule/iptables_"$today".rule /etc/iptables.ipv4

}

reset_fw () {

echo "

*filter

:INPUT ACCEPT [650:121885]

:FORWARD ACCEPT [0:0]

:OUTPUT ACCEPT [688:83029]

:fail2ban-ssh - [0:0]

:fail2ban-ssh443 - [0:0]

-A INPUT -p tcp -m multiport --dports 443 -j fail2ban-ssh443

-A INPUT -p tcp -m multiport --dports 22 -j fail2ban-ssh

-A fail2ban-ssh -j RETURN

-A fail2ban-ssh443 -j RETURN

COMMIT" > default.rule

/sbin/iptables-restore < default.rule

rm default.rule

}

clean_rule () {

cat $1 | grep -o '[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}' | sort | uniq | awk '{print $1}' | while read IP

if [ "$IP" != "127.0.0.1" ] && [ "$IP" != "122.116.33.14" ] && [ "$IP" != "118.163.31.241" ] ; then

echo iptables -A INPUT -s $IP -j DROP

/sbin/iptables -A INPUT -s $IP -j DROP

done

}

ben_fail_ssh

reset_fw

clean_rule /root/rule/iptables_"$today".rule

backup_rule

技術

How to install cx_Oracle on mac?

step 1.
download software
instantclient-basic-xxxx-xxxx-x64.zip
instantclient-sdk-xxxx-xxxx-x64.zip

step 2.
解壓縮上述檔案到同一路徑

step 3.
create symbolic link
ln -s ~/path/path/libclntsh.dylib.11.1 libclntsh.dylib.11.1
ln -s ~/path/path/libclntsh.dylib.11.1 libclntsh.dylib
ln -s ~/path/path/libocci.dylib.11.1 libocci.dylib.11.1
ln -s ~/path/path/libocci.dylib.11.1 libocci.dylib

step 4.
setup env variable
export ORACLE_HOME=/path/path
export DYLD_LIBRARY_PATH=$ORACLE_HOME
export LD_LIBRARY=$ORACLE_HOME
export PATH=”$ORACLE_HOME:$PATH”

step 5.
disable sip
reboot CMD+R
command line：
csrutil disable

step 6.
install cx_Oracle
pip install cx_Oracle

done…:P

技術

auto restart service for windows

有人來跟我說,有一台service動不動就會死掉,
問我有什麼方法.

我找了找,又動手寫了一個python….XDD

pstools + python script + 設個定時執行

下面程式碼：
詳情請見https://github.com/CSWANG/auto_restart_service_for_windows/

# -*- coding:  utf-8 -*-
import subprocess
import time
import smtplib
import datetime
import ConfigParser
import os
import sys
import logging

cfg_pstools_path = "c:\pstools"

__version__ = '0.2'

def initLogging(logFilename):
    """Init for logging
    """
    logging.basicConfig(
        level=logging.DEBUG,
        format='%(asctime)s - %(levelname)s - %(message)s',
        datefmt='%Y/%m/%d %H:%M:%S',
        filename=logFilename,
        filemode='a')
    console = logging.StreamHandler()
    console.setLevel(logging.INFO)
    formatter = logging.Formatter('%(asctime)s %(levelname)-8s %(message)s')
    console.setFormatter(formatter)
    logging.getLogger('').addHandler(console)

def check_service(service_name):
    cmd = "%s\psservice.exe" % (cfg_pstools_path)
    pst = subprocess.Popen(
            [cmd, "query", service_name],
            stdout = subprocess.PIPE,
            stderr = subprocess.PIPE
        )

    out, error = pst.communicate()

    if out.find('RUNNING') > 0:
        return True
    else:
        return False

def start_service(service_name):
    cmd = "%s\psservice.exe" % (cfg_pstools_path)
    pst = subprocess.Popen(
            [cmd, "start", service_name],
            stdout = subprocess.PIPE,
            stderr = subprocess.PIPE
        )

    out, error = pst.communicate()

    if pst.returncode is not 0:
        return False
    return True

def mail(serverURL=None, strFrom='', strTo='', subject='', text=''):
    smtp = smtplib.SMTP()
    smtp.connect(serverURL)
    for x in strTo:
        headers = 'From: %s\r\nTo: %s\r\nSubject: %s\r\n\r\n' % (
            strFrom, x, subject)
        message = headers + text
        smtp.sendmail(strFrom, x, message)
    smtp.quit()

def main():
    start_time = datetime.datetime.now().strftime('%Y_%m_%d %H:%M:%S')
    path = os.path.realpath(os.path.dirname(sys.argv[0]))
    cnf_file = path + '\ps_check_service.cnf'
    config = ConfigParser.ConfigParser()
    config.read(cnf_file)
    service_list = [e.strip() for e in config.get('main', 'service_list').split(',')]
    error_code = 0

    logfile = path + '\ps_check_service.log'
    initLogging(logfile)
    logging.info('check service %s version: %s' % (start_time, __version__))
    
    if os.path.exists("script_status.txt"):
        logging.info('system is running or last time error, please check %s version:%s' % (start_time, __version__))
        service_list = []
        error_code = 1
    else:
        f = file("script_status.txt", "w")
        f.write(start_time)
        f.close()

    check_time = {}
    wait_time = 300
    mailserver = config.get('main', 'mailserver')
    sent = config.get('main', 'sent')

    contacts = [e.strip() for e in config.get('main', 'contacts').split(',')]

    for i in service_list:
        out = check_service(i)
        logging.info("check %s" % (i))

        if out == False:
            start_service(i)
            logging.info("service: %s" % (i))
            logging.info("service restart")
            logging.info("wait: %s" % (90))
            time.sleep(90)
            out = check_service(i)
            if out == False:
                check_time[i] = 1
                while check_time[i] < 3:
                    logging.info("wait_time: %s" % (wait_time))
                    time.sleep(wait_time)
                    start_service(i)
                    logging.info("service: %s service restart" % (i))
                    logging.info("wait: %s" % (90))
                    time.sleep(90)
                    out = check_service(i)
                    if out == False:
                        a = check_time[i]
                        a = a + 1
                        check_time[i] = a
                        error_code = 1
                    else:
                        error_code = 0
                if out == False and error == 1:
                    now = datetime.datetime.now().strftime('%Y_%m_%d %H:%M:%S')
                    subject = 'sapb1 %s service is down, please check %s' % (i, now)
                    msg = 'sapb1 %s service is down, please check %s' % (i, now)
                    logging.info("restart %s service is fail, time: %s" % (i, now))
                    mail(mailserver, sent, contacts, subject, msg)

    if error_code == 0:
        logging.info("check all done")
        os.remove("script_status.txt")

if __name__ == '__main__':
    main()

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

# -*- coding: utf-8 -*-

import subprocess

import time

import smtplib

import datetime

import ConfigParser

import os

import sys

import logging

cfg_pstools_path = "c:\pstools"

__version__ = '0.2'

def initLogging(logFilename):

"""Init for logging

"""

logging.basicConfig(

level=logging.DEBUG,

format='%(asctime)s - %(levelname)s - %(message)s',

datefmt='%Y/%m/%d %H:%M:%S',

filename=logFilename,

filemode='a')

console = logging.StreamHandler()

console.setLevel(logging.INFO)

formatter = logging.Formatter('%(asctime)s %(levelname)-8s %(message)s')

console.setFormatter(formatter)

logging.getLogger('').addHandler(console)

def check_service(service_name):

cmd = "%s\psservice.exe" % (cfg_pstools_path)

pst = subprocess.Popen(

[cmd, "query", service_name],

stdout = subprocess.PIPE,

stderr = subprocess.PIPE

)

out, error = pst.communicate()

if out.find('RUNNING') > 0:

return True

else:

return False

def start_service(service_name):

cmd = "%s\psservice.exe" % (cfg_pstools_path)

pst = subprocess.Popen(

[cmd, "start", service_name],

stdout = subprocess.PIPE,

stderr = subprocess.PIPE

)

out, error = pst.communicate()

if pst.returncode is not 0:

return False

return True

def mail(serverURL=None, strFrom='', strTo='', subject='', text=''):

smtp = smtplib.SMTP()

smtp.connect(serverURL)

for x in strTo:

headers = 'From: %s\r\nTo: %s\r\nSubject: %s\r\n\r\n' % (

strFrom, x, subject)

message = headers + text

smtp.sendmail(strFrom, x, message)

smtp.quit()

def main():

start_time = datetime.datetime.now().strftime('%Y_%m_%d %H:%M:%S')

path = os.path.realpath(os.path.dirname(sys.argv[0]))

cnf_file = path + '\ps_check_service.cnf'

config = ConfigParser.ConfigParser()

config.read(cnf_file)

service_list = [e.strip() for e in config.get('main', 'service_list').split(',')]

error_code = 0

logfile = path + '\ps_check_service.log'

initLogging(logfile)

logging.info('check service %s version: %s' % (start_time, __version__))

if os.path.exists("script_status.txt"):

logging.info('system is running or last time error, please check %s version:%s' % (start_time, __version__))

service_list = []

error_code = 1

else:

f = file("script_status.txt", "w")

f.write(start_time)

f.close()

check_time = {}

wait_time = 300

mailserver = config.get('main', 'mailserver')

sent = config.get('main', 'sent')

contacts = [e.strip() for e in config.get('main', 'contacts').split(',')]

for i in service_list:

out = check_service(i)

logging.info("check %s" % (i))

if out == False:

start_service(i)

logging.info("service: %s" % (i))

logging.info("service restart")

logging.info("wait: %s" % (90))

time.sleep(90)

out = check_service(i)

if out == False:

check_time[i] = 1

while check_time[i] < 3:

logging.info("wait_time: %s" % (wait_time))

time.sleep(wait_time)

start_service(i)

logging.info("service: %s service restart" % (i))

logging.info("wait: %s" % (90))

time.sleep(90)

out = check_service(i)

if out == False:

a = check_time[i]

a = a + 1

check_time[i] = a

error_code = 1

else:

error_code = 0

if out == False and error == 1:

now = datetime.datetime.now().strftime('%Y_%m_%d %H:%M:%S')

subject = 'sapb1 %s service is down, please check %s' % (i, now)

msg = 'sapb1 %s service is down, please check %s' % (i, now)

logging.info("restart %s service is fail, time: %s" % (i, now))

mail(mailserver, sent, contacts, subject, msg)

if error_code == 0:

logging.info("check all done")

os.remove("script_status.txt")

if __name__ == '__main__':

main()

技術

virtualbox usb boot for mac

這兩天,我都在弄usb大拇哥 boot

然後我找到
https://www.sebastien-han.fr/blog/2013/12/16/virtualbox-mac-os-x-10-dot-9-boot-from-an-usb-drive/

然後我又覺得上面的步驟好煩,就寫了一個python,來簡化流程…XDD

#-*- coding:  utf-8 -*-
import shlex
import getpass
import os
from subprocess import Popen, PIPE

def get_exitcode_stdout_stderr(cmd):
    """
    Execute the external command and get its exitcode, stdout and stderr.
    """
    args = shlex.split(cmd)

    proc = Popen(args, stdout=PIPE, stderr=PIPE)
    out, err = proc.communicate()
    exitcode = proc.returncode
    #
    return exitcode, out, err

list_disk ='diskutil list'
exitcode, out, err = get_exitcode_stdout_stderr(list_disk)

print out
print 'choose device'

device = raw_input("Enter device path: ")

#print 'umount %s' % (device)

umount_disk = 'diskutil umountdisk %s' % (device)
exitcode, out, err = get_exitcode_stdout_stderr(umount_disk)

password = getpass.getpass("Enter sudo password: ")

echo = Popen(['echo',password],
            stdout=PIPE,
            )
sudo = Popen(['sudo','-S','chmod','777', device],
            stdin=echo.stdout,
            stdout=PIPE,
            )

usb_vmdk = '/Users/csw/Documents/usbdrive.vmdk'
create_usb_vmdk = 'VBoxManage internalcommands createrawvmdk -filename %s -rawdisk %s' % (usb_vmdk, device)

vbox_del = 'vboxmanage unregistervm %s --delete' % ('USB_BOOT')

if os.path.exists(usb_vmdk):
	exitcode, out, err = get_exitcode_stdout_stderr('rm %s' % (usb_vmdk))
	exitcode, out, err = get_exitcode_stdout_stderr(create_usb_vmdk)
else:
	exitcode, out, err = get_exitcode_stdout_stderr(create_usb_vmdk)

print 'execut command:'
print 'umount_disk: %s' % (umount_disk)
print 'chmod: chmod 777 %s' % (device)
print 'create vmbox usb disk: %s' %(create_usb_vmdk)
print 'if you get "error VERR_RESOURCE_BUSY opening image file" message, re execute: %s' %(umount_disk)

#-*- coding: utf-8 -*-

import shlex

import getpass

import os

from subprocess import Popen, PIPE

def get_exitcode_stdout_stderr(cmd):

"""

Execute the external command and get its exitcode, stdout and stderr.

"""

args = shlex.split(cmd)

proc = Popen(args, stdout=PIPE, stderr=PIPE)

out, err = proc.communicate()

exitcode = proc.returncode

return exitcode, out, err

list_disk ='diskutil list'

exitcode, out, err = get_exitcode_stdout_stderr(list_disk)

print out

print 'choose device'

device = raw_input("Enter device path: ")

#print 'umount %s' % (device)

umount_disk = 'diskutil umountdisk %s' % (device)

exitcode, out, err = get_exitcode_stdout_stderr(umount_disk)

password = getpass.getpass("Enter sudo password: ")

echo = Popen(['echo',password],

stdout=PIPE,

)

sudo = Popen(['sudo','-S','chmod','777', device],

stdin=echo.stdout,

stdout=PIPE,

)

usb_vmdk = '/Users/csw/Documents/usbdrive.vmdk'

create_usb_vmdk = 'VBoxManage internalcommands createrawvmdk -filename %s -rawdisk %s' % (usb_vmdk, device)

vbox_del = 'vboxmanage unregistervm %s --delete' % ('USB_BOOT')

if os.path.exists(usb_vmdk):

exitcode, out, err = get_exitcode_stdout_stderr('rm %s' % (usb_vmdk))

exitcode, out, err = get_exitcode_stdout_stderr(create_usb_vmdk)

else:

exitcode, out, err = get_exitcode_stdout_stderr(create_usb_vmdk)

print 'execut command:'

print 'umount_disk: %s' % (umount_disk)

print 'chmod: chmod 777 %s' % (device)

print 'create vmbox usb disk: %s' %(create_usb_vmdk)

print 'if you get "error VERR_RESOURCE_BUSY opening image file" message, re execute: %s' %(umount_disk)

技術

How to Use LUKS to Encrypt a Disk Partition

install software
Ubuntu
apt-get install cryptsetup
aptitude install cryptsetup
Centos
yum install cryptsetup-luks

1. use device or create file

#check device
fdisk -l /dev/sdc
#create file
dd if=/dev/zero of=/root/secret bs=1M count=1024

#check device

fdisk -l /dev/sdc

#create file

dd if=/dev/zero of=/root/secret bs=1M count=1024

2. Encrypt the partition or file:

#device
cryptsetup -q -y luksFormat /dev/sdc1
#file
cryptsetup -q -y luksFormat /root/secret

#device

cryptsetup -q -y luksFormat /dev/sdc1

#file

cryptsetup -q -y luksFormat /root/secret

3. Map a logical partition:

#device
cryptsetup luksOpen /dev/sdc1 crypt_dev
#file
cryptsetup luksOpen /root/secret crypt_dev

#device

cryptsetup luksOpen /dev/sdc1 crypt_dev

#file

cryptsetup luksOpen /root/secret crypt_dev

This will create a device mapper:

#check /dev/mapper
ls -al /dev/mapper/crypt_dev

1 2	#check /dev/mapper ls -al /dev/mapper/crypt_dev

4. Format the encrypted partition:

mkfs.ext3 /dev/mapper/crypt_dev

1	mkfs.ext3 /dev/mapper/crypt_dev

5. Mount the encrypted partition:

mkdir /mnt/crypt_dev
mount /dev/mapper/crypt_dev /mnt/crypt_dev

1 2	mkdir /mnt/crypt_dev mount /dev/mapper/crypt_dev /mnt/crypt_dev

6. When done unmount the logical partition and close (unlock) the encrypted partition

unmount /mnt
cryptsetup luksClose crypt_dev

1 2	unmount /mnt cryptsetup luksClose crypt_dev

技術

紀錄一下, 或許在不久的未來, 這會變成紀念日也不一定…XDD

1 + 2 + 3 等於 5 喔….蛤~~

XDDD

技術

RPI fail2ban installation

很久沒寫技術BLOG了,今天來寫一下Fail2ban安裝說明…

網路上總是有人喜歡try ssh的密碼,不知為何就是一直try 一直try,或許人家也是中木馬,或許人家也是逼不得已…XD

因小弟有一個特別需求,無法只使用金鑰認證ssh（習慣上我都是設定ssh key來用）
所以就不得不把password開著…開著就一堆無聊的人一直try..try..try..看到就煩

所以就有請fail2ban來維護一下正義…
安裝方法很簡單
sudo apt-get install fail2ban iptables < --做完改設定/etc/fail2ban/jail.conf [ssh] bantime = -1 <--ban永遠 maxretry = 3 <--try三次就ban ban ban 打完收工... 不過這個做完有一個問題,雖然說設定是寫ban永遠...但是因為rpi的iptable不會紀錄,所以他每次reboot後就全部重來改一下/etc/init.d/fail2ban裡面的設定找到 do_stop() 然後在掛{內加入/sbin/iptables-save > /etc/iptables.conf

and
找 do_start()
找到return 0上一行加上/sbin/iptables-restore < /etc/iptables.conf 這樣reboot規則就不會不見了.... 了解?

技術, 生活

太久沒看open source 了

這幾天都在翻著open source,
想做的事情很多, 正在收集一些資料準備大幹一場…
結果突然發現…到底現在有什麼東西是open source不能控制的？？

我翻了翻…幾乎可以找的到的東西,open source 都可以控制,甚至無縫接軌
真是令我吃驚…XDDDD

燃燒吧,小宇宙…XDDD

技術

ORACLE Startup and Shutdown Script

#!/bin/bash

export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin

if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi

case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/emctl start dbconsole"

su oracle -c "/u01/app/oracle/product/11.1.0/db_1/bin/emctl start dbconsole"

touch /var/lock/oracle
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/emctl stop dbconsole"
rm -f /var/lock/oracle
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: `basename $0` start|stop|restart|reload"
exit 1
esac

exit 0

#!/bin/bash

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1

export ORACLE_OWNR=oracle

export PATH=$PATH:$ORACLE_HOME/bin

if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]

then

echo "Oracle startup: cannot start"

exit 1

case "$1" in

start)

# Oracle listener and instance startup

echo -n "Starting Oracle: "

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/emctl start dbconsole"

su oracle -c "/u01/app/oracle/product/11.1.0/db_1/bin/emctl start dbconsole"

touch /var/lock/oracle

echo "OK"

;;

stop)

# Oracle listener and instance shutdown

echo -n "Shutdown Oracle: "

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/emctl stop dbconsole"

rm -f /var/lock/oracle

echo "OK"

;;

reload|restart)

$0 stop

$0 start

;;

echo "Usage: `basename $0` start|stop|restart|reload"

exit 1

esac

exit 0

技術

更改sql developer 語系設定….

其實sqldeveloper是一個好物…在不用錢的狀況下:P

如果需要把他改變成english的話…只需要按照下面的方式修改…

~/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
把下列的設定加入到裏面去…
AddVMOption -Duser.language=en
AddVMOption -Duser.region=US
下次開sqldeveloper就會是english的了….

Chuan-Shun Wang’s Blog

「求知若飢，虛心若愚。」（Stay hungry. Stay foolish.）

技術

簡單小小script

How to install cx_Oracle on mac?

auto restart service for windows

virtualbox usb boot for mac

How to Use LUKS to Encrypt a Disk Partition

紀錄一下, 或許在不久的未來, 這會變成紀念日也不一定…XDD

RPI fail2ban installation

太久沒看open source 了

ORACLE Startup and Shutdown Script

更改sql developer 語系設定….