Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Date: Wed, 2 Oct 2013 18:25:42 +0000 (UTC)
From: "Alena Prokharchyk (JIRA)" <jira@apache.org>
To: cloudstack-issues@incubator.apache.org
Message-ID: <JIRA.12671993.1380736339433.1417.1380738342634@arcas>
In-Reply-To: <JIRA.12671993.1380736339433@arcas>
References: <JIRA.12671993.1380736339433@arcas>
Subject: [jira] [Resolved] (CLOUDSTACK-4784) 2.2.x-4.x DB upgrade: network
 offerings with redundant router support, are missing certain services after
 the upgrade
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CLOUDSTACK-4784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alena Prokharchyk resolved CLOUDSTACK-4784.
-------------------------------------------

    Resolution: Fixed

Fixed in master branch with a2bf7f035ee09b294aa41fe85944f2f510aefacc

> 2.2.x-4.x DB upgrade: network offerings with redundant router support, are missing certain services after the upgrade
> ---------------------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-4784
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4784
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Install and Setup
>    Affects Versions: 4.0.0
>            Reporter: Alena Prokharchyk
>            Assignee: Alena Prokharchyk
>             Fix For: Future
>
>
> Network offerings with redundant router support, are missing certain services after the upgrade from 2.2.x to 4.x:
> PF/LB/StaticNat/SourceNat
> Workaround for existing customers who's upgraded:
> ==========================================================
> 1) Fix network offering. First, get the network offering id:
> mysql> select id from network_offerings where name='DefaultIsolatedNetworkOfferingWithSourceNatService-redundant';
> id
> 9
> Then update the ntwk_offering_service_map table with the missing services:
> insert into ntwk_offering_service_map (network_offering_id, service, provider, created) values (9, 'SourceNat', 'VirtualRouter', now());
> insert into ntwk_offering_service_map (network_offering_id, service, provider, created) values (9, 'StaticNat', 'VirtualRouter', now());
> insert into ntwk_offering_service_map (network_offering_id, service, provider, created) values (9, 'PortForwarding', 'VirtualRouter', now());
> insert into ntwk_offering_service_map (network_offering_id, service, provider, created) values (9, 'Lb', 'VirtualRouter', now());
> 2) Then update the network with the services.
> First, get the ids of the network(s) to update
> mysql> select id from networks where network_offering_id=9;
> id
> 209
> Then insert the entries to ntwk_service_map table:
> insert into ntwk_service_map (network_id, service, provider, created) values (209, 'SourceNat', 'VirtualRouter', now());
> insert into ntwk_service_map (network_id, service, provider, created) values (209, 'StaticNat', 'VirtualRouter', now());
> insert into ntwk_service_map (network_id, service, provider, created) values (209, 'PortForwarding', 'VirtualRouter', now());
> insert into ntwk_service_map (network_id, service, provider, created) values (209, 'Lb', 'VirtualRouter', now());


--
This message was sent by Atlassian JIRA
(v6.1#6144)