Page 1 of 1

Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Wed Feb 11, 2009 7:55 am
by mrhankey_ch
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!

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Wed Feb 11, 2009 8:53 am
by scott
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

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Wed Feb 11, 2009 9:05 am
by mrhankey_ch
Yep, I'm also on CentOS 5... maybe we'll find an answer once!
Scott, thanks for your reply!

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Wed Feb 11, 2009 11:32 am
by scott
are you on x86_64 by any chance? the other 2 people are as well

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Wed Feb 11, 2009 6:05 pm
by aus-city
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

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Wed Feb 11, 2009 6:15 pm
by mrhankey_ch
Hey, mine is x86 32bits.
I've sqlite 3.3.6 from art!

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Thu Feb 12, 2009 8:40 am
by scott
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

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Thu Feb 02, 2012 11:48 am
by azurro
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

Code: Select all

#mech_list: DIGEST-MD5 CRAM-MD5 PLAIN LOGIN
#DIGEST-MD5 is not supported
mech_list: CRAM-MD5 PLAIN LOGIN

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.

Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Posted: Thu Feb 02, 2012 7:27 pm
by scott
Thanks a ton for following up on this older thread with what you found. Very much appreciated!