Thread: Perl DBI
I'm sorry if this is the wrong forum... if someone knows of a better forum (alt.users.trying.to.run.postgres.and.perl.with.apache.on.windows doesn't exist :D), please let me know. Thanks to the many helpful people in this group I located the DBD::Pg files on CPAN. However, following the instructions for PgSimple (this is all being done on the Cygwin side), I get an error that has stumped the one person in the office who uses Perl. (He came up with the supremely helpful: "You're missing the Perl module for postgresql." To which my reply is, "This IS the Perl module for PostGresQL"). Has anyone set up this configuration? Can you tell me what I'm doing wrong here??? (Besides trying to ignore the first error in hopes it would go through steps 2 and 3 anyway). I can read this and say, "Ok, it can't find Perl", but I don't know how to tell it "hey, Perl is over here---> /Perl". I have currently on this box: Apache 2.0.3 Cygwin Postgresql (runs through Cygwin) Active Perl 5.8 [Should I have installed a different Perl through Cygwin as a LINUX build, not through windows as Active Perl?? Would Apache and everything ELSE then have to run through Cygwin? I can see that being an issue; on the other hand it seems kind of a silly way to do this. Access through Windows can see Postgresql; why can't Perl?] Thanks, Cheryl "I Hope To Stop Posting To This List Real Soon Now" Thompson ---------------------Cut N Paste--------------------------------------------- cthompso@MyBox /Pg-Simple-1.0 $ ls COPYRIGHT LICENSE Makefile README test.pl Changes MANIFEST Makefile.PL Simple.pm cthompso@MyBox /Pg-Simple-1.0 $ perl Makefile.pl Warning: prerequisite Pg failed to load: Can't locate Pg.pm in @INC (@INC conta ns: /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_ erl/5.6.1/cygwin-multi /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl ) at (eval 4) line 3. Writing Makefile for Pg::Simple cthompso@MyBox /Pg-Simple-1.0 $ make cp Simple.pm blib/lib/Pg/Simple.pm Manifying blib/man3/Pg.Simple.3 cthompso@MyBox /Pg-Simple-1.0 $ make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.1/c gwin-multi -I/usr/lib/perl5/5.6.1 test.pl 1..1 Can't locate Pg.pm in @INC (@INC contains: blib/arch blib/lib /usr/lib/perl5/5. .1/cygwin-multi /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 /usr/lib perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/cy win-multi /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl .) at blib/li /Pg/Simple.pm line 67. BEGIN failed--compilation aborted at blib/lib/Pg/Simple.pm line 67. Compilation failed in require at test.pl line 10. BEGIN failed--compilation aborted at test.pl line 10. make: *** [test_dynamic] Error 2 cthompso@MyBox /Pg-Simple-1.0
Just a thought, but have you tried installing Pg::Simple via CPAN as well? Doug Gorley | douggorley@shaw.ca ----- Original Message ----- From: Cheryl Thompson <cthompso@ci.irving.tx.us> Date: Tuesday, January 21, 2003 11:18 am Subject: [NOVICE] Perl DBI > I'm sorry if this is the wrong forum... if someone knows of a > better forum > (alt.users.trying.to.run.postgres.and.perl.with.apache.on.windows > doesn'texist :D), please let me know. > > Thanks to the many helpful people in this group I located the > DBD::Pg files > on CPAN. > However, following the instructions for PgSimple (this is all > being done on > the Cygwin side), I get an error that has stumped the one person > in the > office who uses Perl. (He came up with the supremely helpful: "You're > missing the Perl module for postgresql." To which my reply is, > "This IS the > Perl module for PostGresQL"). > > Has anyone set up this configuration? Can you tell me what I'm > doing wrong > here??? (Besides trying to ignore the first error in hopes it > would go > through steps 2 and 3 anyway). > > I can read this and say, "Ok, it can't find Perl", but I don't > know how to > tell it "hey, Perl is over here---> /Perl". > > I have currently on this box: > Apache 2.0.3 > Cygwin > Postgresql (runs through Cygwin) > Active Perl 5.8 > > [Should I have installed a different Perl through Cygwin as a > LINUX build, > not through windows as Active Perl?? Would Apache and everything > ELSE then > have to run through Cygwin? I can see that being an issue; on the > other hand > it seems kind of a silly way to do this. Access through Windows > can see > Postgresql; why can't Perl?] > > Thanks, > Cheryl "I Hope To Stop Posting To This List Real Soon Now" Thompson > > ---------------------Cut N > Paste--------------------------------------------- > > cthompso@MyBox /Pg-Simple-1.0 > $ ls > COPYRIGHT LICENSE Makefile README test.pl > Changes MANIFEST Makefile.PL Simple.pm > > cthompso@MyBox /Pg-Simple-1.0 > $ perl Makefile.pl > Warning: prerequisite Pg failed to load: Can't locate Pg.pm in > @INC (@INC > conta > ns: /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > /usr/lib/perl5/site_ > erl/5.6.1/cygwin-multi /usr/lib/perl5/site_perl/5.6.1 > /usr/lib/perl5/site_perl > ) at (eval 4) line 3. > Writing Makefile for Pg::Simple > > cthompso@MyBox /Pg-Simple-1.0 > $ make > cp Simple.pm blib/lib/Pg/Simple.pm > Manifying blib/man3/Pg.Simple.3 > > cthompso@MyBox /Pg-Simple-1.0 > $ make test > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > -I/usr/lib/perl5/5.6.1/c > gwin-multi -I/usr/lib/perl5/5.6.1 test.pl > 1..1 > Can't locate Pg.pm in @INC (@INC contains: blib/arch blib/lib > /usr/lib/perl5/5. > .1/cygwin-multi /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > /usr/lib > perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > /usr/lib/perl5/site_perl/5.6.1/cy > win-multi /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl > .) at > blib/li > /Pg/Simple.pm line 67. > BEGIN failed--compilation aborted at blib/lib/Pg/Simple.pm line 67. > Compilation failed in require at test.pl line 10. > BEGIN failed--compilation aborted at test.pl line 10. > make: *** [test_dynamic] Error 2 > > cthompso@MyBox /Pg-Simple-1.0 > > > ---------------------------(end of broadcast)---------------------- > ----- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org
This is the module Pg::Simple found at http://www.cpan.org/modules/by-category/07_Database_Interfaces/Pg/ which is linked as /PG/ but actually named PG Simple. -----Original Message----- From: douggorley@shaw.ca [mailto:douggorley@shaw.ca] Sent: Tuesday, January 21, 2003 1:26 PM To: Cheryl Thompson Cc: 'pgsql-novice@postgresql.org' Subject: Re: [NOVICE] Perl DBI Just a thought, but have you tried installing Pg::Simple via CPAN as well? Doug Gorley | douggorley@shaw.ca ----- Original Message ----- From: Cheryl Thompson <cthompso@ci.irving.tx.us> Date: Tuesday, January 21, 2003 11:18 am Subject: [NOVICE] Perl DBI > I'm sorry if this is the wrong forum... if someone knows of a > better forum > (alt.users.trying.to.run.postgres.and.perl.with.apache.on.windows > doesn'texist :D), please let me know. > > Thanks to the many helpful people in this group I located the > DBD::Pg files > on CPAN. > However, following the instructions for PgSimple (this is all > being done on > the Cygwin side), I get an error that has stumped the one person > in the > office who uses Perl. (He came up with the supremely helpful: "You're > missing the Perl module for postgresql." To which my reply is, > "This IS the > Perl module for PostGresQL"). > > Has anyone set up this configuration? Can you tell me what I'm > doing wrong > here??? (Besides trying to ignore the first error in hopes it > would go > through steps 2 and 3 anyway). > > I can read this and say, "Ok, it can't find Perl", but I don't > know how to > tell it "hey, Perl is over here---> /Perl". > > I have currently on this box: > Apache 2.0.3 > Cygwin > Postgresql (runs through Cygwin) > Active Perl 5.8 > > [Should I have installed a different Perl through Cygwin as a > LINUX build, > not through windows as Active Perl?? Would Apache and everything > ELSE then > have to run through Cygwin? I can see that being an issue; on the > other hand > it seems kind of a silly way to do this. Access through Windows > can see > Postgresql; why can't Perl?] > > Thanks, > Cheryl "I Hope To Stop Posting To This List Real Soon Now" Thompson > > ---------------------Cut N > Paste--------------------------------------------- > > cthompso@MyBox /Pg-Simple-1.0 > $ ls > COPYRIGHT LICENSE Makefile README test.pl > Changes MANIFEST Makefile.PL Simple.pm > > cthompso@MyBox /Pg-Simple-1.0 > $ perl Makefile.pl > Warning: prerequisite Pg failed to load: Can't locate Pg.pm in > @INC (@INC > conta > ns: /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > /usr/lib/perl5/site_ > erl/5.6.1/cygwin-multi /usr/lib/perl5/site_perl/5.6.1 > /usr/lib/perl5/site_perl > ) at (eval 4) line 3. > Writing Makefile for Pg::Simple > > cthompso@MyBox /Pg-Simple-1.0 > $ make > cp Simple.pm blib/lib/Pg/Simple.pm > Manifying blib/man3/Pg.Simple.3 > > cthompso@MyBox /Pg-Simple-1.0 > $ make test > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > -I/usr/lib/perl5/5.6.1/c > gwin-multi -I/usr/lib/perl5/5.6.1 test.pl > 1..1 > Can't locate Pg.pm in @INC (@INC contains: blib/arch blib/lib > /usr/lib/perl5/5. > .1/cygwin-multi /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > /usr/lib > perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > /usr/lib/perl5/site_perl/5.6.1/cy > win-multi /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl > .) at > blib/li > /Pg/Simple.pm line 67. > BEGIN failed--compilation aborted at blib/lib/Pg/Simple.pm line 67. > Compilation failed in require at test.pl line 10. > BEGIN failed--compilation aborted at test.pl line 10. > make: *** [test_dynamic] Error 2 > > cthompso@MyBox /Pg-Simple-1.0 > > > ---------------------------(end of broadcast)---------------------- > ----- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org
More specifically, if you type the following at the command line: perl -MCPAN -e 'install Pg::Simple' What happens? Doug Gorley | douggorley@shaw.ca ----- Original Message ----- From: Cheryl Thompson <cthompso@ci.irving.tx.us> Date: Tuesday, January 21, 2003 11:31 am Subject: Re: [NOVICE] Perl DBI > This is the module Pg::Simple found at > http://www.cpan.org/modules/by-category/07_Database_Interfaces/Pg/ > which is > linked as /PG/ but actually named PG Simple. > > > -----Original Message----- > From: douggorley@shaw.ca [mailto:douggorley@shaw.ca] > Sent: Tuesday, January 21, 2003 1:26 PM > To: Cheryl Thompson > Cc: 'pgsql-novice@postgresql.org' > Subject: Re: [NOVICE] Perl DBI > > > Just a thought, but have you tried installing Pg::Simple via CPAN > as well? > > Doug Gorley | douggorley@shaw.ca > > > ----- Original Message ----- > From: Cheryl Thompson <cthompso@ci.irving.tx.us> > Date: Tuesday, January 21, 2003 11:18 am > Subject: [NOVICE] Perl DBI > > > I'm sorry if this is the wrong forum... if someone knows of a > > better forum > > > (alt.users.trying.to.run.postgres.and.perl.with.apache.on.windows > > doesn'texist :D), please let me know. > > > > Thanks to the many helpful people in this group I located the > > DBD::Pg files > > on CPAN. > > However, following the instructions for PgSimple (this is all > > being done on > > the Cygwin side), I get an error that has stumped the one person > > in the > > office who uses Perl. (He came up with the supremely helpful: > "You're> missing the Perl module for postgresql." To which my > reply is, > > "This IS the > > Perl module for PostGresQL"). > > > > Has anyone set up this configuration? Can you tell me what I'm > > doing wrong > > here??? (Besides trying to ignore the first error in hopes it > > would go > > through steps 2 and 3 anyway). > > > > I can read this and say, "Ok, it can't find Perl", but I don't > > know how to > > tell it "hey, Perl is over here---> /Perl". > > > > I have currently on this box: > > Apache 2.0.3 > > Cygwin > > Postgresql (runs through Cygwin) > > Active Perl 5.8 > > > > [Should I have installed a different Perl through Cygwin as a > > LINUX build, > > not through windows as Active Perl?? Would Apache and everything > > ELSE then > > have to run through Cygwin? I can see that being an issue; on > the > > other hand > > it seems kind of a silly way to do this. Access through Windows > > can see > > Postgresql; why can't Perl?] > > > > Thanks, > > Cheryl "I Hope To Stop Posting To This List Real Soon Now" Thompson > > > > ---------------------Cut N > > Paste--------------------------------------------- > > > > cthompso@MyBox /Pg-Simple-1.0 > > $ ls > > COPYRIGHT LICENSE Makefile README test.pl > > Changes MANIFEST Makefile.PL Simple.pm > > > > cthompso@MyBox /Pg-Simple-1.0 > > $ perl Makefile.pl > > Warning: prerequisite Pg failed to load: Can't locate Pg.pm in > > @INC (@INC > > conta > > ns: /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > > /usr/lib/perl5/site_ > > erl/5.6.1/cygwin-multi /usr/lib/perl5/site_perl/5.6.1 > > /usr/lib/perl5/site_perl > > ) at (eval 4) line 3. > > Writing Makefile for Pg::Simple > > > > cthompso@MyBox /Pg-Simple-1.0 > > $ make > > cp Simple.pm blib/lib/Pg/Simple.pm > > Manifying blib/man3/Pg.Simple.3 > > > > cthompso@MyBox /Pg-Simple-1.0 > > $ make test > > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > > -I/usr/lib/perl5/5.6.1/c > > gwin-multi -I/usr/lib/perl5/5.6.1 test.pl > > 1..1 > > Can't locate Pg.pm in @INC (@INC contains: blib/arch blib/lib > > /usr/lib/perl5/5. > > .1/cygwin-multi /usr/lib/perl5/5.6.1/cygwin-multi > /usr/lib/perl5/5.6.1> /usr/lib > > perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1 > > /usr/lib/perl5/site_perl/5.6.1/cy > > win-multi /usr/lib/perl5/site_perl/5.6.1 > /usr/lib/perl5/site_perl > > .) at > > blib/li > > /Pg/Simple.pm line 67. > > BEGIN failed--compilation aborted at blib/lib/Pg/Simple.pm line 67. > > Compilation failed in require at test.pl line 10. > > BEGIN failed--compilation aborted at test.pl line 10. > > make: *** [test_dynamic] Error 2 > > > > cthompso@MyBox /Pg-Simple-1.0 > > > > > > ---------------------------(end of broadcast)-------------------- > -- > > ----- > > TIP 1: subscribe and unsubscribe commands go to > > majordomo@postgresql.org > > > ---------------------------(end of broadcast)---------------------- > ----- > TIP 4: Don't 'kill -9' the postmaster >