Error establishing databse connection

alwaysbeseen 2019-02-06 10:16:54 UTC #1

Keywords: WordPress - AWS - Technical issue - Other
Description:
Hi,

I installed 2 instances roughly at the same time. They were working fine and then 24 > 48 hours later they are now not working and coming up with error database connection.

I have checked the connection credentials and all ok. I have done some digging and found one potential issue with swap files or something but I do not know how to fully resolve. It is lightsail instances.

Really need to get this resolved and functioning and also so it wont happen again. I am trying to run the bitnami support tool aswell but getting "Error: Error writing file /tmp/apache.permissions"

Thanks

gongomgra 2019-02-06 12:31:31 UTC #2

Hi @alwaysbeseen,

Could you please give us more information about your issue? How did you installed those WordPress instances? Did you use the same Bitnami WordPress installer twice or you first installed the Bitnami WordPress stack and then you installed another WordPress using the module installer?

Could you also give us more information about what you have found out regarding the swap files?

For the bnsupport tool, please try to run it with sudo. Also remember to paste here the outputted code so we can download the file and take a look into it.

Best regards,
Gonzalo

alwaysbeseen 2019-02-06 16:13:12 UTC #3

Hi,

Installed from Amazon Lightsail - Install Instances (Instance 1)
Instance 2 - Copied to new region & then new instance created from Snapshot of Instance 1
All confirmed working perfect and fine.
Rebooted instance
Reboot Database / mysql and confirmed all working
I did some digging and there appeared to a similar AWS issue here: https://stackoverflow.com/questions/7315382/error-establishing-a-database-connection-amazon-ec2-after-moving-my-wordpress

I am a bit of a loss.

gongomgra 2019-02-07 10:56:52 UTC #4

Hi @alwaysbeseen,

I think the StackOverflow thread you sent us didn't apply to your issue. Could you please check the status of the services on your instances by running the command below and send us the output?

sudo /opt/bitnami/ctlscript.sh status

Also, if the mysql service is running, try to manually connect to MySQL using the username and password configured for WordPress in the /opt/bitnami/apps/wordpress/htdocs/wp-config.php file under the DB_USER and DB_PASSWORD keys running the command below

mysql -u ${DB_USER} -p bitnami_wordpress

The command above will request you to type the DB_PASSWORD value. Also remember to substitute the ${DB_USER} placeholder with the value present in the wp-config.php file. Could you please let us know if you find any issue trying to connect to MySQL or if it worked?

Hope it helps,
Gonzalo

system 2019-02-21 10:57:02 UTC #5

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!