Date: Sat, 19 Aug 2006 13:25:10 +0200 From: Clement Laforet <sheepkiller@cultdeadsheep.org> To: alan bryan <alan.bryan@gmail.com> Cc: freebsd-ports@freebsd.org Subject: Re: Apache 2.2 and Postgres Message-ID: <20060819112509.GD43378@goofy.cultdeadsheep.org> In-Reply-To: <892916310608171424x2d278a6ak7588509567cdb633@mail.gmail.com> References: <892916310608171424x2d278a6ak7588509567cdb633@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--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
<build and install cleanly>
## 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
<skip>
# 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060819112509.GD43378>