Writing

Infrastructure notes

2017, written while running the AWS estate at Ogilvy and the PCI DSS infrastructure at Econet.

  1. How to get all the database and table sizes in MySQL or MariaDB

    153 words

    If you are working with MySQL or MariaDB web server, sooner or later you will be asked for the size of database or tell me the size of all the database.

  2. How to set or change default text editor for crontab in Linux?

    108 words

    To edit the crontab entries you use. The command will check for the environment variables or. So you need to set the or variable.

  3. How to install a Comodo SSL certificate with NGINX

    280 words

    If you have generated the CSR and purchased or renewed the SSL with Comodo, you might have noticed that, the comodo has sent you 4 files instead of one file.

  4. How to give access to specific users to specific buckets on AWS S3

    176 words

    In AWS S3, you might want to provide the access to selected users to selected buckets.

  5. How to add or change the password (passphrase) of OpenSSH key?

    163 words

    It’s possible you have earlier generated a ssh key without password/ passphrase.

  6. How to find files on linux OS ( distributions )

    245 words

    If you are working on Linux OS, finding files effectively always a tricky part.

  7. How to create CSR ( Certificate Signing Request ) for new SSL or to renew SSL?

    385 words

    SSL (Secure Sockets Layer) is a standard security protocol for establishing encrypted connection between a web server and client browser in communication.

  8. How to decode CSR (Certificate Signing Request) ?

    134 words

    Certificate Signing Request is encrypted piece of code which is going to used for generating the SSL Certificate for your domain name.

  9. AWS – NDB – Ubuntu – Add separate location for MySQL temporary (tmp) storage

    376 words

    By default MySQL uses the system default location used for temporary file storage, which is usually,, or..

  10. Ubuntu 16.04 – Cisco VPN Client installation

    129 words

    On Ubuntu 14.04 only was working. But for Ubuntu 16.04 you need to install as well.

  11. Solution – Apache – SoftException in Application.cpp:388: GID of script “index.php” is smaller than min_gid error

    299 words

    If you are getting the errors in apache logs like below in cPanel/WHM web hosting most probably the file user or group ownership has been changed.

  12. Top 3 ways to debug your code while programming

    275 words

    If you do programming, you will definitely face problems with your code and stuck somewhere. That situation is pretty frustrating for beginners.

  13. Linux – Increase / Resize the Disk Storage in AWS EC2 EBS without reboot

    383 words

    From 13th Feb 2017, there is no need to reboot the EC2 instance for increasing the EBS disk storage.

  14. Linux – How to set default version of PHP in Ubuntu 16.04

    292 words

    It might be possible you have installed multiple version of PHP in you server or system.

Early work

2009 to 2012, starting the month I finished my degree.

  1. Php: How to prevent from XSS Attacks

    474 words

    Data contains HTML or JavaScript can cause a really big Problem, which is being entered by user.

  2. Heart Purely Vectorised : using Adobe Illustrator

    35 words

    I had just created a Heart using vector in Adobe Illustrator. 🙂 This is what it looks like. You can download the Adobe Illustrator source file from here.

  3. Mahatma Gandhi Sketch: in Illustrator (vector)

    35 words

    I just created a sketch of our father of nation Mahatma Gandhi in Adobe Illustrator. The preview in JPG file is given below.

  4. Google Pacman (Source Download)

    176 words

    Day before yesterday Google celebrated 30th anniversary of PAC-MAN.

  5. Finding Rank of a Word: With Repetition

    614 words

    In the previous tutorial, we learned how to find the rank of a word, if the letters are having no repetition.

  6. Finding Rank of a Word. (No Repetition)

    924 words

    Lets first, we should know what is the RANK of a word?

  7. Solution 2: Algorithm 1

    141 words

    Below is the solution for Algorithm Problem 1 You can download the source file here.

  8. Solution Hint: Algorthimic Problem 1st (How to find the shared area of two intersected circle)

    445 words

    If you will go for the problem statement then you will find that you have to find the Area covered by intersection of two or three circles.

  9. Algorithm Problem 2: Easy

    228 words

    Hey, try to solve this. This is an easy problem to solve.

  10. Algorithm Problem 1 : Med

    386 words

    This problem I got to solve on “Prodyogiki 09” in an University Competition of NITs. I was unable to solve that..

  11. Welcome to My Blog!

    153 words

    Hi, Welcome to my blog! I will try to post the content related to programming, algorithmic problems, systems administration, cloud computing.