cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ifarmsafe
Level: Powered On

On premise with mysql no host found

So I have

 

Windows 7

on premise gateway installed and working using https

Mysql server installed with user and database up and running

Mysql server connects with Workbench

Connecter/net installed and working

All required ports open

 

However when I try to create a new connection in MS Flow I get the error that there is no Mysql host found.

 

I know the gateway is connecting because I found that the latest Connecter/net version produces an error when trying to make a new connection. The forums say to install the previous version and that fixes it.

 

I cant see why the make a new connection is unable to see the Mysql server (or at least the mysql server user account and table).

 

Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: On premise with mysql no host found

 

Hi @ifarmsafe ,

 

It appears that you have found a solution to your issue!

If so, please click "Accept as Solution" on the reply that describes how you were able to solve your issue!

This makes your post much easier for other members of the community to see and find when looking for a solution! 

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Super User
Super User

Re: On premise with mysql no host found

Do you have a Flow 1 or Flow 2 Premium account plan? If so, then I'd recommend the MySQL (Preview) connector. Please note that the MySQL connector requires a premium account for both Flow and PowerApps but it greatly improves and simplifies the connection process for MySQL.

This is probably a routing or port issue, as the vast majority of issues with the gateway are. Please review the Troubleshooting the On-premises data gateway documentation, and also review the Port requirements and the Firewall and proxy documentation and insure that your proxy or firewall allows access over those ports.

Also, please review both hardware and software firewalls, including the Windows Firewall on the server. Finally, the Tools for troubleshooting section covers collecting logs and Fiddler tracing. Windows Server's services and the data gateway use far more than just port 80 or port 443, and if you'll notice the data gateway port requirements are are quite lengthy:

*.servicebus.windows.net  5671-5672         Used for Advanced Message Queuing Protocol (AMQP).        
*.servicebus.windows.net  443, 9350-9354    Used by listeners on Service Bus Relay over TCP (requires 443 for access control token acquisition).

For most firewalls, port 80 and 443 are open because they are the HTTP/S ports, however the ports listed above would not be open by default. Also, MySQL defaults to Port 3306, so you'll want to make sure you have opened that (or whatever customer port(s) you set as well). 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Community Support Team
Community Support Team

Re: On premise with mysql no host found

 

Hi @ifarmsafe ,

 

Did installing the previous version of Gateway solve your current problem?

 

If not, could you provide any screenshots or related error messages for creating new connections?

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ifarmsafe
Level: Powered On

Re: On premise with mysql no host found

Thankyou so far for the replies. I will run Fiddler and see what is going on.

 

I also noticed that in the on-premise gateway if I click on connection test it fails but I do not get the option to download the log to see what has failed. There is no link generated next to the test fail message so no way to download the log.

 

I also have Https enabled in the gateway and I can see port 443 is open (as well as 3306). My router is allowing traffic in and out without any port restrictions.

ifarmsafe
Level: Powered On

Re: On premise with mysql no host found

To all,

 

So the Network Port Test decided to magically work and everything was successful through port 443 plus servers.

 

OK now onto the moment of amateurs - the MS Flow new connection Mysql parameters and "server". I have been putting in my IP thinking that is the server for it to point to. Light bulb moment this evening made me put in localhost:3306 and boom the Mysql connection is created.

 

So apologies to those who spent time assisting.

 

Now onto working on Flowing to Mysql tables.

Community Support Team
Community Support Team

Re: On premise with mysql no host found

 

Hi @ifarmsafe ,

 

It appears that you have found a solution to your issue!

If so, please click "Accept as Solution" on the reply that describes how you were able to solve your issue!

This makes your post much easier for other members of the community to see and find when looking for a solution! 

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 93 members 5,466 guests
Please welcome our newest community members: