You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Mohd Zainal Abidin Rabani <za...@nocser.net> on 2016/02/02 06:43:36 UTC
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
<http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>W : www.modern.com.my | www.nocser.net
>
Re[14]: Secondary Storage not available in mysql
Posted by Mohd Zainal Abidin Rabani <za...@nocser.net>.
I try to put primary storage on maintenance mode. But it took a long.
Maybe i need to restart again cloudstack-management.
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
<http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 17:12:56
Subject: RE: Re[12]: Secondary Storage not available in mysql
>As per the log no suitable storage pool(primary storage) available in
>your cluster, due to that vm deployment is failing. Please make sure
>your primary storage is accessible from MS and its in working
>condition.
>
>If you have added your storage with any storage tag details then make
>sure them use the tag information in service offering for vm
>deployment.
>
>............................................
>
>2016-02-02 17:00:36,533 DEBUG [c.c.d.DeploymentPlanningManagerImpl]
>(Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) No
>suitable pools found for volume: Vol[1359|vm=1341|ROOT] under cluster:
>2
>
>
>128.2016-02-02 17:00:36,533 DEBUG [c.c.d.DeploymentPlanningManagerImpl]
>(Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) No
>suitable pools found
>
>
>129.2016-02-02 17:00:36,533 DEBUG [c.c.d.DeploymentPlanningManagerImpl]
>(Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) No
>suitable storagePools found under this Cluster: 2
>
>
>130.2016-02-02 17:00:36,534 DEBUG [c.c.d.DeploymentPlanningManagerImpl]
>(Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) Could
>not find suitable Deployment Destination for this VM under any
>clusters, returning.
>
>
>131.2016-02-02 17:00:36,534 DEBUG [c.c.d.FirstFitPlanner]
>(Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82)
>Searching all possible resources under this Zone: 2
>
>
>
>
>
>
>
>Regards
>Sadhu
>
>
>-----Original Message-----
>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>Sent: Tuesday, February 2, 2016 2:33 PM
>To: users@cloudstack.apache.org
>Subject: Re[12]: Secondary Storage not available in mysql
>
>Here is error from management-server.log :
>
>http://pastebin.com/ucaj99he
>
>---------
>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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@nocser.net>
>Sent: 02/02/2016 16:59:25
>Subject: RE: Re[10]: Secondary Storage not available in mysql
>
>>Please share the management log.
>>
>>Regards
>>Sadhu
>>
>>
>>-----Original Message-----
>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>Sent: Tuesday, February 2, 2016 2:27 PM
>>To: users@cloudstack.apache.org
>>Subject: Re[10]: Secondary Storage not available in mysql
>>
>>I delete console proxy vm and restart cloudstack management. But it
>>still show vm state = stopped and agent state = none (-).
>>
>>---------
>>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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@nocser.net>
>>Sent: 02/02/2016 16:51:23
>>Subject: RE: Re[8]: Secondary Storage not available in mysql
>>
>>>Ok Great earlier problem resolved right and hope it is due to
>>>your
>>>nfs mount problem ?,correct me if I am wrong.
>>>
>>>For console vm ,just destroy from Cloudstack UI ,it will recreate
>>>again.
>>>
>>>
>>>Regards
>>>Sadhu
>>>
>>>
>>>-----Original Message-----
>>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>>Sent: Tuesday, February 2, 2016 2:17 PM
>>>To: users@cloudstack.apache.org
>>>Subject: Re[8]: Secondary Storage not available in mysql
>>>
>>>After i restart NFS server (host) and cloudstack-management, all nfs
>>>shared can be mount in cloudstack UI. But on system vm show console
>>>vm
>>>is stopped.
>>>
>>>---------
>>>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 : zainal@nocser.net
>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>><http://www.nocser.net/>
>>>
>>>
>>>
>>>------ Original Message ------
>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>"Mohd
>>>Zainal Abidin Rabani" <za...@nocser.net>
>>>Sent: 02/02/2016 16:18:55
>>>Subject: RE: Re[6]: Secondary Storage not available in mysql
>>>
>>>>Thanks for sharing the details .as per earlier details your ssvm vm
>>>>already created and what is the state of that vm and agent state as
>>>>well?
>>>>
>>>>Also are you able to mount the storage(nfs share?) which you gave
>>>>in
>>>>secondary storage path from MS as well from host. Which hypervisor
>>>>you
>>>>are using. Check your share folder permission as well.
>>>>
>>>>Please share the management log .
>>>>
>>>>Regards
>>>>Sadhu
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>-----Original Message-----
>>>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>>>Sent: Tuesday, February 2, 2016 1:07 PM
>>>>To: users@cloudstack.apache.org
>>>>Subject: Re[6]: Secondary Storage not available in mysql
>>>>
>>>>Problem:
>>>>
>>>>Secondary storage not detect from cloudstack-management. Cannot
>>>>create
>>>>vm on secondary storage
>>>>
>>>>Work around:
>>>>Try remove from cloudstack UI but error "Cannot delete image store
>>>>with
>>>>active volumes backup!"
>>>>Try to remove from mysql but host not found from table host.
>>>>
>>>>---------
>>>>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 : zainal@nocser.net
>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>><http://www.nocser.net/>
>>>>
>>>>
>>>>
>>>>------ Original Message ------
>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>"Mohd
>>>>Zainal Abidin Rabani" <za...@nocser.net>
>>>>Sent: 02/02/2016 13:51:05
>>>>Subject: RE: Re[4]: Secondary Storage not available in mysql
>>>>
>>>>>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:zainal@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 : zainal@nocser.net
>>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>>><http://www.nocser.net/>
>>>>>
>>>>>
>>>>>
>>>>>------ Original Message ------
>>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>>"Mohd
>>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>>>><http://www.nocser.net/>
>>>>>>
>>>>>>
>>>>>>
>>>>>>------ Original Message ------
>>>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>>>"Mohd
>>>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>>>W : www.modern.com.my | www.nocser.net
>>>>>>
>>>>>
>>>>
>>>
>>
>
RE: Re[12]: Secondary Storage not available in mysql
Posted by Suresh Sadhu <Su...@citrix.com>.
As per the log no suitable storage pool(primary storage) available in your cluster, due to that vm deployment is failing. Please make sure your primary storage is accessible from MS and its in working condition.
If you have added your storage with any storage tag details then make sure them use the tag information in service offering for vm deployment.
............................................
2016-02-02 17:00:36,533 DEBUG [c.c.d.DeploymentPlanningManagerImpl] (Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) No suitable pools found for volume: Vol[1359|vm=1341|ROOT] under cluster: 2
128.2016-02-02 17:00:36,533 DEBUG [c.c.d.DeploymentPlanningManagerImpl] (Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) No suitable pools found
129.2016-02-02 17:00:36,533 DEBUG [c.c.d.DeploymentPlanningManagerImpl] (Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) No suitable storagePools found under this Cluster: 2
130.2016-02-02 17:00:36,534 DEBUG [c.c.d.DeploymentPlanningManagerImpl] (Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) Could not find suitable Deployment Destination for this VM under any clusters, returning.
131.2016-02-02 17:00:36,534 DEBUG [c.c.d.FirstFitPlanner] (Work-Job-Executor-10:ctx-3d0370d8 job-132/job-5376 ctx-cae83e82) Searching all possible resources under this Zone: 2
Regards
Sadhu
-----Original Message-----
From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
Sent: Tuesday, February 2, 2016 2:33 PM
To: users@cloudstack.apache.org
Subject: Re[12]: Secondary Storage not available in mysql
Here is error from management-server.log :
http://pastebin.com/ucaj99he
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net <http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 16:59:25
Subject: RE: Re[10]: Secondary Storage not available in mysql
>Please share the management log.
>
>Regards
>Sadhu
>
>
>-----Original Message-----
>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>Sent: Tuesday, February 2, 2016 2:27 PM
>To: users@cloudstack.apache.org
>Subject: Re[10]: Secondary Storage not available in mysql
>
>I delete console proxy vm and restart cloudstack management. But it
>still show vm state = stopped and agent state = none (-).
>
>---------
>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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@nocser.net>
>Sent: 02/02/2016 16:51:23
>Subject: RE: Re[8]: Secondary Storage not available in mysql
>
>>Ok Great earlier problem resolved right and hope it is due to your
>>nfs mount problem ?,correct me if I am wrong.
>>
>>For console vm ,just destroy from Cloudstack UI ,it will recreate
>>again.
>>
>>
>>Regards
>>Sadhu
>>
>>
>>-----Original Message-----
>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>Sent: Tuesday, February 2, 2016 2:17 PM
>>To: users@cloudstack.apache.org
>>Subject: Re[8]: Secondary Storage not available in mysql
>>
>>After i restart NFS server (host) and cloudstack-management, all nfs
>>shared can be mount in cloudstack UI. But on system vm show console vm
>>is stopped.
>>
>>---------
>>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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@nocser.net>
>>Sent: 02/02/2016 16:18:55
>>Subject: RE: Re[6]: Secondary Storage not available in mysql
>>
>>>Thanks for sharing the details .as per earlier details your ssvm vm
>>>already created and what is the state of that vm and agent state as
>>>well?
>>>
>>>Also are you able to mount the storage(nfs share?) which you gave in
>>>secondary storage path from MS as well from host. Which hypervisor
>>>you
>>>are using. Check your share folder permission as well.
>>>
>>>Please share the management log .
>>>
>>>Regards
>>>Sadhu
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>-----Original Message-----
>>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>>Sent: Tuesday, February 2, 2016 1:07 PM
>>>To: users@cloudstack.apache.org
>>>Subject: Re[6]: Secondary Storage not available in mysql
>>>
>>>Problem:
>>>
>>>Secondary storage not detect from cloudstack-management. Cannot
>>>create
>>>vm on secondary storage
>>>
>>>Work around:
>>>Try remove from cloudstack UI but error "Cannot delete image store
>>>with
>>>active volumes backup!"
>>>Try to remove from mysql but host not found from table host.
>>>
>>>---------
>>>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 : zainal@nocser.net
>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>><http://www.nocser.net/>
>>>
>>>
>>>
>>>------ Original Message ------
>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>"Mohd
>>>Zainal Abidin Rabani" <za...@nocser.net>
>>>Sent: 02/02/2016 13:51:05
>>>Subject: RE: Re[4]: Secondary Storage not available in mysql
>>>
>>>>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:zainal@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 : zainal@nocser.net
>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>><http://www.nocser.net/>
>>>>
>>>>
>>>>
>>>>------ Original Message ------
>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>"Mohd
>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>>><http://www.nocser.net/>
>>>>>
>>>>>
>>>>>
>>>>>------ Original Message ------
>>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>>"Mohd
>>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>>W : www.modern.com.my | www.nocser.net
>>>>>
>>>>
>>>
>>
>
Re[12]: Secondary Storage not available in mysql
Posted by Mohd Zainal Abidin Rabani <za...@nocser.net>.
Here is error from management-server.log :
http://pastebin.com/ucaj99he
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
<http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 16:59:25
Subject: RE: Re[10]: Secondary Storage not available in mysql
>Please share the management log.
>
>Regards
>Sadhu
>
>
>-----Original Message-----
>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>Sent: Tuesday, February 2, 2016 2:27 PM
>To: users@cloudstack.apache.org
>Subject: Re[10]: Secondary Storage not available in mysql
>
>I delete console proxy vm and restart cloudstack management. But it
>still show vm state = stopped and agent state = none (-).
>
>---------
>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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@nocser.net>
>Sent: 02/02/2016 16:51:23
>Subject: RE: Re[8]: Secondary Storage not available in mysql
>
>>Ok Great earlier problem resolved right and hope it is due to your
>>nfs mount problem ?,correct me if I am wrong.
>>
>>For console vm ,just destroy from Cloudstack UI ,it will recreate
>>again.
>>
>>
>>Regards
>>Sadhu
>>
>>
>>-----Original Message-----
>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>Sent: Tuesday, February 2, 2016 2:17 PM
>>To: users@cloudstack.apache.org
>>Subject: Re[8]: Secondary Storage not available in mysql
>>
>>After i restart NFS server (host) and cloudstack-management, all nfs
>>shared can be mount in cloudstack UI. But on system vm show console vm
>>is stopped.
>>
>>---------
>>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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@nocser.net>
>>Sent: 02/02/2016 16:18:55
>>Subject: RE: Re[6]: Secondary Storage not available in mysql
>>
>>>Thanks for sharing the details .as per earlier details your ssvm vm
>>>already created and what is the state of that vm and agent state as
>>>well?
>>>
>>>Also are you able to mount the storage(nfs share?) which you gave in
>>>secondary storage path from MS as well from host. Which hypervisor
>>>you
>>>are using. Check your share folder permission as well.
>>>
>>>Please share the management log .
>>>
>>>Regards
>>>Sadhu
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>-----Original Message-----
>>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>>Sent: Tuesday, February 2, 2016 1:07 PM
>>>To: users@cloudstack.apache.org
>>>Subject: Re[6]: Secondary Storage not available in mysql
>>>
>>>Problem:
>>>
>>>Secondary storage not detect from cloudstack-management. Cannot
>>>create
>>>vm on secondary storage
>>>
>>>Work around:
>>>Try remove from cloudstack UI but error "Cannot delete image store
>>>with
>>>active volumes backup!"
>>>Try to remove from mysql but host not found from table host.
>>>
>>>---------
>>>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 : zainal@nocser.net
>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>><http://www.nocser.net/>
>>>
>>>
>>>
>>>------ Original Message ------
>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>"Mohd
>>>Zainal Abidin Rabani" <za...@nocser.net>
>>>Sent: 02/02/2016 13:51:05
>>>Subject: RE: Re[4]: Secondary Storage not available in mysql
>>>
>>>>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:zainal@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 : zainal@nocser.net
>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>><http://www.nocser.net/>
>>>>
>>>>
>>>>
>>>>------ Original Message ------
>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>"Mohd
>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>>><http://www.nocser.net/>
>>>>>
>>>>>
>>>>>
>>>>>------ Original Message ------
>>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>>"Mohd
>>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>>W : www.modern.com.my | www.nocser.net
>>>>>
>>>>
>>>
>>
>
RE: Re[10]: Secondary Storage not available in mysql
Posted by Suresh Sadhu <Su...@citrix.com>.
Please share the management log.
Regards
Sadhu
-----Original Message-----
From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
Sent: Tuesday, February 2, 2016 2:27 PM
To: users@cloudstack.apache.org
Subject: Re[10]: Secondary Storage not available in mysql
I delete console proxy vm and restart cloudstack management. But it still show vm state = stopped and agent state = none (-).
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net <http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 16:51:23
Subject: RE: Re[8]: Secondary Storage not available in mysql
>Ok Great earlier problem resolved right and hope it is due to your
>nfs mount problem ?,correct me if I am wrong.
>
>For console vm ,just destroy from Cloudstack UI ,it will recreate
>again.
>
>
>Regards
>Sadhu
>
>
>-----Original Message-----
>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>Sent: Tuesday, February 2, 2016 2:17 PM
>To: users@cloudstack.apache.org
>Subject: Re[8]: Secondary Storage not available in mysql
>
>After i restart NFS server (host) and cloudstack-management, all nfs
>shared can be mount in cloudstack UI. But on system vm show console vm
>is stopped.
>
>---------
>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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@nocser.net>
>Sent: 02/02/2016 16:18:55
>Subject: RE: Re[6]: Secondary Storage not available in mysql
>
>>Thanks for sharing the details .as per earlier details your ssvm vm
>>already created and what is the state of that vm and agent state as
>>well?
>>
>>Also are you able to mount the storage(nfs share?) which you gave in
>>secondary storage path from MS as well from host. Which hypervisor you
>>are using. Check your share folder permission as well.
>>
>>Please share the management log .
>>
>>Regards
>>Sadhu
>>
>>
>>
>>
>>
>>
>>
>>-----Original Message-----
>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>Sent: Tuesday, February 2, 2016 1:07 PM
>>To: users@cloudstack.apache.org
>>Subject: Re[6]: Secondary Storage not available in mysql
>>
>>Problem:
>>
>>Secondary storage not detect from cloudstack-management. Cannot create
>>vm on secondary storage
>>
>>Work around:
>>Try remove from cloudstack UI but error "Cannot delete image store
>>with
>>active volumes backup!"
>>Try to remove from mysql but host not found from table host.
>>
>>---------
>>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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@nocser.net>
>>Sent: 02/02/2016 13:51:05
>>Subject: RE: Re[4]: Secondary Storage not available in mysql
>>
>>>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:zainal@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 : zainal@nocser.net
>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>><http://www.nocser.net/>
>>>
>>>
>>>
>>>------ Original Message ------
>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>"Mohd
>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>><http://www.nocser.net/>
>>>>
>>>>
>>>>
>>>>------ Original Message ------
>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>"Mohd
>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>W : www.modern.com.my | www.nocser.net
>>>>
>>>
>>
>
Re[10]: Secondary Storage not available in mysql
Posted by Mohd Zainal Abidin Rabani <za...@nocser.net>.
I delete console proxy vm and restart cloudstack management. But it
still show vm state = stopped and agent state = none (-).
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
<http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 16:51:23
Subject: RE: Re[8]: Secondary Storage not available in mysql
>Ok Great earlier problem resolved right and hope it is due to your
>nfs mount problem ?,correct me if I am wrong.
>
>For console vm ,just destroy from Cloudstack UI ,it will recreate
>again.
>
>
>Regards
>Sadhu
>
>
>-----Original Message-----
>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>Sent: Tuesday, February 2, 2016 2:17 PM
>To: users@cloudstack.apache.org
>Subject: Re[8]: Secondary Storage not available in mysql
>
>After i restart NFS server (host) and cloudstack-management, all nfs
>shared can be mount in cloudstack UI. But on system vm show console vm
>is stopped.
>
>---------
>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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@nocser.net>
>Sent: 02/02/2016 16:18:55
>Subject: RE: Re[6]: Secondary Storage not available in mysql
>
>>Thanks for sharing the details .as per earlier details your ssvm vm
>>already created and what is the state of that vm and agent state as
>>well?
>>
>>Also are you able to mount the storage(nfs share?) which you gave in
>>secondary storage path from MS as well from host. Which hypervisor you
>>are using. Check your share folder permission as well.
>>
>>Please share the management log .
>>
>>Regards
>>Sadhu
>>
>>
>>
>>
>>
>>
>>
>>-----Original Message-----
>>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>>Sent: Tuesday, February 2, 2016 1:07 PM
>>To: users@cloudstack.apache.org
>>Subject: Re[6]: Secondary Storage not available in mysql
>>
>>Problem:
>>
>>Secondary storage not detect from cloudstack-management. Cannot create
>>vm on secondary storage
>>
>>Work around:
>>Try remove from cloudstack UI but error "Cannot delete image store
>>with
>>active volumes backup!"
>>Try to remove from mysql but host not found from table host.
>>
>>---------
>>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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@nocser.net>
>>Sent: 02/02/2016 13:51:05
>>Subject: RE: Re[4]: Secondary Storage not available in mysql
>>
>>>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:zainal@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 : zainal@nocser.net
>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>><http://www.nocser.net/>
>>>
>>>
>>>
>>>------ Original Message ------
>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>"Mohd
>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>>><http://www.nocser.net/>
>>>>
>>>>
>>>>
>>>>------ Original Message ------
>>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>>"Mohd
>>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>>W : www.modern.com.my | www.nocser.net
>>>>
>>>
>>
>
RE: Re[8]: Secondary Storage not available in mysql
Posted by Suresh Sadhu <Su...@citrix.com>.
Ok Great earlier problem resolved right and hope it is due to your nfs mount problem ?,correct me if I am wrong.
For console vm ,just destroy from Cloudstack UI ,it will recreate again.
Regards
Sadhu
-----Original Message-----
From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
Sent: Tuesday, February 2, 2016 2:17 PM
To: users@cloudstack.apache.org
Subject: Re[8]: Secondary Storage not available in mysql
After i restart NFS server (host) and cloudstack-management, all nfs shared can be mount in cloudstack UI. But on system vm show console vm is stopped.
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net <http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 16:18:55
Subject: RE: Re[6]: Secondary Storage not available in mysql
>Thanks for sharing the details .as per earlier details your ssvm vm
>already created and what is the state of that vm and agent state as
>well?
>
>Also are you able to mount the storage(nfs share?) which you gave in
>secondary storage path from MS as well from host. Which hypervisor you
>are using. Check your share folder permission as well.
>
>Please share the management log .
>
>Regards
>Sadhu
>
>
>
>
>
>
>
>-----Original Message-----
>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>Sent: Tuesday, February 2, 2016 1:07 PM
>To: users@cloudstack.apache.org
>Subject: Re[6]: Secondary Storage not available in mysql
>
>Problem:
>
>Secondary storage not detect from cloudstack-management. Cannot create
>vm on secondary storage
>
>Work around:
>Try remove from cloudstack UI but error "Cannot delete image store with
>active volumes backup!"
>Try to remove from mysql but host not found from table host.
>
>---------
>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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@nocser.net>
>Sent: 02/02/2016 13:51:05
>Subject: RE: Re[4]: Secondary Storage not available in mysql
>
>>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:zainal@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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>><http://www.nocser.net/>
>>>
>>>
>>>
>>>------ Original Message ------
>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>"Mohd
>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>W : www.modern.com.my | www.nocser.net
>>>
>>
>
Re[8]: Secondary Storage not available in mysql
Posted by Mohd Zainal Abidin Rabani <za...@nocser.net>.
After i restart NFS server (host) and cloudstack-management, all nfs
shared can be mount in cloudstack UI. But on system vm show console vm
is stopped.
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
<http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 16:18:55
Subject: RE: Re[6]: Secondary Storage not available in mysql
>Thanks for sharing the details .as per earlier details your ssvm vm
>already created and what is the state of that vm and agent state as
>well?
>
>Also are you able to mount the storage(nfs share?) which you gave in
>secondary storage path from MS as well from host. Which hypervisor you
>are using. Check your share folder permission as well.
>
>Please share the management log .
>
>Regards
>Sadhu
>
>
>
>
>
>
>
>-----Original Message-----
>From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
>Sent: Tuesday, February 2, 2016 1:07 PM
>To: users@cloudstack.apache.org
>Subject: Re[6]: Secondary Storage not available in mysql
>
>Problem:
>
>Secondary storage not detect from cloudstack-management. Cannot create
>vm on secondary storage
>
>Work around:
>Try remove from cloudstack UI but error "Cannot delete image store with
>active volumes backup!"
>Try to remove from mysql but host not found from table host.
>
>---------
>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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@nocser.net>
>Sent: 02/02/2016 13:51:05
>Subject: RE: Re[4]: Secondary Storage not available in mysql
>
>>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:zainal@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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>>><http://www.nocser.net/>
>>>
>>>
>>>
>>>------ Original Message ------
>>>From: "Suresh Sadhu" <Su...@citrix.com>
>>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>;
>>>"Mohd
>>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>>W : www.modern.com.my | www.nocser.net
>>>
>>
>
RE: Re[6]: Secondary Storage not available in mysql
Posted by Suresh Sadhu <Su...@citrix.com>.
Thanks for sharing the details .as per earlier details your ssvm vm already created and what is the state of that vm and agent state as well?
Also are you able to mount the storage(nfs share?) which you gave in secondary storage path from MS as well from host. Which hypervisor you are using. Check your share folder permission as well.
Please share the management log .
Regards
Sadhu
-----Original Message-----
From: Mohd Zainal Abidin Rabani [mailto:zainal@nocser.net]
Sent: Tuesday, February 2, 2016 1:07 PM
To: users@cloudstack.apache.org
Subject: Re[6]: Secondary Storage not available in mysql
Problem:
Secondary storage not detect from cloudstack-management. Cannot create vm on secondary storage
Work around:
Try remove from cloudstack UI but error "Cannot delete image store with active volumes backup!"
Try to remove from mysql but host not found from table host.
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net <http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 13:51:05
Subject: RE: Re[4]: Secondary Storage not available in mysql
>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:zainal@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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>W : www.modern.com.my | www.nocser.net
>>
>
Re[6]: Secondary Storage not available in mysql
Posted by Mohd Zainal Abidin Rabani <za...@nocser.net>.
Problem:
Secondary storage not detect from cloudstack-management. Cannot create
vm on secondary storage
Work around:
Try remove from cloudstack UI but error "Cannot delete image store with
active volumes backup!"
Try to remove from mysql but host not found from table host.
---------
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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
<http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@nocser.net>
Sent: 02/02/2016 13:51:05
Subject: RE: Re[4]: Secondary Storage not available in mysql
>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:zainal@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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
>><http://www.nocser.net/>
>>
>>
>>
>>------ Original Message ------
>>From: "Suresh Sadhu" <Su...@citrix.com>
>>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>>W : www.modern.com.my | www.nocser.net
>>
>
RE: Re[4]: Secondary Storage not available in mysql
Posted by Suresh Sadhu <Su...@citrix.com>.
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:zainal@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 : zainal@nocser.net
W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net <http://www.nocser.net/>
------ Original Message ------
From: "Suresh Sadhu" <Su...@citrix.com>
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>W : www.modern.com.my <http://www.modern.com.my/> | www.nocser.net
><http://www.nocser.net/>
>
>
>
>------ Original Message ------
>From: "Suresh Sadhu" <Su...@citrix.com>
>To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>; "Mohd
>Zainal Abidin Rabani" <za...@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:zainal@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 : zainal@nocser.net
>>W : www.modern.com.my | www.nocser.net
>