Thread: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!! PLEASE HELP

Help! I was trying to make an installation of PHP 5.1.2 + Apache
2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
got PHP to work with Apache quite smoothly, so did I marry PHP with
PostgreSQL - scripts connecting to the database work fine from
windows command line, except that the following code:

if (extension_loaded("php_pgsql")) {
echo "PGSQL loaded!";
}

returns no message. Still database queries work fine. Trouble starts
when I try to open a page in my browser - then I get an error
message like this:

Error: call to udefined function pg_connect()...

I changed the php.ini file a billion times, trying to figure out
what to set in the "extension_dir" and "extension=php_pgsql.dll"
lines, and I tried at least as many times to change apache's
httpd.conf file so that the php module is loaded properly. And it
is, as far as I'm concerned - the phpinfo() page shows without a
problem. One peculiar thing about it is that in the "Loaded
modules" section (don't remember the exact name) there's absolutely
no sign of the pgsql module.

I also tried downloading and installing the latest php snapshot,
because someone on a forum told me it might work, but it didn't :o(
I even tried earlier versions of Apache and PHP, but nothing
worked. Initially I figured I must have found a bug, but I don't
really believe it could've gone on for so long without being
noticed by somebody...

I'm begging for help, because the person I'm doing the server for
strongly insists on the machine working on Win 2003 and not some
distribution of linux or unix.

Regards,
krzysieq


--
Nie przychodz! Nie przyjezdzaj! Nie dzwon! Zamow ogloszenie drobne do "Gazety Wyborczej" przez internet wchodzac na
http://www.aaaby.pl/wyborczai wygraj nawet 10.000 zl! 

On 4/27/06, belfegor666@gazeta.pl <belfegor666@gazeta.pl> wrote:
> Help! I was trying to make an installation of PHP 5.1.2 + Apache
> 2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
> got PHP to work with Apache quite smoothly, so did I marry PHP with
> PostgreSQL - scripts connecting to the database work fine from
> windows command line, except that the following code:
>
> if (extension_loaded("php_pgsql")) {
> echo "PGSQL loaded!";
> }
>
> returns no message. Still database queries work fine. Trouble starts
> when I try to open a page in my browser - then I get an error
> message like this:
>
> Error: call to udefined function pg_connect()...
>
> I changed the php.ini file a billion times, trying to figure out
> what to set in the "extension_dir" and "extension=php_pgsql.dll"
> lines, and I tried at least as many times to change apache's
> httpd.conf file so that the php module is loaded properly. And it
> is, as far as I'm concerned - the phpinfo() page shows without a
> problem. One peculiar thing about it is that in the "Loaded
> modules" section (don't remember the exact name) there's absolutely
> no sign of the pgsql module.

Copied straight from my reply on the general list.

you could change the first check to:

if (!function_exists('pg_connect')) {
 die("no pg_connect");
}

What does:

print_r(get_loaded_extensions());

show?

Anything regarding pgsql?

Does your server keep logs? Maybe something in there will give you
some ideas about what's going on..

--
Postgresql & php tutorials
http://www.designmagick.com/

Ok, not to worry, first of all, look at the output to phpinfo() again.
Look in the top section for the "Configuration File (php.ini) Path";
in my case, "C:\WINDOWS\php.ini". Ensure that this is the one you're
editting. If it isn't, thats your problem. If it is...

Your "extension_dir" setting should be your php folder with "/ext"
tabbed on the end, so in my case:

extension_dir = "c:/php/ext/"

Note the forward slashes.

Next, ensure that "php_pgsql.dll" exists in the c:\php\ext directory,
and then check that the following exists in the dynamic extensions
section:

extension=php_pgsql.dll

I'd bet you're just editting the wrong php.ini - Been there, done that :)

Neil.

On 4/27/06, belfegor666@gazeta.pl <belfegor666@gazeta.pl> wrote:
> Help! I was trying to make an installation of PHP 5.1.2 + Apache
> 2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
> got PHP to work with Apache quite smoothly, so did I marry PHP with
> PostgreSQL - scripts connecting to the database work fine from
> windows command line, except that the following code:
>
> if (extension_loaded("php_pgsql")) {
> echo "PGSQL loaded!";
> }
>
> returns no message. Still database queries work fine. Trouble starts
> when I try to open a page in my browser - then I get an error
> message like this:
>
> Error: call to udefined function pg_connect()...
>
> I changed the php.ini file a billion times, trying to figure out
> what to set in the "extension_dir" and "extension=php_pgsql.dll"
> lines, and I tried at least as many times to change apache's
> httpd.conf file so that the php module is loaded properly. And it
> is, as far as I'm concerned - the phpinfo() page shows without a
> problem. One peculiar thing about it is that in the "Loaded
> modules" section (don't remember the exact name) there's absolutely
> no sign of the pgsql module.
>
> I also tried downloading and installing the latest php snapshot,
> because someone on a forum told me it might work, but it didn't :o(
> I even tried earlier versions of Apache and PHP, but nothing
> worked. Initially I figured I must have found a bug, but I don't
> really believe it could've gone on for so long without being
> noticed by somebody...
>
> I'm begging for help, because the person I'm doing the server for
> strongly insists on the machine working on Win 2003 and not some
> distribution of linux or unix.
>
> Regards,
> krzysieq
>
>
> --
> Nie przychodz! Nie przyjezdzaj! Nie dzwon! Zamow ogloszenie drobne do "Gazety Wyborczej" przez internet wchodzac na
http://www.aaaby.pl/wyborczai wygraj nawet 10.000 zl! 
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>