Question

PhpMyAdmin Remote Access

Posted on March 6, 2017
Nginx Apache Debian
Asked by keoisawsmn

Hi there,

Let me start by saying what I’m wanting to achieve: I have a Debian 8.7 droplet with nginx, apache, php and mysql installed as well as mcrypt. I am trying to have phpmyadmin active on a subdomain attached to the droplet. An example of this subdomain could be; pma.example.com.

So far, everything is set up (as far as I can tell). The only issue is when I go to the previously mentioned subdomain, the page that’s opening, instead of displaying a webpage, downloads.

Example of my issue:

I go to https://pma.example.com/phpmyadmin/
The page closes.
A download begins of the page.

Honestly, I’d attach snippets of some of the code I’m using. But I’m not sure what code is relevant. Feel free to request relevant snippets.

Cheers, Brandon.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Jonathan Tittle • March 6, 2017

Accepted Answer

@keoisawsmn

If you’re prompted to download the file you’re attempting to access (i.e. index.php), then PHP is not working – by that I mean PHP is not enabled or it’s incorrectly setup. A downloaded file means that PHP files are not being processed, either by NGINX (PHP-FPM) or Apache (mod_php), so what you’ll need to check and confirm is that PHP is indeed installed (and all required dependencies) and that it’s enabled on the web server that’s supposed to be processing PHP (which I’m guessing is Apache?).

So we can get a better idea of how you setup your Droplet, can you provide the tutorials, guides or steps you took to setup NGINX, Apache, and PHP?

If you set them up without a guide, please provide the commands used.

keoisawsmn • March 6, 2017

@jtittle Hi Jonathan,

Thanks for you reply, with it comes my solution.

The problem was that I didn’t edit my server block for the subdomain to handle .php files.

        location ~ \.php$ {
                        try_files $uri =404;
                        fastcgi_pass unix:/var/run/php5-fpm.sock;
                        fastcgi_index index.php;
                        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_sc$
                        include fastcgi_params;
        }

This is now solved.