Azure Database connection issue for MySQL flexible server

Question

Azure Database connection issue for MySQL flexible server

virajpatil 1

Hello,

I have created Azure Database for MySQL flexible server and created one database in that.
Now I am not able to connect to this database with the help of workbench and with my Laravel website which is hosted on the Azure platform.

Can you guys please help me to fix this issue?

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-09T10:38:54.483+00:00

Hi, @virajpatil Welcome to the Microsoft Q&A forum, and thanks for reaching out.
Can you please share what is the error you are getting or a screenshot of the error? so I can better assist you.

Regards
Geetha
virajpatil 1 Reputation point

2022-06-09T10:59:08.393+00:00

Hello @geetha Thatipatri,

Thank you for your response.

In error log found this error: "php_network_getaddresses: getaddrinfo failed: No such host is known. " but as I have checked in overview and connection string it's giving me the same host name.

Please find attached a screenshot of the workbench connection error.
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-09T11:09:54.997+00:00

@virajpatil Are you using private access or public acces? please check this troubleshoot document and give it a try.

Regards
Geetha
virajpatil 1 Reputation point

2022-06-09T11:55:31.797+00:00

@GeethaThatipatri-MSFT

Using "Private access (VNet Integration)"
So do I need to add IP in this?
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-09T13:41:31.53+00:00

@virajpatil Since you are using Private access for private access it is the VNET NSG that decides the access I would recommend going through this document

Regards
Geetha
virajpatil 1 Reputation point

2022-06-10T11:08:57.913+00:00

Hello @GeethaThatipatri-MSFT

Really Thank you for your support and sharing the document I have gone through the documentation and checked with my setup of database but as er this I am able to connect only Azure VM. I am a bit confused here.

I have created a Database Flexi server for Database and I already have 2 other web servers one for my Laravel application and one for my WordPress application.

Now want to know if I can able to connect the database from the Flexi server with that web server Laravel application?

2 answers

Your answer

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-09T10:38:54.483+00:00

Hi, @virajpatil Welcome to the Microsoft Q&A forum, and thanks for reaching out.
Can you please share what is the error you are getting or a screenshot of the error? so I can better assist you.

Regards
Geetha
virajpatil 1 Reputation point

2022-06-09T10:59:08.393+00:00

Hello @geetha Thatipatri,

Thank you for your response.

In error log found this error: "php_network_getaddresses: getaddrinfo failed: No such host is known. " but as I have checked in overview and connection string it's giving me the same host name.

Please find attached a screenshot of the workbench connection error.
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-09T11:09:54.997+00:00

@virajpatil Are you using private access or public acces? please check this troubleshoot document and give it a try.

Regards
Geetha
virajpatil 1 Reputation point

2022-06-09T11:55:31.797+00:00

@GeethaThatipatri-MSFT

Using "Private access (VNet Integration)"
So do I need to add IP in this?
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-09T13:41:31.53+00:00

@virajpatil Since you are using Private access for private access it is the VNET NSG that decides the access I would recommend going through this document

Regards
Geetha
virajpatil 1 Reputation point

2022-06-10T11:08:57.913+00:00

Hello @GeethaThatipatri-MSFT

Really Thank you for your support and sharing the document I have gone through the documentation and checked with my setup of database but as er this I am able to connect only Azure VM. I am a bit confused here.

I have created a Database Flexi server for Database and I already have 2 other web servers one for my Laravel application and one for my WordPress application.

Now want to know if I can able to connect the database from the Flexi server with that web server Laravel application?

Answer 1

GeethaThatipatri-MSFT 29,587 Microsoft Employee Moderator

Hi, @virajpatil Thanks for providing additional information
• If you are able to connect with Azure VM but not with MySQL workbench, it could be a network configuration issue.
• A getaddrinfo failed in your app does point towards a mismatch with Hostname. The other possibility is that you have chosen private access connectivity and are connecting from outside the vnet without an express route or VPN
for more investigation if you have a support plan you may file a support ticket.

Regards
Geetha

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-15T14:59:56.203+00:00

Hi, @virajpatil We haven't heard back from you. Just checking back, could you please let us know if you need further help in this matter.

Regards
Geetha
virajpatil 1 Reputation point

2022-06-24T08:29:31.5+00:00

Hello @GeethaThatipatri-MSFT

Hope you are fine!

Sorry for the delay in response.
I have checked some documentation and tried as per them but that's not working for me.
that would be a great help if you could create a support ticket.

Thank you
virajpatil 1 Reputation point

2022-06-27T06:24:07.573+00:00

Hello @GeethaThatipatri-MSFT

Is there any chance to look into this issue?
Will you please create one time support ticket for this issue so we get this done?

It is on HIGH PRIORITY.

Thanks in advance
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-06-27T10:44:10.137+00:00

@virajpatil apologies for the delay in my response as I was on leave.
A support ticket needs to be created by you, I would recommend to if you have a support plan you may file a support ticket, or please let me know if you need any help on creating the support case.

Regards
Geetha
virajpatil 1 Reputation point

2022-06-27T10:54:09.907+00:00

Hello @GeethaThatipatri-MSFT

Thank you for your response.

No, I don't have a support plan and as you said one-time support ticket so can you please help me with that?

Thanks

Answer 2

Hi @virajpatil As per the support team please find the articles below and follow the same for setting up your environment to resolve your original issue.

Connect Azure Database for MySQL Flexible Server with private access connectivity method:
https://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet

Connect Azure Database for MySQL Flexible Server with private access connectivity method :
Enable integration with an Azure virtual network

Regards
Geetha

Share via

Azure Database connection issue for MySQL flexible server

2 answers

Your answer