Archive for the ‘VMware’ Category

Running VMware SSO Scripts on SQL Express 2008 with no Management Studio

October 4th, 2012 No comments

I was upgrading from vCenter 5.0 to vCenter 5.1 in my test environment today. One of the pre-requisites was to install SSO. I didn’t want to install a second DB for it so I decided I’d use the vCenter Database installed with vCenter 5.0.

During the install it asked me for the sa password of the vCenter DB. I don’t know what it is because vCenter installed it all automatically. So I chose the second option which asked me to use an existing supported database. The problem here is that I has to run some scripts. Well I tried to install SQL Management Studio for SQL2008 and it turns out that you can’t! You can only install Management Studio when you are first installing the DB. That means now I have to run the scripts using the command line which I’ve not done before.

Okay, so how did I do it? Well it’s not difficult when you know how.

  • Copy the .sql script called SetupTablespaces.sql from the MSSQL directory on the vCenter CD. I copied it to C:\SSODB\
  • Edit it using Wordpad or something and change the directory called CHANGE_ME to the directory you want to use to store the database. Again I am going to use E:\SSODB
  • Run this command

    sqlcmd -S YOUR_SERVER_NAME\VIM_SQLEXP -i E:\SSODB\rsaIMSLiteMSSQLSetupTablespaces.sql

  • Then you should see some RSA files have been created in the SSODB directory
Categories: Linux, VMware Tags: , ,

Happy New Year

January 23rd, 2012 No comments

Gong Hei Fat Choi! This year for the Lunar New Year celebrated in China, Korea and Vietnam, we had a Chinese Lion in the office in VMware.

Categories: My Videos, VMware Tags: , , , ,

vSphere Client Command Line Options

February 21st, 2011 12 comments

I have a number of different ESX Servers and vCenter Servers to connect to at work. None are set up in DNS because they are just test servers. So every time I want to connect I have to try and remember the IP address. Also some are ESX Servers where the login is root, and others are vCenter where the login is administrator. So I often have to connect to two or three different IPs, trying both logins, until I get the one I want.

Today I decided to create a number of shortcuts to each server. I wanted to be able to click on a vSphere Client link and have it automatically connect to eh correct Server, enter the username and password and log me in. Turns out it’s quite easy as the client can’t take that information as a command line argument. However I found it hard to find anything on the internet explaining the options. Of course running \? on the client gives me nothing.

Anyway here is the options you need to pass to the vSphere Client executable to get it to connect to a server with a certain username or password. Now all you need to do is make a number of shortcuts to each server in a folder and you can quickly launch the one you want. Very handy!

VpxClient.exe -i yes -s -u root -p vmware

Categories: Linux, VMware Tags: ,

Google Ireland Search Plugin for Firefox

July 1st, 2010 1 comment

I was pretty irritated with the Google Search in Firefox constantly directing me to as opposed to When I search with the results are better targeted to Irish people are therefore more useful to me. So as a result I wrote my own Firefox search.

If you want to use it click here to install.

bin/bash^M: bad interpreter: no such file or directory

December 29th, 2009 5 comments

I got this error recently when trying to execute a bash script in Linux.

bin/bash^M: bad interpreter: no such file or directory

The problem turned out to be the fact that I downloaded it to a windows machine before copying it to the Linux box. When I downloaded it windows added a number of Windows Carriage Returns at the end of each line. Why? Don’t ask me!

After a bit of Googling I found a number of posts that recommended I use dos2unix to convert it into unix file format. Unfortunately I didn’t have this on my system. So instead I used the following command.

tr -d '\r' < inputfile > outputfile

Categories: Linux, VMware Tags:


October 23rd, 2009 2 comments

VMware_ThinApp_logo_01The company I work for, VMware, has a product called ThinApp which allows you to run software without having to install it. Many of you may have downloaded Firefox for example and when you downloaded it you had to ask a lot of questions as it was being installed. Worse if you tried to install it on another computer you might not be able to as you wouldn’t have sufficient privileges on that computer. Such as an internet cafe or some such.

Now however with ThinApp that is no longer a problem. You no longer need to install applications to run them. There is a great site which has created these ThinApps for lots of free software called thindownload.

Categories: Opinion, VMware Tags:

VMware VCP Cheat Sheet

June 12th, 2009 No comments

vcp-logoI was giving the VI3 VCP course there recently and I realised that the handouts didn’t contain the summary from each section. So instead of waiting for each of the students to write it down I decided to just paste them into a word document. It may be useful as a study aid for anyone taking the Vmware VCP exam.

Once VMware PSO release the vSphere4 VCP exam I will get the summary from that for people as well.

You can download the cheatsheet here.  Download vi3-course-summary

Categories: VMware Tags:

Use an SSH proxy to access the internet around a firewall

May 7th, 2009 No comments

I was using an ESX Server as an SSH tunnel to access the webpage of one of my VMs that was on a different network than my laptop today and I thought it might be useful for people.  Particularity if you want to set up a proxy server to access the internet via a Linux system you might have running outside of your corporate firewall. This would be very useful to access sites that are blocked by your company or use it to download bittorrents etc.

What you need is

  • A Linux system on the internet (running at home, a cheap VM (like this site is running on, or maybe one running on VMware Workstation at home), or maybe your home router)
  • Putty (or a console shell if using Linux)
  • A Web Browser (or any application you want to access the internet, like bittorrent or whatever).


  1. First you need to have SSH access to your Linux system. Not necessarily root.
  2. Use Putty to create a connection to your system. But before you connect look at the options on the left.
  3. Select SSH > Tunnels
  4. Here enter a source port of 1080 and select the Dynamic Radio button.
  5. Select add.tunnelport
  6. Next open your session to your linux system
  7. Configure your application to use a Socks proxy over port 1080. For example in Firefox  select Tools > Options > Advanced > Network > Settings and configure it to use a SOCKS proxy as below.


  1. First you need to have SSH access to your Linux system. Not necessarily root.
  2. Open an SSH session to your system using the following syntax ssh -D 1080 user@mylinux
  3. Configure your application to use a Socks proxy over port 1080. For example in Firefox select Tools > Options > Advanced > Network > Settings and configure it to use a SOCKS proxy as below.


X Forwarding:

Also Linux has a cool feature called X Forwarding. If you open a session to a Linux server from a Linux server (or using a program like Exceed in Windows) using the X flag i.e. ssh -X user@mylinux then you can simply open the GUI of the web browser on the remote machine. I use this for bittorrent.

For example there is not much use in proxying bittorroent to my machine in work. I’d mush rather have it downloaded at home. So I ssh -X to my server at home. Run the command ktorrent & and hey presto the Ktorrent GUI opens on my machine in work, but is running at home. So anything I download will be saved at home. Cool eh?

Categories: Linux, VMware Tags:

VMworld Advanced HA Troubleshooting

September 18th, 2008 No comments

Vmworld USMy Advanced HA Troubleshooting presentation is being delivered in VMworld America today at 4PM local time. It’s being delivered by Henry Chu who also works for PSE here in VMware. Hopefully it’ll go well for him, it must be hard to present someone elses content. Anyway if anybody is in VMworld I’d highly recommend checking it out. it was voted 4th best presentation of VMworld Europe so I reckon it’ll be popular.

It would have been nice if i was able to head to Vegas to give it myself but when they were organising it there was a travel freeze on so they weren’t able to send me. Harsh!

Categories: VMware Tags:

ESX – Find large files in the Service Console

April 9th, 2008 No comments

ESX BoxGot a few cases in work over the last few week where people are finding the root file system full in VMware ESX Server. This causes lots of issues with connectivity to VirtualCenter etc. The problem is that often it is difficult to find the large files that are causing the file system to fill up. I’ve been sending people this handy little script to help them so I thought I’d share it with everyone.

find / -path '/vmfs/*' -prune -o -size +10240000c -exec du -h {} \;

This searches the ESX ignoring the VMFS file system. For standard Linux you can put whatever you want in place of VMFS and it will ignore that folder.

Categories: Linux, VMware Tags: