// home

Latest Post

Apple Music: How to turn off Auto-Renewal

Updated my iPad to iOS 8.4 to try out Apple Music. I’m quite excited about the 3 months FREE! trial. Once iOS got updated, I clicked on Music.

I ignored almost all the prompts, skipped reading the messages and agreed to the terms without reading (surprise!), to get Apple Music up and running asap. While AirPlaying the album Roja to my Linux server (via Shairport), I suddenly started to worry about “what will happen after the free trial?”.

GD Star Rating
loading...
GD Star Rating
loading...

Recent Posts

Google Apps Script: Automatically create Calendar Events from Google Form

Recently I wrote a Google Apps Script for a client which creates Google Calendar events from the responses submitted to a form created using Google Forms.  Based on the start and end date in the form, the script automatically creates an event in a Google calendar, when the form is submitted. Also if a response is edited in the responses spreadsheet, the calendar event is modified automatically through this script.

What’s more using the AppSheet addon, the form can be submitted from a mobile too.

GD Star Rating
loading...
GD Star Rating
loading...

Push custom notifications to your Android Watch from Linux command line or scripts

I had gifted an LG G Watch to my wife in December. She used it religiously for several months. Some time back, she started forgetting to charge it or wearing it to work. I found this the right opportunity to grab it and use it with my Moto G Android phone. So far (after a couple of days of using it), I find the watch quite useful while driving. That’s when I can just glance through the notifications without looking at the phone or taking it out from my jeans pocket.

Custom notification sent from Linux to Android Watch

Custom notification sent from Linux to Android Watch

At night, it is useful to have the watch by the bed side while the phone is changing elsewhere at home. Depending on the notifications (email, SMS or call) on the watch, I can decide if I want to get out of the bed to attend it on the phone.But what’s more?

GD Star Rating
loading...
GD Star Rating
loading...

Wish your partner a happy Valentine’s Day with Android Device Manager

Security is a serious affair, and so is love ;-) So I thought about using one of the security features on Android to surprise my wife on this Valentine’s day.

Wish Happy Valentine's Day with Android Lock Screen

Wish Happy Valentine’s Day with Android Lock Screen

Do not read any further if you don’t know your partner’s passwords. And the best way to get your partner’s password is to share your passwords with him/her.

Fortunately I know the passwords that my wife uses (thanks to the tip mentioned above).

Next, all the phones/tablets (Android, Windows Phone, iPad, Blackberry) can be setup for remote locate, lock and wipe. That’s one of the first few things that I setup on my devices. So the remote security (Android Device Manager) was setup on my wife’s phone (OnePlus One). The stage was all set for the fun.

GD Star Rating
loading...
GD Star Rating
loading...

I am Mufflerman: Powered by OpenCV and PHP Facedetect

Sometime back I worked on a project which required face detection in the photos uploaded by the user. Yesterday I read about our honorable prime minister Modi ji and BJP are setting selfie booths. This led to the idea of “I am Mufflerman” ;-) Try the demo here.

I am Mufflerman

I am Mufflerman

On the demo page, click on the button on the top and upload a selfie (if on a desktop/laptop) or click a selfie if you are browsing the demo on a phone.

Upload a photo which is a selfie. Do not upload a groupfie (more than one person in the photo). The demo does a frontal face detection so look straight into the camera.

GD Star Rating
loading...
GD Star Rating
loading...

Android: Use an NFC tag to connect to your car’s audio

NFC Stickers from eBay India

NFC Stickers from eBay India

I have been wanting to try out NFC tags. What stopped me was the price, availability in India and compatibility with various phones.  So just to have fun with tags, I settled down with QR Code and Microsoft tags until recently. Few weeks back, I ordered a pack of 5 NFC tags from eBay India  for Rs. 295/- from eBay India.

GD Star Rating
loading...
GD Star Rating
loading...

Shell Script: Instantly restart a process or script if it dies

Recently I faced a task in a project, wherein I was asked to ensure that a script (a PHP script) must be always running, to the extent that if it dies, it must restart immediately.

Though the script was fairly tested to handle error conditions, still there could be a few unforeseen situations . This is because the script fetches data from a third party service provider and also relies on constant connectivity with the service provider for real time data.

The script was to run unattended on a Linux server.

GD Star Rating
loading...
GD Star Rating
loading...

SQL Server 2008 R2 on Windows 8: “” is not a valid login or you do not have permission

Got rid of Windows 7 and installed Windows 8 RTM on my laptop. To get back to work, went right ahead to install Visual Studio and SQL Server.

Installation of Visual Studio 2010 was a breeze but SQL Server 2008 R2 left me with a dreadful error saying – “” is not a valid login or you do not have permission. This showed up during the installation.

By ignoring this error, the installation proceeds but I was unable to login using SQL Server Management Studio.

GD Star Rating
loading...
GD Star Rating
loading...

How I installed Tango update on my Dell Venue Pro (Windows Phone 7) bought in India

I bought a Dell Venue Pro, a Windows Phone 7, in February 2011. I broke it’s screen once and went for a replacement. The replacement unit had some issues with the speaker and I got it replaced again. These days the phone is suffering from peculiar battery issues and I may have to replace it’s battery.

Despite these, one thing I can claim proudly is my Dell Venue Pro has always remained updated, till date. It came with a pre-NODO install and I could update it to Mange Beta before the official Mango release. And what’s more, it also got the official Mango release. And just yesterday, I updated my Dell Venue Pro to Tango!

GD Star Rating
loading...
GD Star Rating
loading...

Drupal: Redirect to node when View returns only one row

Ever since I started working on my Wildlife photo gallery in Drupal, I have been discovering the power of Views, which I seldom tap in time-bound projects. Here is an interesting trick that I would like to share.

The case is as follows. I have set up a Page using Views that displays photos based on criteria like species, location and type. The Views Page displays the thumbnails of the photos. Each thumbnail is linked to the Node page, which displays a larger photo and its details.

The page looks good and populated when I have lots of photos for each criteria. Unfortunately, in certain cases I do not have more than one photo displayed on the Views page. For example, I have only one photo of most species – since I started Wildlife photography just this year. As a result, the Views Page shows the thumbnail photo of just one species. This requires an extra, unnecessary click for the visitor to go to the Node page to see the larger photo and its details.

GD Star Rating
loading...
GD Star Rating
loading...

Solved: pfSense is not letting Tata Photon to talk to Tata Indicom Broadband

Recently I faced this strange issue at a client’s place. Users using Tata Photon USB modem were not able to browse the website and other services, hosted on a server sitting at my client’s office. The client is using a Tata Indicom Broadband connection at the office. The server is sitting behind a pfSense firewall.

To add to the confusion, users using Airtel broadband and Reliance USB modem were able to browse the website. It was easy to blame Tata for this but the culprit (well, more or less) was the pfSense firewall.

GD Star Rating
loading...
GD Star Rating
loading...

Welcome to Shekhar Govindarajan’s Blog

Recent Tweets

Follow Me on Twitter