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

--0-304713480-1136845380=:38756
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,
I have successfully compiled and installed postgresql 8.1.1. I have cre=
ated some databases as well.
But I want to get php working with pgsql so that I can do some web deve=
loement.

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 installaio=
n process. I have not removed and installed source code based PHP though=
..

Thanks
Jagan Reddy

[root [at] 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 4f2a=
6fd2
error: Failed dependencies:
php =3D 4.3.9-3 is needed by php-pgsql-4.3.9-3.i386
[root [at] 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 [at] gireesh tmp]#

--0-304713480-1136845380=:38756
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<DIV id=3DRTEContent>Hello,</DIV> <DIV>I have successfully compiled and =
installed postgresql 8.1.1. I have created some databases as well.</DIV> =
<DIV>But I want to get php working with pgsql so that I can do some web =
develoement.</DIV> <DIV> </DIV> <DIV>Whatever rpms I get and insal=
l, 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. </DIV> <=
DIV> </DIV> <DIV>I am still running the default PHP installed by Re=
dHat linux installaion process. I have not removed and installed so=
urce code based PHP though.</DIV> <DIV> </DIV> <DIV>Thanks</DIV> =
<DIV>Jagan Reddy</DIV> <DIV> </DIV> <DIV>[root [at] 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 =3D 4.3.9-3 is needed by p=
hp-pgsql-4.3.9-3.i386 [root [at] gireesh tmp]#
php
--version PHP 4.3.9 (cgi) (built: Nov 4 2005 11:49:35) Copyr=
ight (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 199=
8-2004 Zend Technologies [root [at] gireesh tmp]# </DIV>
--0-304713480-1136845380=:38756--

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 [at] postgresql.org so that your
message can get through to the mailing list cleanly

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 [at] 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
============================================================ ==============

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

------=_Part_7783_5831723.1136901883402
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello
form the php site--

In order to enable PostgreSQL support, --with-pgsql[=3DDIR] is required whe=
n
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<http://nl3.php.net/manual/nl/ini.sect.path-directory.php#ini.exte=
nsion>directive
in
php.ini or *dl()* <http://nl3.php.net/manual/nl/function.dl.php> 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 [at] 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 [at] postgresql.org so that your
> message can get through to the mailing list cleanly
>

--
Met vriendelijke groet
Manjusri Schuit

------=_Part_7783_5831723.1136901883402
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello 
form the php site-- 
 

In order to enable PostgreSQL support,
<var class=3D"option">--with-pgsql[=3DDIR]</var> is required when you com=
pile
PHP. DIR is the PostgreSQL base install directory, defaults to
<tt class=3D"filename">/usr/local/pgsql</tt>. If shared object module is
available, PostgreSQL module may be loaded using
<a href=3D"http://nl3.php.net/manual/nl/ini.sect.path-directory.php#ini.e=
xtension">extension</a> directive in <tt class=3D"filename">php.ini</tt> or
<a href=3D"http://nl3.php.net/manual/nl/function.dl.php">dl()</a>
function. 
 
The default php instalations on most linux distro's don't come with postgre=
sql enabled ! 
So you need to unistall the default php version first. 
 
 <div>On 1/10/06, Jeff MacDonald <<a href=3D"mailto:jam [at] zoidtechnologies.com">jam [at] =
zoidtechnologies.com</a>> wrote:<blockquote class=3D"gmail_quote"=
style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.=
8ex; padding-left: 1ex;">
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 tr=
ied here to insall php-pgsql4.3.9. > No luck. > > I am st=
ill running the default PHP installed by RedHat linux
 > installaion process. I have not removed and installed s=
ource code > based PHP though. > > Thanks > Jagan R=
eddy > what version of redhat are you using? what versi=
on of the php rpm to do you have installed? (use 'rpm -q php'
 to check) regards, J -- Jeff MacDonald Zoid Technolo=
gies, <a href=3D"http://zoidtechnologies.com/">http://zoidtechnologies.com/=
</a> ---------------------------(end of broadcast)--------------=
-------------
 TIP 1: if posting/reading through Usenet, please send an appropriate<br=
> subscribe-nomail command to <a href=
=3D"mailto:majordomo [at] postgresql.org">majordomo [at] postgresql.or g</a> so that y=
our message can get through to the =
mailing list cleanly
 </blockquote></div> -- Met vriendelijke gr=
oet Manjusri Schuit 

------=_Part_7783_5831723.1136901883402--

This is a multi-part message in MIME format.

------_=_NextPart_001_01C61601.B5F2DDE8
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Do NOT uninstall. The package you need to install is called php-pgsql.
You should be able to do a (as root of course or sudo if that is set up)

Yum install php-pgsql

Restart apache and you are good to go.

Sherwin Harris

________________________________

From: pgsql-php-owner [at] postgresql.org
[mailto:pgsql-php-owner [at] postgresql.org] On Behalf Of manjusri schuit
Sent: Tuesday, January 10, 2006 7:05 AM
To: Jeff MacDonald
Cc: Jagan Reddy; pgsql-php [at] postgresql.org
Subject: Re: [PHP] Having tough time getting php working for
postgresql..

Hello
form the php site--

In order to enable PostgreSQL support, --with-pgsql[=3DDIR] 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
<http://nl3.php.net/manual/nl/ini.sect.path-directory.php#ini.extension>
directive in php.ini or dl()
<http://nl3.php.net/manual/nl/function.dl.php> 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 [at] 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 [at] postgresql.org so that your
message can get through to the mailing list cleanly

--
Met vriendelijke groet
Manjusri Schuit

------_=_NextPart_001_01C61601.B5F2DDE8
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">

<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

Do NOT uninstall. The package you =
need to
install is called php-pgsql. You should be able to do a (as root of =
course or
sudo if that is set up)<o:p></o:p>

Yum install =
php-pgsql<o:p></o:p>

Restart apache and you are good to =
go.<o:p></o:p>

Sherwin =
Harris<o:p></o:p>

<o:p> </o:p>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</div>

From:
pgsql-php-owner [at] postgresql.org [mailto:pgsql-php-owner [at] postgresql.org] =
On Behalf Of manjusri schuit 
Sent: Tuesday, January =
10, 2006 7:05
AM 
To: Jeff MacDonald 
Cc: Jagan Reddy;
pgsql-php [at] postgresql.org 
Subject: Re: [PHP] Having =
tough
time getting php working for postgresql..<o:p></o:p>

</div>

<o:p> </o:p>

Hello 
form the php site-- 
 
In order to enable PostgreSQL support, <var>--with-pgsql[=3DDIR]</var>
is required when you compile PHP. DIR is the PostgreSQL base install =
directory,
defaults to <tt>/usr/local/pgsql</tt>. If =
shared object
module is available, PostgreSQL module may be loaded using <a
href=3D"http://nl3.php.net/manual/nl/ini.sect.path-directory .php#ini.exte=
nsion">extension</a>
directive in <tt>php.ini</tt>
or <a href=3D"http://nl3.php.net/manual/nl/function.dl.php">dl()</a> 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. 
 
<o:p></o:p>

<div>

On 1/10/06, Jeff
MacDonald <<a =
href=3D"mailto:jam [at] zoidtechnologies.com">jam [at] zoidtechnologie s.com</a>>=

wrote:<o:p></o:p>

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, <a =
href=3D"http://zoidtechnologies.com/">http://zoidtechnologie s.com/</a><br=
>
 
 
---------------------------(end of broadcast)--------------------------- =
 
TIP 1: if posting/reading through Usenet, please send an appropriate 
 subscribe-nomail command to <a
href=3D"mailto:majordomo [at] postgresql.org">majordomo [at] postgresq l.org</a> so =
that
your 
 message can get through to the =
mailing
list cleanly <o:p></o:p>

</div>

 
 
 
-- 
Met vriendelijke groet 
Manjusri Schuit<o:p></o:p>

</div>

</body>

</html>

------_=_NextPart_001_01C61601.B5F2DDE8--

Hello,

I was having trouble with setting up php-pgsql, but I think I have it
up and running. Before I attempt to move forward with attempting to
code without knowing if the environment is setup correctly, does
anybody know what exactly I am looking for in the phpinfo() tables. I
did a find for pgsql, postgre, etc. and didn't find anything.

I am running Windows XP Pro, Apache 2, PHP 5.1.1, PostgreSQL 8.0.

Thank you in advance.

Patrick

On 1/10/06, Sherwin M. Harris <Sherwin_Harris [at] byu.edu> wrote:
>
>
>
> Do NOT uninstall. The package you need to install is called php-pgsql. You
> should be able to do a (as root of course or sudo if that is set up)
>
> Yum install php-pgsql
>
> Restart apache and you are good to go.
>
> Sherwin Harris
>
>
>
> ________________________________
>
>
> From: pgsql-php-owner [at] postgresql.org [mailto:pgsql-php-owner [at] postgresql.o=
rg]
> On Behalf Of manjusri schuit
> Sent: Tuesday, January 10, 2006 7:05 AM
> To: Jeff MacDonald
> Cc: Jagan Reddy; pgsql-php [at] postgresql.org
> Subject: Re: [PHP] Having tough time getting php working for postgresql..
>
>
>
>
> Hello
> form the php site--
>
> In order to enable PostgreSQL support, --with-pgsql[=3DDIR] 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 [at] 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 [at] postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>
> --
> Met vriendelijke groet
> Manjusri Schuit

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

Am Mittwoch, 11. Januar 2006 18:35 schrieb Patrick White:
> Hello,
>
> I was having trouble with setting up php-pgsql, but I think I have it
> up and running. Before I attempt to move forward with attempting to
> code without knowing if the environment is setup correctly, does
> anybody know what exactly I am looking for in the phpinfo() tables. I
> did a find for pgsql, postgre, etc. and didn't find anything.

you should find "pgsql" (look at the configuration parameters in
http://www.php.net/manual/en/ref.pgsql.php ; they should be listed)

> I am running Windows XP Pro, Apache 2, PHP 5.1.1, PostgreSQL 8.0.

Consult http://www.php.net/manual/en/ref.pgsql.php
Maybe you have to add the libary in your php.ini file

kind regards
janning

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thank you for the quick reply. I was actually able to get it up and
running. It is always as soon as you hit the send button when the
light bulb goes off. The issue I was having was that I didn't realise
the order of which the server will look for the php.ini file (I
thought it was simply looking in the PATH directories), such as the
list I will provide for future reference:

1.PHPIniDir directive (Apache 2 module only)
2.HKEY_LOCAL_MACHINE\SOFTWARE\PHP\IniFilePath
3. The PHPRC environment variable
4. Directory of PHP (for CLI), or the web server's directory (for
SAPI modules)
5. Windows directory (C:\windows or C:\winnt)

My problem was that Apache was set to look in a directory that
contained a completly default php.ini file.

Thanks again, and I apologize for the premature post.

Patrick

---------- Forwarded message ----------
From: Janning Vygen <vygen [at] gmx.de>
Date: Jan 11, 2006 1:00 PM
Subject: Re: [PHP] Having tough time getting php working for postgresql..
To: pgsql-php [at] postgresql.org
Cc: Patrick White <ptothew [at] gmail.com>

Am Mittwoch, 11. Januar 2006 18:35 schrieb Patrick White:
> Hello,
>
> I was having trouble with setting up php-pgsql, but I think I have it
> up and running. Before I attempt to move forward with attempting to
> code without knowing if the environment is setup correctly, does
> anybody know what exactly I am looking for in the phpinfo() tables. I
> did a find for pgsql, postgre, etc. and didn't find anything.

you should find "pgsql" (look at the configuration parameters in
http://www.php.net/manual/en/ref.pgsql.php ; they should be listed)

> I am running Windows XP Pro, Apache 2, PHP 5.1.1, PostgreSQL 8.0.

Consult http://www.php.net/manual/en/ref.pgsql.php
Maybe you have to add the libary in your php.ini file

kind regards
janning

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

> Hello,
>
> I was having trouble with setting up php-pgsql, but
> I think I have it
> up and running. Before I attempt to move forward
> with attempting to
> code without knowing if the environment is setup
> correctly, does
> anybody know what exactly I am looking for in the
> phpinfo() tables. I
> did a find for pgsql, postgre, etc. and didn't find
> anything.
>
> I am running Windows XP Pro, Apache 2, PHP 5.1.1,
> PostgreSQL 8.0.
>
> Thank you in advance.
>
> Patrick

1. test for the apache test page (prior to php
install).
2. test that phpinfo() displays (after php install).
3. edit->find to search for "sql" until you find the
reference to postgresql. it should tell you what
version you are using. of course, this is after pgsql
has been installed.

i also discuss how to use pgadminIII to test that
pgsql is working in the link to the install
instructions i posted earlier today.

once you get everything set up, you may want to
consider a db abstraction layer (i use adodb and find
it quite robust) and a forms generation and validation
class (i use manuel lemos' from phpclasses.org). it
is also very nice.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

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

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

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

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

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

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

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

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

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