WSO2 6.6.0 Analytics - 如何更改为 MySQL
我的环境：Centos 7.9服务器，通过rpm安装：wso2ei-linux-installer-x64-6.6.0.rpm 我已按照以下说明将 Carbon 数据库更改为 MySQL：https://docs。 wso2.com/display/EI660/Changing+to+MySQL 它工作正常。
现在我也想将 Analytics Dashboard 和 Worker 更改为 MySQL。
我已更新 /usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/conf/dashboard/deployment.yaml 中的 jdbcUrl、driverClassName、用户名、密码 WSO2_DASHBOARD_DB 、 BUSINESS_RULES_DB 、 WSO2_STATUS_DASHBOARD_DB 、 WSO2_METRICS_DB 、 WSO2_PERMISSIONS_DB、EI_ANALYTICS 数据库。我已经在 MySQL 中创建了这些数据库并授予了权限。
当我尝试访问 https://10.3.14.4:9643/portal/ 时出现错误“访问问题：/portal/。原因：未找到”
我猜测 Analytics Dashboard 和 Worker 在服务启动时没有为 db 创建表，但我找不到 dbscripts初始化这些数据库。
我只能找到
/usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/wso2/dashboard/dbscripts/metrics/mysql.sql
/usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/wso2 /worker/dbscripts/metrics/mysql.sql
我不确定它的用途。
请给我一些建议，非常感谢。
My environment : Centos 7.9 server , installed via rpm : wso2ei-linux-installer-x64-6.6.0.rpm
I have changed the Carbon database to MySQL follow this intruction : https://docs.wso2.com/display/EI660/Changing+to+MySQL and it works fine.
Now I want to change Analytics Dashboard and Worker to MySQL too.
I have updated jdbcUrl, driverClassName, username, password in /usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/conf/dashboard/deployment.yaml for WSO2_DASHBOARD_DB , BUSINESS_RULES_DB , WSO2_STATUS_DASHBOARD_DB , WSO2_METRICS_DB , WSO2_PERMISSIONS_DB , EI_ANALYTICS databases . I created these databases in MySQL already and granted permission .
When I try to access https://10.3.14.4:9643/portal/ I get error "Problem accessing: /portal/. Reason: Not Found"
I guess that Analytics Dashboard and Worker didn't create tables for dbs when services starting but I cannot find dbscripts for initializing these dbs .
I can only find
/usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/wso2/dashboard/dbscripts/metrics/mysql.sql
/usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/wso2/worker/dbscripts/metrics/mysql.sql
And I'm not sure what is it for.
Please give me some advice thank you very much.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我通过将 java mysql 驱动程序添加到 /usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/lib 来修复它，现在我可以访问 https://10.3.14.4:9643/portal/
I fixed it by adding java mysql driver into /usr/lib64/wso2/wso2ei/6.6.0/wso2/analytics/lib , now I can access https://10.3.14.4:9643/portal/