Re: Implementing mod_perl, Perl 5.004, and Postgres

Oh you definitely want to keep on top of the monthly "recommended" patch cluster with Solaris.
Sorry I didn't think of that. Yes, whenever one is having funky problems ask yourself if you have the latest stable
revision/patchlevel.

----- Original Message -----
From: "Jimi Thompson" <jthompson@link.com>
To: <pgsql-admin@postgresql.org>
Cc: "root" <root@dennis.veritime.com>
Sent: Monday, December 11, 2000 4:10 PM
Subject: Re: [ADMIN] 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."
>
>