AuthPG 1.5 review

AuthPG is a PostgreSQL Authentication Module. PostgreSQL Authentication Module (AuthPG) enables Apache to authenticate users with

License: GPL (GNU General Public License) File size: 0K Developer: Min Sik Kim

0

AuthPG is a PostgreSQL Authentication Module.

PostgreSQL Authentication Module (AuthPG) enables Apache to authenticate users with the information stored in PostgreSQL database. This module gets a username and password pair in the standard way or from a cookie, and you can choose your preferred method.

Usage:

There are two ways to use mod_auth_pg. The one is to make .htaccess file in the directory which requires user authentication, and the other is to edit httpd.conf.

.htaccess

Apache doesn't recognize .htaccess at default. You must edit httpd.conf to enable .htaccess. Open httpd.conf and you will find the line < Directory /any/path >. Between < Directory /any/path > and < /Directory > there is a line which starts with AllowOverride.

The value of this item should contain AuthConfig or All. Edit and save it. Now restart Apache or give the signal with kill to reload httpd.conf.

Open .htaccess in the directory requiring user authentication, and write whatever directives you need.

AuthName my_auth
AuthType Basic
AuthPGHost my.database.server
AuthPGDatabase my_db
AuthPGUserTable user_table

require valid-user

If you specify the name of host after AuthPGHost directive, Apache will try to connect to PostgreSQL using internet domain socket, which means you should run postmaster with -i option, and edit configuration file to allow this type of access. When omit AuthPGHost directive, postmaster and httpd should run on the same machine.
Consult mod_auth_pg.html for the usage of each directive.

Requirements:
PostgreSQL
Apache HTTP Server