MYSQL connection says it's "Throwing Errors"

[graphicgato]

I have connected with the same credential I use to log into PHPMYADMIN and I am getting the “Throws an error, reconnect or refresh the page”.

Please tell me what I am doing wrong.

[kishanprmr]

Can you reconnect your connection and try it again?

[graphicgato]

I did. I reconnected several times and still got the error.

[graphicgato]

I just deleted the connection and added it again. This time from the connections section. It says it’s active. I’m still getting the same error.

[Yazan]

I’m having same error, are there any updates on your end?

I have tried to add the IP’s mentioned in this article and same error keeps coming up.

Yet another topic about static IP-addresses

This has been requested many times before, but since topics are closed very fast I had to open yet another topic about this issue. For reference: MySQL IP adress (#62) Activepieces IP address list (#239) IP Address question (#2880) IP address of activepieces (#3043) Internal systems like databases and API’s commonly use an IP-whitelist for security. Other services often provide a list of static IP-addresses to whitelist, for example Google for connecting Apps Script to a JDBC database. …

[Yazan]

Hey - I kinda found a solution but I do not know how stable it is.

1. I have reconnected the db.
2. I have set the table field into dynamic value and manually entered the table name in my db.
3. I have kept testing the flow and looking at the error logs which will look something like the attached image.
4. I have white listed the static domain that AP is using, note to white list all of it
5. there will be a few static IP addresses upon testing, keep testing the flow until you have all of the static IP’s whitelisted.
6. Viola!

PS: I do not know how sustainable this is - Will have to ask the AP team if these static IP’s will change or are they any more that needs to be added!