cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alena Prokharchyk (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-4784) 2.2.x-4.x DB upgrade: network offerings with redundant router support, are missing certain services after the upgrade
Date Wed, 02 Oct 2013 17:53:41 GMT
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)

Mime
View raw message