From owner-freebsd-ports@FreeBSD.ORG Fri Aug 18 07:29:06 2006 Return-Path: X-Original-To: freebsd-ports@freebsd.org Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 99E6316A4DD for ; Fri, 18 Aug 2006 07:29:06 +0000 (UTC) (envelope-from alan.bryan@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by mx1.FreeBSD.org (Postfix) with ESMTP id C551943D53 for ; Fri, 18 Aug 2006 07:29:05 +0000 (GMT) (envelope-from alan.bryan@gmail.com) Received: by nf-out-0910.google.com with SMTP id n29so1348878nfc for ; Fri, 18 Aug 2006 00:29:04 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=pE/hwITI41BysDcpx5+DfDDPQq4heDq/T++VFIyxlqw6tBco04PVchoo+eD7wm6Zcu9UBr8NcDj3ZuNXSg5eaCZCsy61CnE5wBNhJF2Y6rSl1tovlW7Hdscrp1YRRi5zj11yQHED51+aMSPfDVQpaaWYwwYWWYVm0vaetZOI+mE= Received: by 10.49.93.13 with SMTP id v13mr3680924nfl; Fri, 18 Aug 2006 00:29:04 -0700 (PDT) Received: by 10.49.93.1 with HTTP; Fri, 18 Aug 2006 00:29:04 -0700 (PDT) Message-ID: <892916310608180029g1e0869e7k2387f64c766f7560@mail.gmail.com> Date: Fri, 18 Aug 2006 00:29:04 -0700 From: "alan bryan" To: freebsd-ports@freebsd.org In-Reply-To: <20060818070230.GC78016@underworld.novel.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <892916310608171424x2d278a6ak7588509567cdb633@mail.gmail.com> <20060818070230.GC78016@underworld.novel.ru> Subject: Re: Apache 2.2 and Postgres X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 18 Aug 2006 07:29:06 -0000 On 8/18/06, Roman Bogorodskiy wrote: > > I compiled ports/apache22 with WITH_PGSQL=yes and also tried > > WITH_PGSQL=/usr/local/pgsql with no changes in result. Am I doing > > something wrong here? > > Hm... www/apache22 port has no WITH_PGSQL knob. I was figthing with > apache22 + authentification via postgresql few days ago and now it works > here with www/mod_auth_pgsql2. Are you sure about that? # pwd /usr/ports/www/apache22 # more Makefile.doc # Makefile.doc # Author: Clement Laforet # # This files contains: # - make options output # - apache2 man/docs routines # # $FreeBSD: ports/www/apache22/Makefile.doc,v 1.9 2006/05/10 19:47:15 clement Ex p $ # ## Available knobs: ## By default, modules are compiled as dynamically loadable (DSO) modules. ## ...blah, blah.... ## WITH_(MYSQL|PGSQL|SQLITE): Enable SQL backend *dbd So, I saw that and thought that WITH_PGSQL is valid. So, you are saying that it is not? That would help explain some of the problems I'm seeing. I could use (and have in the past on apache 2.0) www/mod_auth_pgsql2 but I was getting "No Authn provider configured" with the following .htaccess: AuthName "Administration Area" AuthType basic Auth_PG_host localhost Auth_PG_port 5432 Auth_PG_encrypted on Auth_PG_user pgsql Auth_PG_database dbname Auth_PG_pwd_table users Auth_PG_uid_field username Auth_PG_pwd_field password require user username which worked fine in apache 2.0. So, what parts of the new auth stuff do you have loaded in your httpd.conf that you don't get that error? It sounds like I was getting some of the new auth stuff to start trying to do things as a result of the AuthType basic line but I'm not sure what else to put there. Can you share some of your setup details? Thanks! --Alan