Wednesday, 24 July 2013

srm database table showing users

SRM service wont start after upgrade to 5.1 (SSO)


log in to sql manager
select the srm db and find the tables below
right click on table and edit top 200 rows

dbo.pd_acedata
dbo.pd_authorization


this is part of vmware kb 2038046

how to test sql server connection udl file

create a text file but change the extention from .txt to .udl

Tuesday, 23 July 2013

dell / ibm esxi 5 upgrade "error could not obtain module order from esximage db" oem.xml /etc/vmware/support




from dell blog

http://en.community.dell.com/techcenter/b/techcenter/archive/2012/06/28/upgrade-from-dell-customized-vmware-esxi-5-0-to-a-later-update-using-dell-customized-esxi-5-iso-fails.aspx

this worked once the roll back had completed and the host rebooted

~# esxcli software vib remove –n Dell-Configuration-VIB
~# esxcli software vib remove –n Dell-License-VIB


also from vmware kb 2036167
maybe i should have also done

esxcli software vib remove -n Dell-esx-boot-options


same for IBM hosts:
http://www-01.ibm.com/support/docview.wss?uid=isg3T1019361

Monday, 8 July 2013

Remove VIB from ESXi host - vCLI

Remove the Cisco Nexus 1V from ESX host cisco-vem-v152-esx C:\Program Files\VMware\VMware vSphere CLI>esxcli --server=greenesxi3 software vib list Enter username: root Enter password: Name Version Vendor Acceptance Level Install Date ---------------------- ------------------------------------ -------- ---------------- ------------ misc-cnic-register 1.72.1.v50.2-1OEM.500.0.0.472560 Broadcom VMwareCertified 2013-04-29 net-bnx2 2.2.3e.v50.1-1OEM.500.0.0.472560 Broadcom VMwareCertified 2013-04-29 net-bnx2x 1.74.19.v50.1-1OEM.500.0.0.472560 Broadcom VMwareCertified 2013-04-29 net-cnic 1.74.04.v50.1-1OEM.500.0.0.472560 Broadcom VMwareCertified 2013-04-29 net-tg3 3.124c.v50.1-1OEM.500.0.0.472560 Broadcom VMwareCertified 2013-04-29 scsi-bnx2fc 1.74.02.v50.2-1OEM.500.0.0.406165 Broadcom VMwareCertified 2013-04-29 scsi-bnx2i 2.74.07.v50.1-1OEM.500.0.0.472560 Broadcom VMwareCertified 2013-04-29 net-bna 3.2.0.0-1OEM.500.0.0.472560 Brocade VMwareCertified 2013-04-29 scsi-bfa 3.2.0.0-1OEM.500.0.0.472560 Brocade VMwareCertified 2013-04-29 cisco-vem-v152-esx 4.2.1.2.1.1a.0-3.0.1 Cisco PartnerSupported 2013-05-23 OpenManage 7.2-0000 Dell VMwareAccepted 2013-05-23 dell-configuration-vib 5.0-2A00 Dell PartnerSupported 2013-04-29 ima-be2iscsi 4.2.324.12-1OEM.500.0.0.472629 Emulex VMwareCertified 2013-04-29 net-be2net 4.2.327.0-1OEM.500.0.0.472560 Emulex VMwareCertified 2013-04-29 scsi-be2iscsi 4.2.324.12-1OEM.500.0.0.472629 Emulex VMwareCertified 2013-04-29 scsi-lpfc820 8.2.4.141.55-1OEM.500.0.0.472560 Emulex VMwareCertified 2013-04-29 net-igb 4.0.17-1OEM.500.0.0.472560 Intel VMwareCertified 2013-04-29 net-ixgbe 3.11.32-1OEM.500.0.0.472560 Intel VMwareCertified 2013-04-29 scsi-mpt2sas 15.00.01.00.1vmw-1OEM.500.0.0.472560 LSI VMwareCertified 2013-04-29 ima-qla4xxx 500.2.01.31-1vmw.0.0.060523 QLogic VMwareCertified 2013-04-29 net-qlcnic 5.0.750-1OEM.500.0.0.472560 QLogic VMwareCertified 2013-04-29 scsi-qla4xxx 634.5.7.0-1OEM.500.0.0.472560 QLogic VMwareCertified 2013-04-29 ata-pata-amd 0.3.10-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ata-pata-atiixp 0.4.6-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ata-pata-cmd64x 0.2.5-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ata-pata-hpt3x2n 0.3.4-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ata-pata-pdc2027x 1.0-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ata-pata-serverworks 0.4.3-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ata-pata-sil680 0.4.8-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ata-pata-via 0.3.3-2vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 block-cciss 3.6.14-10vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ehci-ehci-hcd 1.0-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 esx-base 5.0.0-2.33.1117897 VMware VMwareCertified 2013-05-23 esx-tboot 5.0.0-2.26.914586 VMware VMwareCertified 2013-04-29 ipmi-ipmi-devintf 39.1-4vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ipmi-ipmi-msghandler 39.1-4vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ipmi-ipmi-si-drv 39.1-4vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 misc-drivers 5.0.0-2.26.914586 VMware VMwareCertified 2013-04-29 net-e1000 8.0.3.1-2vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-e1000e 1.1.2-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-enic 1.4.2.15a-1vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-forcedeth 0.61-2vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-nx-nic 4.0.557-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-qlge 2.0.0.54-1vmw.500.0.0.472560 VMware VMwareCertified 2013-04-29 net-r8168 8.013.00-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-r8169 6.011.00-2vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-s2io 2.1.4.13427-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 net-sky2 1.20-2vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 ohci-usb-ohci 1.0-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 sata-ahci 3.0-6vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 sata-ata-piix 2.12-4vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 sata-sata-nv 3.5-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 sata-sata-promise 2.12-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 sata-sata-sil 2.3-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 sata-sata-svw 2.3-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-aacraid 1.1.5.1-9vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-adp94xx 1.0.8.12-6vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-aic79xx 3.1-5vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-fnic 1.5.0.3-1vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-hpsa 5.0.0-17vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-ips 7.12.05-4vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-megaraid-mbox 2.20.5.1-6vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-megaraid-sas 5.34-1vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-megaraid2 2.00.4-9vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-mptsas 4.23.01.00-5vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-mptspi 4.23.01.00-5vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 scsi-rste 2.0.2.0088-1vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 uhci-usb-uhci 1.0-3vmw.500.2.26.914586 VMware VMwareCertified 2013-04-29 vmware-fdm 5.1.0-1123961 VMware VMwareCertified 2013-07-05 tools-light 5.0.0-2.32.1024429 VMware VMwareCertified 2013-05-15 scsi-qla2xxx 934.5.6.0-1OEM.500.0.0.472560 qlogic VMwareCertified 2013-04-29 C:\Program Files\VMware\VMware vSphere CLI>esxcli --server=greenesxi3 software vib remove --vibname=cisco-vem-v152-esx Enter username: root Enter password: Removal Result Message: Operation finished successfully. Reboot Required: false VIBs Installed: VIBs Removed: Cisco_bootbank_cisco-vem-v152-esx_4.2.1.2.1.1a.0-3.0.1 VIBs Skipped: C:\Program Files\VMware\VMware vSphere CLI>

Friday, 5 July 2013

Prerequisites for the vCenter Server Upgrade - Remove it from the linked mode group

except the vcenter server linked mode configuration wizard shows the "Isolate this vCenter Server instance from linked mode group" shaded or greyed out.
Fix: right click on vcenter server linked mode configuration and run as administrator