As far as i can see, both the commands are same except a ‘-‘ is missing in the 
url filename in the first call.
in the first run it failed with 403 whereas in the second run it was able to 
download.

the script gets the template id by executing the below command:
mysql -h $dbHost --user=$dbUser --password=$dbPassword --skip-column-names -U 
cloud -e "select max(id) from cloud.vm_template where type = \"SYSTEM\" and 
hypervisor_type = \"VMware\" and removed is null”

looks like you are getting NULL instead of the id with the above. 

can you run the above query and see if its returning properly?


~Rajani



On 07-Jul-2014, at 7:30 pm, Yesid Mora <ym...@o4it.com> wrote:

> Hello Rajani, the connection to database is good, the DB server is localhost 
> is the same server that Cloudstack, attached the file db.properties and the 
> output for your command generate error
> 
> /usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt
>  -m /mnt/secondary -u 
> http://download.cloud.com/templates/4.3/systemvm64template-2014-04-13-mastervmware.ova
>  -h vmware -F
> --2014-07-07 09:56:08--  
> http://download.cloud.com/templates/4.3/systemvm64template-2014-04-13-mastervmware.ova
> Resolving download.cloud.com... 54.231.1.249
> Connecting to download.cloud.com|54.231.1.249|:80... connected.
> HTTP request sent, awaiting response... 403 Forbidden
> 2014-07-07 09:56:08 ERROR 403: Forbidden.
> 
> Failed to fetch system vm template from 
> http://download.cloud.com/templates/4.3/systemvm64template-2014-04-13-mastervmware.ova
> Installation failed
> 
> 
> But execute the other command the ouput is:
> 
> /usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt
>  -m /mnt/secondary -u 
> http://download.cloud.com/templates/4.3/systemvm64template-2014-04-13-master-vmware.ova
>  -h vmware -F
> --2014-07-07 09:52:22--  
> http://download.cloud.com/templates/4.3/systemvm64template-2014-04-13-master-vmware.ova
> Resolving download.cloud.com... 176.32.99.39
> Connecting to download.cloud.com|176.32.99.39|:80... connected.
> HTTP request sent, awaiting response... 200 OK
> Length: 314015744 (299M) [application/x-virtualbox-ova]
> Saving to: 
> “/usr/share/cloudstack-common/scripts/storage/secondary/c0739fbf-7e7b-462a-95f8-5273d8b4da9c.ova”
> 
> 100%[========================================================================================================================================>]
>  314,015,744 2.48M/s   in 2m 41s
> 
> 2014-07-07 09:55:04 (1.86 MB/s) - 
> “/usr/share/cloudstack-common/scripts/storage/secondary/c0739fbf-7e7b-462a-95f8-5273d8b4da9c.ova”
>  saved [314015744/314015744]
> 
> File 
> /usr/share/cloudstack-common/scripts/storage/secondary/c0739fbf-7e7b-462a-95f8-5273d8b4da9c.ova
>  does not appear to be compressed
> Moving to 
> /mnt/secondary/template/tmpl/1/NULL///c0739fbf-7e7b-462a-95f8-5273d8b4da9c.ova...could
>  take a while
> Successfully installed system VM template  to 
> /mnt/secondary/template/tmpl/1/NULL/
> 
> Thanks,
> 
> 
> 
> Cordialmente,
> 
> Yesid Mora | Orchestration Engineer | O4IT
> PBX: 251 Ext +57 (1) 423-5460 | Cel: 3124509565
> | Oficina 202 |
> http://www.o4it.com | mailto:ym...@o4it.com
> 
> 
> 
> -----Original Message-----
> From: Rajani Karuturi [mailto:rajani.karut...@citrix.com]
> Sent: Sunday, July 06, 2014 11:52 PM
> To: users@cloudstack.apache.org
> Subject: Re: Template Default SystemVM
> 
> looks like a mysql connection issue to me. Is the mysql server running and 
> are you able to connect to your mysql server from the cloudstack management 
> server??
> 
> Can you share the output when you run the install system template script?
>> /usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt
>>  -m /mnt/secondary -u 
>> http://download.cloud.com/templates/4.3/systemvm64template-2014-04-13-mastervmware.ova
>>  -h vmware -F
> 
> 
> ~Rajani
> 
> 
> 
> On 04-Jul-2014, at 6:31 pm, Yesid Mora <ym...@o4it.com> wrote:
> 
>> Hello, yes I check secondary storage and I see the template but the path in 
>> the template is
>> 
>> /template/tmpl/1/NULL/"files for template"
>> 
>> Buti don’t know why the folder is NULL, And I verify in the database but not 
>> register the template not see the template, additionally yes I add the 
>> primary and secondary storage in Cloudstack and state is good is UP
>> 
>> The output for file template.properties is
>> 
>> filename=47322085-b559-4f7c-ac67-5eb969042cff.ova
>> description=SystemVM Template
>> checksum=
>> hvm=false
>> size=314015744
>> ova=true
>> id=NULL
>> public=true
>> ova.filename=47322085-b559-4f7c-ac67-5eb969042cff.ova
>> uniquename=routing-NULL
>> ova.virtualsize=314015744
>> virtualsize=314015744
>> ova.size=314015744
>> 
>> 
>> thanks
>> 
>> 
>> 
>> Cordialmente,
>> 
>> Yesid Mora | Orchestration Engineer | O4IT
>> PBX: 251 Ext +57 (1) 423-5460 | Cel: 3124509565
>> | Oficina 202 |
>> http://www.o4it.com | mailto:ym...@o4it.com
>> 
>> 
>> 
>> -----Original Message-----
>> From: Harikrishna Patnala [mailto:harikrishna.patn...@citrix.com]
>> Sent: Friday, July 04, 2014 1:01 AM
>> To: users@cloudstack.apache.org
>> Subject: Re: Template Default SystemVM
>> 
>> Do add the host, secondary storage and primary storage into the Cloudstack ?
>> 
>> -Harikrishna
>> On 04-Jul-2014, at 9:25 am, Rajani Karuturi 
>> <rajani.karut...@citrix.com<mailto:rajani.karut...@citrix.com>> wrote:
>> 
>> Do you see the template in your secondary storage?
>> 
>> Can you check the size and state of the template in vm_template table?
>> 
>> 
>> ~Rajani
>> 
>> 
>> 
>> On 04-Jul-2014, at 2:59 am, Yesid Mora 
>> <ym...@o4it.com<mailto:ym...@o4it.com><mailto:ym...@o4it.com>> wrote:
>> 
>> 
>> Hello, I installed cloudstack 4.3.0 and create de zone,pod,cluster,  I 
>> upload the template for system vm but and not see in the GUI and CLI inform 
>> that upload is good the command execute is
>> 
>> /usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt
>>  -m /mnt/secondary -u 
>> http://download.cloud.com/templates/4.3/systemvm64template-2014-04-13-mastervmware.ova
>>  -h vmware -F
>> 
>> Please help me
>> 
>> Thanks,
>> 
>> 
>> 
>> Cordialmente / Best regards,
>> 
>> 
>> 
>> 
>> 
>> Yesid Mora | Orchestration Engineer | O4IT
>> 
>> PBX:+57 (1) 423-5460  Ext  251  | Cel: 3124509565
>> 
>> | Oficina 202 |
>> 
>> www.o4it.com<http://www.o4it.com/><http://www.o4it.com/> | 
>> ym...@o4it.com<mailto:ym...@o4it.com><mailto:ym...@o4it.com>
>> 
>> 
>> 
>> 
>> 
>> <http://www.o4it.com/><http://www.linkedin.com/company/1207504><https://twitter.com/o4it><https://www.facebook.com/o4itofficial><https://www.youtube.com/user/o4itofficial>
>> 
>> 
>> 
>> 
>> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is 
>> for the sole use of the intended recipient(s) and may contain confidential 
>> or proprietary information. Any unauthorized review, use, disclosure or 
>> distribution is prohibited. If you are not the intended recipient, 
>> immediately contact the sender by reply e-mail and destroy all copies of the 
>> original message.
>> 
> 
> <db.zip>

Reply via email to