Saturn Technopark » Open source

Portfolio

Using plink to teleport VNC through firewalls

It has been long since I really wanted to take control of some of our clients machines where we have our price software installed, and our technical and support team were using some sort of freeware or trial ware, which expired and threw us into dilemma.

This is when I tried the real-vnc, with plink. I knew it was possible some how. But how was the question. Finally after a bit of googling, and pouring over putty, plink manual, I came to the solution. (more…)

phpMyIB MySQL Incremental Backup

phpMyIB — MySQL Incremental Backup

(uses php)

Since 2003 April, I was worried about redundant backups of my web databases. By November, it became a mere necessity, since any modifications on the server needed to be reflected onto a local machine such that periodic reports, printouts, financial analysis scripts etc can be run on the intranet.

I had enquired to several people about this at the linux-bangalore 2003 regarding taking icremental backups of running mysql databases, that too having transactional tables. Most of the delegates told me that is not possible. (more…)

MySQL Innodb Control

A primer

On several of our servers, the MySQL innodb data file was configured with auto extend, and we noticed that this was getting bigger for the one which was configured to be autoextended. Very recently on one of our production server, the MySQL failed due to a file size limitation of 3.9G, when the OS refused to let MySQL increase the size. By referring to the MySQL Documenation, we thought it would be a nightmare for us. (more…)

Divehi Fonts

An easy way to install Divehi Unicode fonts on linux

How to install

Installing Divehi Unicode fonts for the web on any rpm based linux box with TrueType support is now easy. The instructions below have been tested on RedHat Linux 7.3 and 8.0, but they are fairly generic so they should apply to any redhat-like linux distribution, such as mandrake or yellowdog. (more…)

Keepalive

Nothing too big to brag about, but in short this is a shell script designed for keeping a watch on running processes. It depends on cron to invoke itself. It checks for dead processes and tries to bring them up while sending a notification to a configured email address. (more…)