Friday, 16 January 2015

Install celery with rabbitmq on Django

›
UPDATE 1 AUGUST 2019  After a lot of headaches at lost I found a great video  tutorial by Mike Hibbert on how to install rabbitmq with ce...
Thursday, 2 October 2014

Install tahoma font on Ubuntu

›
Download tarball that contains all Microsoft fonts To install them type the followiing in a terminal: cd ~ wget http://www.stchman.com/tools...
Friday, 15 August 2014

Cacti setup on Debian 7

›
The only no-nonsense cacti tutorial that actually worked for me on Debian 7.  SNMP (or Simple Network Management Protocol) is us...
Saturday, 31 May 2014

Run Tornado ap on nginx using supervisor

›
First need to install supervisor: apt-get install supervisor Then add tornado.conf to /etc/supervisor/conf.d an example tornado.conf: ...
Tuesday, 20 May 2014

Setting up Varnish on Drupal 7 on Debian

›
apt-get install varnish Install and activate  varnish module https://drupal.org/project/varnish nano /etc/default/varnish Repace the ...
Sunday, 27 April 2014

How to merge to videos using ffmpeg

›
ffmpeg -i 1.mp4 -sameq 1.mpg ffmpeg -i 2.mp4 -sameq 2.mpg cat 1.mpg 2.mpg | ffmpeg -f mpeg -i - -sameq -vcodec mpeg4 output.mp4 source
Saturday, 26 April 2014

Delete dupicate entries in mysql table

›
CREATE TABLE wpdb.wp_posts_deduped like wpdb.wp_posts; INSERT wpdb.wp_posts_deduped SELECT * FROM wpdb.wp_posts GROUP BY post_content, post...

Find mysql database and tabe size

›
These queries are very useful to find bloated databases/tables: Show size of all databases (in MB) SELECT s.schema_name,     SUM(t.data_...
Sunday, 16 February 2014

Burn srt to avi in Linux

›
 To split files use avisplit like: avisplit -s 300 -i video.avi  Then to burn subtitle to the video.avi:  mencoder  in.mp4 -sub mysu...
Thursday, 6 February 2014

Install tahoma fonts on Ubuntu

›
wget -c http://hezardastan.sourceforge.net/persianfonts/tahoma.tar.gz wget -c http://hezardastan.sourceforge.net/persianfonts/bfonts.tar.gz ...