[jira] [Commented] (CLOUDSTACK-4784) 2.2.x-4.x DB upgrade: network offerings with redundant router support, are missing certain services after the upgrade
[ https://issues.apache.org/jira/browse/CLOUDSTACK-4784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13790923#comment-13790923 ] ASF subversion and git services commented on CLOUDSTACK-4784: - Commit 34fecbf5e2b8af9251e016df70fa4063c33fcbb3 in branch refs/heads/4.2 from [~alena1108] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=34fecbf ] 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)
[jira] [Commented] (CLOUDSTACK-4784) 2.2.x-4.x DB upgrade: network offerings with redundant router support, are missing certain services after the upgrade
[ https://issues.apache.org/jira/browse/CLOUDSTACK-4784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)