Diferencia entre revisiones de «Sysadmin»
Ir a la navegación
Ir a la búsqueda
Línea 45: | Línea 45: | ||
Transform MS Access file to CSV https://github.com/brianb/mdbtools | 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: <code>cap production deploy</code> |
Revisión del 11:00 8 sep 2015
Sumario
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: cap production deploy