Skip to content

Instantly share code, notes, and snippets.

@kenshero
Last active August 9, 2016 18:16
Show Gist options
  • Save kenshero/dfa15941977a4ca24f24 to your computer and use it in GitHub Desktop.
Save kenshero/dfa15941977a4ca24f24 to your computer and use it in GitHub Desktop.
Script Rails server
sudo apt-get update
sudo apt-get install git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev python-software-properties libffi-dev -y
cd
git clone git://github.com/sstephenson/rbenv.git .rbenv
echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bash_profile
echo 'eval "$(rbenv init -)"' >> ~/.bash_profile
git clone git://github.com/sstephenson/ruby-build.git ~/.rbenv/plugins/ruby-build
echo 'export PATH="$HOME/.rbenv/plugins/ruby-build/bin:$PATH"' >> ~/.bash_profile
source ~/.bash_profile
rbenv install -v 2.2.2
rbenv global 2.2.2
echo "gem: --no-document" > ~/.gemrc
gem install bundler
gem install rails
rbenv rehash
sudo add-apt-repository ppa:chris-lea/node.js -y
sudo apt-get update
sudo apt-get install nodejs -y
gpg --keyserver keyserver.ubuntu.com --recv-keys 561F9B9CAC40B2F7
gpg --armor --export 561F9B9CAC40B2F7 | sudo apt-key add -
sudo apt-get install apt-transport-https -y
sudo sh -c "echo 'deb https://oss-binaries.phusionpassenger.com/apt/passenger trusty main' >> /etc/apt/sources.list.d/passenger.list"
sudo chown root: /etc/apt/sources.list.d/passenger.list
sudo chmod 600 /etc/apt/sources.list.d/passenger.list
sudo apt-get update
sudo apt-get install nginx-full passenger -y
sudo apt-get install postgresql postgresql-contrib libpq-dev -y
@kenshero
Copy link
Author

Start

sudo adduser xxx
sudo adduser xxx sudo
su xxx

client
ssh-copy-id xxx@IPADDRESS

@kenshero
Copy link
Author

Nginx > /etc/nginx/site-enabled/default

server {
listen 80 default_server;
listen [::]:80 default_server ipv6only=on;
server_name mydomain.com;
passenger_enabled on;
rails_env production;
root /home/deploy/myapp/current/public;
# redirect server error pages to the static page /50x.html
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

/etc/nginx/nginx.conf

/
/ Phusion Passenger
//
/ Uncomment it if you installed ruby-passenger or ruby-passenger-enterprise
//

passenger_root /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini;

passenger_ruby /home/deploy/.rbenv/shims/ruby; # If you use rbenv
// passenger_ruby /home/deploy/.rvm/wrappers/ruby-2.1.2/ruby; # If use use rvm, be sure to change the version number
// passenger_ruby /usr/bin/ruby; # If you use ruby from source

@kenshero
Copy link
Author

kenshero commented May 2, 2016

DROP DATABASE xxxxx;

REVOKE CONNECT ON DATABASE database_name FROM public;

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment