Unable to connect to remote MySQL DB

[hsimran13]

Hello,

I am new to robinhood and trying to deploy a new instance to scan our EFS filesystems. I have it working correctly when using a local MariaDB database but when I try to use RDS the website is no longer able to connect to the remote DB instance:

Danger! PDO Database error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'xxx.us-east-1.rds.amazonaws.com' (13)

I see the following error in the httpd logs:

[Mon Jan 23 21:11:30.711653 2023] [:error] [pid 12154] [client 10.x.x.x:32790] PHP Fatal error:  Call to a member function prepare() on a non-object in /var/www/ses/api/robinhood.php on line 91, referer: http://rbhtest.xxx.xxx.xx/ses/

However, the cli scan works just fine and I can run reports against the remote DB instance without any issues. I am also able to use the mysql cli to connect to the remote database and have confirmed that all information is the same in the apache config.php. Is there anything else that needs to be done for the php files to support a remote DB for robinhood's web UI?

Any help would be greatly appreciated.

Thanks.