<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [dovecot] Re: Question about the password field in a postgresql database</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>> Works fine with me.. Only thing I can think of is that it's </FONT>
<BR><FONT SIZE=2>> some stupid</FONT>
<BR><FONT SIZE=2>> configuration mistake, like not uncommenting the line :)</FONT>
</P>
<P><FONT SIZE=2>Hi Timo,</FONT>
</P>
<P><FONT SIZE=2>I just (double) checked my config files, and it LOOKS ok.</FONT>
</P>
<P><FONT SIZE=2>My dovecot is from cvs, updated yesterday, and running on Redhat 7.3 (if that matters).</FONT>
</P>
<P><FONT SIZE=2>Here is my dovecot-pgsql.conf:</FONT>
</P>
<P><FONT SIZE=2>--8<--</FONT>
<BR><FONT SIZE=2>#</FONT>
<BR><FONT SIZE=2># Postgress connect string. Similar to PHP</FONT>
<BR><FONT SIZE=2>connect = host=A.B.C.D dbname=maildb user=mailuser password=******</FONT>
</P>
<P><FONT SIZE=2>password_query = SELECT password FROM aliases WHERE alias = '%u' AND password != '' AND locked='f';</FONT>
<BR><FONT SIZE=2>user_query = SELECT maildir as home, 100 as uid,498 as gid FROM aliases where alias = '%u';</FONT>
</P>
<P><FONT SIZE=2>#default_pass_scheme = PLAIN</FONT>
<BR><FONT SIZE=2>#default_pass_scheme = PLAIN-MD5</FONT>
<BR><FONT SIZE=2>default_pass_scheme = CRYPT</FONT>
<BR><FONT SIZE=2>--8<--</FONT>
</P>
<BR>
<P><FONT SIZE=2>My NON-working DB entry is:</FONT>
<BR><FONT SIZE=2>--8<--</FONT>
<BR><FONT SIZE=2>maildb-> default_pass_scheme = CRYPT</FONT>
<BR><FONT SIZE=2>maildb-> select * from aliases where alias = 'marc@test.com';</FONT>
<BR><FONT SIZE=2>ERROR: parser: parse error at or near "#"</FONT>
<BR><FONT SIZE=2>maildb=> ;</FONT>
<BR><FONT SIZE=2>maildb=> select * from aliases where alias = 'marc@test.com';</FONT>
<BR><FONT SIZE=2> alias | maildir | password | locked </FONT>
<BR><FONT SIZE=2>---------------+------------------------+------------------------------------+--------</FONT>
<BR><FONT SIZE=2> marc@test.com | test.com/marc/Maildir/ | $1$JJN5H82p$yKs5jnb/csQVYsZZ/4WFS0 | f</FONT>
<BR><FONT SIZE=2>(1 row)</FONT>
<BR><FONT SIZE=2>--8<--</FONT>
</P>
<P><FONT SIZE=2>and the one that IS working:</FONT>
<BR><FONT SIZE=2>--8<--</FONT>
<BR><FONT SIZE=2>maildb=> select * from aliases where alias = 'maikel@test.com';</FONT>
<BR><FONT SIZE=2> alias | maildir | password | locked </FONT>
<BR><FONT SIZE=2>-----------------+--------------------------+-------------------------------------------+--------</FONT>
<BR><FONT SIZE=2> maikel@test.com | test.com/maikel/Maildir/ | {CRYPT}$1$JJN5H82p$yKs5jnb/csQVYsZZ/4WFS0 | f</FONT>
<BR><FONT SIZE=2>(1 row)</FONT>
<BR><FONT SIZE=2>--8<--</FONT>
</P>
<P><FONT SIZE=2>Both strings are crypted versions of 'qwerty'</FONT>
</P>
<BR>
<P><FONT SIZE=2>Thank you,</FONT>
</P>
<BR>
<P><FONT SIZE=2>Maikel Verheijen</FONT>
</P>
</BODY>
</HTML>