Updating a vCenter Appliance to 6.0 Update1

Well, I've just followed my own post, Updating a vCenter v6.0 Appliance and upgraded my appliance to 6.0 Update 1.

And I'm pleased to see the VAMI interface re-appear, along with the option to have it automatically upgrade! I've not explored the other updated / new elements, but I'm keen to finally see parts of Update Manager making an appearance. 

Sophos UTM 9 - "install.tar not on installation media"

Like most people who use the Sophos UTM Home Firewall Software, I do not use the CD-ROM installation method. Previously I've never had any problems converting it to a bootable USB stick, and firing things up.

This time - problems.

Install came up, and promptly fell over after initialising the drive with "Install.tar not on installation media" or something along those lines.

After a few hours searching the internet I found the solution; the Install folder was not being mounted properly by the installer.

SO:

- Start the installation, and after the hardware detection do NOT hit Next.
- Hit Alt+F2 to switch to the console
- mount /dev/sdb2 /install
- Switch back to the install, and complete as normal

You may need to copy the contents of install to the root of the usb stick - I did this previously anyway, as it was a trial an error with another issue (don't know if it helped, but not going back to find out!).

Trial and tribulations of UEFI Bioses

I recently purchased a Gigabyte GA-J1800 motherboard to build a new server specifically to run my Sophos UTM system (thanks to actually having a decent broadband connection now, it needs more horsepower than my little over-crowded ESX lab).

However, I had MASSIVE problems with the board immediately. Getting into the BIOS was completely impossible, so I couldn't actually get past the EFI Boot Shell. Argh.

Solution? Install Windows 8.1, upgrade the BIOS using the Gigabyte AppCenter then everything was a success. Total nightmare however, and a major FAIL on the Gigabyte Quality Control.

It's also really picky about what USB Keyboard you use too ...

Importing large data sets into MySQL

I found myself in need of loading data into a MySQL instance today for testing an application - lots of it (millions of rows). Unfortunately I don't have a MySQL instance in my home lab (it's pretty much all Windows stuff - and a bit of Mac). So what was the easiest solution?

First I grabbed a copy of the Turnkey MySQL VM from https://www.turnkeylinux.org/ - these guys have a lot of Debian images pre-configured to just unpack, lob into a virtualisation platform and get going. A massive time saver.

After that I installed MySQL on my Yosemite Mac - purely for the command line tool.

The fire up terminal, switch into /usr/local/mysql/bin and fire up mysql command line connecting to my instance:

mysql -h hostname -u root -p 

A few quick configuration settings to make things go smoother:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
set foreign_key_checks = 0; 

The load the data from the file using:

source <path_to_file>

Finally, re-enable the checks

set foreign_key_checks = 1; 

Thanks to this StackOverflow post for the details!