From owner-freebsd-questions Thu Aug 8 20:53:26 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C8F0B37B401 for ; Thu, 8 Aug 2002 20:53:23 -0700 (PDT) Received: from boris.st.hmc.edu (boris.ST.HMC.Edu [134.173.63.11]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1AA6243E6E for ; Thu, 8 Aug 2002 20:53:23 -0700 (PDT) (envelope-from jeff@unixconsults.com) Received: from boris.st.hmc.edu (localhost [127.0.0.1]) by boris.st.hmc.edu (8.12.3/8.12.3) with ESMTP id g793rMue001212; Thu, 8 Aug 2002 20:53:22 -0700 (PDT) Received: from localhost (jeff@localhost) by boris.st.hmc.edu (8.12.3/8.12.3/Submit) with ESMTP id g793rMVN001209; Thu, 8 Aug 2002 20:53:22 -0700 (PDT) (envelope-from jeff@unixconsults.com) X-Authentication-Warning: boris.st.hmc.edu: jeff owned process doing -bs Date: Thu, 8 Aug 2002 20:53:22 -0700 (PDT) From: Jeff Jirsa X-X-Sender: jeff@boris.st.hmc.edu To: Brian McCann Cc: freebsd-questions@FreeBSD.ORG Subject: RE: htpasswd / Apache In-Reply-To: <000101c23f54$dcaea130$2e00a8c0@dogbert> Message-ID: <20020808204306.L1167-100000@boris.st.hmc.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-milter on boris.st.hmc.edu Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Thu, 8 Aug 2002, Brian McCann wrote: > I've tried it...but I could NEVER get it to work right with encrypted > passwords. This was actually what I tried first...but since I could > only get it to work with clear text passwords, I gave up on it. My > problem was no matter where I grabbed the PW from to put into the db > (using htpasswd or crypt), I could never authenticate right. Do you > have any example code or a site I could look at to help me out for how > to add people into the DB using encrypted PWs? Preferably MD5. > This link has always worked well for me ... http://www.cgi101.com/class/password/mod_auth_mysql.html The directive to notice is : Auth_MySQL_Encryption_Types Crypt_DES Everything else should be pretty much self explainatory ... MD5 doesn't seem to be an option. Adding them is trivial ... but just in case ... once connected to the db, issue a command similar to: INSERT INTO http_auth (username,passwd,groups) VALUES("username","cryptedpass","default"); - Jeff To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message