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

_______________________________________________
nginx mailing list
nginx@nginx.org
http://nginx.org/mailman/listinfo/nginx