spam@xxxxxx 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
