Change in Host table , You can also remove the secondary storage from UI (if you did any mistake while adding initially)and re-add it.
Also check below article for any ssvm issue : https://cwiki.apache.org/confluence/display/CLOUDSTACK/SSVM%2C+templates%2C+Secondary+storage+troubleshooting regards sadhu -----Original Message----- From: Mohd Zainal Abidin Rabani [mailto:[email protected]] Sent: Tuesday, February 2, 2016 10:06 AM To: [email protected] Subject: Re[2]: Secondary Storage not available in mysql 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 : [email protected] W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net <http://www.nocser.net/> ------ Original Message ------ From: "Suresh Sadhu" <[email protected]> To: "[email protected]" <[email protected]>; "Mohd Zainal Abidin Rabani" <[email protected]> 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:[email protected]] >Sent: Tuesday, February 2, 2016 9:57 AM >To: [email protected] >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 : [email protected] >W : www.modern.com.my | www.nocser.net
