PHP Fatal error: Uncaught CDbException: CDbConnection failed to open the DB connection. in /opt/bitnami/apa che/htdocs/

ramses72 2020-12-28 04:44:10 UTC #1

Keywords: LAMP/MAMP/WAMP - AWS - Technical issue - Secure Connections (SSL/HTTPS)
bnsupport ID: edb1ce60-a484-4ff7-4a86-c78f770e8e01
Description:
Hello

I am trying to move my application from Godaddy hosting to AWS using AWS lightstail on a Linux/UNIX BITNAMI instance running on Apache server.

All the files and database have been migrated successfully to my new AWS instance and SSL certificate was successfully created using LetsEncrypt (CERTBOT) .

I am using AWS MySQL database (8.0.21) and was able to connect successfully to my DB with MySQL workbench but for some reason I am unable to access my site is unavailable. I get error : yoursite is currently unable to handle this request.
HTTP ERROR 500.

Looking at the error logs it looks like an issue with the Yii FrameworkPHP Fatal error: Uncaught CDbException: CDbConnection failed to open the DB connection. in /opt/bitnami/apache/htdocs/yiiframework/db/CDbConnection.php

I would appreciate your help !

Thanks!

Job for bitnami.service failed because the control process exited with error code. See "systemctl status bitnami.service

gongomgra 2020-12-28 10:51:38 UTC #2

Hi @ramses72,

Thanks for using Bitnami. According to that error message, I understand the Yii framework you are using may be having issues with MySQL 8. Can you check the version of the Yii framework you are using supports MySQL 8?

We also recommend you to ask for help in the official Yii forums, as they can help you to better debug your application and understand what is the issue you are facing

Hope it helps,
Gonzalo

ramses72 2020-12-28 19:08:05 UTC #3

Hi @gongomgra

I am using Yii Version 1.1.17

gongomgra 2020-12-29 10:12:15 UTC #4

Hi @ramses72,

According to the official release notes, Yii 1.1.17 was released back in 2016, which may be too old for supporting MySQL 8. We highly recommend you to create a new question in the Yii forums as I mentioned yesterday. I'm posting a link to the Yii release notes for future references

https://www.yiiframework.com/news/93/yii-1-1-17-is-released

ramses72 2020-12-29 13:54:58 UTC #5

Hi @gongomgra

Thanks for the updates I got a response from the Yii Framework forum below . I read the article but it was not helpful to me in my particular case , maybe you can make sense from it.
Please check below and let me know what you think
https://forum.yiiframework.com/t/yii-framework-compatibility-with-mysql-8/131248/2

Thank You !

gongomgra 2020-12-30 09:11:51 UTC #6

Hi @ramses72,

Thanks for the info. According to the user helping you there, your issue must be caused by some changes introduced in MySQL 8 releases. Unfortunately, we are not MySQL experts, so we highly recommend you to ask in the MySQL forums for help on how to check if that's the issue you are facing and how to enable that feature.

https://forums.mysql.com/

You can find the MySQL config file at /opt/bitnami/mysql/my.cnf, and restart the service with the next command

sudo /opt/bitnami/ctlscript.sh restart mysql

You can also find the official MySQL documentation about authentication plugins at https://dev.mysql.com/doc/refman/8.0/en/authentication-plugins.html

I also think it is a good idea to give the Yii latest version a try, just in case it works out of the box with MySQL 8 without the configuration changes to be required.

Hope it helps,
Gonzalo

system 2021-01-13 09:11:52 UTC #7

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!