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 <rohit.ya...@citrix.com> wrote: > > > check developer/pom.xml for hints. > > ________________________________________ > > From: Charles Moulliard [ch0...@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.prasa...@gmail.com > > >wrote: > > > > > On 10 November 2012 16:42, Charles Moulliard <ch0...@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
