Postgres with php3

I don't think Postgres is started by default. Open linuxconf and make it
start every time your Redhat starts.

PgAdmin requires ODBC drivers on the windows machine, have you got them?

HTH,
Poul L. Christiansen

Carsten Huettl wrote:

Date sent: Wed, 21 Jun 2000 09:36:26 +0200
From: "Poul L. Christiansen" <plc@faroenet.fo>
To: Carsten Huettl <CHUETTL@ahorn-Net.de>
Copies to: pgsql-general@postgresql.org, pgsql-novice@postgresql.org
Subject: Re: [GENERAL] Postgres with php3

I don't think Postgres is started by default. Open linuxconf and make it
start every time your Redhat starts.

In this situation of testing I start postgresql or the postmaster
manually. It works. I can login. Create dbs and a smple of tables.
But I cannot connct via the phpPGadmin thats the point of trouble.

PgAdmin requires ODBC drivers on the windows machine, have you got them?

There is no Windows in the game.
Bye
C.

--
Carsten Huettl - <http://www.ahorn-Net.de&gt;
pgp-key on request

Date sent: Wed, 21 Jun 2000 09:36:26 +0200
From: "Poul L. Christiansen" <plc@faroenet.fo>
To: Carsten Huettl <CHUETTL@ahorn-Net.de>
Copies to: pgsql-general@postgresql.org, pgsql-novice@postgresql.org
Subject: Re: [GENERAL] Postgres with php3

I don't think Postgres is started by default. Open linuxconf and make it
start every time your Redhat starts.

In this situation of testing I start postgresql or the postmaster
manually. It works. I can login. Create dbs and a smple of tables.
But I cannot connct via the phpPGadmin thats the point of trouble.

PgAdmin requires ODBC drivers on the windows machine, have you got them?

There is no Windows in the game.
Bye
C.

--
Carsten Huettl - <http://www.ahorn-Net.de&gt;
pgp-key on request

Carsten Huettl wrote:

In this situation of testing I start postgresql or the postmaster
manually. It works. I can login. Create dbs and a smple of tables.
But I cannot connct via the phpPGadmin thats the point of trouble.

Is php loading the pgsql.so module? Does PHP on Red Hat use dynamic loading of
modules? Is it loading the _right_ pgsql.so module? Is php configured with an
appropriate directory for loading modules? Is php compiled with support for
PostgreSQL? Does phpinfo() tell you anything interesting/useful?

If you turn on syslog support in your php.ini you might find some really useful error
messages in your syslog.

I use PHP against PostgreSQL all the time with no problems, but I don't know what the
issues might be with Red Hat I'm afraid since I use Debian. Hence the of-the-wall,
basic check suggestions :-)

Good luck,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

In this situation of testing I start postgresql or the postmaster
manually. It works. I can login. Create dbs and a smple of tables.
But I cannot connct via the phpPGadmin thats the point of trouble.

When I installed PhpPgAdmin on a RH6.2 box, I had to fiddle with the code a
bit to get it to work.There's either a INSTALL or README file that tells you
what things you need to change first.

Rob Nelson
rdnelson@co.centre.pa.us

In this situation of testing I start postgresql or the postmaster
manually. It works. I can login. Create dbs and a smple of tables.
But I cannot connct via the phpPGadmin thats the point of trouble.

I got it by doing the following:

Install postgres - Get it running, sounds like you got that.

Install apache - Get it running. Make sure you can make a html file and
display it.

Install php rpm and the php_pgsql rpm.

Edit your /etc/httpd/conf/httpd.conf, find the php file type entry.
I added html to the file so that php code works in regular html files.
Make sure that php3 file type is enabled.

Make a file with the php3 extension and put something like
<? echo "Hello World" ; ?> in it.

Joseph
IT Manager