Hello,

Sometimes, I can't send mail via SMTP Auth trough PostFix anymore...

I got around the same error as mentionned here http://kb.parallels.com/en/5903
But it is bit different: "no such column: cmusaslsecretDIGEST-MD5"...
It's the same database query that fails! (linked to sqlite)

Any idea on how to fix this?
THANKS!

No help here Im afraid, but I can confirm two other people running into this same problem. One on fedora 8, and one on centos 5

Yep, I'm also on CentOS 5... maybe we'll find an answer once!
Scott, thanks for your reply!

are you on x86_64 by any chance? the other 2 people are as well

Scott,

My server is F8, but 32 bit and I do NOT have this problem if that is of assistance.

However as you know I backport updates from F9 and F10, so my sqlite is actually 3.5.9-2.fc8

Hey, mine is x86 32bits.
I've sqlite 3.3.6 from art!

Well there goes that theory, I thought maybe this was a 64/32 bit combo problem. The C5 user is running 3.3.6 from CentOS, so I dont think its related to sqlite

though this thread is old, it is one of the few listed when searching for this type of error.
so i want to post the solution, which helped in my case on a plesk system with centos 5.5 and postfix

The error is caused because smtpd service incorrectly announces DIGEST-MD5 as an available password encryption method, though this is not
supported by plesk (the column cmusaslsecretDIGEST-MD5 does not exist in /var/spool/postfix/plesk/passwd.db)

SOLUTION:
find sasl-configuration-file smtpd.conf, on above system it is in /usr/lib64/sasl2
change the line starting with mech_list: and remove DIGEST-MD5



and the errors will vanish,
In fact it is not really an unrecoverable error, it is caused by clients that probe several encryption methods, in case of failure they will use the next available method.

Thanks a ton for following up on this older thread with what you found. Very much appreciated!