On Tuesday 20 October 2009 18:49:16 Jerry wrote:
> On Tue, 20 Oct 2009 17:57:35 +0200
>
> Andreas Ntaflos <d...@dword.org> wrote:
> > On Tuesday 20 October 2009 17:07:49 Timo Sirainen wrote:
> > > On Oct 20, 2009, at 9:45 AM, Andreas Ntaflos wrote:
> > > > I'd say you need a static userdb. Something like this:
> > >
> > > A couple of small things:
> > > > passdb sql {
> > > > args = /etc/dovecot/dovecot-sql.conf
> > > > }
> > > >
> > > > userdb static {
> > > > args = uid=vmail gid=vmail home=/var/vmail/%Ld/%Ln
> > > > allow_all_users=yes }
> > >
> > > %Ld/%Ln at this point works for now, but maybe not in future. I'd
> > > have passdb already change it lowercase. Also allow_all_users=yes
> > > isn't required (but maybe not harmful) since passdb sql is used.
> >
> > That's good to know, thanks. And you're right of course, the passdb
> > should already return the correct information, Dovecot shouldn't be
> > asked to change anything afterwards.
> >
> > Fortunately I myself don't use MySQL anymore but have migrated
> > everything to PostgreSQL. It does a much better job as a DBMS
> > (remote, secured access to the DB, fine-grained permissions and
> > rules) and also knows about case sensitivity. So foo...@example.com
> > is not the same as foo...@example.com. Which eliminates this
> > problem class altogether.
>
> MySQL, since at least 5.x knows about case. You can Google for the
> information if you want.Good to know, thanks. Creating tables with a *_cs collation seems to be the trick. Andreas -- Andreas Ntaflos Vienna, Austria GPG Fingerprint: 6234 2E8E 5C81 C6CB E5EC 7E65 397C E2A8 090C A9B4
signature.asc
Description: This is a digitally signed message part.
