Hello,
You can find out related out below.
Regards
Vahric
[r...@postfix-auth1 ~]# ./saslfinger-1.0.3/saslfinger -s
saslfinger - postfix Cyrus sasl configuration Wed Nov 25 18:47:20 EET 2009
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.5.9
System: CentOS release 5.4 (Final)
-- smtpd is linked to --
libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003dfba00000)
-- active SMTP AUTH and TLS parameters for smtpd --
broken_sasl_auth_clients = yes
smtpd_sasl_auth_enable = yes
-- listing of /usr/lib64/sasl2 --
total 3500
drwxr-xr-x 2 root root 4096 Nov 22 23:17 .
drwxr-xr-x 55 root root 36864 Nov 21 04:03 ..
-rwxr-xr-x 1 root root 890 Sep 4 03:04 libanonymous.la
-rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so
-rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2
-rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2.0.22
-rwxr-xr-x 1 root root 876 Sep 4 03:04 libcrammd5.la
-rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so
-rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2
-rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2.0.22
-rwxr-xr-x 1 root root 899 Sep 4 03:04 libdigestmd5.la
-rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so
-rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2
-rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2.0.22
-rwxr-xr-x 1 root root 939 Sep 4 03:04 libgssapiv2.la
-rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so
-rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2
-rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2.0.22
-rwxr-xr-x 1 root root 883 Sep 4 03:04 libldapdb.la
-rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so
-rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2
-rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2.0.22
-rwxr-xr-x 1 root root 862 Sep 4 03:04 liblogin.la
-rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so
-rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2
-rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2.0.22
-rwxr-xr-x 1 root root 864 Sep 4 03:04 libntlm.la
-rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so
-rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2
-rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2.0.22
-rwxr-xr-x 1 root root 862 Sep 4 03:04 libplain.la
-rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so
-rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2
-rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2.0.22
-rwxr-xr-x 1 root root 936 Sep 4 03:04 libsasldb.la
-rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so
-rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2
-rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2.0.22
-rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
-rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so
-rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2
-rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2.0.22
-rw-r--r-- 1 root root 25 Mar 15 2007 Sendmail.conf
-rw-r--r-- 1 root root 280 Nov 22 23:17 smtpd.conf
-- listing of /usr/lib/sasl2 --
total 3440
drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
drwxr-xr-x 50 root root 28672 Nov 20 13:43 ..
-rwxr-xr-x 1 root root 884 Sep 4 03:04 libanonymous.la
-rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so
-rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2
-rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2.0.22
-rwxr-xr-x 1 root root 870 Sep 4 03:04 libcrammd5.la
-rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so
-rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2
-rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2.0.22
-rwxr-xr-x 1 root root 893 Sep 4 03:04 libdigestmd5.la
-rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so
-rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2
-rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2.0.22
-rwxr-xr-x 1 root root 933 Sep 4 03:04 libgssapiv2.la
-rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so
-rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2
-rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2.0.22
-rwxr-xr-x 1 root root 877 Sep 4 03:04 libldapdb.la
-rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so
-rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2
-rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2.0.22
-rwxr-xr-x 1 root root 856 Sep 4 03:04 liblogin.la
-rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so
-rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2
-rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2.0.22
-rwxr-xr-x 1 root root 858 Sep 4 03:04 libntlm.la
-rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so
-rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2
-rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2.0.22
-rwxr-xr-x 1 root root 856 Sep 4 03:04 libplain.la
-rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so
-rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2
-rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2.0.22
-rwxr-xr-x 1 root root 930 Sep 4 03:04 libsasldb.la
-rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so
-rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2
-rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2.0.22
-rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
-rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so
-rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2
-rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2.0.22
-- listing of /etc/sasl2 --
total 16
drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
drwxr-xr-x 82 root root 4096 Nov 25 18:20 ..
-- content of /usr/lib64/sasl2/smtpd.conf --
log_level: 7
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login
sql_engine: mysql
sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
sql_user: --- replaced ---
sql_passwd: --- replaced ---
sql_database: postfix
sql_select: select clear from postfix_smtp where email='%...@%r'
-- active services in /etc/postfix/master.cf --
# service type private unpriv chroot wakeup maxproc command + args
# (yes) (yes) (yes) (never) (100)
smtp inet n - n - - smtpd
pickup fifo n - n 60 1 pickup
cleanup unix n - n - 0 cleanup
qmgr fifo n - n 300 1 qmgr
tlsmgr unix - - n 1000? 1 tlsmgr
rewrite unix - - n - - trivial-rewrite
bounce unix - - n - 0 bounce
defer unix - - n - 0 bounce
trace unix - - n - 0 bounce
verify unix - - n - 1 verify
flush unix n - n 1000? 0 flush
proxymap unix - - n - - proxymap
proxywrite unix - - n - 1 proxymap
smtp unix - - n - - smtp
relay unix - - n - - smtp
-o smtp_fallback_relay=
showq unix n - n - - showq
error unix - - n - - error
retry unix - - n - - error
discard unix - - n - - discard
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - n - - lmtp
anvil unix - - n - 1 anvil
scache unix - - n - 1 scache
-- mechanisms on localhost --
250-AUTH LOGIN PLAIN
250-AUTH=LOGIN PLAIN
-- end of saslfinger output --
-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of Patrick Ben Koetter
Sent: Tuesday, November 24, 2009 11:08 PM
To: [email protected]
Subject: Re: About SMTP Auth with Mysql
* Vahriç Muhtaryan <[email protected]>:
> Any postfix guy have a knowledge about this issue
> Really I would like to solve this and debug
> Actually smtp -v do not show the problem also verbose mode to for sasl
> Any idea ?
It is the Postfix smtpd-daemon and not the smtp-client. If you debug add "-v"
to smtpd, not smtp.
Download saslfinger and run it:
saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
Send debug output to the list.
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Vahriç Muhtaryan
> Sent: Sunday, November 22, 2009 11:21 PM
> To: 'Patrick Ben Koetter'; [email protected]
> Subject: RE: About SMTP Auth with Mysql
>
> I hope that until find the right mailbox and pass it should query each
> setted mysql server but not !
> For to be sure I'm sending different mailbox name and password and wait
> postfix make query step by step but not.
> I told you before with different syntax postfix do differnt actions
> I don't know this is really postfix problem our cyrus problem but I couldn'T
> find any solution
> When you check cyrus docs my sytax is ok but its not working
> İts drive me crazy
Sorry, but I don't understand what you write.
p...@rick
>
> Regards
> Vahric
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Patrick Ben Koetter
> Sent: Sunday, November 22, 2009 4:44 PM
> To: [email protected]
> Subject: Re: About SMTP Auth with Mysql
>
> * Vahriç Muhtaryan <[email protected]>:
> > Hi,
> >
> > (212.58.4.184,212.58.4.247) not worked
> > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
> > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
> > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
> > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
> > 247
>
> How did you test?
>
> Just in case you think it should query both servers at the same time: No,
> it's
> not supposed to do that.
>
> If the 1st server in the list is inaccessible, it should try the second.
>
> Have you tested that?
>
> p...@rick
>
> --
> All technical questions asked privately will be automatically answered on
> the
> list and archived for public access unless privacy is explicitely required
> and
> justified.
>
> saslfinger (debugging SMTP AUTH):
> <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
>
--
All technical questions asked privately will be automatically answered on the
list and archived for public access unless privacy is explicitely required and
justified.
saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
