[jira] [Commented] (CLOUDSTACK-6293) Custom SSL certificate for console proxy does not work after upgrade 4.2.1 -> 4.3

["Amogh Vasekar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13949945#comment-13949945 ] 

Amogh Vasekar commented on CLOUDSTACK-6293:
-------------------------------------------

Seems the file ConsoleProxyInfo is missing from the commit for 4.3, though it made it to master / 4.4
https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=ec4db7b [4.3]
https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=09c3753 [master]



> Custom SSL certificate for console proxy does not work after upgrade 4.2.1 -> 4.3
> ---------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-6293
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6293
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Upgrade
>    Affects Versions: 4.3.0
>            Reporter: Remi Bergsma
>
> We use a custom SSL certificate that had been installed before the upgrade.
> After upgrading from 4.2.1 to 4.3 the console proxy did not work due to a wrong SSL url being generated:
> https://1-2-3-4.*.ssl.example.com instead of https://1-2-3-4.ssl.example.com
> We fixed this by altering these settings to remove "*."
> secstorage.ssl.cert.domain
> consoleproxy.url.domain
> These settings were altered during the upgrade, and they actually break it.
> 2014-03-27 14:46:45,429 DEBUG [utils.db.ScriptRunner] (main:null) 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" 
> 2014-03-27 14:46:45,441 DEBUG [utils.db.ScriptRunner] (main:null) UPDATE `cloud`.`configuration` SET `value` = CONCAT("*.",(SELECT `temptable`.`value` FROM (SELECT * FROM `cloud`.`configuration` WHERE `name`="secstorage.ssl.cert.domain") AS `temptable` WHERE `temptable`.`name`="secstorage.ssl.cert.domain")) WHERE `name`="secstorage.ssl.cert.domain"
> The SQL can be found in this file:
> /usr/share/cloudstack-management/setup/db/schema-421to430.sql
> Please fix this!
> Thanks,
> Remi



--
This message was sent by Atlassian JIRA
(v6.2#6252)