I have a MySQL RDS DB Instance but now I cannot see it supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com

0

I had a MySQL RDS DB Instance but now I cannot see it supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com and I caanot access it.

I had some past due billing for 2 months but I have already paid right now, how much time this will take to be restored ? how to restore my MySQL Database. ?

posta 4 mesi fa195 visualizzazioni
1 Risposta
0

Hello.

Is the region opened in the management console correct?
Looking at the endpoint, it looks like it was created in the "us-west-1" region.
Do you have the "us-west-1" region open?
Also, check all regions and if RDS does not exist, it may have been deleted.
In that case, you will need to restore from the snapshot.
If there are no snapshots left, you cannot restore them.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html

profile picture
ESPERTO
con risposta 4 mesi fa
  • Hi @Riku, Thanks for yor response, answer this helps, I was able to restore the Databse from the snapshot but now I have a weird situation with my app

    When I run my app and the database locally from my computer all is working fine, the application connects, But when I run my app pointing to the AWS MYSQL Database host supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com an error occurs {"error":"unsupported_grant_type"}

    But the weird thing is that I can connect to the DB using Workbench.

    What could be the issue here ?

  • I feel like it's not a connection problem to RDS. Please check the application log etc. to see if a more detailed error is output.

  • Hi @Riku_Kobayashi Thanks

    this is the error when trying to connect

    This connection was immediately refused by the server. Most likely this is because the MySQL server does not allow remote connections to it

    Function Value mysqli_connect_errno() 2002 mysqli_connect_error() Connection refused mysqli_get_client_version() 50012

    How to allow remote connections from my Web App ?

    right now it only connects using MySQL Workbench but not the app.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande