'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年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ