You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Charles Moulliard <ch...@gmail.com> on 2012/11/10 12:12:26 UTC

Upload CentOs, Debian, RHEL, Ubuntu iso

Hi,

Is there a SQL script (or cloud api) that we can use to upload a new ISO
file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?

Regards,

-- 
Charles Moulliard
Apache Committer / Sr. Enterprise Architect (RedHat)
Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com

Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by Sebastien Goasguen <ru...@gmail.com>.
Hi, I am seeing a similar problem with the latest master and the devcloud test environment.

mgt server runs fine, configuration runs fine. But the tinylinux template does not show in the GUI, even though it's in the table and downloaded on secondary storage.

How can I kick it ?

-Sebastien

On Nov 12, 2012, at 11:02 AM, Prasanna Santhanam <pr...@citrix.com> wrote:

> Hi,
> 
> Yes deploydb should insert those entires into vm_templates tables. Not
> all the templates will be downloaded. If you have XenServer in your
> zone, all xenserver built-ins will be downloaded and so on, depending
> on the hypervisor in your zone.
> 
> -- 
> Prasanna.,
> 
> On Sun, Nov 11, 2012 at 10:51:51PM +0530, Charles Moulliard wrote:
>> The template.sql file contains several CentOs but I don't see them under
>> templates or ISO screen of web interface. They have been added to the table
>> vm_template of my local SQL Server.
>> 
>> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
>> removed, type, hvm, bits, account_id, url, checksum, enable_password,
>> display_text,  format, guest_os_id, featured, cross_zones, hypervisor_type,
>> extractable)
>>    VALUES (2, 'centos53-x86_64', 'CentOS 5.3(64-bit) no GUI (XenServer)',
>> 1, now(), now(), 'BUILTIN', 0, 64, 1, '
>> http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2',
>> 'b63d854a9560c013142567bbae8d98cf', 0, 'CentOS 5.3(64-bit) no GUI
>> (XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1);
>> 
>> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
>> type, hvm, bits, account_id, url, checksum, enable_password, display_text,
>> format, guest_os_id, featured, cross_zones, hypervisor_type)
>>    VALUES (3, 'routing-3', 'SystemVM Template (KVM)', 0, now(), 'SYSTEM',
>> 0, 64, 1, '
>> http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2',
>> '2755de1f9ef2ce4d6f2bee2efbb4da92', 0, 'SystemVM Template (KVM)', 'QCOW2',
>> 15, 0, 1, 'KVM');
>> 
>> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
>> type, hvm, bits, account_id, url, checksum, display_text, enable_password,
>> format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
>>    VALUES (4, 'centos55-x86_64', 'CentOS 5.5(64-bit) no GUI (KVM)', 1,
>> now(), 'BUILTIN', 0, 64, 1, '
>> http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2',
>> 'ed0e788280ff2912ea40f7f91ca7a249', 'CentOS 5.5(64-bit) no GUI (KVM)', 0,
>> 'QCOW2', 112, 1, 1, 'KVM', 1);
>> 
>> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
>> type, hvm, bits, account_id, url, checksum, enable_password, display_text,
>> format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
>>    VALUES (5, 'centos56-x86_64-xen', 'CentOS 5.6(64-bit) no GUI
>> (XenServer)', 1, now(), 'BUILTIN', 0, 64, 1, '
>> http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2',
>> '905cec879afd9c9d22ecc8036131a180', 0, 'CentOS 5.6(64-bit) no GUI
>> (XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1);
>> 
>> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
>> type, hvm, bits, account_id, url, checksum, enable_password, display_text,
>> format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
>>    VALUES (7, 'centos53-x64', 'CentOS 5.3(64-bit) no GUI (vSphere)', 1,
>> now(), 'BUILTIN', 0, 64, 1, '
>> http://download.cloud.com/releases/2.2.0/CentOS5.3-x86_64.ova',
>> 'f6f881b7f2292948d8494db837fe0f47', 0, 'CentOS 5.3(64-bit) no GUI
>> (vSphere)', 'OVA', 12, 1, 1, 'VMware', 1);
>> 
>> 
>> 
>> On Sun, Nov 11, 2012 at 5:49 PM, Rohit Yadav <ro...@citrix.com> wrote:
>> 
>>> check developer/pom.xml for hints.
>>> ________________________________________
>>> From: Charles Moulliard [ch007m@gmail.com]
>>> Sent: Sunday, November 11, 2012 8:58 PM
>>> To: cloudstack-users@incubator.apache.org
>>> Subject: Re: Upload CentOs, Debian, RHEL, Ubuntu iso
>>> 
>>> Is this script (setup/db/templates.sql) used when we run the command "mvn
>>> -P developer -pl developer,tools/devcloud -Ddeploydb" ?
>>> 
>>> 
>>> On Sat, Nov 10, 2012 at 5:32 PM, prasanna <srivatsav.prasanna@gmail.com
>>>> wrote:
>>> 
>>>> On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
>>>>> Hi,
>>>>> 
>>>>> Is there a SQL script (or cloud api) that we can use to upload a new
>>> ISO
>>>>> file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
>>>>> 
>>>> 
>>>> Don't think there is an SQL script. Do you want these pre-seeded when
>>>> you first bring up the management server? Why not insert them as
>>>> built-in's into the vm_template table before setting up your
>>>> databases?
>>>> 
>>>> You need to change the vm_template table for that. The script IIRC is
>>>> setup/db/templates.sql
>>>> 
>>>> --
>>>> Prasanna.,
>>>> 
>>> 
>>> 
>>> 
>>> --
>>> Charles Moulliard
>>> Apache Committer / Sr. Enterprise Architect (RedHat)
>>> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
>>> 
>> 
>> 
>> 
>> -- 
>> Charles Moulliard
>> Apache Committer / Sr. Enterprise Architect (RedHat)
>> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
> 


Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by Prasanna Santhanam <pr...@citrix.com>.
Hi,

Yes deploydb should insert those entires into vm_templates tables. Not
all the templates will be downloaded. If you have XenServer in your
zone, all xenserver built-ins will be downloaded and so on, depending
on the hypervisor in your zone.

-- 
Prasanna.,

On Sun, Nov 11, 2012 at 10:51:51PM +0530, Charles Moulliard wrote:
> The template.sql file contains several CentOs but I don't see them under
> templates or ISO screen of web interface. They have been added to the table
> vm_template of my local SQL Server.
> 
> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
> removed, type, hvm, bits, account_id, url, checksum, enable_password,
> display_text,  format, guest_os_id, featured, cross_zones, hypervisor_type,
> extractable)
>     VALUES (2, 'centos53-x86_64', 'CentOS 5.3(64-bit) no GUI (XenServer)',
> 1, now(), now(), 'BUILTIN', 0, 64, 1, '
> http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2',
> 'b63d854a9560c013142567bbae8d98cf', 0, 'CentOS 5.3(64-bit) no GUI
> (XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1);
> 
> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
> type, hvm, bits, account_id, url, checksum, enable_password, display_text,
> format, guest_os_id, featured, cross_zones, hypervisor_type)
>     VALUES (3, 'routing-3', 'SystemVM Template (KVM)', 0, now(), 'SYSTEM',
> 0, 64, 1, '
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2',
> '2755de1f9ef2ce4d6f2bee2efbb4da92', 0, 'SystemVM Template (KVM)', 'QCOW2',
> 15, 0, 1, 'KVM');
> 
> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
> type, hvm, bits, account_id, url, checksum, display_text, enable_password,
> format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
>     VALUES (4, 'centos55-x86_64', 'CentOS 5.5(64-bit) no GUI (KVM)', 1,
> now(), 'BUILTIN', 0, 64, 1, '
> http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2',
> 'ed0e788280ff2912ea40f7f91ca7a249', 'CentOS 5.5(64-bit) no GUI (KVM)', 0,
> 'QCOW2', 112, 1, 1, 'KVM', 1);
> 
> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
> type, hvm, bits, account_id, url, checksum, enable_password, display_text,
>  format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
>     VALUES (5, 'centos56-x86_64-xen', 'CentOS 5.6(64-bit) no GUI
> (XenServer)', 1, now(), 'BUILTIN', 0, 64, 1, '
> http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2',
> '905cec879afd9c9d22ecc8036131a180', 0, 'CentOS 5.6(64-bit) no GUI
> (XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1);
> 
> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
> type, hvm, bits, account_id, url, checksum, enable_password, display_text,
>  format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
>     VALUES (7, 'centos53-x64', 'CentOS 5.3(64-bit) no GUI (vSphere)', 1,
> now(), 'BUILTIN', 0, 64, 1, '
> http://download.cloud.com/releases/2.2.0/CentOS5.3-x86_64.ova',
> 'f6f881b7f2292948d8494db837fe0f47', 0, 'CentOS 5.3(64-bit) no GUI
> (vSphere)', 'OVA', 12, 1, 1, 'VMware', 1);
> 
> 
> 
> On Sun, Nov 11, 2012 at 5:49 PM, Rohit Yadav <ro...@citrix.com> wrote:
> 
> > check developer/pom.xml for hints.
> > ________________________________________
> > From: Charles Moulliard [ch007m@gmail.com]
> > Sent: Sunday, November 11, 2012 8:58 PM
> > To: cloudstack-users@incubator.apache.org
> > Subject: Re: Upload CentOs, Debian, RHEL, Ubuntu iso
> >
> > Is this script (setup/db/templates.sql) used when we run the command "mvn
> > -P developer -pl developer,tools/devcloud -Ddeploydb" ?
> >
> >
> > On Sat, Nov 10, 2012 at 5:32 PM, prasanna <srivatsav.prasanna@gmail.com
> > >wrote:
> >
> > > On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
> > > > Hi,
> > > >
> > > > Is there a SQL script (or cloud api) that we can use to upload a new
> > ISO
> > > > file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
> > > >
> > >
> > > Don't think there is an SQL script. Do you want these pre-seeded when
> > > you first bring up the management server? Why not insert them as
> > > built-in's into the vm_template table before setting up your
> > > databases?
> > >
> > > You need to change the vm_template table for that. The script IIRC is
> > > setup/db/templates.sql
> > >
> > > --
> > > Prasanna.,
> > >
> >
> >
> >
> > --
> > Charles Moulliard
> > Apache Committer / Sr. Enterprise Architect (RedHat)
> > Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
> >
> 
> 
> 
> -- 
> Charles Moulliard
> Apache Committer / Sr. Enterprise Architect (RedHat)
> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com


Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by Charles Moulliard <ch...@gmail.com>.
The template.sql file contains several CentOs but I don't see them under
templates or ISO screen of web interface. They have been added to the table
vm_template of my local SQL Server.

INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
removed, type, hvm, bits, account_id, url, checksum, enable_password,
display_text,  format, guest_os_id, featured, cross_zones, hypervisor_type,
extractable)
    VALUES (2, 'centos53-x86_64', 'CentOS 5.3(64-bit) no GUI (XenServer)',
1, now(), now(), 'BUILTIN', 0, 64, 1, '
http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2',
'b63d854a9560c013142567bbae8d98cf', 0, 'CentOS 5.3(64-bit) no GUI
(XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1);

INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
type, hvm, bits, account_id, url, checksum, enable_password, display_text,
format, guest_os_id, featured, cross_zones, hypervisor_type)
    VALUES (3, 'routing-3', 'SystemVM Template (KVM)', 0, now(), 'SYSTEM',
0, 64, 1, '
http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2',
'2755de1f9ef2ce4d6f2bee2efbb4da92', 0, 'SystemVM Template (KVM)', 'QCOW2',
15, 0, 1, 'KVM');

INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
type, hvm, bits, account_id, url, checksum, display_text, enable_password,
format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
    VALUES (4, 'centos55-x86_64', 'CentOS 5.5(64-bit) no GUI (KVM)', 1,
now(), 'BUILTIN', 0, 64, 1, '
http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2',
'ed0e788280ff2912ea40f7f91ca7a249', 'CentOS 5.5(64-bit) no GUI (KVM)', 0,
'QCOW2', 112, 1, 1, 'KVM', 1);

INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
type, hvm, bits, account_id, url, checksum, enable_password, display_text,
 format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
    VALUES (5, 'centos56-x86_64-xen', 'CentOS 5.6(64-bit) no GUI
(XenServer)', 1, now(), 'BUILTIN', 0, 64, 1, '
http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2',
'905cec879afd9c9d22ecc8036131a180', 0, 'CentOS 5.6(64-bit) no GUI
(XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1);

INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
type, hvm, bits, account_id, url, checksum, enable_password, display_text,
 format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
    VALUES (7, 'centos53-x64', 'CentOS 5.3(64-bit) no GUI (vSphere)', 1,
now(), 'BUILTIN', 0, 64, 1, '
http://download.cloud.com/releases/2.2.0/CentOS5.3-x86_64.ova',
'f6f881b7f2292948d8494db837fe0f47', 0, 'CentOS 5.3(64-bit) no GUI
(vSphere)', 'OVA', 12, 1, 1, 'VMware', 1);



On Sun, Nov 11, 2012 at 5:49 PM, Rohit Yadav <ro...@citrix.com> wrote:

> check developer/pom.xml for hints.
> ________________________________________
> From: Charles Moulliard [ch007m@gmail.com]
> Sent: Sunday, November 11, 2012 8:58 PM
> To: cloudstack-users@incubator.apache.org
> Subject: Re: Upload CentOs, Debian, RHEL, Ubuntu iso
>
> Is this script (setup/db/templates.sql) used when we run the command "mvn
> -P developer -pl developer,tools/devcloud -Ddeploydb" ?
>
>
> On Sat, Nov 10, 2012 at 5:32 PM, prasanna <srivatsav.prasanna@gmail.com
> >wrote:
>
> > On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
> > > Hi,
> > >
> > > Is there a SQL script (or cloud api) that we can use to upload a new
> ISO
> > > file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
> > >
> >
> > Don't think there is an SQL script. Do you want these pre-seeded when
> > you first bring up the management server? Why not insert them as
> > built-in's into the vm_template table before setting up your
> > databases?
> >
> > You need to change the vm_template table for that. The script IIRC is
> > setup/db/templates.sql
> >
> > --
> > Prasanna.,
> >
>
>
>
> --
> Charles Moulliard
> Apache Committer / Sr. Enterprise Architect (RedHat)
> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
>



-- 
Charles Moulliard
Apache Committer / Sr. Enterprise Architect (RedHat)
Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com

RE: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by Rohit Yadav <ro...@citrix.com>.
check developer/pom.xml for hints.
________________________________________
From: Charles Moulliard [ch007m@gmail.com]
Sent: Sunday, November 11, 2012 8:58 PM
To: cloudstack-users@incubator.apache.org
Subject: Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Is this script (setup/db/templates.sql) used when we run the command "mvn
-P developer -pl developer,tools/devcloud -Ddeploydb" ?


On Sat, Nov 10, 2012 at 5:32 PM, prasanna <sr...@gmail.com>wrote:

> On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
> > Hi,
> >
> > Is there a SQL script (or cloud api) that we can use to upload a new ISO
> > file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
> >
>
> Don't think there is an SQL script. Do you want these pre-seeded when
> you first bring up the management server? Why not insert them as
> built-in's into the vm_template table before setting up your
> databases?
>
> You need to change the vm_template table for that. The script IIRC is
> setup/db/templates.sql
>
> --
> Prasanna.,
>



--
Charles Moulliard
Apache Committer / Sr. Enterprise Architect (RedHat)
Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com

Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by Charles Moulliard <ch...@gmail.com>.
Is this script (setup/db/templates.sql) used when we run the command "mvn
-P developer -pl developer,tools/devcloud -Ddeploydb" ?


On Sat, Nov 10, 2012 at 5:32 PM, prasanna <sr...@gmail.com>wrote:

> On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
> > Hi,
> >
> > Is there a SQL script (or cloud api) that we can use to upload a new ISO
> > file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
> >
>
> Don't think there is an SQL script. Do you want these pre-seeded when
> you first bring up the management server? Why not insert them as
> built-in's into the vm_template table before setting up your
> databases?
>
> You need to change the vm_template table for that. The script IIRC is
> setup/db/templates.sql
>
> --
> Prasanna.,
>



-- 
Charles Moulliard
Apache Committer / Sr. Enterprise Architect (RedHat)
Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com

Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by prasanna <sr...@gmail.com>.
On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
> Hi,
>
> Is there a SQL script (or cloud api) that we can use to upload a new ISO
> file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
>

Don't think there is an SQL script. Do you want these pre-seeded when
you first bring up the management server? Why not insert them as
built-in's into the vm_template table before setting up your
databases?

You need to change the vm_template table for that. The script IIRC is
setup/db/templates.sql

-- 
Prasanna.,

Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by Charles Moulliard <ch...@gmail.com>.
pre-seeded is also an option to speed up installation of testing
environment with different Linux images/iso


On Sat, Nov 10, 2012 at 4:15 PM, prasanna <ts...@apache.org> wrote:

> On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
> > Hi,
> >
> > Is there a SQL script (or cloud api) that we can use to upload a new ISO
> > file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
> >
> > Regards,
> >
>
> Don't think there is an SQL script. Do you want these pre-seeded when
> you first bring up the management server?
>



-- 
Charles Moulliard
Apache Committer / Sr. Enterprise Architect (RedHat)
Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com

Re: Upload CentOs, Debian, RHEL, Ubuntu iso

Posted by prasanna <ts...@apache.org>.
On 10 November 2012 16:42, Charles Moulliard <ch...@gmail.com> wrote:
> Hi,
>
> Is there a SQL script (or cloud api) that we can use to upload a new ISO
> file (CentOs, Debian, RHEL, Ubuntu) into the Mngt Server ?
>
> Regards,
>

Don't think there is an SQL script. Do you want these pre-seeded when
you first bring up the management server?