tisa.g0v.tw development

最後編輯：2015-01-17 建立：2014-03-20 歷史紀錄

反黑箱服貿串連

SHELLING FThis board contains sensitive information and was shared to "invitees only".

Insensitive information should be going to 服貿協議相關 g0v 專案

SHELLING FProduction

SHELLING FSSH access

Transfer your `~/.ssh/id_rsa.pub` to authorized owners for ssh access without password.

$ ssh tisa@<ip>

If you don't have `id_rsa.pub`, run

$ ssh-keygen

Then you will have it in `~/.ssh/`

Machine List

For your conveniences to access rapidly, put this machines into your `~/.ssh/config` as following format.

Host tisa
HostName 162.243.145.68
User tisa
Port 22

tisa

Function: Reverse Proxy by Nginx, Postgresql 9.3 (Postgis Extension), App
IP: `162.243.145.68`

tisa-app1 (shut down)

Function: App
IP: `107.170.210.212`

tisa-app2 (shut down)

Function: App
IP: `107.170.209.101`

tisa-db1 (shut down)

Function: Database by Postgresql 9.3 (Postgis Extension)
IP: `107.170.209.102`
Running App as well

Deployment

All `/tisa-app\\d+/` machines have a clone of codebase at `~/tisa-map`. Currently we have no capistrano script. Just run

$ git pull

And restart unicorn server in `screen` session.

Database

setup

$ createuser tisa --superuser --encrypted --pwprompt
$ createdb tisa
$ sequel config/database.yml -m migrations

connection

To run Sequel console, put following content in `config/database.yml`

production:
:adapter: postgres
:host: 162.243.145.68
:database: tisa
:username: tisa
:password: tisamap
:encoding: utf8
:pool: 5

And run

$ sequel config/database.yml

backup

$ pg_dump --blobs --verbose --no-owner --format tar --encoding utf8 --file tisa-yyyy-mm-dd.tar tisa

Some recent backups from the production environment

restore

$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U tisa -d tisa --format tar tisa-yyyy-mm-dd.tar

SHELLING FDevelopment

SHELLING Fpostgresql array column

http://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/pg_array_rb.html

http://www.postgresql.org/docs/9.3/static/functions-array.html

postgresql json column

http://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/pg_json_rb.html

http://www.postgresql.org/docs/9.3/static/functions-json.html

KUANG-CHE W代碼對照表與服務貿易特定承諾表對照數字(紅字, 57 個)

https://www.dropbox.com/sh/xh488y46hgxjy6b/LFIfMNhQ_M

SHELLING FSchema

SHELLING FCompany

Tisa

CPC

Group

Category

Standard

NCHILDContributors

NCHILD nchild xchild@gmail.com

Shelling Ford navyblueshellingford@gmail.com

howard chi chilijung@gmail.com

Johnson Liang johnsonliang7@gmail.com

Shenk Wang shenkyw@gmail.com

ipa chiu ipawei@gmail.com

Lucien Lee lkiral7903@gmail.com

WeiHung wayne930242@gmail.com