Skip to content

Instantly share code, notes, and snippets.

# Mac Homebrew command to install the RDS command-line tools
# Ubuntu users may find https://launchpad.net/~awstools-dev/+archive/awstools/ useful
brew install rds-command-line-tools
rds-create-db-parameter-group mysql-utf8 -f mysql5.1 -d "MySQL 5.1 configured for UTF-8"
rds-modify-db-parameter-group mysql-utf8 \
--parameters="name=character_set_server, value=utf8, method=immediate" \
--parameters="name=character_set_client, value=utf8, method=immediate" \
--parameters="name=character_set_results, value=utf8, method=immediate" \
@randika
randika / error_fix
Created February 16, 2014 03:57
Offending RSA key - Host key verification failed.
Error
Offending RSA key in /Users/USER/.ssh/known_hosts:22
RSA host key for 128.xxx.xxx.xxx has changed and you have requested strict checking.
Host key verification failed.
Fix
ssh-keygen -R 128.xxx.xxx.xxx
@randika
randika / config_note
Created February 11, 2014 04:35
php-fpm nginx 504 Gateway Timeout error
Edit
vim /etc/nginx/sites-available/example.com
location ~ \.php$ {
...
fastcgi_read_timeout 300; # Add this line
...
}
Edit
<?php
$user_signup_password = 'password';
$pass = urlencode($user_signup_password);
$salt = substr(str_replace('+', '.', base64_encode(sha1(microtime(true), true))), 0, 22);
// 2a is the bcrypt algorithm selector
// 12 is the workload factor
<?php
$user_signup_password = 'password';
$pass = urlencode($user_signup_password);
$pass_crypt = crypt($pass); // Crypt will add a salt by default
echo "signup password: ".$pass_crypt; // You save this on database
$user_login_password = "password"; // This is what will you enter when login - change this to see if it works

install php

with mysql pgsql intl support

$ brew install php --with-apache --with-mysql --with-pgsql --with-intl

set php timezone in php ini

date.timezone = Europe/Vienna
@randika
randika / config_notes
Last active January 3, 2016 18:18
Install Oracle Java on Ubuntu 12 or 13
$ sudo add-apt-repository ppa:webupd8team/java
$ sudo apt-get update
$ sudo apt-get install oracle-java7-installer
$ java -version
java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)
@randika
randika / gist:7924336
Created December 12, 2013 07:24
PHP extension Mcrypt in Ubuntu 13.10 (Nginx, PHP-FPM)
Make symbolic link to ini files in mods-available
sudo ln -s /etc/php5/conf.d/mcrypt.ini /etc/php5/mods-available/mcrypt.ini
Enable mods
sudo php5enmod mcrypt
Restart FPM
sudo service php5-fpm restart
@randika
randika / ec2_notes
Created November 28, 2013 06:28 — forked from anonymous/ec2_notes
EC2 Ubuntu Attache EBS volume and move /home
lsblk
xvdb 202:16 0 15G 0 disk
xvda1 202:1 0 8G 0 disk /
sudo mkfs.ext4 /dev/xvdb
sudo mkdir /mnt/tmp
sudo mount /dev/xvdb/ /mnt/tmp
{
"profile": {
"id": 8,
"user_id": 2,
"full_name": "Test User",
"image": "",
"age": 49,
"gender": "",
"mobile_number": "01121212121",
"orientation": "",