Re: problem enabling postgres in php

From: "Tobias Boes" <tobias(dot)boes(at)gmx(dot)de>
To: "Jason Minion" <jason(dot)minion(at)sigler(dot)com>, "Parang Saraf" <parang(dot)saraf(at)gmail(dot)com>, <pgsql-php(at)postgresql(dot)org>
Subject: Re: problem enabling postgres in php
Date: 2006-06-22 18:33:35
Message-ID: 01bd01c6962a$60b204b0$0201a8c0@desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

copy the php_pgsql.dll to the bin folder of your apache. That might work.
Ensure that the right php.ini gets allocated.

regards

Tobias
----- Original Message -----
From: "Jason Minion" <jason(dot)minion(at)sigler(dot)com>
To: "Parang Saraf" <parang(dot)saraf(at)gmail(dot)com>; <pgsql-php(at)postgresql(dot)org>
Sent: Wednesday, June 21, 2006 3:57 PM
Subject: Re: [PHP] problem enabling postgres in php

When you run phpinfo, one of the values it shows on the screen will be
the location of the php.ini file that it is using. Also, some people
have found that they need to add a trailing slash to the extension dir,
mine is:

extension_dir = "c:/php/ext/"

Jason Minion
jason(dot)minion(at)sigler(dot)com

________________________________

From: pgsql-php-owner(at)postgresql(dot)org
[mailto:pgsql-php-owner(at)postgresql(dot)org] On Behalf Of Parang Saraf
Sent: Wednesday, June 21, 2006 12:26 AM
To: pgsql-php(at)postgresql(dot)org
Subject: [PHP] problem enabling postgres in php

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(dot)saraf(at)gmail(dot)com

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

In response to

Browse pgsql-php by date

  From Date Subject
Next Message arie nugraha 2006-06-26 02:28:31 Cannot make connection to postgresql 7.4 on FreeBSD
Previous Message operationsengineer1 2006-06-22 18:19:45 Re: problem enabling postgres in php