Index of /code/PostgreSQL/y_pam

 Name                    Last modified      Size  Description
 Parent Directory                             -   
 LICENSE                 24-Mar-2007 22:08  1.4K  
 Makefile                24-Mar-2007 22:08  1.2K  
 README.html             25-Mar-2007 08:51  1.6K  
 y_pg_pamc.c             25-Mar-2007 08:36  4.6K  
 y_pg_pamc.sql           24-Mar-2007 22:08  478   

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.