[
https://issues.apache.org/jira/browse/CLOUDSTACK-4784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13784243#comment-13784243
]
ASF subversion and git services commented on CLOUDSTACK-4784:
-------------------------------------------------------------
Commit a2bf7f035ee09b294aa41fe85944f2f510aefacc in branch refs/heads/master
from [~alena1108]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=a2bf7f0 ]
CLOUDSTACK-4784: 22x to 4.x upgrade - don't ignore redundant router network
offering, when update ntwk_offering_serivce_map with PF/StaticNat/SourceNat
services
> 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)
