Problem using nginx with PMEA (PHP MySQL ExtJS Admin)

[Stefan Scott]

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:

http://github.com/jbruni/PHP-MySQL-ExtJS-Admin

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:

http://github.com/jbruni/PHP-MySQL-ExtJS-Admin#readme

This looks fairly straightforward!


However, when I point my browser to myserver.com/pmea
or myserver.com/pmea/index.php, I get a blank page.

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

[CODE]<?
phpinfo();
?>[/CODE]
...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:

[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;

        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!
-- 
Posted via http://www.ruby-forum.com/.