Hi Timo,
I use:
/etc/dovecot/dovecot-sql.conf
driver = mysql connect = host=127.0.0.1 dbname=mailserver user=mailuser password=xxxxxxxx default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u';
I was able to get it working if I changed the %u ... Is there a way to regex %u for @com in the config?
-- :::::: :::::: Preston J. Lord :: :::: :::::: Manager / Software Design Engineer :::::::::: :::::: plord@inetx.ca :: :::::::::::::: :: :: :::::::::: iNTRICATE NETWORKS :: :: :::::::: Toll Free 1-866-949-4638 :::::: :::::: www.iNETx.ca
Phone: 1-306-778-0800 Fax: 1-306-778-7675 #4 1081 Central Avenue North Swift Current, SK, CA S9H 4Z2
This email including attachments is confidential and legally privileged. If you are not the intended recipient, any redistribution or copying of this message is prohibited. If you have received this email in error please notify us immediately, by return email, and delete this email.
From: Timo Sirainen tss@iki.fi Date: Sat, 11 Apr 2009 21:24:13 -0400 To: Preston Lord plord@sasktel.net Cc: dovecot@dovecot.org Subject: Re: [Dovecot] Issue with converting users from cyrus user.domain.com
passdb