Apache 2.2 and Postgres
in [Ports]
|
From: Roman Bogorodskiy on 18 Aug 2006 03:52 --1ccMZA6j1vT5UqiK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable alan bryan wrote: > On 8/18/06, Roman Bogorodskiy <novel(a)freebsd.org> wrote: > >> 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? > > > >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. >=20 > Are you sure about that? Oh, you're right, I missed that. > # pwd > /usr/ports/www/apache22 >=20 > # more Makefile.doc > # Makefile.doc > # Author: Clement Laforet=20 > <clement(a)FreeBSD.org> > # > # 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=20 > clement Ex > p $ > # >=20 > ## Available knobs: > ## By default, modules are compiled as dynamically loadable (DSO) modules. > ## >=20 > ....blah, blah.... >=20 > ## WITH_(MYSQL|PGSQL|SQLITE): Enable SQL backend *dbd >=20 > 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. >=20 > 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: Yeah, I had the same error. It fixed by placing line "LoadModule auth_pgsql_module libexec/apache22/mod_auth_pgsql.so" before other "LoadModule" entries (that sound rather weird, yes). > AuthName "Administration Area" > AuthType basic >=20 > 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 >=20 > require user username >=20 > 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? >=20 > Thanks! >=20 > --Alan > _______________________________________________ > freebsd-ports(a)freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-ports > To unsubscribe, send any mail to "freebsd-ports-unsubscribe(a)freebsd.org" --1ccMZA6j1vT5UqiK Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (FreeBSD) iQCVAwUBROVw/4B0WzgdqspGAQIfogQAw0Hrj7Cp39xSpE82rNNjOZXyXvQlUdUm Vx79hOqBfryVrCc8YdCXsCiUmyuP2pztpIZCCvz1xkZIRtsiXoVSk+Mj8/RNthHI CKT2KeccbSTi7QuVigRW2Z5dd2BiHMKEjpCcnX2bt8JNubK/Nj+YtoVRj05aOkOh 74FckUDLcgI= =hYA3 -----END PGP SIGNATURE----- --1ccMZA6j1vT5UqiK--
From: "alan bryan" on 18 Aug 2006 12:19 On 8/18/06, Roman Bogorodskiy <novel(a)freebsd.org> wrote: > > 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: > > Yeah, I had the same error. It fixed by placing line > "LoadModule auth_pgsql_module libexec/apache22/mod_auth_pgsql.so" > before other "LoadModule" entries (that sound rather weird, yes). That does sound weird but it did solve the problem for me too. Thanks! For now I'll just continue using mod_auth_pgsql2 although I still think there is something wrong with the DBD and PGSQL things in the www/apache22 port. Hopefully someone with more experience in this than I can take a look at the way the port builds and links against PGSQL and see if they can get it to work. I was getting none of the dbd related .so to link against the pgsql libs which is why nothing dbd related was working. _______________________________________________ freebsd-ports(a)freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscribe(a)freebsd.org"
From: Clement Laforet on 19 Aug 2006 07:29 --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--
First
|
Prev
|
Pages: 1 2 Prev: FreeBSD Apache HTTP Accept Filter Error Next: error compiling dsniff on FreeBSD, |