Thread

1. Postgres with php3

   Carsten Huettl <chuettl@ahorn-net.de> — 2000-06-20T18:50:10Z

   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
   
   

2. Re: Postgres with php3

   Poul L. Christiansen <plc@faroenet.fo> — 2000-06-21T07:36:26Z

   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
   
   
   

3. Re: Postgres with php3

   Carsten Huettl <chuettl@ahorn-net.de> — 2000-06-21T20:04:11Z

   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
   
   

4. Re: [GENERAL] Postgres with php3

   Carsten Huettl <chuettl@ahorn-net.de> — 2000-06-21T20:04:11Z

   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
   
   

5. Re: Postgres with php3

   Andrew McMillan <andrew@catalyst.net.nz> — 2000-06-22T02:41:10Z

   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
   
   
   
   

6. RE: Postgres with php3

   Joseph <lters@mrtc.com> — 2000-06-23T09:56:55Z

   > 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