Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problems compiling for pgsql support

Problems compiling for pgsql support

From
"Aaron"
Date:
I have been trying to get php version 4.3.3 to work with postgresql for days
now.  I have postgresql installed and running on the server.  We are using
the WHM/Cpanel management suite so we are using apache 1.3.29 aswell.

I have php currently configured as reported by phpinfo()

'./configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-xml'
'--enable-bcmath' '--enable-calendar' '--enable-ftp' '--with-gd'
'--with-jpeg-dir=/usr/local' '--with-png-dir=/usr'
'--with-xpm-dir=/usr/X11R6' '--with-gettext' '--enable-magic-quotes'
'--with-mysql' '--with-pear' '--enable-sockets' '--enable-track-vars'
'--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf'
'--enable-versioning' '--with-zlib'

When I try to reconfigure php with the '--with-pgsql-dir=/usr' flag php
appears to compile and configure properly yet the builddate in phpinfo();
never changes.

In looking thru the php.net website it seems like there have been a lot of
issues with getting pgsql and php working properly.  I have exhaused my
ideas on what could be the cause and hope maybe someone out there might have
a few tricks I can try.

Thanks in advance.

Aaron

Re: Problems compiling for pgsql support

From
brew@theMode.com
Date:
Aaron.....

> I have php currently configured as reported by phpinfo()
>
> './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-xml'
> '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--with-gd'
> '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr'
> '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--enable-magic-quotes'
> '--with-mysql' '--with-pear' '--enable-sockets' '--enable-track-vars'
> '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf'
> '--enable-versioning' '--with-zlib'

So to me it looks like the php that is running does not include the
postgresql php module which contains the functions to talk to the
database.  But maybe you are using pear as the interface between apache,
php and postgresql.  I guess you can't connect to the database, right?

> When I try to reconfigure php with the '--with-pgsql-dir=/usr' flag php
> appears to compile and configure properly yet the builddate in
> phpinfo(); never changes.

Maybe you have to restart Apache?  Php is most usually an Apache module
and unless Apache restarts the changes won't be there.

What OS are you using?  I use Debian and don't often compile I just grab
the packages.....

brew

Re: Problems compiling for pgsql support

From
"Rod K"
Date:
You say you reconfigured, but you didn't say if you rebuilt....

> -----Original Message-----
> From: pgsql-php-owner@postgresql.org
> [mailto:pgsql-php-owner@postgresql.org]On Behalf Of Aaron
> Sent: Thursday, March 18, 2004 9:42 PM
> To: pgsql-php@postgresql.org
> Subject: [PHP] Problems compiling for pgsql support
>
>
>
> I have been trying to get php version 4.3.3 to work with
> postgresql for days
> now.  I have postgresql installed and running on the server.  We are using
> the WHM/Cpanel management suite so we are using apache 1.3.29 aswell.
>
> I have php currently configured as reported by phpinfo()
>
> './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-xml'
> '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--with-gd'
> '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr'
> '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--enable-magic-quotes'
> '--with-mysql' '--with-pear' '--enable-sockets' '--enable-track-vars'
> '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf'
> '--enable-versioning' '--with-zlib'
>
> When I try to reconfigure php with the '--with-pgsql-dir=/usr' flag php
> appears to compile and configure properly yet the builddate in phpinfo();
> never changes.
>
> In looking thru the php.net website it seems like there have been a lot of
> issues with getting pgsql and php working properly.  I have exhaused my
> ideas on what could be the cause and hope maybe someone out there
> might have
> a few tricks I can try.
>
> Thanks in advance.
>
> Aaron
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>

Re: Problems compiling for pgsql support

From
Aaron aka va_fish_freek
Date:
I finally upgraded php to version 4.3.4 and got pgsql to take when
rebuilding.  The php rebuild was not producing any noticeable errors.

PHP was being rebuilt thru the cpanel "update Apache" module.  As the final
stage of this step Apache is restarted.  So i never really understood why
the build date on 4.3.3 was not getting updated.

Anyway thanks to everyone whom responded.