Re: CS 4.5.2 Fails to Start.

2015-09-13 Thread Remi Bergsma
Hi, The issue is already solved on 4.6 (which is the same as master now). The two queries were replaced by this one (https://github.com/apache/cloudstack/pull/757/files): UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE `name`="consoleproxy.url.domain" OR `name`="secstorage.ssl

Re: CS 4.5.2 Fails to Start.

2015-09-13 Thread Keerthiraja SJ
I update the same on https://issues.apache.org/jira/browse/CLOUDSTACK-8836 Thanks, Keerthi On Sun, Sep 13, 2015 at 9:44 PM, Keerthiraja SJ wrote: > Sorry pasted the wrong query. > > > #realhostip changes, before changing table and adding default value > UPDATE `cloud`.`configuration` SET value

Re: CS 4.5.2 Fails to Start.

2015-09-13 Thread Keerthiraja SJ
Sorry pasted the wrong query. #realhostip changes, before changing table and adding default value UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE `name`="consoleproxy.url.domain" OR `name`="consoleproxy.url.domain"; UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHE

Re: CS 4.5.2 Fails to Start.

2015-09-13 Thread Keerthiraja SJ
After I change the query on /usr/share/cloudstack-management/setup/db/schema-421to430.sql I deploy the database cleanly where I could able to proceed and started successfully. #realhostip changes, before changing table and adding default value UPDATE `cloud`.`configuration` SET value=CONCAT("*.",v

Re: CS 4.5.2 Fails to Start.

2015-09-13 Thread Keerthiraja SJ
I really want to know after I comment this line and do the database-setup will this effect the cloudstack once I build. I really not know what really this query use to do. Because I want to build a production environment right now so if I comment this two query and do the database initialization

Re: CS 4.5.2 Fails to Start.

2015-09-13 Thread Remi Bergsma
Hi Keerthi, Did you clear the MySQL cloud db in between attempts? I’m a bit confused. Are you using CentOS 6 or 7? First I thought CentOS 7, but now you show an CentOS 6 MariaDB package? If you’re on CentOS 6 I’d recommend using the MySQL version that ships with it. Otherwise, the fix as descri

Re: CS 4.5.2 Fails to Start.

2015-09-13 Thread Keerthiraja SJ
Even After I commented this line on MariaDB-server-10.0.21-1.el6.x86_64. #realhostip changes, before changing table and adding default value #UPDATE `cloud`.`configuration` SET value = CONCAT("*.",(SELECT `temptable`.`value` FROM (SELECT * FROM `cloud`.`configuration` WHERE `name`="consoleproxy.u

Re: CS 4.5.2 Fails to Start.

2015-09-12 Thread Remi Bergsma
Hi, The root cause was recently fixed here: https://github.com/apache/cloudstack/pull/757/files As a workaround you can either alter the query (as mentioned below) or downgrade mariadb: systemctl stop mariadb yum -y remove mariadb-libs yum -y install mariadb-1:5.5.41-2.el7_0.x86_64 mariadb-ser

Re: CS 4.5.2 Fails to Start.

2015-09-11 Thread giraffeg forestg
Hi CLOUDSTACK-8212 might become your help. https://issues.apache.org/jira/browse/CLOUDSTACK-8212 1. This is resolved by commenting out: --- [root@acs ~]# vi /usr/share/cloudstack-management/setup/db/schema-421to430.sql : #realhostip changes, before changing table and adding default value #

Re: CS 4.5.2 Fails to Start.

2015-09-11 Thread Keerthiraja SJ
I really face this issue when I install on MariaDB. If I do the same on MySQL this pass it. On Fri, Sep 11, 2015 at 7:09 PM, Keerthiraja SJ wrote: > Hi All, > > Today I tried to install the CS 4.5.2 on fresh box where I could able to > successfully deploy > the cloudstack-setup-databases. > > Af