UBUNTU + RAILS

gistfile1.sh

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

netstat -lnp | grep mongo

$ which psql
/usr/bin/psql
$ psql
psql: FATAL: role "octave" does not exist
$ sudo -u postgres createuser octave
Shall the new role be a superuser? (y/n) y
$ psql
psql: FATAL: database "octave" does not exist
$ createdb
$ psql

vi /etc/apt/sources.list

touch /etc/apt/sources.list.d/pgdg.list
echo >> "deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main"

dpkg -l libgcrypt11
cat /proc/version
wget http://security.debian.org/debian-security/pool/updates/main/libg/libgcrypt11/libgcrypt11_1.5.0-5+deb7u1_amd64.deb
dpkg --get-selections | grep cryp
dpkg --purge --force-all libgcrypt11:i386

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

481 touch /usr/share/postgresql/9.1/extension/hstore.control
493 touch /usr/share/postgresql/9.1/extension/hstore--1.sql

sudo -u postgres psql my_app_development
create extension hstore;
psql -d zykin_ilya_production -c '\dx'

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';

\df hstore
\dT

pg_restore -h localhost -d inmyroom_development ./dump.sql

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

brew install sphinx --mysql --pgsql

brew install redis

psql -h localhost -d database_development -c 'CREATE EXTENSION dblink'