Postfix - error: no such column: cmusaslsecretDIGEST-MD5
-
- Forum User
- Posts: 26
- Joined: Wed Feb 11, 2009 7:42 am
Postfix - error: no such column: cmusaslsecretDIGEST-MD5
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!
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!
-
- 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
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
-
- Forum User
- Posts: 26
- Joined: Wed Feb 11, 2009 7:42 am
Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Yep, I'm also on CentOS 5... maybe we'll find an answer once!
Scott, thanks for your reply!
Scott, thanks for your reply!
-
- 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
are you on x86_64 by any chance? the other 2 people are as well
Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
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
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
-
- Forum User
- Posts: 26
- Joined: Wed Feb 11, 2009 7:42 am
Re: Postfix - error: no such column: cmusaslsecretDIGEST-MD5
Hey, mine is x86 32bits.
I've sqlite 3.3.6 from art!
I've sqlite 3.3.6 from art!
-
- 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
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
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.
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.
-
- 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
Thanks a ton for following up on this older thread with what you found. Very much appreciated!