Re: Cyrus SASL2 + Postfix + PAM - part 3

4 msg	Forwards vs aliases ?
4 msg	no content-filter for authed users
2 msg	postfix does not flush queued mails
1 msg	Re: [dkim-milter-beta] mlfi_negotiate() problem
2 msg	newby Q
14 msg	PAM 'smtp' file question

Cyrus SASL2 + Postfix + PAM - part 3
\ Michael Hallager (15 Nov 2007)
. \ Voytek Eymont (15 Nov 2007)
. . \ Michael Hallager (15 Nov 2007)
. . . \ Voytek Eymont (15 Nov 2007)
. . . . \ Michael Hallager (15 Nov 2007)

9 msg	transport error?
3 msg	Can't figure out if this rejection is coming fr...
8 msg	Alias with check_recipient_access: /etc/ppostfi...
2 msg	NDR reports
7 msg	Sender-ID and the Hotmail devil...
2 msg	Postifx with IMAP
2 msg	Postfix and procmail
4 msg	destination limits - what is 'destination'
1 msg	Redirect message based on Conditions
1 msg	Cyrus SASL2 + Postfix + PAM - part 2
6 msg	Cyrus SASL2 + Postfix + PAM
5 msg	header_checks and content_filter documentation ...
2 msg	Some problem configuring postfix/procmail with ...

Subject:	Re: Cyrus SASL2 + Postfix + PAM - part 3
Group:	Postfix-users
From:	Michael Hallager
Date:	15 Nov 2007

> but what do you REQUIRE for succesfull authentication?
> I need user
> whats' in your mysql table 'user' or 'user' ?

no, just the username.

> > ok, how should I make my log this verbose?
>
> append
> 'verbose=1'
> at end of both lines in /etc/pam.d/smtp

Nov 15 16:46:47 saslauthd[29445]: pam_mysql - option verbose is set to "1"
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_close_db() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_sm_authenticate() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_open_db() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_open_db() returning 0.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_check_passwd() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_format_string() called
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_quick_escape() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - SELECT password FROM accounts
WHERE username = 'DELETED'
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_check_passwd()
returning 6.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_sql_log() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_sql_log() returning 0.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_converse() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_open_db() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_check_passwd() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_sql_log() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_sql_log() returning 0.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_sm_authenticate() returning
0.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_release_ctx() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_destroy_ctx() called.
Nov 15 16:46:47 saslauthd[29445]: pam_mysql - pam_mysql_close_db() called.