Thread: 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."
Attachment
On Thu, 9 Nov 2000, Jimi Thompson wrote:
> 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
> :)
If your use directive in your perl routine states:
use DBI;
And you are getting stderr complaining about missing Pg in @INC
then you are missing DBD::Pg. Grab it from CPAN and do a build.
This presumes you have the prerequisite: DBI.pm
Apache ---> DBI.pm ---> DBD::Pg (Pg.pm) ---> Postgres
|<------ Perl ---------->|
Obviously I have a great future behind me in cartography but I
think you get the idea: DBI is a generic interface that uses
a specific driver to access Pg. DBI and DBD are perl modules.
Good hunting,
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
--------------------------------------------------------------------
Jimi Thompson writes: > 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 ./configure --with-perl gmake all gmake install -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
jimi, you have to install modules like DBD-pg, DBD-CSV, DBI etc, which u get from www.cpan.org all the best try ur luck after installing them. i hope u''' be on target!!! regards Rajesh Intercept Consulting - INDIA --- Jimi Thompson <jthompson@link.com> wrote: > 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." > > > begin:vcard > n:Thompson;Jimi > tel;cell:817-980-7863 > tel;work:817-619-3612 > x-mozilla-html:FALSE > url:hww > adr:;;;;;; > version:2.1 > email;internet:jthompson@link.com > fn:Jimi Thompson > end:vcard > __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/
jimi, you have to install modules like DBD-pg, DBD-CSV, DBI etc, which u get from www.cpan.org all the best try ur luck after installing them. i hope u''' be on target!!! regards Rajesh Intercept Consulting - INDIA --- Jimi Thompson <jthompson@link.com> wrote: > 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." > > > begin:vcard > n:Thompson;Jimi > tel;cell:817-980-7863 > tel;work:817-619-3612 > x-mozilla-html:FALSE > url:hww > adr:;;;;;; > version:2.1 > email;internet:jthompson@link.com > fn:Jimi Thompson > end:vcard > __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/
Jimi,
could you be more informative ? Environment, error messages
I have several projects running under modperl and using postgres
as a database backend and have no problem. I use DBD::Pg though
Oleg
On Thu, 9 Nov 2000, Jimi Thompson wrote:
> Date: Thu, 09 Nov 2000 15:25:54 -0600
> From: Jimi Thompson <jthompson@link.com>
> To: pgsql-admin@postgresql.org
> 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."
>
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
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."
Attachment
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."
Attachment
there are 2 Perl interfaces to Postgres. Pg and DBD::Pg . They are different. DBD has a prereqisite of DBI. CPAN installation works even easier than RPM if you allow it to follow prerequisites it will download and install eerything needed to satisfy the dependencies.
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."
Attachment
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." > >