When looking at the web server logs, the following error is repeated multiple times:*** Error Establishing a Database ConnectionWhich of the following may be causes of the connectivity problems?
(Choose two.)
The security group for the database does not have the appropriate egress rule from the database to the web server.
The certificate used by the web server is not trusted by the RDS instance.
The security group for the database does not have the appropriate ingress rule from the web server to the database.
The port used by the application developer does not match the port specified in the RDS configuration.
The database is still being created and is not available for connectivity.
Explanations:
The security group controls inbound (ingress) and outbound (egress) traffic, but the error suggests a connection issue from the web server to the database, so this is not relevant in this case.
The certificate issue would typically affect SSL/TLS connections, but the error does not indicate any SSL-related problem, and Amazon RDS does not require certificates for standard database connections.
The database’s security group must allow inbound traffic from the web server. If the ingress rule is not properly configured, the connection will be blocked, leading to errors such as “Error Establishing a Database Connection.”
If the application is trying to connect to the wrong port, the connection will fail. The port specified in the application’s configuration must match the port the RDS instance is using.
If the database were still being created, it would not allow any connections at all, but the error message indicates the connection is being attempted, implying the database is available or partially available.
I categorize that the answer is:
The security group for the database does not have the appropriate ingress rule from the web server to the database.