Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4E405632375 for ; Fri, 10 Apr 2009 23:13:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 34036-01 for ; Fri, 10 Apr 2009 23:13:03 -0300 (ADT) X-Greylist: delayed 00:10:53.535561 by SQLgrey-1.7.6 Received: from emerald.lightlink.com (emerald.lightlink.com [64.57.176.19]) by mail.postgresql.org (Postfix) with ESMTP id CB6106321F7 for ; Fri, 10 Apr 2009 23:13:03 -0300 (ADT) Received: from [172.16.10.72] (cpe-24-58-18-216.twcny.res.rr.com [24.58.18.216]) by emerald.lightlink.com (8.9.3p2/8.8.8) with ESMTP id WAA23463 for ; Fri, 10 Apr 2009 22:02:08 -0400 Message-ID: <49DFFA17.9060000@lightlink.com> Date: Fri, 10 Apr 2009 22:01:59 -0400 From: Bob McConnell User-Agent: Thunderbird 2.0.0.21 (X11/20090302) MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: phpinfo() doesn't show postgres as a configured module References: <49DFEA88.2070800@pinpointresearch.com> In-Reply-To: <49DFEA88.2070800@pinpointresearch.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/4 X-Sequence-Number: 4009 Steve Crawford wrote: > my extraidentity wrote: >> >> When I run the PHP function phpinfo() on my server that has both >> Apache and PHP on it, it doesn't show postgres as a configured >> module. I am running Apache version 2.0.54 and PHP version 5.2.8 >> (however the phpinfo() function displays that it is version 5.0.4 >> ; what is up with that???) >> >> What command do I need to run to get the postgres module to work >> with PHP? I have tried to configure the server this way and it >> didn't seem to fix it: >> >> ./configure --with-pgsql=/usr/local/pgsql/ >> --with-apxs2=/usr/local/apache2/bin/apxs >> make >> >> Any ideas what I am doing wrong? >> > Multiple things, possibly. What OS and how did you install PHP and PG? > > I'll venture a guess that you somehow installed PHP and/or PG with > whatever system installer your disro uses (yum? apt?...) and it ended up > wherever that distro specifies. Then you compiled some stuff from source > and it ended up in the "normal" locations defined by the source/makefile > defaults and you have ended up with two or more versions (5.0.4/5.2.8) > of PHP. You could even end up with Apache seeing one version and PHP > command-line seeing a different one. Once you sort that out, be sure to > enable PG in php.ini. > > Cheers, > Steve If phpinfo() doesn't show the Postgres options, it was compiled without them. That's the same problem I have with Slackware. The packaged version of PHP only includes the MySQL addictionware. No matter what I do, I can't get it configured my way. So I don't install those packages, but get the source for Apache, PHP and Postgres. That's the only way I can make sure they get compiled and installed with my choice of options, not those of someone with a hidden agenda trying to promote an inferior product. Bob McConnell N2SPP