Notes:
but I failed to test my connection. It always display "Connection String test failed: Unable to connect to any of the specified MySQL hosts.".Connection string: user Uid=abod6155_ukgsadmin; Pwd=<hidden>; server=****.xyz; port=3306; database=abod6155_ukgs.
Is it really true that I must convert to enterprise not personal to use this feature? thank you.
Hi @Andrew Osmond ,
You can have a look at this post.
It's not clear why connection to MySQL have some issues. But if you use the Advanced Configuration using this format in the connection string (including the username and password), then you should be able to make it work:
Server=SERVER; Port=PORT; Database=DB; Uid=USERNAME; Pwd=PASSWORD
Also, you do not need to upgrade your environment to enterprise. We connected to the server using our personal environment and it works.
Regards,
Bryan
Thank you. Is it true that the withlist is our environmental platform which is: ****.outsystemscloud.com?
There is no whitelisting applied to our OutSystems Cloud even in personal environments. Though probably it will block those suspicious sites.
However, you can implement whitelisting on your MySQL environment server so it only allows your OutSystems environment to connect, for additional security.
Just wanted to ask, did that connection string worked on your end?
First of all you need to find out the public facing IP address of your environment and that IP needs to be whitelisted on the MySQL end.
Here is the step by step procedure to find the public facing IP address of your environment
@Andrew Osmond Confirm that the OutSystems environment is using a compatible version of the MySQL connector.