MySQL connector issues

I am on a 60 day trial.  I have MySQL (Aurora and straight-up MySQL) at Amazon RDS and an independent server, all of which I can access from my PC via MySQL Workbench.  All of the servers are set to be publicly accessible.  

 

I can't connect to any of them with Domo's MySQL connector this afternoon.

 

 

Failed to authenticate. Verify the credentials and try again. Could not establish a connection with the MySQL host; please check your settings and try again.
 
 

 

Any ideas?

Brad

Best Answer

  • Unknown
    Answer ✓

    Brad,

     

    It is possible to connect to a MySQL database in the AWS environment. Domo requires that any database connection to have SSL enabled so that would be step one. You would also want to make sure that the Domo IPs are whitelisted and bi-directional traffic is enabled on the database and port that you are attempting to connect to. The list if IP addresses can be found in the Domo Help center under "Whitelist".

    I am no longer with Domo, please reach out to another Domo lead for assistance. Thank you!

Answers

  • kshah008
    kshah008 Contributor

    Hi all,


    Can anybody help @PBSmith out?

    Thanks!

  • I ultimately gave up and was able to work this out through the Workbench tool.  I am curious, however, if others succeed connecting to MySQL at Amazon.

  • Unknown
    Answer ✓

    Brad,

     

    It is possible to connect to a MySQL database in the AWS environment. Domo requires that any database connection to have SSL enabled so that would be step one. You would also want to make sure that the Domo IPs are whitelisted and bi-directional traffic is enabled on the database and port that you are attempting to connect to. The list if IP addresses can be found in the Domo Help center under "Whitelist".

    I am no longer with Domo, please reach out to another Domo lead for assistance. Thank you!
  • kshah008
    kshah008 Contributor

    @PBSmith, did Archimedes' reply help you out?

  •  

    Yes, this took care of the issue.   Thanks for the advice on enabling SSL.

     

    Brad