PHP 5.8 -> Postgres on Win2003

View: New views
6 Messages — Rating Filter:   Alert me  

PHP 5.8 -> Postgres on Win2003

by Raymond O'Donnell :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi all,

Is anyone successfully using PHP 5.8 to talk to PostgreSQL on Windows
Server 2003?

I tried upgrading today from 5.1.4 to 5.8 - I had avoided upgrading for
a while due to a known bug in the PG extension - but it seems that
either the extension is still buggy or I'm doing something silly,
because any call to a pg_* function results in "Call to undefined
function" messages in the log.

I've rolled back to 5.1.4 for the moment, but obviously this isn't
ideal...any input welcome!

Thanks,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@...
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

--
Sent via pgsql-php mailing list (pgsql-php@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

PHP 5.2.8, was: PHP 5.8 -> Postgres on Win2003

by Raymond O'Donnell :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On 21/01/2009 11:53, Raymond O'Donnell wrote:
> Is anyone successfully using PHP 5.8 to talk to PostgreSQL on Windows
> Server 2003?

Correction - that should of course be PHP 5.2.8  :-)

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@...
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

--
Sent via pgsql-php mailing list (pgsql-php@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: PHP 5.8 -> Postgres on Win2003

by chris smith-9 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Raymond O'Donnell wrote:

> Hi all,
>
> Is anyone successfully using PHP 5.8 to talk to PostgreSQL on Windows
> Server 2003?
>
> I tried upgrading today from 5.1.4 to 5.8 - I had avoided upgrading for
> a while due to a known bug in the PG extension - but it seems that
> either the extension is still buggy or I'm doing something silly,
> because any call to a pg_* function results in "Call to undefined
> function" messages in the log.

You haven't got the pgsql extension loaded. You'll need to copy your
changes from the 5.1.4 php.ini file to the 5.2.8 php.ini (and restart
the webserver if applicable).

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


--
Sent via pgsql-php mailing list (pgsql-php@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: PHP 5.8 -> Postgres on Win2003

by Raymond O'Donnell :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On 21/01/2009 21:45, Chris wrote:

> You haven't got the pgsql extension loaded. You'll need to copy your
> changes from the 5.1.4 php.ini file to the 5.2.8 php.ini (and restart
> the webserver if applicable).

Chris, thanks for the reply. That was the first thing I thought of... I
did in fact copy the entire php.ini file from the old installation to
the new one, and double-checked that the line "extension=php_pgsql.ini"
was uncommented.

The new installation is also in the same place as the old one, so the
registry key to tell PHP where to find php.ini didn't have to be changed.

I'm really puzzled by this one.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@...
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

--
Sent via pgsql-php mailing list (pgsql-php@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: PHP 5.8 -> Postgres on Win2003

by chris smith-9 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Raymond O'Donnell wrote:

> On 21/01/2009 21:45, Chris wrote:
>
>> You haven't got the pgsql extension loaded. You'll need to copy your
>> changes from the 5.1.4 php.ini file to the 5.2.8 php.ini (and restart
>> the webserver if applicable).
>
> Chris, thanks for the reply. That was the first thing I thought of... I
> did in fact copy the entire php.ini file from the old installation to
> the new one, and double-checked that the line "extension=php_pgsql.ini"
> was uncommented.

An extension will either be a .so or .dll won't it? Or will this syntax
include an external file ? (I've never seen it used so I don't know what
it does). If it's an extra file, did you copy it? :)

> The new installation is also in the same place as the old one, so the
> registry key to tell PHP where to find php.ini didn't have to be changed.
>
> I'm really puzzled by this one.

Anything in the logs about being unable to locate extensions?

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


--
Sent via pgsql-php mailing list (pgsql-php@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: PHP 5.8 -> Postgres on Win2003

by glenn_nz :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi

I'm trying to get this running too.

I have:

- copied the php_pgsql.dll file to the ext directory.
- added the following to my php.ini:
       [PHP_PGSQL]
       extension=php_pgsql.dll
- restarted the server

No joy, I still get, "We were unable to use the PostgreSQL database because the PostgreSQL extension for PHP is not installed. Check your PHP.ini to see how you can enable it."

Any ideas?

Thanks

Glenn