Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Forum for getting help with Project Gamera, Spamassassin, Clamav, qmail-scanner and other anti-spam tools.
mrhankey_ch
Forum User
Forum User
Posts: 26
Joined: Wed Feb 11, 2009 7:42 am

Postfix - error: no such column: cmusaslsecretDIGEST-MD5

Unread post 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!
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

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

Unread post 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
mrhankey_ch
Forum User
Forum User
Posts: 26
Joined: Wed Feb 11, 2009 7:42 am

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

Unread post by mrhankey_ch »

Yep, I'm also on CentOS 5... maybe we'll find an answer once!
Scott, thanks for your reply!
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

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

Unread post by scott »

are you on x86_64 by any chance? the other 2 people are as well
aus-city
Forum Regular
Forum Regular
Posts: 685
Joined: Thu Oct 26, 2006 11:56 pm

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

Unread post 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
mrhankey_ch
Forum User
Forum User
Posts: 26
Joined: Wed Feb 11, 2009 7:42 am

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

Unread post by mrhankey_ch »

Hey, mine is x86 32bits.
I've sqlite 3.3.6 from art!
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

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

Unread post 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
azurro
New Forum User
New Forum User
Posts: 1
Joined: Thu Feb 02, 2012 11:13 am
Location: Austria

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

Unread post 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.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

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

Unread post by scott »

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