WSO2 IdentityServer 5.11 和 WSO2 API Management 3.2.0 集成存在 DB 脚本问题 [英] WSO2 IdentityServer 5.11 and WSO2 API Management 3.2.0 integration have DB script issue
问题描述
按照以下网址https://apim.docs.wso2.com/en/latest/install-and-setup/setup/distributed-deployment/configuring-wso2-identity-server-as-a-key-manager/#step-4-configure-wso2-is-with-wso2-api-m当我尝试配置 WSO2 IS 5.11.0 和 WSO2 APIM 3.2.0 时，发现以下问题
Following the below URL https://apim.docs.wso2.com/en/latest/install-and-setup/setup/distributed-deployment/configuring-wso2-identity-server-as-a-key-manager/#step-4-configure-wso2-is-with-wso2-api-m When I am trying to configure WSO2 IS 5.11.0 and WSO2 APIM 3.2.0, found below issues
- 在删除 AUTO_INCREMENT 标记之前，表交替 sql 命令不起作用.sql命令是shared_db
ALTER TABLE REG_RESOURCE_COMMENT ADD COLUMN REG_RESOURCE_COMMENT_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE REG_RESOURCE_COMMENT ADD COLUMN REG_RESOURCE_COMMENT_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE REG_RESOURCE_PROPERTY ADD COLUMN REG_RESOURCE_PROPERTY_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE REG_RESOURCE_PROPERTY ADD COLUMN REG_RESOURCE_PROPERTY_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE REG_RESOURCE_RATING ADD COLUMN REG_RESOURCE_RATING_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE REG_RESOURCE_RATING ADD COLUMN REG_RESOURCE_RATING_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE REG_RESOURCE_TAG ADD COLUMN REG_RESOURCE_TAG_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE REG_RESOURCE_TAG ADD COLUMN REG_RESOURCE_TAG_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE UM_SHARED_USER_ROLE 添加列 UM_SHARED_USER_ROLE_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE UM_SHARED_USER_ROLE ADD COLUMN UM_SHARED_USER_ROLE_ID INTEGER NOT NULL AUTO_INCREMENT;
apim_db;ALTER TABLE IDN_OAUTH2_ACCESS_TOKEN_AUDIT 添加列 IDN_OAUTH2_ACCESS_TOKEN_AUDIT_ID INTEGER NOT NULL AUTO_INCREMENT;
apim_db; ALTER TABLE IDN_OAUTH2_ACCESS_TOKEN_AUDIT ADD COLUMN IDN_OAUTH2_ACCESS_TOKEN_AUDIT_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE IDN_OAUTH2_SCOPE_BINDING 添加列 IDN_OAUTH2_SCOPE_BINDING_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE IDN_OAUTH2_SCOPE_BINDING ADD COLUMN IDN_OAUTH2_SCOPE_BINDING_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE IDN_AUTH_USER_SESSION_MAPPING ADD COLUMN IDN_AUTH_USER_SESSION_MAPPING_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE IDN_AUTH_USER_SESSION_MAPPING ADD COLUMN IDN_AUTH_USER_SESSION_MAPPING_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE IDN_OAUTH2_CIBA_REQUEST_SCOPES 添加列 IDN_OAUTH2_CIBA_REQUEST_SCOPES_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE IDN_OAUTH2_CIBA_REQUEST_SCOPES ADD COLUMN IDN_OAUTH2_CIBA_REQUEST_SCOPES_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_SP_PURPOSE_PURPOSE_CAT_ASSC 添加列 CM_SP_PURPOSE_PURPOSE_CAT_ASSC_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_SP_PURPOSE_PURPOSE_CAT_ASSC ADD COLUMN CM_SP_PURPOSE_PURPOSE_CAT_ASSC_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_PURPOSE_PII_CAT_ASSOC 添加列 CM_PURPOSE_PII_CAT_ASSOC_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_PURPOSE_PII_CAT_ASSOC ADD COLUMN CM_PURPOSE_PII_CAT_ASSOC_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_SP_PURPOSE_PII_CAT_ASSOC 添加列 CM_SP_PURPOSE_PII_CAT_ASSOC_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_SP_PURPOSE_PII_CAT_ASSOC ADD COLUMN CM_SP_PURPOSE_PII_CAT_ASSOC_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_CONSENT_RECEIPT_PROPERTY 添加列 CM_CONSENT_RECEIPT_PROPERTY_ID INTEGER NOT NULL AUTO_INCREMENT;
ALTER TABLE CM_CONSENT_RECEIPT_PROPERTY ADD COLUMN CM_CONSENT_RECEIPT_PROPERTY_ID INTEGER NOT NULL AUTO_INCREMENT;
注意:这些 sql commnads 在删除 AUTO_INCREMENT 标记之前不起作用.请建议，是否可以从上面的 sql 命令中删除 AUTO_INCREMENT 标记?
N.B: These sql commnads are not working until removing AUTO_INCREMENT tag. Please suggest, is it ok to remove AUTO_INCREMENT tag from above sql commands?
- 启动 IS，我在日志中收到以下错误消息.[2021-01-19 16:08:07,649] [] 警告 {org.wso2.carbon.core.CarbonAxisConfigurator} - 无法从注册表加载传输.某些传输可能未初始化.org.wso2.carbon.registry.core.exceptions.RegistryException:无法放置资源 无法将属性添加到资源/_system/config/repository/transsports/http/listener.字段REG_VERSION"没有默认值在 org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.put(MountHandler.java:299)在 org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2505)
请建议，如何解决这个问题?
Please suggest, how to solve this issue?
推荐答案
查看产品兼容性页面 看起来产品 wso2am3.2.0 和 wso2is5.11.0 不是兼容.
Looking at the product compatibility page it looks like the products wso2am3.2.0 and wso2is5.11.0 are not compatible.
当您尝试配置环境时，wso2 文档似乎也不一致.
It also looks like wso2 documentation was inconsistent when you were trying configure your environment.
您可以尝试以另一种方式配置您的密钥管理器，请查看 文档页面
You can try configure your key manager in another way, look at that documentation page
这篇关于WSO2 IdentityServer 5.11 和 WSO2 API Management 3.2.0 集成存在 DB 脚本问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
