From owner-freebsd-questions@FreeBSD.ORG Wed Dec 26 23:14:04 2007 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 305B916A417 for ; Wed, 26 Dec 2007 23:14:04 +0000 (UTC) (envelope-from peter.schuller@infidyne.com) Received: from smtp.infidyne.com (ds9.infidyne.com [88.80.6.206]) by mx1.freebsd.org (Postfix) with ESMTP id AE9C713C459 for ; Wed, 26 Dec 2007 23:14:03 +0000 (UTC) (envelope-from peter.schuller@infidyne.com) Received: from c-8216e555.03-51-73746f3.cust.bredbandsbolaget.se (c-8216e555.03-51-73746f3.cust.bredbandsbolaget.se [85.229.22.130]) by smtp.infidyne.com (Postfix) with ESMTP id ABBBA759C2; Thu, 27 Dec 2007 00:14:01 +0100 (CET) From: Peter Schuller To: freebsd-questions@freebsd.org Date: Thu, 27 Dec 2007 00:13:50 +0100 User-Agent: KMail/1.9.7 References: <200712261534.03553.af300wsm@gmail.com> In-Reply-To: <200712261534.03553.af300wsm@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart3547821.RgcfIH46jf"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200712270013.58919.peter.schuller@infidyne.com> Cc: Andrew Falanga Subject: Re: dovecot questions X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Dec 2007 23:14:04 -0000 --nextPart3547821.RgcfIH46jf Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline > configuration isn't quite so simple. There were several in this list that > suggested the use of Dovecot when I inquired for suggestions as to a good > POP/IMAP server. I'll add my recommendation to that (having used courier in the past). > So, I'm hoping that these same folks can offer help in getting me running. > The WIKI for Dovecot is helpful, but seems to assume much in terms of what > the reader will understand. How do I add users to the system? If I've > done my work correctly, I've setup my Dovecot system to store virtual use= rs > in a PostgreSQL database. However, how do I add users?=20 Dovecot doesn't really care. You provide the method of obtaining the user l= ist=20 from the database, in the form of SQL statements (assuming they differ from= =20 defaults), and it's up to you to make sure this returns the appropriate=20 information (so in other words, dovecot doesn't add users for you). I used to run a pg+dovecot+postfix, but have since moved away from it and I= =20 don't have the configs easily accessible to check out specifics. But=20 googling, this should be useful in terms of providing a bunch of real-world= =20 configuration examples: http://www.gjdv.at/snippets/linux/virtual_mail_hosting > Also, with respect to the configuration file (dovecot.conf) why are there > so many passdb/userdb? If I have passdb sql "turned on", should I "turn > off" all other passdb sections? What is the significance of the userdb > static { } section in that file? It appears that it is necessary for use > if using a single user to access several mailboxes (i.e. virtual users > which is what I want to implement). Is this true? I can't answer each one of the above off hand, but things like uids is=20 controlled by the user database that it sounds like you want to keep in=20 PostgreSQL. This includes the ability to set the uid/gid, which you can hav= e=20 different for each user, the same, or some combination thereof, on a per-us= er=20 basis. Your exact table design is up to you, as long as you can give doveco= t=20 the appropriate SQL statements for obtaining relevant information. > If I'm understanding things correctly, the next, very important item, is > how do I setup new users and how would those users then manage things like > passwords, etc.? This is up to you. dovecot does not provide and user interfaces for managin= g=20 accounts (that I am aware of). Typically a reason to have the user database= =20 in a relational database would be to enable the construction of such=20 interfaces, or perhaps use of existing tools. But unless I am missing=20 something, user management is beyond the scope of what dovecot itself is=20 providing. =2D-=20 / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org --nextPart3547821.RgcfIH46jf Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQBHcuA2DNor2+l1i30RAtcXAJ0WiOqjMKfeDAbsw4Q8XjYwVHgeYgCgtIjT X3yfj9OokfkIHwB/zKflMA4= =/d4r -----END PGP SIGNATURE----- --nextPart3547821.RgcfIH46jf--