Cannot connect to RDS MySQL DB
-
Hello – I’ve been searching for information but I’ve not found a solution to this one.
I am standing up a wordpress instance in Amazon AWS. We have an RDS instance of MySQL 5.7 running and we configured Route53 with a friendly DNS name. We’ll call it blogtest-db.mydomain.com. Now, I have WordPress files copied to /var/www/html and I’m getting the ‘database connection details’ setup screen. I have added the wordpresstest user to MySQL with full privileges. When complete the setup using db name: wordpresstest, username: wordpresstest, using the correct password, database host: blogtest-db.mydomain.com. I get “Error establishing a database connection”. I’ve tried both with and without adding :3306 to the DB hostname. No dice.
However, if I ssh to the wordpress host IP I am able to use mysql to connect to the RDS instance using all of the above information.
I’m pulling my hair out here trying to figure this out. Any help is greatly appreciated. Thanks!
The page I need help with: [log in to see the link]
-
Additional content from my phpinfo. Sorry I forgot this on the last post and I can’t seem to edit it.
Apache Version Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.24 Apache API Version 20120211 Server Administrator root@localhost Hostname:Port ip-10-144-252-147.us-west-2.compute.internal:443 User/Group apache(48)/48 Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 60 - Keep-Alive: 5 Virtual Server Yes Server Root /etc/httpd Loaded Modules core mod_so http_core mod_access_compat mod_actions mod_alias mod_allowmethods mod_auth_basic mod_auth_digest mod_authn_anon mod_authn_core mod_authn_dbd mod_authn_dbm mod_authn_file mod_authn_socache mod_authz_core mod_authz_dbd mod_authz_dbm mod_authz_groupfile mod_authz_host mod_authz_owner mod_authz_user mod_autoindex mod_cache mod_cache_disk mod_data mod_dbd mod_deflate mod_dir mod_dumpio mod_echo mod_env mod_expires mod_ext_filter mod_filter mod_headers mod_include mod_info mod_log_config mod_logio mod_mime_magic mod_mime mod_negotiation mod_remoteip mod_reqtimeout mod_rewrite mod_setenvif mod_slotmem_plain mod_slotmem_shm mod_socache_dbm mod_socache_memcache mod_socache_shmcb mod_status mod_substitute mod_suexec mod_unique_id mod_unixd mod_userdir mod_version mod_vhost_alias mod_dav mod_dav_fs mod_dav_lock mod_lua prefork mod_proxy mod_lbmethod_bybusyness mod_lbmethod_byrequests mod_lbmethod_bytraffic mod_lbmethod_heartbeat mod_proxy_ajp mod_proxy_balancer mod_proxy_connect mod_proxy_express mod_proxy_fcgi mod_proxy_fdpass mod_proxy_ftp mod_proxy_http mod_proxy_scgi mod_proxy_wstunnel mod_ssl mod_systemd mod_cgi mod_php7I’ve resolved this issue. It was SELinux. It has to be enabled in our environment so we had to add a boolean. Alternatively if we didn’t need/want it enabled, simply disabling SELinux would’ve solved the issue as well –
FYI – The commands to enable/disable SELinux are below
enable:
setenforce 1
disable:
setenforce 0A good way to test is to simple turn it off and try to run the wordpress setup wizard. If you can connect finish the setup and re-enable SELinux. If SELinux is the culprit, you will get an error establishing database connection error when you re-enable it.
It’s probably important to note that SELinux provides important safety features and disabling it is kind of the lazy way to address the issue.
I found this article that helped.
https://techblog.jeppson.org/2016/10/install-wordpress-centos-7/and here is more information regarding SELinux and using booleans.
https://wiki.gentoo.org/wiki/SELinux/Tutorials/Using_SELinux_booleansI hope this saves someone some time one day.
- The topic ‘Cannot connect to RDS MySQL DB’ is closed to new replies.