Problem using nginx with PMEA (PHP MySQL ExtJS Admin)

Stefan Scott lists at
Fri May 14 09:54:41 MSD 2010

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:

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:

This looks fairly straightforward!

However, when I point my browser to
or, I get a blank page.

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

...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:

[CODE]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:[/CODE]

Here is my config.php file:


$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()


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

[CODE]    server {
        listen 443;

        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_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;
        location / {
            rewrite ^/pmea(.*)$1 permanent;

Here is the file /usr/local/nginx/conf/fastcgi_params.pmea (included in

[CODE]fastcgi_index  index.php;

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!
Posted via

More information about the nginx mailing list