CODEWITHSUNDEEP
azureazure-functions
Karan Desai
Karan Desai

Reputation: 3152

How to allow azure function to access database hosted on Azure VM?

We have time triggered Azure Function deployed on portal to perform some iterative task at specific time. Our azure function uses the database deployed on Azure VM via connection string provided at AppSettings. The function throws following error on running:

MySql.Data: Authentication to host 'xxx' for user 'xxx using method 'mysql_native_password' failed with message: Client with IP address 'x.x.x.x' is not allowed to connect to this MySQL server. MySql.Data: Client with IP address 'x.x.x.x' is not allowed to connect to this MySQL server*

When we white-list the IP mentioned in error message, the function runs successfully. But since the azure function has no determined work-station or PC of same IP that handles the execution, whenever the function runs from new IP, it throws the error back. Therefore, we require a mechanism by which we can white-list all IPs of PCs that will be running our function app OR some better mechanism to authenticate and allow azure function to access our database hosted on Azure VM.

What we tried?

Thus, is there any way by which azure function can access our database deployed on Virtual machine securely?

I have opened up the issue on github but no reply yet from there.

Upvotes: 3

Views: 4715

Answers (2)

June Lau
June Lau

Reputation: 191

You need to set up a Virtual Network (VNet) where both your App Service Plan hosting the Azure Function and the VM participate.

Then from Azure Functions, view All Properties > Networking and you should see the virtual network to connect.

This method doesn't require you to whitelist IP addresses for your VM and secures your VM by allowing only internal network traffice.

Note that your Azure Function must be set up on an App Service Plan, rather than on a Consumption plan.

Upvotes: 1

Karan Desai
Karan Desai

Reputation: 3152

Finally, after thorough researching, found the solution.

One need to white-list all Outbound IPs of Function App in Virtual Machine where DB is deployed. The outbound IP address can be found from resources.azure.com. On searching your resource (in my case Function app's name), there will be a long json output from where you have to pick possibleOutboundIpAddresses parameter as shown in the image. Whitelist all Ips and then your azure function app can access your database deployed on virtual machine.

Also, I searched whether these IPs tend to change on regular basis or not. While I didn't find any official word from it, but from various internet sources I came to know that even if the IPs gets planned to be changed ever, everyone will get enough notifications before that to prevent any problems.

Image

Upvotes: 5

Related Questions