CIS_KV_Keystore
and the VMware Directory Services (Lotus) Service Provider tagging. After the tag association is created, this information is then pulled into the Inventory Service database for display within the vSphere Web Client. cis_kv_keyvalue
table, this association is broken. The older tag associations are not removed from the cis_kv_keyvalue
table. This in turn results in UI displaying that the object no longer has a tag associated and requires that the tag(s) be re-associated through the vSphere Web Client.Tagging
Service Provider store within Lotus
. Unlike removing an object from vCenter Server such as a virtual machine, removing a tag or category causes both the tag association within VCDB as well as the stored tag and category object(s) to be destroyed. This flushes any tag association stored in the cis_kv_keyvalue
table and removes the tag and/or category from all Platform Services Controllers. If multiple vCenter Servers are all connected to the same vSphere domain and using the tag and/or category to their infrastructure, their cis_kv_keyvalue
table also has the tag associations cleared as well. This in turn, results in the UI displaying that the object no longer exists within the tagging UI and requires that the tag and category be re-created and re-associated using the vSphere Web Client.shell.set --enable True
shell
cat /etc/vmware-vpx/vcdb.properties | grep "password =" | awk '{ print $3 }'
hostname:~ # cat /etc/vmware-vpx/vcdb.properties | grep "password =" | awk '{ print $3 }'
<password>
/opt/vmware/vpostgres/9.3/bin/psql -d VCDB vc
select surr_key, kv_key from cis_kv_keyvalue where kv_provider = 'tagging:TagAssociations:default-scope';
surr_key | kv_key |
10 |
tag_association urn:vmomi:VirtualMachine:vm-51:########-####-####-####-########13a7 InventoryServiceTag:########-####-####-####-########d2b1:GLOBAL |
11 |
tag_association urn:vmomi:VirtualMachine:vm-92:########-####-####-####-########13a7 InventoryServiceTag:########-####-####-####-########d2b1:GLOBAL |
12 |
tag_association urn:vmomi:VirtualMachine:vm-69:########-####-####-####-########13a7 InventoryServiceTag:########-####-####-####-########0106:GLOBAL |
13 |
tag_association urn:vmomi:VirtualMachine:vm-201:########-####-####-####-########13a7 InventoryServiceTag:########-####-####-####-########df80:GLOBAL |
14 |
tag_association urn:vmomi:ClusterComputeResource:domain-c7:########-####-####-####-########13a7 InventoryServiceTag:########-####-####-####-########ad06:GLOBAL |
15 |
tag_association urn:vmomi:HostSystem:host-71:########-####-####-####-########13a7 InventoryServiceTag:########-####-####-####-########5ad9:GLOBAL |
tag_association urn:vmomi:VirtualMachine:vm-51:########-####-####-####-########13a7 InventoryServiceTag:########-####-####-####-########d2b1:GLOBAL
########-####-####-####-########d2b1
########-####-####-####-########d2b1
#######-####-####-####-########0106
while the other has the tag: ########-####-####-####-########df80
########-####-####-####-########5ad9
########-####-####-####-########ad06
To obtain the object name in order to determine its tagging association discussed above:
select id, name from VPX_ENTITY where id = VM_Number;
Example:
select id, name from VPX_ENTITY where id = '51';
Example Output:
51 | wCAI
The virtual machine wCAI was tagged with the above tag.
shell.set --enable True
shell
/opt/likewise/bin/ldapsearch -b "cn=Tagging,cn=Services,dc=vsphere,dc=local" -s sub "objectclass=*" -D "cn=Administrator,cn=Users,dc=vsphere,dc=local" -w '[email protected] Password' -H ldap://FQDN_of_External_PSC:389 | less
/opt/likewise/bin/ldapsearch -b "cn=Tagging,cn=Services,dc=vsphere,dc=local" -s sub "objectclass=*" -D "cn=Administrator,cn=Users,dc=vsphere,dc=local" -w '[email protected] Password' | less
/bin/install-parameter vmdir.domain-name
unique_domain.local
# One Master urn:vmomi:InventoryServiceCategory:########-####-####-####-########ec99:GLO
BAL, urn:vmomi:InventoryServiceScope:default-scope:GLOBAL, Tagging, services
, vsphere.local
dn: cn=urn:vmomi:InventoryServiceCategory:########-####-####-####-########ec99
:GLOBAL,cn=urn:vmomi:InventoryServiceScope:default-scope:GLOBAL,cn=Tagging,cn
=services,dc=vsphere,dc=local
nTSecurityDescriptor:: AQAEgBQAAAA0AAAAAAAAAFQAAAABBgAAAAAABxUAAAC28X00kchLtzP
jTfDadcGg9AEAAAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAAgBwAAMAAAAAABgAMAAA
AAECAAAAAAAHIAAAAJoCAAAAACgAMwAAIAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAA
AAoADMAACABBgAAAAAABxUAAAC28X00kchLtzPjTfDadcGg9AEAAA==
vmwTaggingObjectState: CREATE
vmwTaggingCategoryVersion: 0
vmwTaggingCategoryCardinality: single
vmwTaggingCategoryName: Infrastructure
objectClass: top
objectClass: vmwTaggingCategoryModel
cn: urn:vmomi:InventoryServiceCategory:########-####-####-####-########ec99:GL
OBAL
# urn:vmomi:InventoryServiceTag:########-####-####-####-########d2b1:GLOBAL,
urn:vmomi:InventoryServiceCategory:########-####-####-####-########ec99:GLOB
AL, urn:vmomi:InventoryServiceScope:default-scope:GLOBAL, Tagging, services,
vsphere.local
dn: cn=urn:vmomi:InventoryServiceTag:########-####-####-####-########d2b1:GLOB
AL,cn=urn:vmomi:InventoryServiceCategory:########-####-####-####-########ec99
:GLOBAL,cn=urn:vmomi:InventoryServiceScope:default-scope:GLOBAL,cn=Tagging,cn
=services,dc=vsphere,dc=local
nTSecurityDescriptor:: AQAEgBQAAAA0AAAAAAAAAFQAAAABBgAAAAAABxUAAAC28X00kchLtzP
jTfDadcGg9AEAAAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAAgBwAAMAAAAAABgAMAAA
AAECAAAAAAAHIAAAAJoCAAAAACgAMwAAIAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAA
AAoADMAACABBgAAAAAABxUAAAC28X00kchLtzPjTfDadcGg9AEAAA==
vmwTaggingObjectState: CREATE
vmwTaggingTagVersion: 0
vmwTaggingTagName: CA Servers
objectClass: top
objectClass: vmwTaggingTagModel
cn: urn:vmomi:InventoryServiceTag:########-####-####-####-########d2b1:GLOBAL
...
# urn:vmomi:InventoryServiceTag:########-####-####-####-########df80:GLOBAL,
urn:vmomi:InventoryServiceCategory:########-####-####-####-########fc1c:GLOB
AL, urn:vmomi:InventoryServiceScope:default-scope:GLOBAL, Tagging, services,
vsphere.local
dn: cn=urn:vmomi:InventoryServiceTag:########-####-####-####-########df80:GLOB
AL,cn=urn:vmomi:InventoryServiceCategory:########-####-####-####-########fc1c
:GLOBAL,cn=urn:vmomi:InventoryServiceScope:default-scope:GLOBAL,cn=Tagging,cn
=services,dc=vsphere,dc=local
nTSecurityDescriptor:: AQAEgBQAAAA0AAAAAAAAAFQAAAABBgAAAAAABxUAAAC28X00kchLtzP
jTfDadcGg9AEAAAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAAgBwAAMAAAAAABgAMAAA
AAECAAAAAAAHIAAAAJoCAAAAACgAMwAAIAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAA
AAoADMAACABBgAAAAAABxUAAAC28X00kchLtzPjTfDadcGg9AEAAA==
vmwTaggingObjectState: CREATE
vmwTaggingTagVersion: 0
vmwTaggingTagName: TestingTag
objectClass: top
objectClass: vmwTaggingTagModel
cn: urn:vmomi:InventoryServiceTag:########-####-####-####-########df80:GLOBAL
Breaking down one of these tagging entries:
# urn:vmomi:InventoryServiceTag:########-####-####-####-########d2b1:GLOBAL,
urn:vmomi:InventoryServiceCategory:########-####-####-####-########ec99:GLOB
AL, urn:vmomi:InventoryServiceScope:default-scope:GLOBAL, Tagging, services,
vsphere.local
dn: cn=urn:vmomi:InventoryServiceTag:########-####-####-####-########d2b1:GLOB
AL,cn=urn:vmomi:InventoryServiceCategory:########-####-####-####-########ec99
:GLOBAL,cn=urn:vmomi:InventoryServiceScope:default-scope:GLOBAL,cn=Tagging,cn
=services,dc=vsphere,dc=local
nTSecurityDescriptor:: AQAEgBQAAAA0AAAAAAAAAFQAAAABBgAAAAAABxUAAAC28X00kchLtzP
jTfDadcGg9AEAAAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAAgBwAAMAAAAAABgAMAAA
AAECAAAAAAAHIAAAAJoCAAAAACgAMwAAIAEGAAAAAAAHFQAAALbxfTSRyEu3M+NN8Np1waAgAgAAA
AAoADMAACABBgAAAAAABxUAAAC28X00kchLtzPjTfDadcGg9AEAAA==
vmwTaggingObjectState: CREATE
vmwTaggingTagVersion: 0
vmwTaggingTagName: CA Servers
objectClass: top
objectClass: vmwTaggingTagModel
cn: urn:vmomi:InventoryServiceTag:########-####-####-####-########d2b1:GLOBAL
- The tag has the identifier: ########-####-####-####-########d2b1
- The tag has the name CA Servers
- The objectClass is vmwTaggingTagModel indicating it is a tag
- The tag has never had a name change indicated by vmwTaggingTagModel 0
- The tag belongs to the Category identifier: ########-####-####-####-########ec99(belonging to the Infrastructure Category)
<tag type="InventoryServiceTag">########-####-####-####-########d2b1</tag>
val |
anyType |
|