Thread: Having tough time getting php working for postgresql.. Pleeese help

Having tough time getting php working for postgresql.. Pleeese help

From
Jagan Reddy
Date:
Hello,
I have successfully compiled and installed postgresql 8.1.1. I have created some databases as well.
But I want to get php working with pgsql so that I can do some web develoement.
 
Whatever rpms I get and insall, it is still complaining for another.  I believe I have PHP 4.3.9 and I tried here to insall php-pgsql4.3.9.  No luck. 
 
I am still running the default PHP installed by RedHat linux installaion process.  I have not removed and installed source code based PHP though.
 
Thanks
Jagan Reddy
 
[root@gireesh tmp]# rpm -Uvh php-pgsql-4.3.9-3.i386.rpm
warning: php-pgsql-4.3.9-3.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2
error: Failed dependencies:
        php = 4.3.9-3 is needed by php-pgsql-4.3.9-3.i386
[root@gireesh tmp]# php --version
PHP 4.3.9 (cgi) (built: Nov  4 2005 11:49:35)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
[root@gireesh tmp]#

Re: Having tough time getting php working for postgresql..

From
Jeff MacDonald
Date:
greetings,

On Mon, 2006-01-09 at 14:23 -0800, Jagan Reddy wrote:
> Hello,
> I have successfully compiled and installed postgresql 8.1.1. I have
> created some databases as well.
> But I want to get php working with pgsql so that I can do some web
> develoement.
>
> Whatever rpms I get and insall, it is still complaining for another.
> I believe I have PHP 4.3.9 and I tried here to insall php-pgsql4.3.9.
> No luck.
>
> I am still running the default PHP installed by RedHat linux
> installaion process.  I have not removed and installed source code
> based PHP though.
>
> Thanks
> Jagan Reddy
>

what version of redhat are you using?

what version of the php rpm to do you have installed? (use 'rpm -q php'
to check)

regards,
J
--
Jeff MacDonald
Zoid Technologies, http://zoidtechnologies.com/


Re: Having tough time getting php working for postgresql..

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

> But I want to get php working with pgsql so that I can do some web develoement.

Check that you have php working using the php_info function.  Place a file
in your web area containing this:

<?php
phpinfo();
?>

If php is working it should show a bunch of info.  Read about the
phpinfo() function at:

http://php.net/manual/en/function.phpinfo.php

You further need postgreSQL support.  This is for the postgreSQL php
functions.  It should report this on the page, under the heading pgsql.

If you don't have it, you'll have to figure out how to add it.

If postgreSQL support shows on the phpinfo output the next step is to make
a connection to the database.

At which point are you having problems?  I can't help you with Red Hat as
I use Debian, but it must be similar.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================


Re: Having tough time getting php working for postgresql..

From
manjusri schuit
Date:
Hello
form the php site--

In order to enable PostgreSQL support, --with-pgsql[=DIR] is required when you compile PHP. DIR is the PostgreSQL base install directory, defaults to /usr/local/pgsql. If shared object module is available, PostgreSQL module may be loaded using extension directive in php.ini or dl() function.

The default php instalations on most linux distro's don't come with postgresql enabled !
So you need to unistall the default php version first.


On 1/10/06, Jeff MacDonald <jam@zoidtechnologies.com> wrote:
greetings,

On Mon, 2006-01-09 at 14:23 -0800, Jagan Reddy wrote:
> Hello,
> I have successfully compiled and installed postgresql 8.1.1. I have
> created some databases as well.
> But I want to get php working with pgsql so that I can do some web
> develoement.
>
> Whatever rpms I get and insall, it is still complaining for another.
> I believe I have PHP 4.3.9 and I tried here to insall php-pgsql4.3.9.
> No luck.
>
> I am still running the default PHP installed by RedHat linux
> installaion process.  I have not removed and installed source code
> based PHP though.
>
> Thanks
> Jagan Reddy
>

what version of redhat are you using?

what version of the php rpm to do you have installed? (use 'rpm -q php'
to check)

regards,
J
--
Jeff MacDonald
Zoid Technologies, http://zoidtechnologies.com/


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly



--
Met vriendelijke groet
Manjusri Schuit