Can't log into phpmyadmin on Wordpress Azure App Service

Question

Can't log into phpmyadmin on Wordpress Azure App Service

massad 65

I was able to log into phpMyAdmin after creating the app service, but somewhere along the line, it broke.

When I try to log in, I get this message: Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin.

I have tried Chrome, IE and Firefox. I have tried deleting cookies a hundred times. I have tried Incognito and InPrivate modes. Nothing works.

Please help!

massad 65 Reputation points

2023-10-09T18:47:59.63+00:00

When I removed the extra instances of the app as set in the Scaling Out blade, phpmyadmin worked. So I guess it's not compatible with having multiple instances for some reason?
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-10-10T13:29:36.24+00:00

@massad Thanks for reaching out to Microsoft Q&A , apologize for any inconvenience caused on this.

Based on the information provided, I understand that you are using Wordpress on Azure App service image from marketplace which interm comes with phpmyadmin and you have scaled out your app service to multiple instances when you try to login/request this URL https://<webAppName>.azurewebsites.net/phpmyadmin you are not able to log-in to it.

To test this out we have created an app service using Wordpress image from marketplace, also we have scaled it to 3 instances. we are able to login-in to phpmyadmin without any issues as shown below.

Feel free to reach back to me if you have any further questions on this.
massad 65 Reputation points

2023-10-10T14:04:26.2833333+00:00

Please scroll down and see if there is a cookie session error. Also, please delete cookies from the site and try again. It works the first time, but then stops working.
massad 65 Reputation points

2023-10-10T14:05:46.3466667+00:00

Also - please try setting up the Health Check. I am using endpoint /readme.html which is a common file in all Wordpress instances
massad 65 Reputation points

2023-10-10T14:08:08.1166667+00:00

Also - please try with the CDN configured.
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-10-11T10:13:58.1833333+00:00

@massad Thanks for your response. Can you change the HTTPS Only setting to On under the configuration settings of webapp as shown below:

and if you are still facing the issue. Could you please share more details about which marketplace image you are using, configuration changes that you have done step by step so that I can build it in my environment and will be checking with the internal team further on this.
massad 65 Reputation points

2023-10-11T14:54:48.91+00:00

Same issue with the HTTPS Only enable unfortunately.

I have been working on the site and changing things for days so can't really give you a step by step. However, I did delete and recreate the Web App at one point (using the same name), which left behind a bunch of other resources. I have since deleted the extra resources, but maybe there is still something lingering.

Are you able to try deleting and recreating the Web App with the same name and see if this phpmyadmin login issue happens?

I'm going to try creating a new app with a different name and see if it works.

Thanks!
massad 65 Reputation points

2023-10-11T18:09:50.5666667+00:00
I was able to replicate the issue on a new instance:

Set up Wordpress App Service with defaults

Once deployed, access /phpmyadmin with login provided in setup

It logs in fine

Increase to 3 instances on the Scale Out blade

Get an error that WORDPRESS_LOCAL_STORAGE_CACHE_ENABLED (in Configuration) must be set to false

Set WORDPRESS_LOCAL_STORAGE_CACHE_ENABLED to false

Increase to 3 instances on the Scale Out blade

Access /phpmyadmin - it works the first time

Enable Health Check with endpoint /readme.html

Wait until the Heath Check is a checkmark for all instances

Access /phpmyadmin - it DOES NOT work

Disable Health Check

Access /phpmyadmin - it DOES NOT work

The only other thing I did on the new instance was install the WP Forms plugin to test another issue I have with HTML emails.
massad 65 Reputation points

2023-10-11T18:16:11.14+00:00

I tried switching back to 1 instance and the phpmyadmin login works. But when I clicked on the WordPress database, I got this message. When I logged out and back in, phpmyadmin works fine (with one instance)
massad 65 Reputation points

2023-10-11T18:31:54.6466667+00:00

Interestingly, If I use the Automatic scale, it works better. I have the same results on both the original and new instance. It allows you to log in, and then you get an error message. When you click on a database, it kicks you out, but the login works. After a couple of times of this, you can access everything fine.

Here is the error on the first login:

And here are the settings I'm using on Scale Out:
massad 65 Reputation points

2023-10-11T18:32:54.1566667+00:00

This is on Central US location BTW

Accepted answer

0 additional answers

Your answer

massad 65 Reputation points

2023-10-09T18:47:59.63+00:00

When I removed the extra instances of the app as set in the Scaling Out blade, phpmyadmin worked. So I guess it's not compatible with having multiple instances for some reason?
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-10-10T13:29:36.24+00:00

@massad Thanks for reaching out to Microsoft Q&A , apologize for any inconvenience caused on this.

Based on the information provided, I understand that you are using Wordpress on Azure App service image from marketplace which interm comes with phpmyadmin and you have scaled out your app service to multiple instances when you try to login/request this URL https://<webAppName>.azurewebsites.net/phpmyadmin you are not able to log-in to it.

To test this out we have created an app service using Wordpress image from marketplace, also we have scaled it to 3 instances. we are able to login-in to phpmyadmin without any issues as shown below.

Feel free to reach back to me if you have any further questions on this.
massad 65 Reputation points

2023-10-10T14:04:26.2833333+00:00

Please scroll down and see if there is a cookie session error. Also, please delete cookies from the site and try again. It works the first time, but then stops working.
massad 65 Reputation points

2023-10-10T14:05:46.3466667+00:00

Also - please try setting up the Health Check. I am using endpoint /readme.html which is a common file in all Wordpress instances
massad 65 Reputation points

2023-10-10T14:08:08.1166667+00:00

Also - please try with the CDN configured.
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator

2023-10-11T10:13:58.1833333+00:00

@massad Thanks for your response. Can you change the HTTPS Only setting to On under the configuration settings of webapp as shown below:

and if you are still facing the issue. Could you please share more details about which marketplace image you are using, configuration changes that you have done step by step so that I can build it in my environment and will be checking with the internal team further on this.
massad 65 Reputation points

2023-10-11T14:54:48.91+00:00

Same issue with the HTTPS Only enable unfortunately.

I have been working on the site and changing things for days so can't really give you a step by step. However, I did delete and recreate the Web App at one point (using the same name), which left behind a bunch of other resources. I have since deleted the extra resources, but maybe there is still something lingering.

Are you able to try deleting and recreating the Web App with the same name and see if this phpmyadmin login issue happens?

I'm going to try creating a new app with a different name and see if it works.

Thanks!
massad 65 Reputation points

2023-10-11T18:09:50.5666667+00:00

I was able to replicate the issue on a new instance:

Set up Wordpress App Service with defaults

Once deployed, access /phpmyadmin with login provided in setup

It logs in fine

Increase to 3 instances on the Scale Out blade

Get an error that WORDPRESS_LOCAL_STORAGE_CACHE_ENABLED (in Configuration) must be set to false

Set WORDPRESS_LOCAL_STORAGE_CACHE_ENABLED to false

Increase to 3 instances on the Scale Out blade

Access /phpmyadmin - it works the first time

Enable Health Check with endpoint /readme.html

Wait until the Heath Check is a checkmark for all instances

Access /phpmyadmin - it DOES NOT work

Disable Health Check

Access /phpmyadmin - it DOES NOT work

The only other thing I did on the new instance was install the WP Forms plugin to test another issue I have with HTML emails.
massad 65 Reputation points

2023-10-11T18:16:11.14+00:00

I tried switching back to 1 instance and the phpmyadmin login works. But when I clicked on the WordPress database, I got this message. When I logged out and back in, phpmyadmin works fine (with one instance)
massad 65 Reputation points

2023-10-11T18:31:54.6466667+00:00

Interestingly, If I use the Automatic scale, it works better. I have the same results on both the original and new instance. It allows you to log in, and then you get an error message. When you click on a database, it kicks you out, but the login works. After a couple of times of this, you can access everything fine.

Here is the error on the first login:

And here are the settings I'm using on Scale Out:
massad 65 Reputation points

2023-10-11T18:32:54.1566667+00:00

This is on Central US location BTW

Answer 1

VenkateshDodda-MSFT 24,951 Microsoft Employee Moderator

@massad Thanks for your response and patience on this.

I have checked with App Service engineering team and sharing the below.

Our engineering Team has identified a bug and actively working on a fix on this issue. At this moment we don't have any ETA for this.

Currently, the workaround on this issue is.

Set Session(ARR) Affinity flag to On in Azure App Service (Configurations -> General Settings -> Session Affinity). Please note that this might cause unequal distribution of traffic, if the App Service is using multiple instances.

Feel free to reach back to me if you have any further questions on this.

massad 65 Reputation points

2023-10-12T14:48:05.9633333+00:00

This workaround is fine because phpmyadmin only needs to be used occasionally. You just don't want to be fighting to get into it when you have a problem :). So I will enable App Affinity when I need to acces phpmyadmin and otherwise leave it turned off.

Share via

Can't log into phpmyadmin on Wordpress Azure App Service

0 additional answers

Your answer