Cannot access MySQL from Laravel Web App

Question

Cannot access MySQL from Laravel Web App

Zeyad Naguib 0

Hello, I have a PHP 8.1 Laravel project setup with MySQL, I have followed exactly all the steps in this tutorial: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-php-database-app but instead of the sample project they gave, I use my own project on GitHub which works locally, up until the step that they require to do "php artisan migrate --force", it doesn't work, it gives me an SQLSTATE[HY000] [2002] Connection refused, I haven't changed anything or did anything outside of the steps, I'm not sure what's the issue. GitHub integrated successfully and deployment is successful, my configuration variables are setup correctly, and I can access the website using the domain (doesn't work yet because haven't finished up setting it but it sends me to the web app explorer page where I can view env, logs, requests, etc). I'm trying "php artisan migrate --force" on the Web App SSH in /home/site/wwwroot

I have tried to add MYSQL_ATTR_SSL_KEY and VERIFY_SERVER_CERT to my config/database.php but still did not work.

            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
                PDO::MYSQL_ATTR_SSL_KEY    => '/ssl/DigiCertGlobalRootCA.crt.pem',
                PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false
            ]) : [],

Tushar Kumar 3,371 Reputation points MVP

2023-06-27T14:59:45.89+00:00

In Visual Studio Code in the browser, open config/database.php in the explorer.In the mysql connection, see that the app settings you created earlier for the MySQL connection are already used (DB_HOST, DB_DATABASE, DB_USERNAME, DB_PASSWORD, MYSQL_ATTR_SSL_CA).

I belive you are mising something on above line, can you verify the connection string if you are using the same creds that you have used to setup mysql.
Zeyad Naguib 0 Reputation points

2023-06-27T15:30:37.9066667+00:00

My database.php has all those variables being used, in my web app configuration I have also correctly configured all the variables. Can you clarify on how do I verify the connection strings? Currently I have no connection strings, only the configuration variables.
Tushar Kumar 3,371 Reputation points MVP

2023-06-28T10:18:15.01+00:00

Hi Zeyad Naguib,

You can try connecting to your MySQL instance using MySQL workbench, also check on MySQl networking configuration if you have correct config with Virtual network.
Zeyad Naguib 0 Reputation points

2023-06-28T13:45:06.25+00:00

I tried that and followed the "Connect through MySQL Workbench" instructions on the server resource, but I'm receiving this error:

Your connection attempt failed for user "USER" to the MySQL

server at "HOST":3306:

Unable to connect to localhost

USER and HOST being my server username and host. All inputs are correct and as configured in the configuration. The server status is in ready state as well in MySQL Server -> Connect.
SnehaAgrawal-MSFT 22,706 Reputation points Moderator

2023-06-29T12:08:19.08+00:00

@Zeyad Naguib Could you please make sure that you have set up the firewall rules to allow web app to connect to the server.

See- Manage firewall rules for Azure Database for MySQL - Flexible Server using the Azure portal

If you have already set up the app settings and firewall rules correctly, you can try to connect to the MySQL server in Azure using the mysql command in the local terminal window.

Use the value you specified previously for <admin-user> and <mysql-server-name>. When prompted for a password, use the password you specified when you created the database in Azure.

If issue remains let us know.
Zeyad Naguib 0 Reputation points

2023-06-29T16:55:24.62+00:00

@SnehaAgrawal-MSFT The article is a little outdated so I cannot find the firewall settings in my MySQL server.

My MySQL Server Settings:

However, any traffic related settings I can find on the Web App settings. But I have no restrictions set on inbound traffic. Here is the networking page on my web app.

Here is the "access restriction" page:

Even when I disable the allow all rule and apply my own client IP and try to connect, I still face the same issue.
Lastly, when I try to connect to the database using the CLI in Azure as you suggest, I get an error that the hostname "HOST" is not found (-2) (even though the credentials are correct).

1 answer

Your answer

Tushar Kumar 3,371 Reputation points MVP

2023-06-27T14:59:45.89+00:00

In Visual Studio Code in the browser, open config/database.php in the explorer.In the mysql connection, see that the app settings you created earlier for the MySQL connection are already used (DB_HOST, DB_DATABASE, DB_USERNAME, DB_PASSWORD, MYSQL_ATTR_SSL_CA).

I belive you are mising something on above line, can you verify the connection string if you are using the same creds that you have used to setup mysql.
Zeyad Naguib 0 Reputation points

2023-06-27T15:30:37.9066667+00:00

My database.php has all those variables being used, in my web app configuration I have also correctly configured all the variables. Can you clarify on how do I verify the connection strings? Currently I have no connection strings, only the configuration variables.
Tushar Kumar 3,371 Reputation points MVP

2023-06-28T10:18:15.01+00:00

Hi Zeyad Naguib,

You can try connecting to your MySQL instance using MySQL workbench, also check on MySQl networking configuration if you have correct config with Virtual network.
Zeyad Naguib 0 Reputation points

2023-06-28T13:45:06.25+00:00

I tried that and followed the "Connect through MySQL Workbench" instructions on the server resource, but I'm receiving this error:

Your connection attempt failed for user "USER" to the MySQL

server at "HOST":3306:

Unable to connect to localhost

USER and HOST being my server username and host. All inputs are correct and as configured in the configuration. The server status is in ready state as well in MySQL Server -> Connect.
SnehaAgrawal-MSFT 22,706 Reputation points Moderator

2023-06-29T12:08:19.08+00:00

@Zeyad Naguib Could you please make sure that you have set up the firewall rules to allow web app to connect to the server.

See- Manage firewall rules for Azure Database for MySQL - Flexible Server using the Azure portal

If you have already set up the app settings and firewall rules correctly, you can try to connect to the MySQL server in Azure using the mysql command in the local terminal window.

Use the value you specified previously for <admin-user> and <mysql-server-name>. When prompted for a password, use the password you specified when you created the database in Azure.

If issue remains let us know.
Zeyad Naguib 0 Reputation points

2023-06-29T16:55:24.62+00:00

@SnehaAgrawal-MSFT The article is a little outdated so I cannot find the firewall settings in my MySQL server.

My MySQL Server Settings:

However, any traffic related settings I can find on the Web App settings. But I have no restrictions set on inbound traffic. Here is the networking page on my web app.

Here is the "access restriction" page:

Even when I disable the allow all rule and apply my own client IP and try to connect, I still face the same issue.
Lastly, when I try to connect to the database using the CLI in Azure as you suggest, I get an error that the hostname "HOST" is not found (-2) (even though the credentials are correct).

Answer 1

@Zeyad Naguib I don't think the issue is with access restrictions of your app service. I would recommend first reviewing Azure App Service virtual network integration troubleshooting guide - Azure | Microsoft Learn and using tcpping to hit your MySQL database server. If you're not getting any response, configure service endpoints on the VNet. If no errors there, it may be an issue with the SSL in which you can download it again. You can also step through Connect using mysql command-line client with TLS/SSL to verify the connection.

Share via

Cannot access MySQL from Laravel Web App

1 answer

Your answer