Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 - Mailing list pgsql-php
From | |
---|---|
Subject | Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 |
Date | |
Msg-id | 9789220.35641146153563864.JavaMail.webadm@ew10 Whole thread Raw |
Responses |
Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34
|
List | pgsql-php |
>> 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... It actually is "C:\WINDOWS" (not C:\WINDOWS\php.ini), but the file wasn't there. I copied it and adjusted so that the relevant lines match the new location. Still no effect. >> 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. Done. It is: "c:/php5/ext/". I also tried "C:/PHP5/ext/" and the same with backslashes. No effect. >> 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 Done. It's there, all right. >> >> I'd bet you're just editting the wrong php.ini - Been there, >> done that :) I probably was. Unfortunately, editing the right one (which was missing, by the way) didn't do me no good. Any other ideas, what might I be doing wrong? >> >> Neil. Thanks, Chris. 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/wyborcza i 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 > -- 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!