y_pam_auth( username text, password text ) returns bool

Linux PAM authentication function. Obviously, this kind of thing presumes you trust the server. The service file name is y_pg_pamc. I have only tested this against Linux PAM.

The Makefile implements the standard PostgreSQL PGXS build infrastructure. Run 'make' and 'make install' with appropriate permissions to build and install y_pg_pam.so. Execute the SQL calls in y_pg_pam.sql to instantiate the functions within your database.

Examples:

% select y_pam_auth( 'username', 'wrongpass' );
 y_pam_auth 
------------
 f
(1 row)

% select y_pam_auth( 'username', 'rightpass' );
 y_pam_auth 
------------
 t
(1 row)

Please send comments and suggestions to 'ron dot peterson at yellowbank dot com'.


More Yellowbank Code.


Last modified: Sun Mar 25 08:51:18 EDT 2007