You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Alena Prokharchyk (JIRA)" <ji...@apache.org> on 2013/10/02 19:53:41 UTC
[jira] [Created] (CLOUDSTACK-4784) 2.2.x-4.x DB upgrade: network
offerings with redundant router support, are missing certain services after
the upgrade
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)