[Dev] [IS] Foreign key references from Identity tables to User Manager tables
Hi IS team, We have encountered the following issue when running the identity mysql script before the user manager tables. ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.IDN_ASSOCIATED_ID' (errno: 150) ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.UM_USER_ACCOUNT_ASSOCIATIONS' (errno: 150) This is because there is a foreign key dependency to UM_DOMAIN table in user manager tables from the above tables. Therefore both the identity tables and user manager tables should be in a single database. With that how can we setup a cluster with the database seperation? Appreciate your help. Thanks, Tanya -- Tanya Madurapperuma Senior Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [IS] Foreign key references from Identity tables to User Manager tables
This script need to be fixed and it will be included in in carbon-identity-4.5.1. Thanks. Regards, Prasad. On Tue, Jun 9, 2015 at 3:25 PM, Tanya Madurapperuma ta...@wso2.com wrote: Hi IS team, We have encountered the following issue when running the identity mysql script before the user manager tables. ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.IDN_ASSOCIATED_ID' (errno: 150) ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.UM_USER_ACCOUNT_ASSOCIATIONS' (errno: 150) This is because there is a foreign key dependency to UM_DOMAIN table in user manager tables from the above tables. Therefore both the identity tables and user manager tables should be in a single database. With that how can we setup a cluster with the database seperation? Appreciate your help. Thanks, Tanya -- Tanya Madurapperuma Senior Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com -- Prasad Tissera Software Engineer. Mobile : +94777223444 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [IS] Foreign key references from Identity tables to User Manager tables
Hi Tanya, We already have a public jira [1] for this. [1] - https://wso2.org/jira/browse/IDENTITY-3335 Thanks, Thanuja On Tue, Jun 9, 2015 at 3:25 PM, Tanya Madurapperuma ta...@wso2.com wrote: Hi IS team, We have encountered the following issue when running the identity mysql script before the user manager tables. ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.IDN_ASSOCIATED_ID' (errno: 150) ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.UM_USER_ACCOUNT_ASSOCIATIONS' (errno: 150) This is because there is a foreign key dependency to UM_DOMAIN table in user manager tables from the above tables. Therefore both the identity tables and user manager tables should be in a single database. With that how can we setup a cluster with the database seperation? Appreciate your help. Thanks, Tanya -- Tanya Madurapperuma Senior Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com -- *Thanuja Lakmal* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94715979891 +94758009992 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [IS] Foreign key references from Identity tables to User Manager tables
Thanks Prasad and Thanuja ! Appreciate if you could fix this at the earliest since we need this for the ES release. Thanks, Tanya On Tue, Jun 9, 2015 at 3:36 PM, Thanuja Jayasinghe than...@wso2.com wrote: Hi Tanya, We already have a public jira [1] for this. [1] - https://wso2.org/jira/browse/IDENTITY-3335 Thanks, Thanuja On Tue, Jun 9, 2015 at 3:25 PM, Tanya Madurapperuma ta...@wso2.com wrote: Hi IS team, We have encountered the following issue when running the identity mysql script before the user manager tables. ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.IDN_ASSOCIATED_ID' (errno: 150) ERROR 1005 (HY000): Can't create table 'WSO2CARBON_DB.UM_USER_ACCOUNT_ASSOCIATIONS' (errno: 150) This is because there is a foreign key dependency to UM_DOMAIN table in user manager tables from the above tables. Therefore both the identity tables and user manager tables should be in a single database. With that how can we setup a cluster with the database seperation? Appreciate your help. Thanks, Tanya -- Tanya Madurapperuma Senior Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com -- *Thanuja Lakmal* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94715979891 +94758009992 -- Tanya Madurapperuma Senior Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev