Diferencia entre revisiones de «Sysadmin»
Ir a la navegación
Ir a la búsqueda
(No se muestran 10 ediciones intermedias del mismo usuario) | |||
Línea 1: | Línea 1: | ||
+ | == Network == | ||
+ | |||
+ | Check iptables rules ([https://www.linode.com/docs/security/firewalls/control-network-traffic-with-iptables source]) | ||
+ | <pre>sudo iptables -L -nv</pre> | ||
+ | |||
+ | Ban ip with iptables | ||
+ | <pre>sudo iptables -I INPUT -s 196.52.32.4 -j DROP</pre> | ||
+ | |||
+ | Show all active connections to Web server – sorted and unique ([https://www.blackmoreops.com/2014/09/25/find-number-of-unique-ips-active-connections-to-web-server/ source]) | ||
+ | <pre> | ||
+ | netstat -antu | grep :80 | grep -v LISTEN | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | ||
+ | </pre> | ||
+ | |||
+ | Check what processes are consuming active IPs | ||
+ | <pre> | ||
+ | sudo netstat -tunp | ||
+ | </pre> | ||
+ | |||
+ | == Utilities == | ||
+ | |||
+ | * http://pow.cx/ | ||
+ | |||
== MySQL backups == | == MySQL backups == | ||
Línea 40: | Línea 62: | ||
ARCHFLAGS=-Wno-error=unused-command-line-argument-hard-error-in-future gem install ... | 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 | ||
+ | |||
+ | <pre> | ||
+ | vagrant up | ||
+ | vagrant ssh | ||
+ | cd /vagrant | ||
+ | rails server | ||
+ | </pre> | ||
+ | |||
+ | '''Deploy''' | ||
+ | |||
+ | merge de stage hacia develop, y luego de develop hacia master. Así: | ||
+ | |||
+ | <pre> | ||
+ | git co develop | ||
+ | git merge stage | ||
+ | git co master | ||
+ | git push # No te olvides del push! | ||
+ | cap production deploy | ||
+ | </pre> |
Revisión actual del 20:57 12 nov 2017
Sumario
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
- Deploy Rails App with Puma and Nginx via Mina
- Digital Ocean: Ubuntu, Nginx, Unicorn, Rails
- Ubuntu, Rails ready, with nginx & unicorn
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 [email protected] -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