From owner-freebsd-isp@FreeBSD.ORG  Wed Mar 16 20:42:31 2005
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
Delivered-To: freebsd-isp@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 3B77D16A4CF
	for <freebsd-isp@freebsd.org>; Wed, 16 Mar 2005 20:42:31 +0000 (GMT)
Received: from saturn.bueller.ca (c180636.static.uniserve.ca [216.113.195.89])
	by mx1.FreeBSD.org (Postfix) with SMTP id 4C68943D2D
	for <freebsd-isp@freebsd.org>; Wed, 16 Mar 2005 20:42:30 +0000 (GMT)
	(envelope-from matt@bueller.ca)
Received: (qmail 68638 invoked by uid 89); 16 Mar 2005 20:57:56 -0000
Received: from trapdoor.netbistro.com (HELO ?192.168.1.103?) (204.239.167.96)
  by saturn.bueller.ca with SMTP; 16 Mar 2005 20:57:56 -0000
Message-ID: <42389A66.40605@bueller.ca>
Date: Wed, 16 Mar 2005 12:43:18 -0800
From: Matt Ferris <matt@bueller.ca>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "Scott St. John" <scott@scottah.com>
References: <200503161844.j2GIinBi053119@kelly.talon.net>
In-Reply-To: <200503161844.j2GIinBi053119@kelly.talon.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
cc: freebsd-isp@freebsd.org
Subject: Re: FTP controlled by SQL
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 16 Mar 2005 20:42:31 -0000

On 3/16/2005 10:45 AM,Scott St. John wrote:
> Hi-
> 
> I have a client who wants to be able to add/remove users to an FTP site. 
> They do not have access to the machine so this sounds like a job for PHP and
> MySQL.  I have been trying (pulling hair out) with Proftp and MySQL.
> 
> My question is:  is anyone on the list doing something like this and what
> are you using?
> 
> Thanks!
> 
> -Scott

We have ProFTP authenticating via a MySQL database. It was a little 
tricky to setup given the ProFTP site is restructuring their documentation.

You can find some help at 
http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-SQL.html

--
Matt Ferris
matt@bueller.ca