[MariaDB/WordPress connection issue probabbly] Wordpress can not connect to DB

[Kurt57]

Platform

AWS

bndiagnostic ID know more about bndiagnostic ID

57f644d4-4081-b7b1-0857-7c0137676e44

bndiagnostic output

===== Begin of bndiagnostic tool output =====

✓ Resources: No issues found
? Connectivity: Found possible issues
? Mariadb: Found possible issues
? Processes: Found possible issues
✓ Wordpress: No issues found
? Apache: Found possible issues
✓ Php: No issues found

[Connectivity]

Server ports 22, 80 and/or 443 are not publicly accessible. Please check the
following guide to open server ports for remote access:

https://docs.bitnami.com/general/faq/administration/use-firewall/

[Mariadb]

Press [Enter] to continue:
Found recent error messages in the MariaDB error log:

2024-08-22 8:16:18 0 [ERROR] Aborting

Please check the following guide to troubleshoot MariaDB issues:

https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-m
ariadb/

[Processes]

One or more component's processes are not running:

mariadb not running

You can try to restart the process with the following command:

$ sudo /opt/bitnami/ctlscript.sh start COMPONENT_NAME

[Apache]

Found recent error or warning messages in the Apache error log.
Press [Enter] to continue:

[Thu Aug 22 08:24:12.642206 2024] [proxy_fcgi:error] [pid 2054:tid 
140505845307136] [client **ip_address**:54770] AH01071: Got error 'PHP message: 
PHP Warning: mysqli_real_connect(): (HY000/2002): Connection refused in 
/opt/bitnami/wordpress/wp-includes/class-wpdb.php on line 1982'
 [Thu Aug 22 08:24:12.949306 2024] [proxy_fcgi:error] [pid 864:tid 
140505895663360] [client **ip_address**:54780] AH01071: Got error 'PHP message: 
PHP Warning: mysqli_real_connect(): (HY000/2002): Connection refused in 
/opt/bitnami/wordpress/wp-includes/class-wpdb.php on line 1982'
 [Thu Aug 22 08:24:13.250900 2024] [proxy_fcgi:error] [pid 2054:tid 
140505811736320] [client **ip_address**:54794] AH01071: Got error 'PHP message: 
PHP Warning: mysqli_real_connect(): (HY000/2002): Connection refused in 
/opt/bitnami/wordpress/wp-includes/class-wpdb.php on line 1982'

Please check the following guide to troubleshoot server issues:

https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-erro
rs-apache/

A high number of incoming requests originate from one or more unique IP
addresses. This could indicate a bot attack. The following guide shows how to
check for and block suspicious IP addresses.
Press [Enter] to continue:

https://docs.bitnami.com/bch/apps/moodle/troubleshooting/deny-connections-
bots-apache/

===== End of bndiagnostic tool output =====

bndiagnostic was not useful. Could you please tell us why?

it was successful

Describe your issue as much as you can

i am getting this issue while try to open my Wordpress website

Warning: mysqli_real_connect(): (HY000/2002): Connection refused in /opt/bitnami/wordpress/wp-includes/class-wpdb.php on line 1982
Connection refused

Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or that contact with the database server at 127.0.0.1:3306 could not be established. This could mean your host’s database server is down.

Are you sure you have the correct username and password?
Are you sure you have typed the correct hostname?
Are you sure the database server is running?
If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.

[gongomgra]

Hi @Kurt57,

Thanks for using Bitnami. I have checked your bndiagnostic data and I have found a couple of errors. First, the MariaDB database is not running due to the next error:

2024-08-22  8:16:18 0 [ERROR] mariadbd: Can't create/write to file '/tmp/mysql-init' (Errcode: 2 "No such file or directory")
2024-08-22  8:16:18 0 [ERROR] Aborting

It is so weird you can not write into the /tmp folder. Can you run the command below and try to start MariaDB again?

sudo chown 777 /tmp

The other error I have found is that MariaDB is not monitored by Gonit. Did you update anything in its configuration? Apart from this, it looks like there are a few IP addresses performing a lot of requests to your website. We recommend you to check our guide about bots and how to block them in case it is necessary

https://docs.bitnami.com/virtual-machine/apps/wordpress/troubleshooting/deny-connections-bots-apache/

[Bruce96389]

The error you're encountering indicates that your WordPress site is unable to connect to the MariaDB database. The Bitnami diagnostic tool output points to several potential issues, including MariaDB not running and connectivity problems. Here's how you can troubleshoot this:

Steps to Fix the Issue:
Check if MariaDB is Running:

First, verify if MariaDB is running. You can do this by SSHing into your server and running the following command:
bash
Copy code
sudo /opt/bitnami/ctlscript.sh status
If MariaDB is not running, try starting it with:
bash
Copy code
sudo /opt/bitnami/ctlscript.sh start mariadb
If the database still doesn't start, check the MariaDB logs for more details:
bash
Copy code
sudo tail -n 100 /opt/bitnami/mariadb/logs/mysqld.log
Check Database Credentials:

Ensure that the database credentials in the wp-config.php file are correct. You can access the file by running:
bash
Copy code
sudo nano /opt/bitnami/wordpress/wp-config.php
Verify the database name, username, password, and hostname (usually localhost or 127.0.0.1):
php
Copy code
define('DB_NAME', 'your_database_name');
define('DB_USER', 'your_database_user');
define('DB_PASSWORD', 'your_database_password');
define('DB_HOST', '127.0.0.1:3306');
Check Server Ports:

The diagnostic tool indicated that ports 22, 80, or 443 might not be accessible. This can affect your site's connectivity. Ensure that the ports are open:
SSH into your server and run:
bash
Copy code
sudo ufw allow 22
sudo ufw allow 80
sudo ufw allow 443
sudo ufw enable
Check Apache Logs:

The Apache error log contains warnings related to database connections. To diagnose further, review the Apache logs:
bash
Copy code
sudo tail -n 100 /opt/bitnami/apache2/logs/error_log
Check for Bot Attacks:

If you notice a high number of incoming requests, it might indicate a bot attack. You can block suspicious IPs using the .htaccess file or through the server firewall.
Restart the Services:

After making these changes, restart the services to see if it resolves the issue:
bash
Copy code
sudo /opt/bitnami/ctlscript.sh restart
YourTexasBenefits com
If the issue persists after trying these steps, please provide any additional error logs, and I'll help further troubleshoot.

[github-actions]

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

[github-actions]

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.