On Fri, Dec 16, 2016 at 5:20 PM, <jo...@familiealbers.nl> wrote: > in ovirt engine the table. > > vds_spm_id_map > > holds the ids used in spm election. > > engine_20150824095956=# select * from vds_spm_id_map ; > storage_pool_id | vds_spm_id | vds_id > --------------------------------------+------------+-------------------------------------- > 144fb47d-b38c-4bb7-867b-373d7ba9f0a9 | 1 | > 313ed02c-8029-4fb3-ba1c-5b3c9902ddb1 > 144fb47d-b38c-4bb7-867b-373d7ba9f0a9 | 2 | > 7fdebf8a-1503-4b54-9681-0201ee330381 > > these particular id's seem to be added when a vds is added to the engine or > when the storage pool is first setup. > > I would like to be able to obtain this nr (in my case its generally 1 or 2 > as i have two hosts per dc / cluster) through an api or even better from the > hosts itself. > > When testing I connect to the storage pools using the api
Do you mean vdsm api? You can get the host id using vdsClient: # vdsClient -s 0 getStoragePoolInfo fe307b9e-8f6b-4958-955a-0faeeae8b017 name = No Description isoprefix = pool_status = connected lver = 7 spm_id = 1 master_uuid = eeb8e812-4e69-469a-a07a-272ea3a79105 version = 4 domains = 16fe0625-be29-4a77-81c5-1bc0e5267eea:Active,eeb8e812-4e69-469a-a07a-272ea3a79105:Active type = ISCSI master_ver = 3 16fe0625-be29-4a77-81c5-1bc0e5267eea = {'status': 'Active', 'diskfree': '97844723712', 'isoprefix': '', 'alerts': [], 'disktotal': '106568876032', 'version': 4} eeb8e812-4e69-469a-a07a-272ea3a79105 = {'status': 'Active', 'diskfree': '98918465536', 'isoprefix': '', 'alerts': [], 'disktotal': '106568876032', 'version': 4} If you have vdsm source, you can use the new client: # contrib/jsonrpc StoragePool getInfo storagepoolID=fe307b9e-8f6b-4958-955a-0faeeae8b017 { "info": { "name": "No Description", "isoprefix": "", "pool_status": "connected", "lver": 7, "spm_id": 1, "master_uuid": "eeb8e812-4e69-469a-a07a-272ea3a79105", "version": "4", "domains": "16fe0625-be29-4a77-81c5-1bc0e5267eea:Active,eeb8e812-4e69-469a-a07a-272ea3a79105:Active", "type": "ISCSI", "master_ver": 3 }, "dominfo": { "16fe0625-be29-4a77-81c5-1bc0e5267eea": { "status": "Active", "diskfree": "97844723712", "isoprefix": "", "alerts": [], "disktotal": "106568876032", "version": 4 }, "eeb8e812-4e69-469a-a07a-272ea3a79105": { "status": "Active", "diskfree": "98918465536", "isoprefix": "", "alerts": [], "disktotal": "106568876032", "version": 4 } } } > and its important > the hostid used when making this api call is correct or bad things happen. > > I have been searching high and low to no avail. In understand the engine is > in charge here but i really would be helped if this values can be obtained > without going into the db. > > As i am continuously rebuilding dc's / storage pools and hosts i cannot keep > track of when which host is installed hence the need to know the spm_id as > listed. > > It might be i am all wrong but the when i use the vds_spm_id as listed i can > connect the host to the storage pools using the api. _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users