Skip to main content
Nintex Community Menu Bar
Question

Not Able to Connect to MySQL

  • July 11, 2024
  • 5 replies
  • 4 views
  • Translate

Forum|alt.badge.img+3

I’m trying to use the new MySQL connector but am struggling to get it to work. 

For the URL endpoint I put 173.236.29.190:3306, then the database, user and password. I know the IP and port work as I have successfully connected to the database using Skyvia and that access. I have set up your IP addresses on the whitelist in the Remote mySQL application in cPanel. When I enter the information in the connector and press on the “Test Connection” button, the system waits about 5 seconds then gives me no response, not “connection failed” or “connection succeeded” response.

When I press on Save Connection, the system grays the screen and gives a message that it is saving the connection, but then nothing happens. It stays gray forever. When I click on the back button, it warns that nothing is saved and I might lose my information … and sure enough, nothing is saved. 

I realize this connector is relatively new, but if you could build documentation for how to use connectors, it would be greatly appreciated. This has proven to be a significant trial-and-error (mostly error) exercise.

Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+13

Do you have SSL enabled on the Data Source?

Translate

Forum|alt.badge.img+3
  • Author
  • 18 replies
  • July 11, 2024

Yes … but do I need to put the https:// in the connector string?

Translate

Forum|alt.badge.img+13

No, your connector string should just be “HOST:PORT” e.g.

123.45.67.89:3306
mysqldemo.myserver.com:3306

Translate

Forum|alt.badge.img+3
  • Author
  • 18 replies
  • July 11, 2024

That’s what it says: 173.236.29.190:3306. I tried it again yesterday and got the same results. When I test the connection, it runs for about 30 seconds and then gives me back the screen but I don’t see any test results showing up anywhere and then when I SAVE the connection, it greys the screen indefinitely. I can hit the back button at any time but then get the warning message that doing so will lose unsaved information. Thoughts? I need this to work to use Skuid as almost all my outside data is in mySQL.

Translate

Forum|alt.badge.img+13

John, I sent you an email - let’s follow-up offline to see if we can figure this out. 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings