pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Installation problems   was Re: is this list live?
7+ messages / 3 participants
[nested] [flat]

* Installation problems   was Re: is this list live?
@ 2000-10-17 17:20 Vince Vielhaber <vev@michvhf.com>
  2000-10-17 17:27 ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Vince Vielhaber @ 2000-10-17 17:20 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-php

On Tue, 17 Oct 2000, Josh Berkus wrote:

> Folks,
> 
> > I'm guessing it's more like PHP and PostgreSQL just work so flawlessly
> > together that noone has anything to say.
> 
> Actually, I've been having problems installing the PHP-Postgres
> interface on a VA Box running Postgres 7.0.2.  I just thought that
> nobody was on the list.  SO, let me throw this out there:
> 
> 1. Postgres was installed from RPM, and PHP4 was built from source
> (because RPMs were not available at the time).  The webserver we are
> running is Xitami
> 
> 2. When we tried to build the postgres interface from source, the make
> crashes after about 5 minutes, saying that it can't find certain
> libraries that are present and in the directory we supplied in the make
> command line.
> 
> 3. When we try to install from RPM, PHP-Postgres wants a library called
> pgsql.so.  THis library, as far as I can tell, does not exist in any of
> the Postgres sources.
> 
> Any thoughts?

Not sure right off what a "VA Box" is and I'm not familiar with Xitami, 
BUT I may be able to shed some light on things.

In #2 above, it sounds like your OS installation is incomplete or you
have some missing tools required to build PostgreSQL.

Are you installing PostgreSQL from one of our RPMs or from somewhere
else?  If it's one of ours, check with Lamar Owen on this library.  The
only thing I can find that comes close is plpgsql and I doubt that's it.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================






^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Installation problems   was Re: is this list live?
  2000-10-17 17:20 Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
@ 2000-10-17 17:27 ` Adam Lang <aalang@rutgersinsurance.com>
  2000-10-17 18:27   ` Re: Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Adam Lang @ 2000-10-17 17:27 UTC (permalink / raw)
  To: ; +Cc: pgsql-php

VA... they sell linux servers.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Vince Vielhaber" <vev@michvhf.com>
To: "Josh Berkus" <josh@agliodbs.com>
Cc: "phpp" <pgsql-php@postgresql.org>
Sent: Tuesday, October 17, 2000 1:20 PM
Subject: Installation problems was Re: is this list live?


> On Tue, 17 Oct 2000, Josh Berkus wrote:
>
> > Folks,
> >
> > > I'm guessing it's more like PHP and PostgreSQL just work so flawlessly
> > > together that noone has anything to say.
> >
> > Actually, I've been having problems installing the PHP-Postgres
> > interface on a VA Box running Postgres 7.0.2.  I just thought that
> > nobody was on the list.  SO, let me throw this out there:
> >
> > 1. Postgres was installed from RPM, and PHP4 was built from source
> > (because RPMs were not available at the time).  The webserver we are
> > running is Xitami
> >
> > 2. When we tried to build the postgres interface from source, the make
> > crashes after about 5 minutes, saying that it can't find certain
> > libraries that are present and in the directory we supplied in the make
> > command line.
> >
> > 3. When we try to install from RPM, PHP-Postgres wants a library called
> > pgsql.so.  THis library, as far as I can tell, does not exist in any of
> > the Postgres sources.
> >
> > Any thoughts?
>
> Not sure right off what a "VA Box" is and I'm not familiar with Xitami,
> BUT I may be able to shed some light on things.
>
> In #2 above, it sounds like your OS installation is incomplete or you
> have some missing tools required to build PostgreSQL.
>
> Are you installing PostgreSQL from one of our RPMs or from somewhere
> else?  If it's one of ours, check with Lamar Owen on this library.  The
> only thing I can find that comes close is plpgsql and I doubt that's it.
>
> Vince.
> --
> ==========================================================================
> Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
>  128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
>         Online Campground Directory    http://www.camping-usa.com
>        Online Giftshop Superstore    http://www.cloudninegifts.com
> ==========================================================================
>
>




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Installation problems   was Re: is this list live?
  2000-10-17 17:20 Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  2000-10-17 17:27 ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
@ 2000-10-17 18:27   ` Vince Vielhaber <vev@michvhf.com>
  2000-10-17 18:59     ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
  2000-10-17 19:37     ` Re: Installation problems   was Re: is this list live? Josh Berkus <josh@agliodbs.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Vince Vielhaber @ 2000-10-17 18:27 UTC (permalink / raw)
  To: Adam Lang <aalang@rutgersinsurance.com>; +Cc: pgsql-php

On Tue, 17 Oct 2000, Adam Lang wrote:

> VA... they sell linux servers.

Oh, Ok.  Are they known for installing the entire OS or do they leave
out the development stuff?  I remember reading not too long ago that
someone isn't putting the development stuff on by default but I don't
recall who.

Vince.

> 
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> ----- Original Message -----
> From: "Vince Vielhaber" <vev@michvhf.com>
> To: "Josh Berkus" <josh@agliodbs.com>
> Cc: "phpp" <pgsql-php@postgresql.org>
> Sent: Tuesday, October 17, 2000 1:20 PM
> Subject: Installation problems was Re: is this list live?
> 
> 
> > On Tue, 17 Oct 2000, Josh Berkus wrote:
> >
> > > Folks,
> > >
> > > > I'm guessing it's more like PHP and PostgreSQL just work so flawlessly
> > > > together that noone has anything to say.
> > >
> > > Actually, I've been having problems installing the PHP-Postgres
> > > interface on a VA Box running Postgres 7.0.2.  I just thought that
> > > nobody was on the list.  SO, let me throw this out there:
> > >
> > > 1. Postgres was installed from RPM, and PHP4 was built from source
> > > (because RPMs were not available at the time).  The webserver we are
> > > running is Xitami
> > >
> > > 2. When we tried to build the postgres interface from source, the make
> > > crashes after about 5 minutes, saying that it can't find certain
> > > libraries that are present and in the directory we supplied in the make
> > > command line.
> > >
> > > 3. When we try to install from RPM, PHP-Postgres wants a library called
> > > pgsql.so.  THis library, as far as I can tell, does not exist in any of
> > > the Postgres sources.
> > >
> > > Any thoughts?
> >
> > Not sure right off what a "VA Box" is and I'm not familiar with Xitami,
> > BUT I may be able to shed some light on things.
> >
> > In #2 above, it sounds like your OS installation is incomplete or you
> > have some missing tools required to build PostgreSQL.
> >
> > Are you installing PostgreSQL from one of our RPMs or from somewhere
> > else?  If it's one of ours, check with Lamar Owen on this library.  The
> > only thing I can find that comes close is plpgsql and I doubt that's it.
> >
> > Vince.
> > --
> > ==========================================================================
> > Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
> >  128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
> >         Online Campground Directory    http://www.camping-usa.com
> >        Online Giftshop Superstore    http://www.cloudninegifts.com
> > ==========================================================================
> >
> >
> 
> 

-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================






^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Installation problems   was Re: is this list live?
  2000-10-17 17:20 Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  2000-10-17 17:27 ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
  2000-10-17 18:27   ` Re: Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
@ 2000-10-17 18:59     ` Adam Lang <aalang@rutgersinsurance.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Adam Lang @ 2000-10-17 18:59 UTC (permalink / raw)
  To: ; +Cc: pgsql-php

I don't know specifics about them... just that they had a grossly over
valued IPO. :)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Vince Vielhaber" <vev@michvhf.com>
To: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: "phpp" <pgsql-php@postgresql.org>
Sent: Tuesday, October 17, 2000 2:27 PM
Subject: Re: Installation problems was Re: is this list live?


> On Tue, 17 Oct 2000, Adam Lang wrote:
>
> > VA... they sell linux servers.
>
> Oh, Ok.  Are they known for installing the entire OS or do they leave
> out the development stuff?  I remember reading not too long ago that
> someone isn't putting the development stuff on by default but I don't
> recall who.
>
> Vince.
>
> >
> > Adam Lang
> > Systems Engineer
> > Rutgers Casualty Insurance Company
> > ----- Original Message -----
> > From: "Vince Vielhaber" <vev@michvhf.com>
> > To: "Josh Berkus" <josh@agliodbs.com>
> > Cc: "phpp" <pgsql-php@postgresql.org>
> > Sent: Tuesday, October 17, 2000 1:20 PM
> > Subject: Installation problems was Re: is this list live?
> >
> >
> > > On Tue, 17 Oct 2000, Josh Berkus wrote:
> > >
> > > > Folks,
> > > >
> > > > > I'm guessing it's more like PHP and PostgreSQL just work so
flawlessly
> > > > > together that noone has anything to say.
> > > >
> > > > Actually, I've been having problems installing the PHP-Postgres
> > > > interface on a VA Box running Postgres 7.0.2.  I just thought that
> > > > nobody was on the list.  SO, let me throw this out there:
> > > >
> > > > 1. Postgres was installed from RPM, and PHP4 was built from source
> > > > (because RPMs were not available at the time).  The webserver we are
> > > > running is Xitami
> > > >
> > > > 2. When we tried to build the postgres interface from source, the
make
> > > > crashes after about 5 minutes, saying that it can't find certain
> > > > libraries that are present and in the directory we supplied in the
make
> > > > command line.
> > > >
> > > > 3. When we try to install from RPM, PHP-Postgres wants a library
called
> > > > pgsql.so.  THis library, as far as I can tell, does not exist in any
of
> > > > the Postgres sources.
> > > >
> > > > Any thoughts?
> > >
> > > Not sure right off what a "VA Box" is and I'm not familiar with
Xitami,
> > > BUT I may be able to shed some light on things.
> > >
> > > In #2 above, it sounds like your OS installation is incomplete or you
> > > have some missing tools required to build PostgreSQL.
> > >
> > > Are you installing PostgreSQL from one of our RPMs or from somewhere
> > > else?  If it's one of ours, check with Lamar Owen on this library.
The
> > > only thing I can find that comes close is plpgsql and I doubt that's
it.
> > >
> > > Vince.
> > > --
> > >
==========================================================================
> > > Vince Vielhaber -- KA8CSH    email: vev@michvhf.com
http://www.pop4.net
> > >  128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4
Networking
> > >         Online Campground Directory    http://www.camping-usa.com
> > >        Online Giftshop Superstore    http://www.cloudninegifts.com
> > >
==========================================================================
> > >
> > >
> >
> >
>
> --
> ==========================================================================
> Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
>  128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
>         Online Campground Directory    http://www.camping-usa.com
>        Online Giftshop Superstore    http://www.cloudninegifts.com
> ==========================================================================
>
>




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Installation problems   was Re: is this list live?
  2000-10-17 17:20 Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  2000-10-17 17:27 ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
  2000-10-17 18:27   ` Re: Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
@ 2000-10-17 19:37     ` Josh Berkus <josh@agliodbs.com>
  2000-10-17 19:48       ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
  2000-10-17 20:29       ` Re: Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  1 sibling, 2 replies; 7+ messages in thread

From: Josh Berkus @ 2000-10-17 19:37 UTC (permalink / raw)
  To: Vince Vielhaber <vev@michvhf.com>; pgsql-php

Vince,

> Oh, Ok.  Are they known for installing the entire OS or do they leave
> out the development stuff?  I remember reading not too long ago that
> someone isn't putting the development stuff on by default but I don't
> recall who.

On the 420 (the model I'm using) they leave out a lot of the development
stuff.  It's sold as a workstation.  However, I've been installing the
stuff myself.  

I used the RPMs off PostgreSQL.org to install.  I believe that the first
time (this machine had a disk partitioning problem and I had to
re-install everything) I built from source as the RPM's weren't
available, but I'm not really sure.

BTW, Jeff MacDonald at PG-SQL Inc. is working on this (I have a support
contract) but he isn't making much headway so any help is appreciated.

-Josh Berkus

-- 
______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology      josh@agliodbs.com
    and data management solutions       (415) 436-9166
   for law firms, small businesses       fax  436-0137
    and non-profit organizations.       pager 338-4078
                        		San Francisco



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Installation problems   was Re: is this list live?
  2000-10-17 17:20 Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  2000-10-17 17:27 ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
  2000-10-17 18:27   ` Re: Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  2000-10-17 19:37     ` Re: Installation problems   was Re: is this list live? Josh Berkus <josh@agliodbs.com>
@ 2000-10-17 19:48       ` Adam Lang <aalang@rutgersinsurance.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Adam Lang @ 2000-10-17 19:48 UTC (permalink / raw)
  To: pgsql-php

Like I said... I had many problems with using RPMs of one program and then
compiling another that is dependent on libraries from the RPM.    If you
can, a compile from scratch of the three apps would almost assuredly solve
your problem.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Vince Vielhaber" <vev@michvhf.com>; "phpp" <pgsql-php@postgresql.org>
Sent: Tuesday, October 17, 2000 3:37 PM
Subject: Re: Installation problems was Re: is this list live?


> Vince,
>
> > Oh, Ok.  Are they known for installing the entire OS or do they leave
> > out the development stuff?  I remember reading not too long ago that
> > someone isn't putting the development stuff on by default but I don't
> > recall who.
>
> On the 420 (the model I'm using) they leave out a lot of the development
> stuff.  It's sold as a workstation.  However, I've been installing the
> stuff myself.
>
> I used the RPMs off PostgreSQL.org to install.  I believe that the first
> time (this machine had a disk partitioning problem and I had to
> re-install everything) I built from source as the RPM's weren't
> available, but I'm not really sure.
>
> BTW, Jeff MacDonald at PG-SQL Inc. is working on this (I have a support
> contract) but he isn't making much headway so any help is appreciated.
>
> -Josh Berkus
>
> --
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                         Josh Berkus
>    Complete information technology      josh@agliodbs.com
>     and data management solutions       (415) 436-9166
>    for law firms, small businesses       fax  436-0137
>     and non-profit organizations.       pager 338-4078
>                         San Francisco




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Installation problems   was Re: is this list live?
  2000-10-17 17:20 Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  2000-10-17 17:27 ` Re: Installation problems   was Re: is this list live? Adam Lang <aalang@rutgersinsurance.com>
  2000-10-17 18:27   ` Re: Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
  2000-10-17 19:37     ` Re: Installation problems   was Re: is this list live? Josh Berkus <josh@agliodbs.com>
@ 2000-10-17 20:29       ` Vince Vielhaber <vev@michvhf.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Vince Vielhaber @ 2000-10-17 20:29 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-php

On Tue, 17 Oct 2000, Josh Berkus wrote:

> Vince,
> 
> > Oh, Ok.  Are they known for installing the entire OS or do they leave
> > out the development stuff?  I remember reading not too long ago that
> > someone isn't putting the development stuff on by default but I don't
> > recall who.
> 
> On the 420 (the model I'm using) they leave out a lot of the development
> stuff.  It's sold as a workstation.  However, I've been installing the
> stuff myself.  
> 
> I used the RPMs off PostgreSQL.org to install.  I believe that the first
> time (this machine had a disk partitioning problem and I had to
> re-install everything) I built from source as the RPM's weren't
> available, but I'm not really sure.
> 
> BTW, Jeff MacDonald at PG-SQL Inc. is working on this (I have a support
> contract) but he isn't making much headway so any help is appreciated.

Well I'm sure he's reading/listening so I'll tell you both.

If it were me, what I'd do (aside from using FreeBSD instead of Linux,
but that's another thing) first is find all of the developers RPMs and get
them installed.  

Then install PostgreSQL from sources.

Then build and install any and all of the extra packages you want to use
with php (I build imapd, gd and mcrypt - something else too but I can't
think of it off hand).  

Since I use apache instead of Xitami I'll give the apache version.

Configure apache with the options you want.

Configure php with all of the options and extra stuff (imapd, etc) and
without mysql.  Make and make install.

Go back to the apache directory and finish building and installing it.  

If you have all of your development stuff installed correctly, all of
these steps should just flow (except for the occasional build errors
in apache wrt mcrypt.

Lastly, make sure you've added any necessary libraries to either your
LD_LIBRARY_PATH or your ldconfig or whatever applies to your OS.

Build hint:  In any directory you run configure in with any extra
switches, create a script file with all of the switches in it.  eg:

#!/bin/sh

./configure \
	--without-mysql \
	--with-apache=../apache_1.3.14 \

... and so on.   Yes, Marc I got that idea from you.  :)

That way if you need to rebuild it you only need to execute the script.

Hope it helps!!

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================






^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2000-10-17 20:29 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-17 17:20 Installation problems   was Re: is this list live? Vince Vielhaber <vev@michvhf.com>
2000-10-17 17:27 ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-17 18:27   ` Vince Vielhaber <vev@michvhf.com>
2000-10-17 18:59     ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-17 19:37     ` Josh Berkus <josh@agliodbs.com>
2000-10-17 19:48       ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-17 20:29       ` Vince Vielhaber <vev@michvhf.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox