Issue with Azure App Service while deploying Web Service (PHP with MySQL)

Question

Issue with Azure App Service while deploying Web Service (PHP with MySQL)

Error_401 86

I'm new to Azure App Service.

I want to run a WebPage, I'm using PHP and MySQL as backend. Everything is working fine for me when I'm running local but my task is to connect the database residing in a remote server. I have created a VM in Azure and installed XAMP, now I'm trying to connect the MySQL in that remote server with the Azure "MySQL in App" but every time I connect I get the error "MySQL in App import failed"

NOTE - I'm not using the root account - a proper account with a password has been configured in MySQL, also note that XAMP uses port 3306 for MySQL and that is opened in the networking part of that VM so there is no issue in VM.

Please let me know if you need more information. I need a solution ASAP,

Thanks

Answer 1

Ryan Hill 16,076 Microsoft Employee

Hi @Error_401 ,

It sounds like your mixing IaaS, the deployed VM, with PaaS, Azure App Service. MySQL InApp; which you can read more about here, is an offering meant for quickly testing/troubleshooting your application before moving to production workloads. Since MySQL In-App is scaled down local database, connecting to it is done in the app service through various dynamically created application settings; it doesn't use 3306.

I can't speak on XAMPP, but you can follow https://learn.microsoft.com/en-us/azure/app-service/tutorial-php-mysql-app?pivots=platform-linux tutorial on creating a PHP app backed by MySQL Azure instance. You can leverage the MySQL In-App to perform all your testing and then export the schema to a MySQL Azure instance.

Regards,
Ryan

Error_401 86 Reputation points

2021-04-15T07:40:37.033+00:00

Hi, then I have a question.
I'm basically trying to make a DMZ architecture where the front-end will be in the DMZ and the backend MySQL database will be in a private network.
'
How do I achieve this in Azure App-Service

Thanks
Error_401 86 Reputation points

2021-04-15T07:47:33.6+00:00

Hi
I'm basically very new to Azure.
I think I have to create Azure MySQL database and somehow connect Azure App-Service with Azure MySQL database

Correct me if I'm wrong.
Ryan Hill 16,076 Reputation points Microsoft Employee

2021-04-15T14:12:03.917+00:00

You are correct. The tutorial I linked above walks you through creating the database and configuring to connect your application to it. Instead adding 0.0.0.0 for begin and end IP address in this step, you can either skip this step or add your client IP address so you can configure your database schema from your machine. You can also add the outbound IP address of app service. This will ensure your database server only accepts traffic from your client machine and app.
Error_401 86 Reputation points

2021-04-15T16:36:08.943+00:00

Thank You @Ryan Hill for guiding me.
I finally made the architecture and it is working fine for me.

Can you help me with building SQL Clusters on the same architecture using MySQL in Azure.

This is what I made -
I defined an Azure database for MySQL, which I'm managing from MySQL Workbench
Azure App Service - Where I uploaded my PHP and HTML files, I'm managing the connection string from Diagnostics Console in KUDU, I actually configured the SQL_Connection String there and updated all the PHP files there with the connection.
I configured the firewall setting where Azure database for MySQL is accessible only by the Azure App Service and (Workbench console server only when required otherwise I have closed the connection)

Thanks
Ryan Hill 16,076 Reputation points Microsoft Employee

2021-04-15T17:22:27.667+00:00

Just to confirm @Error_401 , are you referring to https://www.mysql.com/products/cluster/faq.html#:~:text=MySQL%20Cluster%20Database%20FAQ%20-%20General%20%20,%201%2B%20nodes%20%28Gigabit%20Ethernet%20-%20TCP%2FIP%29%20?
Error_401 86 Reputation points

2021-04-20T04:43:36.723+00:00

Hi,
Apologies for the delayed response. I want to design a MySQL Cluster on Microsoft Azure, on the same architecture.
Ryan Hill 16,076 Reputation points Microsoft Employee

2021-04-20T13:26:25.39+00:00

No worries @Error_401 . Unfortunately, I'm not too familiar with MySQL Cluster. Choose the right MySQL Server option in Azure however will provide more details on MySQL offerings. If MySQL cluster is something like an add-on that's installed on top of an existing instance, then you may be looking at an IaaS (VM with MySQL installed on it) deployment.

Issue with Azure App Service while deploying Web Service (PHP with MySQL)

0 additional answers

Activity