Nginx+htpasswd+PHPpgadmin

Platform: ubuntu_12.04_64bit

更多内容可移驾至我的独立Blog: http://www.justfbt.com/

---

Install depends

# apt-get install -y nginx php5-fpm php5-pgsql

Set up nginx

root@ser232:/etc/nginx#cat sites-enabled/default |grep -v '#' |grep -v '^$'

server {
    root /usr/share/nginx/www;
    index index.php index.html index.htm;
    server_name localhost;
    location / {
        try_files $uri $uri/ /index.html;
        auth_basic "secret";    # setup acl use account
        auth_basic_user_file /usr/share/nginx/www/pgadmin/passwd.db; #setup acl use account
#       allow x.x.x.x;
#       allow x.x.x.x;
#       deny all;
    }
    location /doc/ {
        alias /usr/share/doc/;
        autoindex on;
        allow 127.0.0.1;
        deny all;
    }
    location ~ \.php$ {
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass 127.0.0.1:9000;
        fastcgi_index index.php;
        include fastcgi_params;
    }
}

Set up phppgadmin’s pkg

# wget http://work-sfws.qiniudn.com/phpPgAdmin-5.1.tar.bz2
# tar -xf phpPgAdmin-5.1.tar.bz2
# cp -a phpPgAdmin-5.1 /usr/share/nginx/www/pgadmin
# service nginx reload
# service php5-fpm restart

Set up htpasswd

Install libapache-htpasswd-perl:

# apt-get install -y apache2-utils

Generate login db file:

# htpasswd -c /usr/share/nginx/www/pgadmin/passwd.db username

generate htpasswd online:

http://tool.oschina.net/htpasswd

END !