-
-
Save the-teacher/3103066 to your computer and use it in GitHub Desktop.
| 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 "user@gmail.com" | |
| 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'
rvm install ruby-2.0.0-p247 --with-readline-dir=$rvm_path/usr
gem update --system
rvm use ruby-2.0.0-p247@open-cook --create