Thread: Postgres with php3
Hello, I have setup a RH 6.2 box with postgres. The httpd (apache) has support for php3. But I don't know if the rh installation builds in the php3 support in postgres. I installed the pgadmin 2.0.2 but it did not find any database. Maybe this is becuase rh installs in different directories then recommended. The pgphp package is installed as I see from rpm -q How do I check if the postgres installation is correct with support for php3. TIA C. -- Carsten Huettl - <http://www.ahorn-Net.de> pgp-key on request
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: > Hello, > > I have setup a RH 6.2 box with postgres. > The httpd (apache) has support for php3. > But I don't know if the rh installation builds in the php3 support in > postgres. I installed the pgadmin 2.0.2 but it did not find any > database. Maybe this is becuase rh installs in different directories > then recommended. > The pgphp package is installed as I see from rpm -q > How do I check if the postgres installation is correct with support for > php3. > > TIA > C. > > -- > Carsten Huettl - <http://www.ahorn-Net.de> > 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> 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