// home

Latest Post

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...

Recent Posts

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...

Install Windows Phone 7 Mango update on a non-rooted, non-developer-unlocked Dell Venue Pro (India)

Mango is the much awaited update for Windows Phone 7. The Mango update brings 500 new features, over the latest NoDo update. These features include multitasking, E-mail conversation view, Internet Explorer 9, Twittter and Linkedin integration and custom ringtones.

As of now Mango is in beta. The beta update is available to those with a developer account and pretty much limited to certain countries which does not include India. But my Dell Venue Pro bought in India is powered by Mango Beta now! It was earlier running official NoDo update (OS version: 7.0.7390). Following is how I updated my Dell Venue Pro without rooting it, unlocking it and without a developer account.

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

Authenticate osTicket against Zimbra LDAP

osTicket is a free online helpdesk/support ticket system. Zimbra Open Source Edition is a free groupware product which offers E-mail, Calendar, Tasks and Chat. Recently for a client I had setup these two products.

Zimbra stores the E-mail users’ credentials in its built-in LDAP server. Hence it made sense to authenticate the login of other services or products like osTicket against Zimbra’s LDAP.

Following is a short tutorial on how I achieved it.

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

Tethering a Dell Venue Pro bought in India

Tethering allows the sharing of a mobile phone’s GPRS/EDGE/3G Internet connection with a PC, typically via USB or Bluetooth/WiFi. Nokia, Andorid and Windows Mobile (before Windows Phone 7) phones support tethering. Most service providers in India have data plans that allow tethering, enabling access to the Internet on laptops while on the move.

In fact, tethering has often come to my rescue where most other ways to connect to the Internet have failed. I blame it on the lack of their availability and/or price. Hence I aptly demand tethering from every phone I own or use. But my latest  phone, a Dell Venue Pro (powered by Windows Phone 7), does not support tethering out of the box.

Googling reveals a hack which is repeated across the Web. But the hack never worked on my Dell Venue Pro.

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

Solved: Extension filename.php not present

The day was pleasant till I got an E-mail from a client with a PHP script file attached to it. I had to schedule the PHP script via Cron on a Linux server. For PHP scripts in Cron, I do not prefer writing the Cron job as:

1  30  *  *  *  /usr/bin/php -q /opt/script.php

Instead, I prefer a crisper line as:

1  30  *  *  *  /opt/script.php

The latter is obviously neater and readable. To prepare a PHP script to execute just by the filename, you need to do two things:

  1. Add a line to the path to the PHP interpreter at the top of the script. For example:
    #!/usr/bin/php -q
    <?php           
    // PHP code          
    ?>
  2. Make the script executable as:
    chmod + script.php

Before inserting it in Cron it is always a good idea to test the script by executing it manually as:

/opt/script.php

What always worked for me, failed on me this time with an error saying: Extension /opt/script.php not present. What will you do when you get an informative error (being sarcastic) like this? I too had no clue.

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

Solved: Unable to call toll free numbers in India using Windows Phone 7

I recently purchased a Dell Venue Pro powered by Windows Phone 7. It has been about 10 days that I’m living with lack of apps, tethering, E-mail client with conversation view and a feature rich Twitter client. I’m hoping that most of these will be solved by future updates and upcoming apps.

On the other hand, I’m at war with issues on the phone due to lack of my familiarity with a Windows Phone. After all, I had been using Android for almost two years. One issue that bothered me the most was, I could not dial toll free numbers in India using my Dell Venue Pro.

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

Solved: Setting up D-LINK DWA-525 (RaLink Device 3060) Wireless Desktop PCI Adapter on Fedora 14 Linux

D-Link DWA-525 Wireless N 150 Desktop Adapter

D-Link DWA-525 Wireless N 150 Desktop Adapter

My new “desktop grade server machine” at home has a 802.11n wireless PCI adapter namely D-LINK DWA-525 Wireless N 150 Desktop Adapter.  An adapter like this plugs into one of the PCI slots and connects to a wireless or Wi-Fi network. This helps to keep the machine anywhere in the house and not necessarily near a router or Ethernet port.

On my desktop, I did a minimal or base installation of Fedora 14 Linux. Fedora was not able to recognize the wireless adapter and hence could not connect to the Wi-Fi router at my home. But with some efforts, I was able to make the adapter work on Fedora 14. Additionally, I was also able to configure the wireless adapter from the command line. What follows is a crisp tutorial with the required steps to setup DIR-615 PCI adapter on Linux.

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

Install Fedora 14 Linux without a monitor (headless), keyboard and CD/DVD

As I tweeted http://twitter.com/#!/shekharg/status/30986928094453760 sometime back, I bought a new desktop for my home. This desktop (my home server) is with 16GB of RAM and with no monitor. For the monitor, I thought of hooking it up to my TV via a VGA port (a.k.a. RGB port). The machine has a DVD writer and I also bought a keyboard for Rs. 160.

I required the TV, keyboard and DVD drive only for the one time installation of the operating system. Post the installation, I access the machine only across the network – via SSH (Secure SHell) or a web browser.

But I decided against the easy way of installation using my TV and keyboard. Instead, I challenged myself to install Fedora 14 without using a monitor, keyboard/mouse and DVD drive on the server.

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

Welcome to Shekhar Govindarajan’s Blog

Recent Tweets

Follow Me on Twitter