Last active
October 7, 2015 04:07
-
-
Save the-teacher/3103066 to your computer and use it in GitHub Desktop.
UBUNTU + RAILS
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| VBOX | |
| C:\Users\USER\VirtualBox VMs\Ubuntu>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" modifyhd Ubuntu.vdi --resize 10000 | |
| BUTTONS | |
| gconftool-2 --set "/apps/metacity/general/button_layout" --type string "menu:minimize,maximize,close" | |
| gsettings set org.gnome.desktop.wm.preferences button-layout ':minimize,maximize,close' | |
| GNOME COMMANDER | |
| sudo apt-get install gnome-commander -y | |
| COMMON | |
| sudo apt-get update | |
| sudo apt-get install build-essential bison openssl libreadline6 libreadline6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-0 libsqlite3-dev sqlite3 libxslt1.1 libxslt1-dev libxml2 libxml2-dev libxslt-dev autoconf libc6-dev nodejs -y | |
| GIT | |
| sudo apt-get install git -y | |
| git --version | |
| git config --global user.name "User Name" | |
| git config --global user.email "[email protected]" | |
| GITK | |
| sudo apt-get install gitk -y | |
| gitk | |
| IMAGE MAGICK | |
| sudo apt-get install imagemagick librmagick-ruby libmagickwand-dev -y | |
| convert --version | |
| POSTGRESQL | |
| sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev postgresql-server-dev-9.1 pgadmin3 -y | |
| sudo -u postgres psql postgres | |
| CREATE ROLE "ADMIN_NAME" PASSWORD 'qwerty' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN; | |
| \q | |
| sudo /etc/init.d/postgresql restart | |
| psql postgres ADMIN_NAME | |
| SELECT version(); | |
| SELECT datname FROM pg_database; | |
| \q | |
| MySQL | |
| sudo apt-get install mysql-server mysql-common mysql-client libmysqlclient-dev libmysql-ruby -y | |
| mysql --version | |
| mysql -u root -pqwerty | |
| REDIS | |
| sudo apt-get install redis-server -y | |
| redis-server -v | |
| MONGODB | |
| sudo apt-key adv --keyserver keyserver.ubuntu.com --recv 7F0CEB10 | |
| sudo -i | |
| echo "deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen" >> /etc/apt/sources.list | |
| ctrl+D | |
| sudo apt-get update | |
| sudo apt-get install mongodb-10gen | |
| mongo --version | |
| MONGODB Problem | |
| sudo rm /var/lib/mongodb/mongod.lock | |
| sudo -u mongodb mongod -f /etc/mongodb.conf --repair | |
| sudo service mongodb start | |
| http://cheat.errtheblog.com/s/mongo | |
| NODE.JS (TODO UPDATE NODE) | |
| sudo apt-get install nodejs -y | |
| process.exit() | |
| nodejs --version | |
| SPHINX | |
| cd ~ && mkdir sphinx && cd ~/sphinx | |
| wget http://sphinxsearch.com/files/sphinx-2.0.4-release.tar.gz | |
| tar xvzf sphinx-2.0.4-release.tar.gz | |
| cd sphinx-2.0.1-beta/ | |
| ./configure --with-pgsql --with-mysql | |
| make | |
| sudo make install | |
| searchd | |
| RVM (04.2013) | |
| # set terminal env => https://rvm.io/integration/gnome-terminal/ | |
| \curl -L https://get.rvm.io | bash -s stable --rails --autolibs=enabled # Or, --ruby=1.9.3 | |
| rvm notes | |
| rvm list | |
| (!) readline | |
| rvm --skip-autoreconf pkg install readline | |
| rvm install 1.9.3 --with-readline-dir=$rvm_path/usr | |
| cd ~/.rvm/src/ruby-1.9.3-pXXX/ext/readline | |
| ruby extconf.rb -- --with-readline-dir=~/.rvm/patches/readline-6.2/ | |
| make && make install | |
| rvm --default use 1.9.3 | |
| rvm gemset create frontend | |
| rvm gemset use frontend | |
| # now `rails c` should works! | |
| (!) autoload | |
| edit ~/.bashrc | |
| [ -z "$PS1" ] && return => if [[ -n "$PS1" ]]; then | |
| Add to end of file | |
| if [[ -s $HOME/.rvm/scripts/rvm ]] ; then source $HOME/.rvm/scripts/rvm ; fi | |
| fi | |
| shell reload => source ~/.bashrc | |
| Keys | |
| mkdir .ssh && cd .ssh/ | |
| copy files | |
| PhantomJS | |
| sudo -i | |
| cd /tmp | |
| wget https://phantomjs.googlecode.com/files/phantomjs-1.9.0-linux-x86_64.tar.bz2 | |
| tar xvjf phantomjs-1.9.0-linux-x86_64.tar.bz2 | |
| mkdir -p /opt/bin | |
| cp phantomjs-1.9.0-linux-x86_64/bin/phantomjs /opt/bin | |
| echo 'export PATH="$PATH:/opt/bin"' > /etc/profile.d/opt.sh | |
| exit | |
| vi .bash_profile => comment export PATH | |
| QT + Capybara | |
| sudo apt-get install libqt4-dev | |
| gem install capybara-webkit -v '0.14.2' | |
| ============================================ | |
| RVM (old) | |
| # set terminal env => https://rvm.io/integration/gnome-terminal/ | |
| curl -L https://get.rvm.io | bash -s stable --ruby | |
| rvm notes | |
| sudo apt-get install libncurses5-dev libreadline6 libreadline6-dev | |
| rvm --skip-autoreconf pkg install readline | |
| rvm install 1.9.3 --with-readline-dir=$rvm_path/usr | |
| rvm --default use 1.9.3 | |
| gem install rails --no-ri --no-rdoc | |
| rm -rf $rvm_path/usr | |
| rvm requirements | |
| rvm reinstall 1.9.3 | |
| #rvm install 1.9.2 --with-readline-dir=$rvm_path/usr | |
| #rvm --default use 1.9.2 | |
| #rvm use 1.9.2 | |
| #cd ~/.rvm/src/ruby-1.9.2-p290/ext/readline | |
| #ruby extconf.rb -- --with-readline-dir=~/.rvm/patches/readline-6.2/ | |
| #make && make install | |
| #ruby -v | |
| #gem install rails --no-ri --no-rdoc |
Author
Author
481 touch /usr/share/postgresql/9.1/extension/hstore.control
493 touch /usr/share/postgresql/9.1/extension/hstore--1.sql
Author
sudo -u postgres psql my_app_development
create extension hstore;
psql -d zykin_ilya_production -c '\dx'
Author
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
\c template1
VACUUM FREEZE;
UPDATE pg_database SET datallowconn = FALSE WHERE datname = 'template1';
Author
\df hstore
\dT
Author
pg_restore -h localhost -d inmyroom_development ./dump.sql
Author
find / -name 'postgresql.conf'
vi /Users/admin/Library/Application\ Support/Postgres93/var/postgresql.conf
netstat -an | grep 5432
sudo mkdir /var/pgsql_socket
sudo chmod 777 /var/pgsql_socket
(!) pgsql restart
Author
brew install sphinx --mysql --pgsql
Author
brew install redis
Author
psql -h localhost -d database_development -c 'CREATE EXTENSION dblink'
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
RAILS_ENV=production rake db:setup
psql:/yourprojectpath/yourproject/db/structure.sql:29: ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/hstore.control": No such file or directory
sudo apt-get install postgresql-contrib
psql -d yourproject_production -U yourdbuser -W
CREATE EXTENSION hstore;
\q
RAILS_ENV=production rake db:drop
RAILS_ENV=production rake db:setup