Upgrade MySQL server

I recently had to upgrade a mysql server from version 4.0.x to 5.0.x and ran into the following issues.

#1 Error Client does not support authentication protocol

This was due to the fact that the mysql client was older than 4.1 and the server was upgraded to 5.0.x and according to the MySQL documentation: MySQL 5.0 uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older (pre-4.1) clients.

You can either upgrade the mysql client to a version 4.1 or greater or run the following for the user name that needs to connect with a mysql client version of 4.0 or less.

mysql> SET PASSWORD FOR
    -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');


In addition, you may need to edit your mysql server 
to accept old password. You can do this in the /etc/my.cnf 
file by adding old-password = 1 to the [mysqld] section and
restarting mysql.

#2 DNS issues. I was getting an error that the username couldn't
connect from a particular hostname.  To take DNS queries out of the
connection, you can add skip-name-resolution to the [mysqld] section
of your /etc/my.cnf file and this will tell mysql server daemon to 
not perform a DNS lookup of the calling IP address. Restart mysql.
Advertisements

Upgrade ESX 3.5 to 4.0 with Upgrade Manager

  1. Backup VirtualCenter Server database just to be safe.
  2. Perform an upgrade from VirtualCenter Server 2.5 to vCenter Server 4.0
  3. Download latest ESX 4.x update .iso from VMware. You will need your license account to login
  4. Login to vSphere client and enable the Upgrade Manager
  5. Browse to the Upgrade Manager tab
  6. Click on Admin View -> Download the patches from VMware through Upgrade Manager
  7. Exit Admin view
  8. Click on “Attach …” and create a baseline with the .iso you downloaded. Finish the install instructions.
  9. Create a Baseline group
  10. Select “Scan …” NOTE: Non-compliant means the ESX host or virtual machine is unpatched or out of date
  11. Make sure the host is in maintenance mode and there are no running virtual machines on it
  12. Select “Remediate …”
  13. Choose to update to upgrade to 4.0

Upgrade VMware Infrastructure 3.x to VMware vSphere 4.x

These instructions are a subset of instruction found here: http://blogs.vmware.com/vmtn/2009/06/vsphere-virtual-machine-upgrade-process.html

The above instructions are for Windows server upgrade.  These have been modified for Linux vm hosts.

Upgrading a VMware Infrastructure 3.x environment to VMware vSphere 4 involves more than just upgrading vCenter Server and upgrading your ESX/ESXi hosts (as if that wasn’t enough). You should also plan on upgrading your virtual machines. VMware vSphere introduces a new hardware version (version 7), and vSphere also introduces a new paravirtualized network driver (VMXNET3) as well as a new paravirtualized SCSI driver (PVSCSI). To take advantage of these new drivers as well as other new features, you’ll need to upgrade your virtual machines.  If you are running a mixed environment of ESX 3.5 and ESX 4.0 be careful upgrading the hardware version of your virtual machines.  Hardware version 7 virtual machines will NOT run on ESX 3.5 hosts!!! In addition, VMOTION is not supported for paravirt (VMI) or enhanced networking (VMXNET3) devices so take that into consideration before using those devices.

For those upgrading VMware tools in a Linux environment(Especially Oracle NFS shops!!!). Make sure to backup your /etc/fstab file before applying the upgrade. Went to upgrade vmware tools while I was upgrading the hardware versions to 7 in our dev/test environments and wiped out all of the nfs mount paths for our Oracle DB servers. Each VM had like 8 mount path’s too! It’s a good thing we started with vSphere in dev/test and didn’t jump the gun

  1. Backup VirtualCenter Server database just to be safe.
  2. Perform an upgrade from VirtualCenter Server 2.5 to vCenter Server 4.0
  3. Download latest ESX 4.x update .iso from VMware. You will need your license account to login
  4. Login to vSphere client and enable the Upgrade Manager
  5. Browse to the Upgrade Manager tab
  6. Click on Admin View -> Download the patches from VMware through Upgrade Manager
  7. Exit Admin view
  8. Click on “Attach …” and create a baseline with the .iso you downloaded. Finish the install instructions.
  9. Create a Baseline group
  10. Select “Scan …” NOTE: Non-compliant means the ESX host or virtual machine is unpatched or out of date
  11. Make sure the host is in maintenance mode and there are no running virtual machines on it
  12. Select “Remediate …”
  13. Choose to update to upgrade to 4.0
  14. Upgrade VMware Tools in the guest operating system. You can do this by right-clicking on the virtual machine and selecting Guest > Install/Upgrade VMware Tools. When prompted, choose to perform an automatic tools upgrade. When the VMware Tools upgrade is complete, the virtual machine will reboot.
  15. After the guest operating system reboots and is back up again, shutdown the guest operating system. You can do this by right-clicking on the virtual machine and selecting Power > Shutdown Guest.
  16. Upgrade the virtual machine hardware by right-clicking the virtual machine and selecting Upgrade Virtual Hardware.
  17. Click OK to commit the changes you’ve made to the virtual machine.
  18. Power on the virtual machine. When the guest operating system is fully booted up, log in.

If you perform these steps on a template, then you can be assured that all future virtual machines cloned from this template also have the latest paravirtualized drivers installed for maximum performance. UPDATE: Per this VMware KB article, VMware doesn’t support using the PVSCSI adapter for boot devices. That is not to say that it doesn’t work (it does work), but that it is not supported. Thanks to Eddy for pointing that out in the comments!

Upgrade VirtualCenter 2.x to vCenter Server 4.0

* Download the vCenter Server 4.0 update package with all the modules from: http://downloads.vmware.com/d/details/vc40u1/ZHcqYmQlcCpiZGVqZA==

Note: You will need a valid vmware login to download the package.

* The package name was VMware-VIMSetup-all-162902.zip

* Unzip the package

* BACKUP YOUR EXISTING VirtualCenter 2.x database first!!!

* Double click the autorun.exe in the extracted folder.

* Followed the upgrade instructions.  We didn’t run into any trouble with the upgrade.