SQLBuddy with nginx

[fsk141]

Hello,
I was wondering if sqlbuddy supports nginx & if there was any special configuration required. I'm currently trying to run it & am only getting a blank page ;(

[Emmanuel Higgins]

Hi there,

I am using sqlbuddy on nginx. Here's my config:

server {

        listen   80;

        server_name  sql.mywebsite.com;

        root /var/www/sql;

        access_log  /var/log/nginx/sql.access.log;

        location / {

                root   /var/www/sql;

                index index.php;

        }

        location ~ \.php$ {

                fastcgi_pass   127.0.0.1:9000;

                fastcgi_index  index.php;

                fastcgi_param  SCRIPT_FILENAME  /var/www/sql$fastcgi_script_name;

                include fastcgi_params;

        }

}

Turning on php errors may show up something if you're just getting a blank page.

[motojoester]

Yes, SQL Buddy supports Nginx. If you would like to test SQL Buddy on Nginx, try FusionLeaf Stack. The instructions are here: http://code.google.com/p/fusionleaf/wiki/stack_instructions

Emmanuel also makes a good point. Try creating a simple test page to see if PHP is configured correctly with Nginx:

<?php

echo 'Hello Word';

?>

All you should see if Hello World if you try to visit the page in your web browser. If you see all of the code on the webpage, it means either the last block (location ~ \.php$) in your nginx .conf is not configured correctly or PHP is not working properly.

[p4guru]

looks like folks over at ars did an article with sqlbuddy nginx setup at http://arstechnica.com/information-technology/2012/12/web-served-part-4-get-your-database-on/2/

On Tuesday, July 24, 2012 4:42:55 AM UTC+10, fsk141 wrote: