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.
Any ideas?
Brad
Best 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!2
Answers
-
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.
0 -
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!2 -
Yes, this took care of the issue. Thanks for the advice on enabling SSL.
Brad
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive