store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Wed Oct 01, 2014 4:16 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Wed Feb 11, 2009 7:55 am 
Offline
Forum User
Forum User

Joined: Wed Feb 11, 2009 7:42 am
Posts: 26
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!


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Wed Feb 11, 2009 8:53 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7913
Location: earth
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


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Wed Feb 11, 2009 9:05 am 
Offline
Forum User
Forum User

Joined: Wed Feb 11, 2009 7:42 am
Posts: 26
Yep, I'm also on CentOS 5... maybe we'll find an answer once!
Scott, thanks for your reply!


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Wed Feb 11, 2009 11:32 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7913
Location: earth
are you on x86_64 by any chance? the other 2 people are as well


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Wed Feb 11, 2009 6:05 pm 
Offline
Forum Regular
Forum Regular

Joined: Thu Oct 26, 2006 11:56 pm
Posts: 678
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


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Wed Feb 11, 2009 6:15 pm 
Offline
Forum User
Forum User

Joined: Wed Feb 11, 2009 7:42 am
Posts: 26
Hey, mine is x86 32bits.
I've sqlite 3.3.6 from art!


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Thu Feb 12, 2009 8:40 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7913
Location: earth
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


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Thu Feb 02, 2012 11:48 am 
Offline
New Forum User
New Forum User

Joined: Thu Feb 02, 2012 11:13 am
Posts: 1
Location: Austria
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:
#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.


Top
 Profile  
 
 Post subject: Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Unread postPosted: Thu Feb 02, 2012 7:27 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7913
Location: earth
Thanks a ton for following up on this older thread with what you found. Very much appreciated!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group