Alena Prokharchyk created CLOUDSTACK-4784:
---------------------------------------------
Summary: 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
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)
