ariaDB [cloud]> select * from vm_template;
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
| id | unique_name | name |
uuid | public | featured | type | hvm |
bits |
url
| format | created | removed | account_id |
checksum | display_text |
enable_password | enable_sshkey | guest_os_id | bootable | prepopulate |
cross_zones | extractable | hypervisor_type | source_template_id |
template_tag | sort_key | size | state | update_count | updated |
dynamically_scalable |
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
| 1 | routing-1 | SystemVM Template (XenServer) |
cf459945-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-xen.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
74b92f031cc5c2089ee89efb81344dcf | SystemVM Template (XenServer)
| 0 | 0 | 184 | 1 | 0
| 1 | 0 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 2 | centos53-x86_64 | CentOS 5.3(64-bit) no GUI (XenServer) |
cf45be09-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 |
http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2
| VHD | 2015-09-11 02:38:08 | 2015-09-11 02:38:08 | 1 |
b63d854a9560c013142567bbae8d98cf | CentOS 5.3(64-bit) no GUI (XenServer)
| 0 | 0 | 12 | 1 | 0
| 1 | 1 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 3 | routing-3 | SystemVM Template (KVM) |
cf45d927-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-kvm.qcow2.bz2
| QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
85a1bed07bf43cbf022451cb2ecae4ff | SystemVM Template (KVM)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | KVM | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 4 | centos55-x86_64 | CentOS 5.5(64-bit) no GUI (KVM) |
cf45eb74-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 |
http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2
| QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
ed0e788280ff2912ea40f7f91ca7a249 | CentOS 5.5(64-bit) no GUI (KVM)
| 0 | 0 | 112 | 1 | 0
| 1 | 1 | KVM | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 5 | centos56-x86_64-xen | CentOS 5.6(64-bit) no GUI (XenServer) |
cf45fae4-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
905cec879afd9c9d22ecc8036131a180 | CentOS 5.6(64-bit) no GUI (XenServer)
| 0 | 0 | 142 | 1 | 0
| 1 | 1 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 1 |
| 6 | centos64-x64 | CentOS 6.4(64-bit) GUI (Hyperv) |
cf46438e-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/releases/4.3/centos6_4_64bit.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
eef6b9940ea3ed01221d963d4a012d0a | CentOS 6.4 (64-bit) GUI (Hyperv)
| 0 | 0 | 182 | 1 | 0
| 1 | 1 | Hyperv | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 7 | centos53-x64 | CentOS 5.3(64-bit) no GUI (vSphere) |
cf460fcc-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/releases/2.2.0/CentOS5.3-x86_64.ova
| OVA | 2015-09-11 02:38:08 | NULL | 1 |
f6f881b7f2292948d8494db837fe0f47 | CentOS 5.3(64-bit) no GUI (vSphere)
| 0 | 0 | 12 | 1 | 0
| 1 | 1 | VMware | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 8 | routing-8 | SystemVM Template (vSphere) |
cf461e57-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-vmware.ova
| OVA | 2015-09-11 02:38:08 | NULL | 1 |
ef593a061f3b7594ab0bfd9b0ed0a0d4 | SystemVM Template (vSphere)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | VMware | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 1 |
| 9 | routing-9 | SystemVM Template (HyperV) |
cf4634f1-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2013-12-23-hyperv.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
5df45ee6ebe1b703a8805f4e1f4d0818 | SystemVM Template (HyperV)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | Hyperv | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 10 | routing-10 | SystemVM Template (LXC) |
23c9be31-5869-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
| QCOW2 | 2015-09-11 02:40:29 | NULL | 1 |
2755de1f9ef2ce4d6f2bee2efbb4da92 | SystemVM Template (LXC)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | LXC | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
10 rows in set (0.00 sec)
On Fri, Sep 11, 2015 at 3:27 PM, prapul cool <
prapul_cool2...@yahoo.com.invalid> wrote:
> Hi keerthiaja,
>
> In vm_template table ,have a column with the name of 'size'. Seems your
> db deployment was not complete so can drop database and redeploy
> cloudstack.... Regards,
> Prapul sriram,
> Cloud Architect,
> PSI Cloud Solutions,
> Psiclouds.com.
>
>
> On Friday, 11 September 2015 3:13 PM, Keerthiraja SJ <
> sjkeer...@gmail.com> wrote:
>
>
> ERROR [c.c.u.d.ScriptRunner] (main:null) Error executing: UPDATE
> `cloud`.`configuration` SET value = CONCAT("*.",(SELECT `temptable`.`value`
> FROM (SELECT * FROM `cloud`.`configuration` WHERE
> `name`="consoleproxy.url.domain") AS `temptable` WHERE
> `temptable`.`name`="consoleproxy.url.domain")) WHERE
> `name`="consoleproxy.url.domain"
> ERROR [c.c.u.d.ScriptRunner] (main:null)
> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
> link failure
>
> The last packet successfully received from the server was 63 milliseconds
> ago. The last packet sent successfully to the server was 63 milliseconds
> ago.
> ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to execute upgrade
> script: /usr/share/cloudstack-management/setup/db/schema-421to430.sql
> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
> link failure
>
>
> ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to upgrade the
> database
>
> On Fri, Sep 11, 2015 at 2:46 PM, Keerthiraja SJ <sjkeer...@gmail.com>
> wrote:
>
> > Hi All,
> >
> > After successfully installation I could while starting the
> > cloudstack-management ther seems to some error while connecting to my
> > database.
> >
> > I am right now into production setup.
> >
> > ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to upgrade the
> > database
> > com.cloud.utils.exception.CloudRuntimeException: Unable to execute
> upgrade
> > script: /usr/share/cloudstack-management/setup/db/schema-40to410.sql
> >
> > ERROR [c.c.u.d.ScriptRunner] (main:null) Error executing: alter table
> > vm_template add size bigint unsigned
> > ERROR [c.c.u.d.ScriptRunner] (main:null)
> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate
> column
> > name 'size'
> > ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to execute
> upgrade
> > script: /usr/share/cloudstack-management/setup/db/schema-40to410.sql
> >
> >
> > The Version of the MYSQL
> >
> > MariaDB-server-10.1.7-1.el6.x86_64
> > MariaDB-common-10.1.7-1.el6.x86_64
> > MariaDB-client-10.1.7-1.el6.x86_64
> >
> > If this is not the right version MARIADB then what version should I have
> > to install.
> >
> > Thanks,
> > Keerthi
> >
>
>
>
