X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id F37D29FA5BA for ; Wed, 21 Jun 2006 02:26:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84696-04 for ; Wed, 21 Jun 2006 02:26:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.197]) by postgresql.org (Postfix) with ESMTP id E330F9FA4A6 for ; Wed, 21 Jun 2006 02:26:11 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s13so61347wxc for ; Tue, 20 Jun 2006 22:26:10 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=Xm3bgPpOHe+KJZcr/Isk37O2Js/gW2HBI826oMQnuOfyyb789UZXE+WRemaXFKYPLUDtYQ2twoMO+KWz+GlA/ErwtUrnMOfee3yrsdyt++qkdUg4oUZecleJx4EiSZoUyyEeg4CzateKlSP5ghai7tuIyUR1x9a+koBsqOvbFyA= Received: by 10.70.18.10 with SMTP id 10mr444845wxr; Tue, 20 Jun 2006 22:26:10 -0700 (PDT) Received: by 10.70.90.16 with HTTP; Tue, 20 Jun 2006 22:26:10 -0700 (PDT) Message-ID: <46ed1b650606202226o5458f380m98ea5e81c03a2587@mail.gmail.com> Date: Wed, 21 Jun 2006 01:26:10 -0400 From: "Parang Saraf" To: pgsql-php@postgresql.org Subject: problem enabling postgres in php MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_115493_30191704.1150867570739" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/17 X-Sequence-Number: 3542 ------=_Part_115493_30191704.1150867570739 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline hello, I am working with Postgresql 8.1.3, Apache 2.0.58 and PHP 5.1.4. on windows 2k. My phpinfo is working fine. But I am not able to enable postgres support. According to phpinfo the configuration file (php.ini) path is "C:\WINNT". All my extensions are in the "C:\php\ext" dir. I modified the php.ini file situated in the C:\WINNT dir as follows : extension_dir = "C:\php\ext and also removed the ';' (semicolon) infront of the extension=php_pgsql.dll with all the other extension being blocked by semicolon. Then I restarted the comp but it is not reflecting the changes in the phpinfo. Under the "php configuration core" phpinfo is showing the extension_dir as C:\php5 and include_path as ".;C:\php5\pear". But i dont have any directory named php5. So, i created a directory named php5 in C:\ and copied all the extension dlls into it and made a folder named pear in it and copied the php.ini file in it. But it still didnt reflect any changes. I doubt that it is not reading the php,ini file from the "C:\WINNT" directory. To check that I tried changing the color code of " highlight.string" from DD0000 to FF9900. I again restarted the comp but still it didnt reflect this change too. So, i think that it is using some other php.ini file. So, i searched for the php.ini file and i found it in the following locations : C:\WINNT\ C:\php5\ So, i made the same changes everywhere including the "php.ini-dist" and " php.ini-recommended" files found in C:\php dir. But still the problem persisted. Then I removed the php.ini file from the "C:\WINNT" dir but the phpinfo still worked even without it being present in the dir. I also tried reinstalling php several times but that also didnt help. But what I found strange was that i was not able to remove the "php5ts.dll" from the C:\WINNT dir and "php5apache2.dll" from the C:\php dir. Everytime it gave an error that these files are in use. I dont have any information about these files. Do i have to modify the "System Path variable" ?? I also tried modifying that too by adding C:\php and C:\php5 in it. I also added one more system variable PHPRC with the value C:\WINNT. But still i am not able to enable the postgres with php. I think there is no compatibility issues as google search gives some phpinfo links that works with the same version of php and postgres. When i try to connect to the database it gives the error "Call to undefined function pg_connect()" which i think is obvious as phpinfo is not showing postgres in it. It would be a great help if you could figure out the error and can help me enabling the postgres in php. I have been trying for the past 3 days to enable it. Thanks a lot for spending your valuable time. Regards Parang Saraf parang.saraf@gmail.com ------=_Part_115493_30191704.1150867570739 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline hello,

I am working with Postgresql 8.1.3, Apache 2.0.58 and PHP 5.1.4. on windows 2k.

My phpinfo is working fine. But I am not able to enable postgres support. According to phpinfo the configuration file (php.ini) path is "C:\WINNT".  All my extensions are in the  "C:\php\ext"  dir. I modified the php.ini file situated in the C:\WINNT dir as follows :

extension_dir = "C:\php\ext  and also removed the ';' (semicolon) infront of the extension=php_pgsql.dll  with all the other extension being blocked by semicolon. Then I restarted the comp but it is not reflecting the changes in the phpinfo.

Under the "php configuration core" phpinfo is showing the extension_dir as C:\php5 and include_path as ".;C:\php5\pear". But i dont have any directory named php5. So, i created a directory named php5 in C:\ and copied all the extension dlls into it and made a folder named pear in it and copied the php.ini file in it. But it still didnt reflect any changes.

I doubt that it is not reading the php,ini file from the "C:\WINNT" directory. To check that I tried changing the color code of  "highlight.string" from DD0000 to FF9900. I again restarted the comp but still it didnt reflect this change too. So, i think that it is using some other php.ini file. So, i searched for the php.ini file and i found it in the following locations :

C:\WINNT\
C:\php5\

So, i made the same changes everywhere including the "php.ini-dist" and "php.ini-recommended" files found in C:\php dir. But still the problem persisted. Then I removed the php.ini file from the "C:\WINNT" dir but the phpinfo still worked even without it being present in the dir.

I also tried reinstalling php several times but that also didnt help. But what I found strange was that i was not able to remove the "php5ts.dll"  from the C:\WINNT dir and "php5apache2.dll" from the C:\php dir. Everytime it gave an error that these files are in use. I dont have any information about these files.

Do i have to modify the "System Path variable" ?? I also tried modifying that too by adding C:\php and C:\php5 in it. I also added one more system variable PHPRC with the value C:\WINNT.

But still i am not able to enable the postgres with php. I think there is no compatibility issues as google search gives some phpinfo links that works with the same version of php and postgres. When i try to connect to the database it gives the error "Call to undefined function pg_connect()" which i think is obvious as phpinfo is not showing postgres in it.

It would be a great help if you could figure out the error and can help me enabling the postgres in php. I have been trying for the past 3 days to enable it.

Thanks a lot for spending your valuable time.

Regards
Parang Saraf
parang.saraf@gmail.com
------=_Part_115493_30191704.1150867570739--