Skip to main content
Nintex Community Menu Bar
Question

Issues Connecting to MySQL


Forum|alt.badge.img+13

Hi,

Trying in Sandbox for the first time to add a New Data Source for MySQL hosted on google, and for some unknown reason, it does not want to work.

I’m able to connect with same credentials Using MySQL Workbench but in Skuid I get an error:

Here are the steps I did:

Added a new CSP Trusted Site with URL: https://gateway-us.skuid.net

Created a new Data Source

Type: MySQL / MariaDB

Entered the credentials in all 5 fields

and get the following error:



Anyone have any idea on why, and  how I can make this work?

tested on sandbox Skuid version: 12.2.2 (latest)

Thx


Translate
This topic has been closed for comments

Forum|alt.badge.img+13
  • Scholar
  • July 11, 2024

Bumped by Error 😉

Translate

Forum|alt.badge.img
  • July 11, 2024

I am also having the same issue. Can anyone help me with this.

Translate

Forum|alt.badge.img+8

Hi Dave, what IP addresses have you allowed to access your MySQL database in the Google setup?

Translate

Forum|alt.badge.img+8

The following IP addresses need to be whitelisted.

  • 34.212.42.49
  • 35.164.193.200
  • 50.112.34.48
Translate

Forum|alt.badge.img+13
  • Scholar
  • July 11, 2024

Hi Ben,

Sorry I was out of the office yesterday.

All IP addresses have been whitelisted from the beginning, so I don’t think that is the issue.

And it cases it helps, when I try to set up the new data source, it does not provide me with the list of IP to whitelist (saw that it’s supposed to do that on Youtube skuid vids and documentation) and directly fails when I try to connect

If you want I can email you the credentials to the SOQL DB hosted on google, as there is only test data in there for now.

Let me know please

Thx




Translate

Forum|alt.badge.img+8

Hi Dave, if you want to send the credentials to ben@skuid.com I can see if I can connect.

Translate

Forum|alt.badge.img+13
  • Scholar
  • July 11, 2024

just sent, thank you for your help!

Translate

Forum|alt.badge.img+8

Ok after investigating some more, I think I may know what the issue is. It looks like you may have alerted us to a missing section in our documentation. I alerted the docs team and they hope to have something out explaining this in detail in the next few weeks.

In the mean time, you can follow these steps…

  1. Go to Configure -> Data Sources -> Data Services
  2. Click the “Modify JWT Signing Certificate” Button
  3. There are some instructions in that popup that you can follow, but I’ll add some detail as well.
  4. Go do your Certificate Management screen in Salesforce Setup.
  5. Create a new Self-signed certificate, you can call it whatever you want, but SkuidJWTCert is a good name.
  6. Download that certificate to your computer.
  7. Back in the popup (you may need to refresh to see your newly created certificate listed), select the cert you created, and paste the entire contents of the file you downloaded into the text box.
  8. After saving, try creating your MySQL data source again.
Translate

Forum|alt.badge.img+13
  • Scholar
  • July 11, 2024

Worked like a charm, thank you for your help to both Ben 🙂

Good to know I was not crazy 😃

Now that i can connect , will try to understand how to use the data, but should be fairly simple hopefully! 

Thx

Translate

Forum|alt.badge.img

I also encountered with same problem. As I search for the problem there are many suggestions but not worked any of it. It Will  be helpful if anyone answer me…

Translate

Forum|alt.badge.img+13
  • Scholar
  • July 11, 2024

Hi Stella did you try the solution above from Ben Hubbard?

Once I followed his instructions it worked fine 

As well make sure you Add a new CSP Trusted Site in SF with URL: https://gateway-us.skuid.net

And that your SQL database white list the IP above or allow all IP’s to connect.

Translate

Forum|alt.badge.img+13
  • Scholar
  • July 11, 2024

Hi Guys,

Everything was working fine(we changed the DB, to PostgreSQL and use SSL and all was working fine) , but now we refreshed our sandbox and tried to connect and no longer works, as well other sandbox I had with active connection no longer works..

Now we get this error when we try new connection and previous one that was working.

Error making proxy request to data source,

in Dev Console it does not not show more than this

Anyone has any ideas please…

Thank you!

Translate

Arne-Per
Forum|alt.badge.img+8
  • Rookie
  • July 11, 2024

did you ever figure this out? Thanks

Translate

Forum|alt.badge.img+13
  • Scholar
  • July 11, 2024

Hey Arne, yes We have moved to PostgreSQL which was a better fit for us, but at this point have been using it for 5 months+ and it’s behaving properly mostly. If you have a specific issue/question let me know, maybe i can assist

Translate

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