By using AWS re:Post, you agree to the Terms of Use

'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.

asked 2 years ago46 views
1 Answer
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

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions