'Permission denied' connecting from instance to database

0

I cannot connect from my Lightsail instances to the Lightsail database, always 'permission denied'.
I can connect to the same database remotely with public mode enabled.

In my app I have the connection string defined as:

'db' =>
		[
			'dsn'         => 'mysql:dbname=dbmaster;host=endpoint;port=3306',
			'username'    => 'username',
			'password'    => 'password',
			'persistent'  => false,
			'log_queries' => false,
			'reconnect'   => false,
			'queries'     =>
			[
				'SET NAMES UTF8',
			],
		],

Edited by: Lester on Apr 7, 2020 6:05 PM
Preview looks fine, published version not same, special characters converted to html entity codes.

Lester
已提問 4 年前檢視次數 342 次
1 個回答
0

If anyone else encounters this, this was the reason:

"..By default, the httpd_can_network_connect_db Boolean is off, preventing Apache HTTP Server scripts and modules from connecting to database servers.."

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/selinux_users_and_administrators_guide/sect-security-enhanced_linux-working_with_selinux-booleans

setsebool -P httpd_can_network_connect_db on

Lester
已回答 4 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南