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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 703 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive