Ok, i have the result. Show id 33. Now i try update to host_details. But id 33 not available on host_id table. Host_details only show 2 host-cloudstack. How to update?

Query: update host_details set value = 'nfs://10.2.28.40/sec01' where host_id = 33 and name = 'orig.url';

---------
Regards,
Mohd Zainal Abidin Rabani
Technical Support

ModernOne Data Solutions Sdn. Bhd. (1119382-D)
No. 83-2, Jalan TKS 1,
Kajang Sentral, 43000 Kajang, Selangor.
T : 03-8737 0030 | F : 03-8737 0070
E : zai...@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net <http://www.nocser.net/>



------ Original Message ------
From: "Suresh Sadhu" <suresh.sa...@citrix.com>
To: "users@cloudstack.apache.org" <users@cloudstack.apache.org>; "Mohd Zainal Abidin Rabani" <zai...@nocser.net>
Sent: 02/02/2016 12:29:31
Subject: RE: Secondary Storage not available in mysql

Try below query.
select id from host where type = 'SecondaryStorageVM';

regards
sadhu
-----Original Message-----
From: Mohd Zainal Abidin Rabani [mailto:zai...@nocser.net]
Sent: Tuesday, February 2, 2016 9:57 AM
To: users@cloudstack.apache.org
Subject: Secondary Storage not available in mysql

Hi,

I want to change ip address for secondary storage. But when i query select id from host where type = 'SecondaryStorage';

It return 0, mean no value. Am i make mistake or data not there?

---------
Regards,
Mohd Zainal Abidin Rabani
Technical Support

ModernOne Data Solutions Sdn. Bhd.(1119382-D) No. 83-2, Jalan TKS 1, Kajang Sentral, 43000 Kajang, Selangor.
T : 03-8737 0030 | F : 03-8737 0070
E : zai...@nocser.net
W : www.modern.com.my | www.nocser.net

Reply via email to