<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Verdana","sans-serif";
color:windowtext;}
span.syntax
{mso-style-name:syntax;}
span.syntaxalpha
{mso-style-name:syntax_alpha;}
span.syntaxpunct
{mso-style-name:syntax_punct;}
span.syntaxquote
{mso-style-name:syntax_quote;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Hallo
Liste,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>habe
entsprechend des Buches mein Auth im Cyrus-Imap konfiguriert.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nutze
das Plugin Sql für die Authentifizierung<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>sasl_pwcheck_method:
auxprop<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>sasl_auxprop_plugin:
sql<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span class=syntaxalpha><span lang=EN-US>SELECT</span></span><span
class=syntax><span lang=EN-US> </span></span><span class=syntaxpunct><span
lang=EN-US>pass </span></span><span class=syntaxalpha><span lang=EN-US>FROM</span></span><span
class=syntax><span lang=EN-US> </span></span><span class=syntaxquote><span
lang=EN-US>`smtpauth` WHERE user=‘user1’<o:p></o:p></span></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Klappt
soweit auch ganz gut, nur will ich die Passwörter md5 verschlüsselt in der
Datenbank haben.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Wie
teile ich dem Systme nun mit, dass die Passwörter MD5 (Hash) in der Datenbank
sind.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Passwort
in der Datenbank: </span>3102125cae72c19f215480ddf2d0d5c3<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Gebe ich nun als Klartextpasswort im Mailclient ein
„mypassswd“ schlägt die Auth fehl:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US>message.log<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:10 inetmx imap[20302]: sql auxprop plugin using mysql engine<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:10 inetmx imap[20302]: accepted connection<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:10 inetmx imap[20302]: DIGEST-MD5 server step 1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:10 inetmx imap[20302]: DIGEST-MD5 server step 2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:10 inetmx imap[20302]: realm changed: authentication aborted<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:10 inetmx imap[20302]: badlogin: HOST [nn.nn.nn.nn] DIGEST-MD5
[SASL(-13): authentication failure: realm changed: authentication aborted]<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin Parse the username user1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin try and connect to a host<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin trying to open db 'mailsetting' on
host 'host.de'<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin Parse the username user1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin try and connect to a host<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin trying to open db 'mailsetting' on
host 'host.de'<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin Parse the username user1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin try and connect to a host<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin trying to open db 'mailsetting' on
host 'host.de'<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: begin transaction<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin create statement from userPassword
user nnnnn<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin doing query SELECT pass FROM smtpauth
WHERE user = 'user1';<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin create statement from
cmusaslsecretPLAIN user1 nnnnn<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin doing query SELECT pass FROM smtpauth
WHERE user = 'user1';<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: commit transaction<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin Parse the username user1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin try and connect to a host<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: sql plugin trying to open db 'mailsetting' on
host 'host.de'<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Nov
8 03:03:13 inetmx imap[20302]: badlogin: HOST [nn.nn.nn.nn] plaintext user1
SASL(-13): authentication failure: checkpass failed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Gebe
ich aber </span>3102125cae72c19f215480ddf2d0d5c3 ein geht alles gut. Ist ja
logisch.<o:p></o:p></p>
<p class=MsoNormal>Wie kann ich das Plugin anweisen das Passwort was vom Client
kommt mittels MD5 umzuwandeln?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hinweis: Ich muss die Passwörter nicht zwingend md5
verschlüsselt speichern, anders verschlüsselt in die DB geht auch.<o:p></o:p></p>
<p class=MsoNormal>Klartextpasswörter in der DB sind keine Option.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Nutze<o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>cyrus-sasl
2.1.21<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>cyrus-sasl-sqlauxprop
2.1.21 (ist das Plugin für SQL)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>cyrus-imap
2.2.12<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Danke
für eure Hilfe. Bin sehr ratlos. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Martin<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>