Troubleshooting PHPMyAdmin Site Extension

If you recently started having trouble (HTTP 500) with PHPMyAdmin (PMA) SiteExtension, it may be a problem with sessions.

The errors look like this:

Browser

Screenshot of Error

Text Description

Chrome The page cannot be displayed because an internal server error has occurred.
Internet Explorer The website cannot display the pageThis error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.For more information about HTTP errors, see Help.

We can force PMA to use files as session handler. To do this, follow these steps:

 

1. Launch Kudu Console (<site>.scm.azurewebsites.net)

2. Under Debug Console, select CMD, then click SiteExtensions

3. Click phpmyadmin

4. Click libraries

5. Once here, expand the list area by clicking the down arrow

6. Scroll down and find session.inc.php, open it by clicking the pencil icon

7. Search (ctrl-f) for save_handler

8. From the beginning of the line, remove the // characters

So this should now read:

ini_set(‘session.save_handler’, ‘files’);

Notice the // characters have been removed.

9. Click save

10. Now startup PMA !