[jira] [Commented] (CLOUDSTACK-1709) AWS Regions - As part of adding a new region , project related entries should not be synced from accounts table.

["Kishan Kavala (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-1709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13606260#comment-13606260 ] 

Kishan Kavala commented on CLOUDSTACK-1709:
-------------------------------------------

I'll document below steps:

To remove project account:
mysql> delete from account where type = 5;

To set default zone id as null:
mysql> update account set default_zone_id = null;

I do not see any other option.
                
> AWS Regions - As part of adding a new region , project related entries should not be synced from accounts table.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-1709
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1709
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server
>    Affects Versions: 4.1.0
>         Environment: Build from 4.1.0
>            Reporter: Sangeetha Hariharan
>            Assignee: Kishan Kavala
>             Fix For: 4.1.0
>
>
> Regions - As part of adding a new region , project related entries should not be synced from accounts table.
> FS states the following needs to be done when adding a new region.
> mysqldump -u cloud -p -h <region1_db_host> cloud account user domain > region1.sql
> mysql -u cloud -p -h <regionN_db_host> cloud < region1.sql  
> Project entries from existing regions's accounts DB should not be synced to the new region.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira