WordPress site - error establishing database connection

Question

WordPress site - error establishing database connection

Milica Sebić 0

hello, i have a question. about a year ago i hosted a WordPress site on azure, i have azure for students starter plan. for a year it worked like a charm and suddenly i have error establishing a database connection even tho nobody touched anything. credentials are correct. i enabled debugging and got:

mysqli_real_connect(): (HY000/2002): An attempt was made to access a socket in a way forbidden by its access permissions. in C:\home\site\wwwroot\wp-includes\class-wpdb.php on line 2019

but on that line i see just code for connecting to database.

that site is very important to me and now i cannot access or repair it. is there a way for my site to get live again?

Konstantinos Passadis 19,586 Reputation points MVP

2023-06-15T20:58:27.54+00:00

Hello @Millica SebWelcome to Microsoft QnA!

I understand you are facing a MySql connection issue

I think your case falls under ths category

https://learn.microsoft.com/en-us/azure/mysql/single-server/concepts-certificate-rotation

Azure Database for MySQL single server as part of standard maintenance and security best practices will complete the root certificate change starting October 2022. This article gives you more details about the changes, the resources affected, and the steps needed to ensure that your application maintains connectivity to your database server.

Note

This article applies to Azure Database for MySQL - Single Server ONLY. For Azure Database for MySQL - Flexible Server, the certificate needed to communicate over SSL is DigiCert Global Root CA

This article contains references to the term slave, a term that Microsoft no longer uses. When the term is removed from the software, we'll remove it from this article.

Why is a root certificate update required?

Azure Database for MySQL users can only use the predefined certificate to connect to their MySQL server, which is located here. However, Certificate Authority (CA) Browser forum recently published reports of multiple certificates issued by CA vendors to be non-compliant.

Per the industry's compliance requirements, CA vendors began revoking CA certificates for non-compliant CAs, requiring servers to use certificates issued by compliant CAs, and signed by CA certificates from those compliant CAs. Since Azure Database for MySQL used one of these non-compliant certificates, we needed to rotate the certificate to the compliant version to minimize the potential threat to your MySQL servers.

Do I need to make any changes on my client to maintain connectivity?

If you followed steps mentioned under Create a combined CA certificate below, you can continue to connect as long as BaltimoreCyberTrustRoot certificate is not removed from the combined CA certificate. To maintain connectivity, we recommend that you retain the BaltimoreCyberTrustRoot in your combined CA certificate until further notice.

Please verify your Server Connection and whether your Root CA Cert is valid and rotated!

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards
Milica Sebić 0 Reputation points

2023-06-15T22:19:29.5266667+00:00

@Konstantinos Passadis hi, thanks for your answer. i think this is not a case because i haven't configured SSL through Azure Dashboard, I used plugins for WordPress. even if it was the case, i don't see any connections with database. my site was working 10 days ago, so this certainly isn't a problem. around this time in year 2022 i've created site. maybe that timing has something to do with my problem?
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-06-19T06:13:39.1466667+00:00

@Milica Sebić Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

Could you please enable the WordPress error logs by following this blog post and also refer to this troubleshooting guide for troubleshooting common database connection errors in WordPress.

If the issue still persists, please do help us with last four digits of your subscription Id, WebApp Name and Issue time stamp (utc) to check and assist you further on this.
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-06-21T03:10:44.85+00:00

Hello @Milica Sebić ,

Following up to see if you have a chance to check my previous response and helped. Do let us know if you have any further questions on this.

Your answer

Milica Sebić 0 Reputation points

2023-06-15T22:19:29.5266667+00:00

@Konstantinos Passadis hi, thanks for your answer. i think this is not a case because i haven't configured SSL through Azure Dashboard, I used plugins for WordPress. even if it was the case, i don't see any connections with database. my site was working 10 days ago, so this certainly isn't a problem. around this time in year 2022 i've created site. maybe that timing has something to do with my problem?
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-06-19T06:13:39.1466667+00:00

@Milica Sebić Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

Could you please enable the WordPress error logs by following this blog post and also refer to this troubleshooting guide for troubleshooting common database connection errors in WordPress.

If the issue still persists, please do help us with last four digits of your subscription Id, WebApp Name and Issue time stamp (utc) to check and assist you further on this.
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-06-21T03:10:44.85+00:00

Hello @Milica Sebić ,

Following up to see if you have a chance to check my previous response and helped. Do let us know if you have any further questions on this.

Share via

WordPress site - error establishing database connection

Your answer