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 haven't played with apache so am not sure what php3 is. But I'm sure you first need to get postgres running. Go to /usr/doc/ and read the README under your version of postgres. It tells you how to turn on postgres and get the postmaster running. You want it to turn on each time you boot Linux. Now read about php3 and see how it interfaces.... On Tue, 20 Jun 2000, 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 > > Yours Truly, - Karl F. Larsen, k5di@arrl.net (505) 524-3303 -
I use apache, php3 and postgresql 6.5.3 on a RedHat 6.1 system. I installed the plain vanilla apache code from RPM, installed the plain vanilla postgresql from RPM. Then you have to install the PHP3 *source* RPM, modify the build file and re-roll the RPM with postgresl support. It was really a piece of cake. There are specific instructions on www.php.net <http://www.php.net> (http://www.php.net/FAQ.php#5.3 <http://www.php.net/FAQ.php#5.3> ) . Pat Patrick C. Wolf R&D Manager Aerojet Socorro Plant -----Original Message----- From: Karl F. Larsen [mailto:k5di@zianet.com] Sent: Wednesday, June 21, 2000 6:20 AM To: Carsten Huettl Cc: pgsql-general@postgresql.org; pgsql-novice@postgresql.org Subject: Re: [NOVICE] Postgres with php3 I haven't played with apache so am not sure what php3 is. But I'm sure you first need to get postgres running. Go to /usr/doc/ and read the README under your version of postgres. It tells you how to turn on postgres and get the postmaster running. You want it to turn on each time you boot Linux. Now read about php3 and see how it interfaces.... On Tue, 20 Jun 2000, 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 > > Yours Truly, - Karl F. Larsen, k5di@arrl.net (505) 524-3303 -
On Wed, 21 Jun 2000, WOLF, PATRICK wrote: >I use apache, php3 and postgresql 6.5.3 on a RedHat 6.1 system. I installed >the plain vanilla apache code from RPM, installed the plain vanilla >postgresql from RPM. Then you have to install the PHP3 *source* RPM, modify [snip] I installed Red Hat 6.2 and these all worked together out of the box. -- Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/> PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D Linux: The choice of a GNU generation. <http://www.linux.org/>
On Wed, 21 Jun 2000, Anthony E. Greene wrote:
> On Wed, 21 Jun 2000, WOLF, PATRICK wrote:
> >I use apache, php3 and postgresql 6.5.3 on a RedHat 6.1 system. I installed
> >the plain vanilla apache code from RPM, installed the plain vanilla
> >postgresql from RPM. Then you have to install the PHP3 *source* RPM, modify
> [snip]
>
> I installed Red Hat 6.2 and these all worked together out of the box.
Hey Tony,
You got any PHP scripts I could have a look at? I'm a perl guy myself
but I am curious how the other half lives!
Cheers,
Tom
--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA Phone: 718-354-5528
Fax: 718-354-5056
--------------------------------------------------------------------
Powered by: PostgreSQL s l a c k w a r e FreeBSD:
RDBMS |---------- linux The Power To Serve
--------------------------------------------------------------------
> I haven't played with apache so am not sure what php3 is. But I'm sure you > first need to get postgres running. Go to /usr/doc/ and read the README postgresql runs. I have created a sample of dbs for testing with some tables. It runs perfekt at this point. I can see the db files in the PGDATA directory. It seems to be allright. > under your version of postgres. It tells you how to turn on postgres and pgsql v6.5.x > get the postmaster running. You want it to turn on each time you boot > Linux. Bye C. -- Carsten Huettl - <http://www.ahorn-Net.de> pgp-key on request
Have you tried creating a php script like: <?php phpinfo() ?> This will display a page in a browser with how php is configured. You can confirm that postgres is in your php. Danny Aldham Providing Certified Internetworking Solutions to Business www.postino.com E-Mail, Web Servers, Web Databases, SQL PHP & Perl > > I haven't played with apache so am not sure what php3 is. But I'm sure you > > first need to get postgres running. Go to /usr/doc/ and read the README > > postgresql runs. I have created a sample of dbs for testing with > some tables. It runs perfekt at this point. I can see the db files in the > PGDATA directory. It seems to be allright. > > > under your version of postgres. It tells you how to turn on postgres and > pgsql v6.5.x > > get the postmaster running. You want it to turn on each time you boot > > Linux. > > Bye > C. > > -- > Carsten Huettl - <http://www.ahorn-Net.de> > pgp-key on request >