Re: Implementing mod_perl, Perl 5.004, and Postgres

Dennis,

I am posting in the hopes that this helps some other poor Slowlaris user.  After much hair pulling and assistance
from some very kind people (Dennis, Dana, etc.), I have my application installed.

My current OS is solaris 2.6 (on this box).  For those not familiar is Sparc-Solaris 2.6, about all you get from a
standard install is a command prompt.  There isn't enough software there to actually DO anything except maybe make
the cursor blink.  Well, it's not really THAT bad, but it is certainly very close to it.

In order for any of this to work (CPAN, DBI, DBD, etc.), you need to apply approximately 60 MB of patches to your
OS.  I'm not sure which individual patch did the job and I have absolutely no intention of testing to find out.
If you, dear reader, care to please feel free to do so.  I, however, wash my hands of the process.

In frustration, I contacted Sun who advised me to apply the y2k patches and the "recommend bundle" of patches,
which I have done.  This seems to have resolved the continuing issues I have had with package dependencies.
HALLELUJAH!


This then allowed the DBI to install.  In turn this allowed the DBD to install, along with a current version of
CPAN, which does at least try to resolve the package dependencies it encounters.  Now, all I have to do is tweak
my scripts and all will be well in the world.

Final word of warning - watch those users and file permissions in the scripts accessing the database.




root wrote:

> Yes,
>
> you must do:
> perl -MCPAN -e shell
> install Bundle::DBI
>
> You must then
> chmod 777 -R /path to DBD-Pg-0.95        **********be very careful***********
> su postgres
> cd /path to DBD-Pg-0.95
> POSTGRES_INCLUDE=/usr/include/pgsql
> POSTGRES_LIB=/usr/lib/pgsql
> export POSTGRES_INCLUDE
> export POSTGRES_LIB
> ./configure
> make
> exit ********back to root
> make install
>
> Good luck (again) ;)
>
> Rodney Hampton
> root@veritime.com
>
> On Mon, 04 Dec 2000, you wrote:
> >
> > root wrote:
> >
> > > I'll do you one better.  Here it is:
> > >
> > > On Thu, 30 Nov 2000, you wrote:
> > > >
> > > > I am posting this because it will probably help someone else out.  There are about a zillion different
> > > > flavors of the Pg.pm.  This has proven to be a real hair-puller for me and I am hoping this saves
> > > > someone else some time.
> > > >
> > > > To Dana: Thanks for pointing me in the right direction.  I haven't had time until now, to really get
> > > > my teeth back into this thing again.  I tried to install it from the command line as you suggested,
> > > > but CPAN says that it isn't sure which module I want.  I searched manually and found 3 that would seem
> > > > to qualify.  I have tentatively ruled out the third one because I am running 7.0.2 and not 95.
> > > > However, this leaves me with items 1 and 2.
> > > >
> > > > As soon as I determine which one is really "it", I will add to this posting to let everyone know.  In
> > > > the mean time, someone might want to mention this in the FAQ somewhere, especially if they know which
> > > > module is "correct" or have some way to differentiate between all of them.  More reading and empirical
> > > > testing on the way.
> > > >
> > > > PgSQL-0.51: "Pure perl" interface to PostgreSQL  [ download / quickinstall ]
> > > > CPAN directory: G/GT/GTHYNI (Göran Thyni)
> > > > Category  >> Database Interfaces  >>  PgSQL
> > > >
> > > > perl: Perl5 extension for PostgreSQL  [ download / quickinstall ]
> > > >  CPAN directory:M/ME/MERGL (Edmund Mergl)
> > > >  Category  >> Database Interfaces  >>  Pg
> > > >
> > > >  Postgres-1.4: Perl interface to the Postgres95 SQL database engine  [ download / quickinstall ]
> > > > CPAN directory: V/VK/VKHERA (Vivek Khera)
> > > > Category  >>Database Interfaces  >>  Postgres
> > > >
> > > >
> > > >
> > > > Dana Hudes wrote:
> > > >
> > > > > Do you have Pg installed?
> > > > > that's the Perl interface to Postgres and it is apparently not part of the build from the RPM set.
> > > > > so go to CPAN and install in the usual manner i.e., as root :
> > > > > perl -MCPAN -eshell
> > > > > install Pg
> > > > > quit
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Jimi Thompson" <jthompson@link.com>
> > > > > To: <pgsql-admin@postgresql.org>
> > > > > Sent: Thursday, November 09, 2000 4:25 PM
> > > > > Subject: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres
> > > > >
> > > > > > I am trying to get Postgres to accept Perl as an interface.  I am
> > > > > > running Apache 1.3.14, Perl 5.004_04, and mod_perl.  My application is a
> > > > > > help desk/call ticketing system called Teacup
> > > > > > (http://www.altara.org.teacup.html) which is written in Perl.  It's a
> > > > > > series of CGI scripts which allow input, queries, etc. to a Postgres
> > > > > > back-end.
> > > > > >
> > > > > > Each of my components (apparently) works fine individually.  Apache is
> > > > > > displaying pages and will run perl and cgi scripts. Perl is operating in
> > > > > > and outside Apache.  Mod_perl is working just fine.  My problem is in
> > > > > > trying to use Perl to access Postgres.
> > > > > >
> > > > > > I keep getting error messages from my CGI scripts regarding a file
> > > > > > called Pg.pm.  Since this appears to be a perl module, I was wondering
> > > > > > if anyone knows how to go about making Perl and Postgres like each other
> > > > > > :)
> > > > > >
> > > > > > Jimi Thompson
> > > > > > L3 communications
> > > > > >
> > > > > > "It's the same thing we do every night, Pinky."
> > > > > >
> > > > > >
> > > >
> > > > --
> > > > Jimi Thompson
> > > > Web Master
> > > > L3 communications
> > > >
> > > > "It's the same thing we do every night, Pinky."
> > > >
> > > >
> > >
> > > ----------------------------------------
> > > Content-Type: text/x-vcard; name="jthompson.vcf"
> > > Content-Transfer-Encoding: 7bit
> > > Content-Description: Card for Jimi Thompson
> > > ----------------------------------------
> > >
> > > --
> > >
> > >   ------------------------------------------------------------------------
> > >                              Name: DBD-Pg-0.95.tar
> > >    DBD-Pg-0.95.tar           Type: Unix Tape Archive (application/x-tar)
> > >                          Encoding: base64
> > >                   Download Status: Not downloaded with message
> >
> > Thanks for the tip!  It seems that this is a never ending battle of package/module dependencies which have
> > to be manually resovled.  I never realized how spoiled I was by Red Hat and the RPM.  This is what I get for
> > running Solaris 2.6 :).  Upon attempting to install this module, I get a request for DBI.  DBI wants me to
> > set environment variables. Again, I'm guessing that this is DBI-1.14.tar.gz from CPAN.  I could be wrong and
> > it could be a totally different DBI.
> >
> >
> > --
> > Jimi Thompson
> > Web Master
> > L3 communications
> >
> > "It's the same thing we do every night, Pinky."
> >
> >
>
> ----------------------------------------
> Content-Type: text/x-vcard; name="jthompson.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Jimi Thompson
> ----------------------------------------
>
> --

--
Jimi Thompson
Web Master
L3 communications

"It's the same thing we do every night, Pinky."