wso2 / api-manager

All issues, tasks, improvements and new features of WSO2 API Manager
Apache License 2.0
34 stars 8 forks source link

wso2 api manager v.4.3.0 switching from h2 to mysql database #3337

Open JGMAGNO opened 2 weeks ago

JGMAGNO commented 2 weeks ago

Description

I successfully executed dbscripts for apim_db and shared_db, and configured my deployment.toml to point to the mysql database server,

[database.apim_db]
#type = "h2"
#url = "jdbc:h2:./repository/database/WSO2AM_DB;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE"
#username = "wso2carbon"
#password = "wso2carbon"
type = "mysql"
url = "jdbc:mysql://192.168.15.91:3306/apim_db"
username = "root"
password = "password"
driver="com.mysql.cj.jdbc.Driver"

[database.shared_db]
#type = "h2"
#url = "jdbc:h2:./repository/database/WSO2SHARED_DB;DB_CLOSE_ON_EXIT=FALSE"
#username = "wso2carbon"
#password = "wso2carbon"
type = "mysql"
url = "jdbc:mysql://192.168.15.91:3306/shared_db"
username = "root"
password = "password"
driver="com.mysql.cj.jdbc.Driver"

but I am encountering this error.

image

Steps to Reproduce

https://apim.docs.wso2.com/en/4.3.0/install-and-setup/setup/setting-up-databases/changing-default-databases/changing-to-mysql/

Affected Component

APIM

Version

4.3

Environment Details (with versions)

No response

Relevant Log Output

No response

Related Issues

No response

Suggested Labels

No response