dovecot - Nov 2006 - MySQL Configuration

Dovecot 1.0.rc10
FreeBSD 6.1

This is probably a dumb question; however, I have never let a little thing 
like that bother me in the past.

In the 'dovecot.conf' file there are the follow two sections:

  # SQL database
  passdb sql {
    # Path for SQL configuration file, see doc/dovecot-sql.conf for example
    args = /usr/local/etc/dovecot-sql.conf
  }

  userdb sql {
    # Path for SQL configuration file, see doc/dovecot-sql.conf for example
    args = /usr/local/etc/dovecot-sql.conf
  }

I keep the 'users' and their respective 'passwords' in the same
MySQL
database. I am not sure why I wouldn't. Therefore, would it not make more 
sense to have just one MySQL configuration line in the 'dovecot.conf'
file
rather than two, or am I missing something here?


-- 
Gerard Seibert
gerard at seibercom.net

Laws are like sausages.  It's better not to see them being made.

	Otto von Bismarck
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url :
http://dovecot.org/pipermail/dovecot/attachments/20061104/7b1f8d7d/attachment-0001.pgp

On Sat, 2006-11-04 at 11:06 -0500, Gerard Seibert wrote:
> I keep the 'users' and their respective 'passwords' in the
same MySQL
> database. I am not sure why I wouldn't. Therefore, would it not make
more
> sense to have just one MySQL configuration line in the
'dovecot.conf' file
> rather than two, or am I missing something here?
It is not a matter of where information is stored. At authentication you need
username and password. At mail delivery you need address and mailbox location.
Dovecot allows you to do prefetching of userdb data in the passdb query and
use just one query. However for some features to work you still need a valid,
non prefetch userdb configuration (e.g. Dovecot LDA).

ciao

Luca