14. September 2015
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.
8. September 2015
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.
- 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!).
7. September 2015
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 ...
1. September 2015
Programming , Sys Admin
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:
Finally, re-enable the checks
set foreign_key_checks = 1;