Обсуждение: Re: PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34
>> 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!
> 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. 1. did you rrestart apache before checking if anything changed? 2. check this link for throough instructions how to get everything working - it works on xp home since i've done it twice. my guess is works on 2003, too. http://www.geocities.com/operationsengineer1/ is php_pgsql.dll showing up as installed when you run phpinfo()? it could be that your php.ini file isn't being read. i have instructions for how to set up an environment variable that will automatically read php.ini in the php set of instructions (i think - it is one of the three). good luck. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Thanks for help, everyone :o) I finally got it working. Here's how I did it, by the way, if enyone encounters the same problem. It turned out I actually was editing the wrong php.ini, since the one in my c:\php5 folder was never even read by apache. This is odd because I checked a thousand times, and I bet my ass I had the PHPIniDir directive set to C:\php5 in my httpd.conf. I tried various approaches to this - forward slash, trailing slash, moving the php directory somewhere else - nothing. php.ini would always be looked for in c:\windows directory, nowhere else. Seems as though Windows knows better where to look for this file than apache itself, because the phpinfo() would show that php.ini was in c:\windows :o[[ Everything works pretty neat right now. Thanks for help again Chris Thursday, April 27, 2006, 8:01:17 PM, you wrote: >> 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. oyc> 1. did you rrestart apache before checking if anything oyc> changed? oyc> 2. check this link for throough instructions how to oyc> get everything working - it works on xp home since oyc> i've done it twice. my guess is works on 2003, too. oyc> http://www.geocities.com/operationsengineer1/ oyc> is php_pgsql.dll showing up as installed when you run oyc> phpinfo()? it could be that your php.ini file isn't oyc> being read. i have instructions for how to set up an oyc> environment variable that will automatically read oyc> php.ini in the php set of instructions (i think - it oyc> is one of the three). oyc> good luck. oyc> __________________________________________________ oyc> Do You Yahoo!? oyc> Tired of spam? Yahoo! Mail has the best spam protection around oyc> http://mail.yahoo.com oyc> ---------------------------(end of oyc> broadcast)--------------------------- oyc> TIP 2: Don't 'kill -9' the postmaster oyc> -- oyc> Nie przychodz! Nie przyjezdzaj! Nie dzwon! Zamow ogloszenie oyc> drobne do "Gazety Wyborczej" przez internet wchodzac na oyc> http://www.aaaby.pl/wyborcza i wygraj nawet 10.000 zl! oyc> --- oyc> avast! antivirus: Incoming message clean. oyc> Virus signature database (VPS): 0617-3, 2006-04-28 oyc> Tested on: 2006-04-30 15:38:14 oyc> avast! - Copyright (c) 1988-2006 ALWIL Software. oyc> http://www.avast.com mailto:belfegor666@gazeta.pl --- avast! antivirus: Outgoing message clean. Virus signature database (VPS): 0617-3, 2006-04-28 Tested on: 2006-04-30 15:54:00 avast! - Copyright (c) 1988-2006 ALWIL Software. http://www.avast.com -- 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!