# Problem using nginx with PMEA (PHP MySQL ExtJS Admin)

**URL:** <https://www.ruby-forum.com/t/problem-using-nginx-with-pmea-php-mysql-extjs-admin/188580>\
**Category:** NGINX\
**Created:** [May 14, 2010, 7:54am UTC](https://www.ruby-forum.com/t/problem-using-nginx-with-pmea-php-mysql-extjs-admin/188580 "2010-05-14T07:54:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefans](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9d8465/32.png) [@stefans](https://www.ruby-forum.com/u/stefans)\
**Post date:** [May 14, 2010, 7:54am UTC](https://www.ruby-forum.com/t/problem-using-nginx-with-pmea-php-mysql-extjs-admin/188580/1 "2010-05-14T07:54:41Z")

</div>

Hi -

Sorry if this is slightly off-topic. I am trying to use a PHP MySQL  
admin program called PMEA (PHP MySQL ExtJS Admin), located here:

> **[GitHub - jbruni/PHP-MySQL-ExtJS-Admin: MySQL CRUD in the browser with...](https://github.com/jbruni/PHP-MySQL-ExtJS-Admin)**
>
> MySQL CRUD in the browser with beautiful ExtJS interface and PHP back-end - GitHub - jbruni/PHP-MySQL-ExtJS-Admin: MySQL CRUD in the browser with beautiful ExtJS interface and PHP back-end

PMEA looks like a nice PHP program - it generates a CRUD for a MySQL  
database using the Ajax library ExtJS. So I am excited about getting it  
to work on my server.

But so far, I have not been able to install PMEA. I am using ExtJS 3.2.  
My webserver is nginx.

I have changed the file config.php that comes with PMEA, according to  
the instructions in the readme:

> **[GitHub - jbruni/PHP-MySQL-ExtJS-Admin: MySQL CRUD in the browser with...](https://github.com/jbruni/PHP-MySQL-ExtJS-Admin#readme)**
>
> MySQL CRUD in the browser with beautiful ExtJS interface and PHP back-end - GitHub - jbruni/PHP-MySQL-ExtJS-Admin: MySQL CRUD in the browser with beautiful ExtJS interface and PHP back-end

This looks fairly straightforward!

However, when I point my browser to [myserver.com/pmea](http://myserver.com/pmea)  
or [myserver.com/pmea/index.php](http://myserver.com/pmea/index.php), I get a blank page.

As a test, if I change the contents of file index.php to read…

`<?
phpinfo();
?>`  
…then I get the standard php test page. This probably indicates that  
the server configuration (in nginx.conf) is correct.

So it maybe something is wrong with the way I have PMEA configured.  
Maybe it doesn’t work with ExtJS 3.2? Or maybe I have a file in the  
wrong location, or something wrong in config.php?

I think my nginx.conf is ok - but maybe there is actually something  
wrong with it!

Thanks for any help.

File and directory listings are below.

================================================

Here is the directory where I’ve installed pmea and ext-3.2.1:

`myserver /home/stefanscott/sources/pmea: ls -l
total 36
-rwxrwxrwx 1 root root 1635 2010-05-14 05:13 config.php
drwxr-xr-x 10 root root 4096 2010-05-14 01:27 ext-3.2.1
-rwxrwxrwx 1 root root 527 2010-05-14 01:43 index.php
drwxrwxrwx 4 root root 4096 2009-07-25 18:06 pmea
-rwxrwxrwx 1 root root 1109 2009-07-25 18:34 README.txt
-rwxrwxrwx 1 root root 43 2009-05-13 19:13 s.gif
-rwxrwxrwx 1 root root 552 2009-07-25 18:33 VERSION.txt
myserver /home/stefanscott/sources/pmea:`

Here is my config.php file:

[CODE]\<?php

$pmea\_config = array(

// extRoot = path to your ExtJS 3 installation (root folder here  
refers to your public site root)  
‘extRoot’ =\> ‘/ext-3.2.1’,

// title = browser window title and grid title  
‘title’ =\> ‘PHP MySQL ExtJS Admin’,

// pageSize = number of rows to display at once  
‘pageSize’ =\> 30,

‘host’ =\> ‘localhost’,  
‘user’ =\> ‘root’,  
‘pass’ =\> ‘MySqlPasswordForRoot’,  
‘name’ =\> ‘MySqlDatabase001’,

‘debug’ =\> false,  
‘showtype’ =\> false,  
‘language’ =\> ‘en’,  
‘initial\_table’ =\> ‘’,  
‘allowed\_tables’ =\> array(),  
‘forbidden\_tables’=\> array()  
);

?\>[/CODE]

Here the part of file /usr/local/nginx/conf/nginx.conf about pmea:

[CODE] server {  
listen 443;  
server\_name [myserver.com](http://myserver.com);

```
    ssl on;
    ssl_certificate /etc/ssl/certs/myssl.crt;
    ssl_certificate_key /etc/ssl/private/myssl.key;

    ssl_session_timeout 5m;

    ssl_protocols SSLv2 SSLv3 TLSv1;
    ssl_ciphers

```

ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP;  
ssl\_prefer\_server\_ciphers on;

```
    location /pmea/ {
        access_log /usr/local/nginx/logs/pmea.access_log;
        error_log /usr/local/nginx/logs/pmea.error_log;
        root /home/stefanscott/sources/;
        index index.php;
        include /usr/local/nginx/conf/fastcgi_params.pmea;
        }
}

server {
    listen 80;
    server_name myserver.com;
    location / {
        rewrite ^/pmea(.*) https://myserver.com/pmea$1 permanent;
    }
}[/CODE]

```

Here is the file /usr/local/nginx/conf/fastcgi\_params.pmea (included in  
nginx.conf):

[CODE]fastcgi\_index index.php;  
fastcgi\_pass 127.0.0.1:9000;

fastcgi\_param SCRIPT\_FILENAME $document\_root$fastcgi\_script\_name;  
fastcgi\_param HTTPS on;

fastcgi\_param QUERY\_STRING $query\_string;  
fastcgi\_param REQUEST\_METHOD $request\_method;  
fastcgi\_param CONTENT\_TYPE $content\_type;  
fastcgi\_param CONTENT\_LENGTH $content\_length;

fastcgi\_param SCRIPT\_NAME $fastcgi\_script\_name;  
fastcgi\_param REQUEST\_URI $request\_uri;  
fastcgi\_param DOCUMENT\_URI $document\_uri;  
fastcgi\_param DOCUMENT\_ROOT $document\_root;  
fastcgi\_param SERVER\_PROTOCOL $server\_protocol;

fastcgi\_param GATEWAY\_INTERFACE CGI/1.1;  
fastcgi\_param SERVER\_SOFTWARE nginx/$nginx\_version;

fastcgi\_param REMOTE\_ADDR $remote\_addr;  
fastcgi\_param REMOTE\_PORT $remote\_port;  
fastcgi\_param SERVER\_ADDR $server\_addr;  
fastcgi\_param SERVER\_PORT $server\_port;  
fastcgi\_param SERVER\_NAME $server\_name;

# PHP only, required if PHP was built with --enable-force-cgi-redirect

fastcgi\_param REDIRECT\_STATUS 200;[/CODE]

These last two files are used by the webserver nginx. I think they are  
ok, because when I test them using index.php containing only \<? phpinfo(); ?\> they work fine. But when I use the file index.php supplied  
with PMEA, I get a blank page in my browser.

Thanks for any help!