SQL JOINS quick tutorial
Table T1, Table T2 INNER JOIN returns only matching rows from T1, T2 LEFT OUTER JOIN returns (all T1 rows) X (matching T1 rows in… Read More »SQL JOINS quick tutorial
Technical
https in 5 easy steps
Simple 5 step guide to setting up https with your own self-signed certificate Prerequisites: Apache2, Ubuntu Server Generate local keypair /usr/bin/openssl genrsa -des3 -out {your… Read More »https in 5 easy steps
Colors to your life
Very often we are impressed with awe when we see a beautiful picture, photo, advert. The colors, their combination presents an alluring view just right… Read More »Colors to your life
Secretmyth BDRips – audio/video out of sync
More recently, all Secretmyth BDRips I download started to have a audio out of sync with video issue. Real sad, because the movie quality is… Read More »Secretmyth BDRips – audio/video out of sync
Interesting alternatives to databases in opensource
I stumbled upon this url. The list of various options on databases is pretty amazing. http://www.webresourcesdepot.com/25-alternative-open-source-databases-engines/ It’s a definite read. I never knew so many… Read More »Interesting alternatives to databases in opensource
How to manually uninstall Symantec Endpoint Protection client from Windows 2000, XP and 2003, 32-bit Editions
Much recently to my dismay, I figured out that I cannot remove Symantec’s Endpoint Protection from my own laptop without administrator password. I do not… Read More »How to manually uninstall Symantec Endpoint Protection client from Windows 2000, XP and 2003, 32-bit Editions
Wikimedia Downloads
Wikimedia Downloads The following kinds of downloads are available: Database backup dumps A complete copy of all Wikimedia wikis, in the form of wikitext source… Read More »Wikimedia Downloads
SSH : Forwarded connection refused by server: Administratively prohibited [open failed]
Change localhost to 127.0.0.1 and it should work. 🙂 If that doesn’t solve it, problem might be in sshd_config or authorized_keys2 – Metawerx Wiki: SSHTunnelTroubleshooting.
Solr replication
1)On solr.master: +Edit scripts.conf: solr_hostname=localhost solr_port=8983 rsyncd_port=18983 +Enable and start rsync: rsyncd-enable; rsyncd-start +Run snapshooter: snapshooter After running this, you should be able to see… Read More »Solr replication