Good afternoon again
I was thinking about the Dovecot upgrading so i´m doing this in the next
hours. in the other hand here i show you the dovecot-ldap.conf file I
think it has just the necessary options to bind the LDAP server.
/hosts = *********
base = ou=People,o=*****,o=******
ldap_version = 3
auth_bind = yes
auth_bind_userdn = uid=%u,ou=People,o=******,o=******
/About the dovecot.conf should I use some login options as
/login_process_per_connection = yes /or /login_processes_count = 1/?
For now thanks so much for the help i´ll inform about the new version
installation
Juan Felipe Estrada
dovecot-requ...@dovecot.org escribió:
Send dovecot mailing list submissions to
dovecot@dovecot.org
To subscribe or unsubscribe via the World Wide Web, visit
http://dovecot.org/cgi-bin/mailman/listinfo/dovecot
or, via email, send a message with subject or body 'help' to
dovecot-requ...@dovecot.org
You can reach the person managing the list at
dovecot-ow...@dovecot.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of dovecot digest..."
Today's Topics:
1. Re: Need a little shadow to MySQL conversion help (Jerry)
2. Re: Need a little shadow to MySQL conversion help (Marc Perkel)
3. Re: Need a little shadow to MySQL conversion help
(Andreas Ntaflos)
4. Re: Need a little shadow to MySQL conversion help
(Andreas Ntaflos)
5. IMAP goes down from time to time (Juan Felipe Estrada)
6. Re: VZW Blackberry BIS problems? (Patrick Domack)
7. Re: IMAP goes down from time to time (Andreas Ntaflos)
8. Re: IMAP goes down from time to time (Timo Sirainen)
9. Re: VZW Blackberry BIS problems? (Timo Sirainen)
----------------------------------------------------------------------
Message: 1
Date: Tue, 20 Oct 2009 12:49:16 -0400
From: Jerry <ges...@yahoo.com>
Subject: Re: [Dovecot] Need a little shadow to MySQL conversion help
To: dovecot@dovecot.org
Message-ID: <20091020124916.114b8...@scorpio.seibercom.net>
Content-Type: text/plain; charset=US-ASCII
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.
password_query = SELECT password FROM view_users WHERE email='%u';
SELECT password, email AS user FROM ..
changes username to same case as it's in the database (so lowercase
probably) and there's no need to use %L anymore.
You mean something like
SELECT password, LOWER(email) as user FROM view_users WHERE email='%u'
should do the trick? I shall test this on my test server, just for
fun.
Andreas
