I cannot connect to MySQL DB from react app service

Question

I cannot connect to MySQL DB from react app service

Roger 1

Hello,

I've created a MySQL db and deployed a react backend as an app service. However, the app service crashes when I try to access it. When I open the diagnostic tool, I get the following message:

I am able to connect to the DB from MySQL Workbench and access the DB. I'm using the same url and credentials for the web. Do you know what could be the problem?

Thanks!

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-24T14:29:44.333+00:00

Hi, @Roger Welcome to Microsoft Q&A, Thanks for posting your query.
Can you please tell me if you are using a single server or flexible?
For a normal app service, you will have a terminal where you can check if you can resolve the name and connect on port 3306 using, nslookup and telnet tools to identify. since the error message, you are getting in the log is unable to connect to the database.

Regards
Geetha
Roger 1 Reputation point

2022-05-25T09:06:22.183+00:00

Hi Geetha,

Thank you for your reply. I'm using flexible server.

I tested with the command line. nslookup could resolve the domain and with telnet, I got asked for the password. After that I got the following message:

"Got packets out of orderConnection closed by foreign host."

Thanks!

Roger
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-26T08:45:57.16+00:00

Hi @Roger Can you please tell me a little more about your use case and the steps you followed so we can better assist you.

Regards
Geetha
Roger 1 Reputation point

2022-05-26T09:36:40.997+00:00

Hi Geetha,

I created a flexible server from the azure portal. The configuration looks like this:

I added the firewall rules so I can connect remotely and in Server Parameters changed require_secure_transport to OFF due to a previous error. I am able to connect remotely using MySQL workbench.

Then I created a DB from the portal and ran a SQL script to create the structure and data using:
az mysql flexible-server execute -n <server-name> -u <username> -p "<password>" -d <database-name> --file-path "<file-path>"

From MySQL Workbench I can see that the file execution was correct.

The react backend is deployed in the app service. It was deployed from Visual Code with the following settings:

Thanks!
Roger
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-27T15:53:55.01+00:00

Hi @Roger For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket, else let us know so we can create a one-time-free support ticket for you to work closely on this matter.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-30T23:38:43.14+00:00

Hi, @Roger We haven't heard back from you. Just wanted to check if you are still facing the issue? did you get a chance to check my above reply?

Regards
Geetha

1 answer

Your answer

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-24T14:29:44.333+00:00

Hi, @Roger Welcome to Microsoft Q&A, Thanks for posting your query.
Can you please tell me if you are using a single server or flexible?
For a normal app service, you will have a terminal where you can check if you can resolve the name and connect on port 3306 using, nslookup and telnet tools to identify. since the error message, you are getting in the log is unable to connect to the database.

Regards
Geetha
Roger 1 Reputation point

2022-05-25T09:06:22.183+00:00

Hi Geetha,

Thank you for your reply. I'm using flexible server.

I tested with the command line. nslookup could resolve the domain and with telnet, I got asked for the password. After that I got the following message:

"Got packets out of orderConnection closed by foreign host."

Thanks!

Roger
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-26T08:45:57.16+00:00

Hi @Roger Can you please tell me a little more about your use case and the steps you followed so we can better assist you.

Regards
Geetha
Roger 1 Reputation point

2022-05-26T09:36:40.997+00:00

Hi Geetha,

I created a flexible server from the azure portal. The configuration looks like this:

I added the firewall rules so I can connect remotely and in Server Parameters changed require_secure_transport to OFF due to a previous error. I am able to connect remotely using MySQL workbench.

Then I created a DB from the portal and ran a SQL script to create the structure and data using:
az mysql flexible-server execute -n <server-name> -u <username> -p "<password>" -d <database-name> --file-path "<file-path>"

From MySQL Workbench I can see that the file execution was correct.

The react backend is deployed in the app service. It was deployed from Visual Code with the following settings:

Thanks!
Roger
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-27T15:53:55.01+00:00

Hi @Roger For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket, else let us know so we can create a one-time-free support ticket for you to work closely on this matter.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-30T23:38:43.14+00:00

Hi, @Roger We haven't heard back from you. Just wanted to check if you are still facing the issue? did you get a chance to check my above reply?

Regards
Geetha

Answer 1

Roger 1

Hello Geetha,

Yes, I think I manage to fix this issue. The url in the ORM config file was incorrect and this provoke the connection issues.

Thank you for your help!

Roger

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-05-31T10:12:57.073+00:00

Thanks, @Roger for confirming that your issue is now resolved.

Regards
Geetha

Share via

I cannot connect to MySQL DB from react app service

1 answer

Your answer