tisa.g0v.tw development

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

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

Production

SSH 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

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

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

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

Some recent backups from the production environment

• http://140.112.20.144/tisa-2014-04-06.tar
• http://140.112.20.144/tisa-2014-04-10.tar
• http://140.112.20.144/tisa-2014-04-19.tar

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

Development

postgresql 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

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

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

Schema

Company

Tisa

CPC

Group

Category

Standard

Contributors

 nchild [email protected]

 Shelling Ford [email protected]

 howard chi [email protected]

 Johnson Liang [email protected]

 Shenk Wang [email protected]

 ipa chiu [email protected]

 Lucien Lee [email protected]

 WeiHung [email protected]