[ 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