From owner-freebsd-isp Wed Jul 5 13:43:18 2000 Delivered-To: freebsd-isp@freebsd.org Received: from com4u.ch (mail.niamh.com [195.129.74.66]) by hub.freebsd.org (Postfix) with ESMTP id 54E8437C01D for ; Wed, 5 Jul 2000 13:42:26 -0700 (PDT) (envelope-from micheal@com4u.ch) Received: from [194.230.199.33] (HELO [194.230.199.33]) by com4u.ch (CommuniGate Pro SMTP 3.3b5) with ESMTP id 1423581; Wed, 05 Jul 2000 22:44:08 +0200 Mime-Version: 1.0 X-Sender: micheal@mail.com4u.ch Message-Id: In-Reply-To: References: Date: Wed, 5 Jul 2000 22:42:04 +0200 To: "Troy Settle" , freebsd-isp@freebsd.org From: Michael O Shea Subject: RE: Centralised user information Content-Type: text/plain; charset="us-ascii" ; format="flowed" Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org >** We avoid sys users like the plague here. For hosting and such we >** store the user in PostGres. Onec that is done Radiator can access >** them and ProFTP can access them and CHROOT them into their home dirs. >** YOu could also get Apache to auth against the PostGres database and >** mailservers is not a prob either. > >What are you doing about mail? > >At one time, I had Postfix and Cyrus 1.5.something working against a MySQL >database, but the creation of Cyrus mailboxes was not automatic (severe >PITA). I haven't seen any other reasonable POP3/IMAP combo that can auth >through a database at all, so I'm kinda stuck. > >-Troy Well you can run Postfix against Postgres I think. We have just bought Joydesk for a free mailservice that we are rolling out, which will auth against any SQL db. Its primary dev platform is on FreeBSD and its pretty well tested. See http://www.joydesk.com. MY present mailserver is CommuniGate pro http://www.stalker.com/CGatePro.html which is one of the best servers I have ever seen and now can auth against LDAP. This is very beautifull in that you can define Domain Level Admins and just set the limits on a per domain basis and let the domain owner add/delete accounts and all that stuff and not care about what and how many accounts each domain has. It has saved us many man hours in setup of email here. -- Micheal O Shea Email:micheal@com4u.ch com4u.ch http://www.com4u.ch Breitistrasse 7B PGP key available upon request. CH-5506 Maegenwil Tel: +41 62 896 46 26 Switzerland To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message