Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3419E6335AF for ; Thu, 16 Apr 2009 20:02:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 05657-03 for ; Thu, 16 Apr 2009 20:02:39 -0300 (ADT) X-Greylist: delayed 00:06:38.596146 by SQLgrey-1.7.6 Received: from outbound-mail-343.bluehost.com (outbound-mail-343.bluehost.com [66.147.249.4]) by mail.postgresql.org (Postfix) with SMTP id E9EA46326FF for ; Thu, 16 Apr 2009 20:02:45 -0300 (ADT) Received: (qmail 15388 invoked by uid 0); 16 Apr 2009 22:50:19 -0000 Received: from unknown (HELO box498.bluehost.com) (66.147.242.98) by outboundproxy7.bluehost.com.bluehost.com with SMTP; 16 Apr 2009 22:50:19 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=consistentstate.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding:X-Antivirus:X-Antivirus-Status:X-Identified-User; b=WaRGal8LGX8X0Gdjaj7qhpPmlD5URl3OKQiFTYstJkucD1lIv4PfoskOnUuISbNzmORtsimL7BMTFi4LO8hNkGtbskMFuCdE6EN71Eq1XE1qt6WUz/5tBC9mybyIeGVz; Received: from 75-171-209-72.hlrn.qwest.net ([75.171.209.72] helo=[127.0.0.1]) by box498.bluehost.com with esmtpa (Exim 4.69) (envelope-from ) id 1LuaV2-0007uv-2Q for pgsql-php@postgresql.org; Thu, 16 Apr 2009 16:56:04 -0600 Message-ID: <49E7B777.8060507@consistentstate.com> Date: Thu, 16 Apr 2009 16:55:51 -0600 From: Brian Fehrle User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: phpinfo() doesn't show postgres as a configured module References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Antivirus: avast! (VPS 090416-0, 04/16/2009), Outbound message X-Antivirus-Status: Clean X-Identified-User: {3049:box498.bluehost.com:consist3:consistentstate.com} {sentby:smtp auth 75.171.209.72 authed with brianf+consistentstate.com} 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/5 X-Sequence-Number: 4010 I had this exact same problem too, and a friend and I just got it working. I'll show what we did. I am running Sabayon Linux 4.1 (built on Gentoo) PHP 5.2.8-r2 Apache 2.2.11 postgresql-server 8.3.5 Obviously it will depend on your configuration/distro/whatnot how you can change it, but for me, this is how I fixed it. I'm very new to the Linux world so I hope I phrase all this correctly. First I edited my make file. # nano /etc/make.conf In there is a line: USE="stuffystuff" At the very end I added "postgres" (minus the quotes) to the line, right before the last quote. (the line was broken up into multiple lines. Each line, except for the last, ends with \, be sure to not change any of that.) Saved the file. Then I emerged php and told it to use the make file. # emerge -N dev-lang/php This recompiled my php, took a little while. When that was done, I restarted the apache server. # /etc/init.d/apache2 restart When it restarted, I ran my php file with phpinfo(); on it and there was a new entry for pgsql listed. I hope this was of some help, I'm sure if you provide some information on your installation, someone can help do the same thing on your end. Good Luck, Brian 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? > > -Mark > > > ------------------------------------------------------------------------ > Windows Live™: Keep your life in sync. Check it out. >