From owner-freebsd-isp Fri Mar 16 8:25:29 2001 Delivered-To: freebsd-isp@freebsd.org Received: from sunny.fishnet.com (sunny.fishnet.com [209.150.200.6]) by hub.freebsd.org (Postfix) with ESMTP id DF71737B719 for ; Fri, 16 Mar 2001 08:25:25 -0800 (PST) (envelope-from hhudson@eschelon.com) Received: from walleye.corp.fishnet.com (209.150.192.114) by sunny.fishnet.com (5.0.048) id 3AA5BD700007DBA6 for freebsd-isp@freebsd.org; Fri, 16 Mar 2001 10:25:45 -0600 Message-ID: <2FA3BA0C7551724CA6DDF4E3453605050AF442@walleye.corp.fishnet.com> From: "Hudson, Henrik H." To: "'freebsd-isp@freebsd.org'" Subject: PAM and MySQL Date: Fri, 16 Mar 2001 10:28:51 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hello List- I tried this on questions, but didn't hear anything back so I will try it over here :) I am working through some theoretical setups in my mind and I have come to a stumbling block. Of course, I might just be missing something. We are an ISP which offers web hosting on FreeBSD and Debian boxes and some Windows2000 boxes. For the most part it is FTP access only with a few shell accounts creeping in here and there. I know ProFTPD has a mySQL plugin to handle authentication and I am fairly confident that I could figure out the PAM authentication to a mySQL database but this only handles shell (telnet and ssh) login authentication, right? The stumbling block is that we run Apache in suEXEC mode and would like to continue doing this. If I have, let's say, 5 servers mounting webfiles to a central location how do those files know who their owner is for suEXEC purposes? Does PAM handle the UID and GID lookups too? For example, when you do a "ls -l" in a directory? or do we have to go to a NIS/NIS+ environment for this? I am an empty fountian, fill me with knowledge ;) Thanks in advance! --- Henrik Hudson Senior Systems Administrator -IP Services Eschelon Telecom, Inc. Phone: 612/436-6477 E-Mail: hhudson@eschelon.com General Help or Questions: sysadmin@eschelon.com Microsoft: "Where would you like to go to today" Linux: "Where would you like to go tomorrow" FreeBSD: "Hey, when are you guys going to catch up" To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message