convert -colorspace RGB -interlace none -density 300×300 -quality 100 file.pdf file.jpg

Reference: http://www.linuxquestions.org/questions/linux-software-2/how-to-convert-pdf-to-jpg-910611/

iptables -A PREROUTING -i eth0 -t mangle -p tcp –dport 443 -j MARK –set-mark 1
echo 201 https >> /etc/iproute2/rt_tables
ip rule add fwmark 1 table https
ip route add default dev tun0 table https
iptables -t nat -A POSTROUTING -o tun0 -j MASQUERADE

sudo apt-get install libmysqlclient16-dev

Installing sqlite3 (1.3.4) with native extensions
Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.

/usr/local/rvm/rubies/ruby-1.9.3-p194/bin/ruby extconf.rb

Gem files will remain installed in /usr/local/rvm/gems/ruby-1.9.3-p194/gems/sqlite3-1.3.4 for inspection.
Results logged to /usr/local/rvm/gems/ruby-1.9.3-p194/gems/sqlite3-1.3.4/ext/sqlite3/gem_make.out
An error occurred while installing sqlite3 (1.3.4), and Bundler cannot continue.
Make sure that `gem install sqlite3 -v ‘1.3.4’` succeeds before bundling.

Solution: gem install sqlite3 -v ‘1.3.4’

backup: mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

Restore is as follows:

# mysql -u root -ptmppassword 
mysql> create database sugarcrm;
Query OK, 1 row affected (0.02 sec)

# mysql -u root -ptmppassword sugarcrm < /tmp/sugarcrm.sql

# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

Reference: http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

1. gem uninstall mysql2

2. Under project folder, run bundle install

1. sudo apt-get install libtool

2. rvm pkg install libyaml

3. rvm reinstall $(rvm list strings | tr “\n” ‘,’)

4. rvm all-gemsets do rvm gemset pristine

sudo /usr/bin# /usr/bin/mysql_install_db

*** parsers/baseparser.rb~ 2011-01-12 22:35:06.000000000 +0200
*** parsers/baseparser.rb 2011-01-12 22:35:06.000000000 +0200

*** 216,222 ****
version = version[1] unless version.nil?
encoding = ENCODING.match(results)
encoding = encoding[1] unless encoding.nil?
! @source.encoding = encoding
standalone = STANDALONE.match(results)
standalone = standalone[1] unless standalone.nil?
return [ :xmldecl, version, encoding, standalone ]
— 216,222 —-
version = version[1] unless version.nil?
encoding = ENCODING.match(results)
encoding = encoding[1] unless encoding.nil?
! @source.encoding = encoding unless encoding.nil?
standalone = STANDALONE.match(results)
standalone = standalone[1] unless standalone.nil?
return [ :xmldecl, version, encoding, standalone ]

Reference Link: http://pastie.org/1454110

a2enmod userdir