Sysadmin

De Álvaro Ortiz
Saltar a: navegación, buscar

Network

Check iptables rules (source)

sudo iptables -L -nv

Ban ip with iptables

sudo iptables -I INPUT -s 196.52.32.4 -j DROP

Show all active connections to Web server – sorted and unique (source)

netstat -antu | grep :80 | grep -v LISTEN | awk '{print $5}' | cut -d: -f1 | sort | uniq -c

Check what processes are consuming active IPs

sudo netstat -tunp

Utilities

MySQL backups

mysqldump -u USER -p your_database_name | gzip > your_database_name.sql

Postgresql

  • Start server in OS X: pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
  • Stop: pg_ctl -D /usr/local/var/postgres stop -s -m fast
  • createuser USER
  • createdb DB

Rails in production

SSH

Change default SSH port + Prevent root user from loging in via SSH

vi /etc/ssh/sshd_config
PermitRootLogin no
Port 50683
/etc/init.d/ssh restart
ssh username@hostname.com -p 50683

Problems installing gems in Mac OS X

If error:

clang: error: unknown argument: '-multiply_definedsuppress' [-Wunused-command-line-argument-hard-error-in-future]


Solution

ARCHFLAGS=-Wno-error=unused-command-line-argument-hard-error-in-future gem install ...


Data

Transform MS Access file to CSV https://github.com/brianb/mdbtools

Mumumío

IP en .Vagrantfile

vagrant up
vagrant ssh
cd /vagrant
rails server

Deploy

merge de stage hacia develop, y luego de develop hacia master. Así:

git co develop
git merge stage
git co master
git push # No te olvides del push!
cap production deploy