From: Brian Fehrle <brianf@consistentstate.com>
To: pgsql-php@postgresql.org
Subject: Re: phpinfo() doesn't show postgres as a configured module
Date: Thu, 16 Apr 2009 16:55:51 -0600
Message-ID: <49E7B777.8060507@consistentstate.com> (raw)
In-Reply-To: <COL117-W42F89E1634351103FB8906B7810@phx.gbl>
References: <COL117-W42F89E1634351103FB8906B7810@phx.gbl>
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.
> <http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_042009;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: brianf@consistentstate.com
Subject: Re: phpinfo() doesn't show postgres as a configured module
In-Reply-To: <49E7B777.8060507@consistentstate.com>
References: <COL117-W42F89E1634351103FB8906B7810@phx.gbl> <49E7B777.8060507@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox