francois-blanchard

Backup server with gem Backup and Whenever

Config Backup

Install backup gem

$ gem install backup

Generate Backup files see doc for genrate's options

francois-blanchard

Create nested attributes with checkbox

# Class
has_many :sc_invited_celebrities
accepts_nested_attributes_for :proposed_posts, :sc_invited_celebrities, :answer_to_questions

# Controller
def new
 @social_campaign = SocialCampaign.new

francois-blanchard

Add user MySQL

> CREATE DATABASE name_database;
> CREATE USER 'name_user'@'ip_or_localhost' IDENTIFIED BY 'choose_password';
> GRANT ALL PRIVILEGES ON name_database.* TO 'name_user'@'ip_or_localhost';
> FLUSH PRIVILEGES;

Delete user

francois-blanchard

Error Capistrano deploy - fatal: Could not parse object 'xx...xx'

1. Connect you to your server $ ssh user@myserver
2. Go to your deploy path and select the shared directorycd /your/directory/deploy/shared
3. Remove the git cache rm -rf cached-copy
4. Retry to deploy & have fun ;)

francois-blanchard

How to debug a failed travis.ci build

1/ Go to travais build

https://travis-ci.com/gitUser/gitRepo/builds/XXXXXX

2/ Connect to travis build with ssh

francois-blanchard

Google cloud - Manage ip instance with gcloud

Before you begin

Install & config

1. Install the gcloud command-line tool.
2. Set a default region and zone.

List items

francois-blanchard

Check and Repair MySQL Tables Using Mysqlcheck

Check a Specific Table in a Database

$ mysqlcheck -c database_name table_name -u root -p

Check All Tables in a Database

francois-blanchard

Intro

This script concat all csv file (by default order) in one csv file result.csv only with first and second columns. Additional behaviour : skip 8 first lines (header) and 5 last lines (footer)

Requirements

brew install coreutils

Tips

francois-blanchard

MySQL Server: Bind To Multiple IP Address

$ vi /etc/mysql/my.cnf
> bind-address    = 0.0.0.0
> #skip-networking

## Block all connections to 3306 ##

francois-blanchard

Configure server for deploy rails app

Objective

Prepare a server for a Rails app with MySQL (percona) + NGINX (passenger)
Deploy rails app in new server with Capistrano v3

For this example we need :

• server
• git repo with rails app (here i use ruby 2.1.1 and rails 4.1.2)
• knife solo (http://matschaffer.github.io/knife-solo/)