Can you please tell what is the problem you are facing right now(please define your env and ur problem statement) .. your initial query was answered(secondary storage not available in mysql) and what you want to achieve now so that easy to for us to help you.
Share any logs if you see any errors in the log. Regards Sadhu -----Original Message----- From: Mohd Zainal Abidin Rabani [mailto:zai...@nocser.net] Sent: Tuesday, February 2, 2016 11:14 AM To: users@cloudstack.apache.org Subject: Re[4]: Secondary Storage not available in mysql I already tried using UI but not success. It said about template and images. Maybe need to migrate before delete. --------- 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 13:40:41 Subject: RE: Re[2]: Secondary Storage not available in mysql >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:zai...@nocser.net] >Sent: Tuesday, February 2, 2016 10:06 AM >To: users@cloudstack.apache.org >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 : 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 >