[jira] [Commented] (CLOUDSTACK-4784) 2.2.x-4.x DB upgrade: network offerings with redundant router support, are missing certain services after the upgrade

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ 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)