Re: Implementing mod_perl, Perl 5.004, and Postgres

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(at)link(dot)com>
> > > To: <pgsql-admin(at)postgresql(dot)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."