jdbc - 我试图在 wso2 中使用 MySQL 更改我的注册表数据库是 5.9.0 并按照步骤操作，但它没有反射(reflect)在控制台中？

Question

我遵循以下文档-
https://is.docs.wso2.com/en/5.9.0/setup/changing-to-mysql/

我还尝试过仅针对上述用例更改 LDAP 用户存储是否需要执行 AND 哪个最适合使用 MySQL 的用户存储 LDAP 或 JDBC
https://is.docs.wso2.com/en/5.9.0/setup/configuring-a-jdbc-user-store/

这是我的 deployment.toml 文件配置-

[server]
hostname = "localhost"
node_ip = "127.0.0.1"
base_path = "https://$ref{server.hostname}:${carbon.management.port}"

[super_admin]
username = "admin"
password = "admin"
create_admin_account = true

[user_store]
type = "database"
TenantManager="org.wso2.carbon.user.core.tenant.JDBCTenantManager"
ReadOnly=false
ReadGroups=true
WriteGroups=true

[database.user]
url = "jdbc:mysql://localhost:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"
driver = "com.mysql.jdbc.Driver"

[realm_manager]
data_source = "WSO2USER_DB"

[database.carbon_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"

[database.identity_db]

type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"

[database.shared_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"

[keystore.primary]
name = "wso2carbon.jks"
password = "wso2carbon"

并且更改没有反射(reflect)在 WSO2 控制台中，它仍然显示 H2 数据库-

Answer 1

Wso2 Identity 5.9.0 separates its databases into 3 parts as IDENTITY_DB, CARBON_DB, SHARED_DB. You can read about what they handle in 

https://is.docs.wso2.com/en/5.9.0/setup/changing-to-mysql/ this documentation. 

From the above 3 databases, CARBON_DB cannot be pointed to another database type other than H2. CARBON_DB contains internal information and you will not have a requirement to change its database source. 

因此，将以下配置添加到 deployment.toml 是无用的。

[database.carbon_db]
type = "mysql"
url= "jdbc:mysql://127.0.0.1:3306/regdb?useSSL=false"
username = "regadmin"
password = "regadmin"

在管理控制台中，它按预期显示位于 H2 中的 CARBON_DB 位置。建议在生产环境中将嵌入式 LDAP 用户存储更改为其他内容。您可以在此处将其指向 JDBC、LDAP 或 Active Directory 用户存储。