[Dovecot] Does anyone have SQL working in 1.03?

[Andrew Hutchings]

On Fri, 2005-10-14 at 22:52 -0400, Jonathan wrote:
> This just isn't working for me.  I've tried everything.
>  ===
> 
> I've tried both of these selects on the password:
> 
>      password_query = SELECT local_part || '@' || domain as user,  
> password FROM accounts WHERE local_part = '%n' AND domain = '%d' AND a
> ctive = 'Y' ;
>      password_query = SELECT password FROM accounts WHERE local_part  
> = '%n' AND domain = '%d' AND active = 'Y' LIMIT 1;
> 
> and this, and some variants, on the user
>      user_query = SELECT home_dir AS home, uid, gid FROM accounts  
> WHERE local_part = '%n' AND domain = '%d' LIMIT 1;
> 
> all mimic the functionality of the conf example files.
> 

What is in your auth section of dovecot.conf?

Regards
Andrew
--
Andrew Hutchings (A-Wing) - Linux Guru
Netserve Consultants - http://www.domaincity.co.uk/
Linux CDs and DVDs - http://www.linuxiso.co.uk/
Random quote 90: "This is not about browsers. Our competitors are trying
to create an alternative platform to Windows." - BRAD SILVERGBERG,
Senior Vice President, Microsoft