From owner-freebsd-ports@FreeBSD.ORG Sat Aug 19 11:25:22 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 441EC16A5B3 for ; Sat, 19 Aug 2006 11:25:13 +0000 (UTC) (envelope-from sheepkiller@cultdeadsheep.org) Received: from goofy.cultdeadsheep.org (charon.cultdeadsheep.org [80.65.226.72]) by mx1.FreeBSD.org (Postfix) with SMTP id 9F49E43D46 for ; Sat, 19 Aug 2006 11:25:11 +0000 (GMT) (envelope-from sheepkiller@cultdeadsheep.org) Received: (qmail 94263 invoked by uid 1000); 19 Aug 2006 13:25:10 +0200 Date: Sat, 19 Aug 2006 13:25:10 +0200 From: Clement Laforet To: alan bryan Message-ID: <20060819112509.GD43378@goofy.cultdeadsheep.org> References: <892916310608171424x2d278a6ak7588509567cdb633@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="eqp4TxRxnD4KrmFZ" Content-Disposition: inline In-Reply-To: <892916310608171424x2d278a6ak7588509567cdb633@mail.gmail.com> User-Agent: Mutt/1.5.10i Cc: freebsd-ports@freebsd.org 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: Sat, 19 Aug 2006 11:25:22 -0000 --eqp4TxRxnD4KrmFZ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Alan, On Thu, Aug 17, 2006 at 02:24:31PM -0700, alan bryan wrote: > Hi, >=20 > I'm trying to get Apache 2.2 and Postgres to work together so that I > can use mod_authn_dbd. >=20 > I think the problem is that APR is not being passed the correct > arguments so that it configures with PGSQL support. >=20 > # ldd /usr/local/libexec/apache22/mod_authn_dbd.so > /usr/local/libexec/apache22/mod_authn_dbd.so: > # ldd /usr/local/libexec/apache22/mod_dbd.so > /usr/local/libexec/apache22/mod_dbd.so: >=20 > Shouldn't there be various pgsql things listed here? No. dbd relies on apr-util. mod_authn_dbd -> mod_dbd -> libaprutil.so. > I compiled ports/apache22 with WITH_PGSQL=3Dyes and also tried > WITH_PGSQL=3D/usr/local/pgsql with no changes in result. Am I doing > something wrong here? No, except WITH_PGSQL is just a flag, you can't pass a customized=20 path to WITH_PGSQL (it uses bsd.databases.mk).=20 I don't use pgsql and I tested with gforge sample config file: here what I got: # make WITH_PGSQL=3Dyes install clean ## ldd /usr/local/lib/libaprutil-1.so =20 /usr/local/lib/libaprutil-1.so: libpq.so.3 =3D> /usr/local/lib/libpq.so.3 (0x8817b000) libexpat.so.6 =3D> /usr/local/lib/libexpat.so.6 (0x88237000) libiconv.so.3 =3D> /usr/local/lib/libiconv.so.3 (0x88255000) libapr-1.so.2 =3D> /usr/local/lib/libapr-1.so.2 (0x88342000) libcrypt.so.3 =3D> /lib/libcrypt.so.3 (0x88362000) libpthread.so.2 =3D> /usr/lib/libpthread.so.2 (0x8837a000) libintl.so.6 =3D> /usr/local/lib/libintl.so.6 (0x8839f000) libssl.so.4 =3D> /usr/lib/libssl.so.4 (0x883a8000) libcrypto.so.4 =3D> /lib/libcrypto.so.4 (0x883d6000) libm.so.4 =3D> /lib/libm.so.4 (0x884c9000) libz.so.3 =3D> /lib/libz.so.3 (0x884df000) #cat /usr/local/etc/apache22/Includes/pg.conf=20 DBDriver pgsql DBDParams "dbhost=3Dlocalhost dbname=3Dgforge user=3Dgforge pass=3Dxxxxx" DBDMin 1 DBDKeep 2 DBDMax 10 DBDExptime 60 # grep _dbd /usr/local/etc/apache22/httpd.conf=20 LoadModule authn_dbd_module libexec/apache22/mod_authn_dbd.so LoadModule dbd_module libexec/apache22/mod_dbd.so # /usr/local/etc/rc.d/apache22.sh restart # grep DBD /var/log/httpd-error.log| head -2 [Sat Aug 19 13:20:25 2006] [crit] (20014)Internal error: DBD: Can't connect= to pgsql [Sat Aug 19 13:20:25 2006] [crit] (20014)Internal error: DBD: failed to ini= tialise Driver is found. Please ensure you have all modules activated. When reinstalling=20 apache, LoadModule list isn't updated if httpd.conf exists. regards, clem --eqp4TxRxnD4KrmFZ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFE5vUVsRhfjwcjuh0RArEoAJ93EZ8QrPP0B4+bFoiVXKpBaavmQwCguosD +7iHN8aG2T+BfGoeN6nkNPI= =YLvw -----END PGP SIGNATURE----- --eqp4TxRxnD4KrmFZ--