unsuccessful sql auth logging how

[Dan White]

spam at srv.hu wrote:
> pwcheck_method: auxprop
> auxprop_plugin: sql
> mech_list: login plain
> password_format: plain
> sql_engine: pgsql
> sql_hostnames: localhost
> sql_user: myUser
> sql_passwd: 123
> sql_database: maildb
> sql_select: select smtpauth from smtpauth('%u', '%r')
> 
> My problem is that I would like to log in my database the unsuccessful and
> the successful login attempts, but I can't pass my stored procedure the
> plaintext password what the user using during the authentication. %p is not
> working for me. The procedure only now the username so I can log only that
> the username was correct or not. 

You won't get the user-submitted password in the auxprop plugin, 
but you should get it in a saslauthd mechanism, such as the 
pam+sql backend.

- Dan