Thread: Perl DBI

Perl DBI

From
Cheryl Thompson
Date:
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


Re: Perl DBI

From
douggorley@shaw.ca
Date:
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


Re: Perl DBI

From
Cheryl Thompson
Date:
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


Re: Perl DBI

From
douggorley@shaw.ca
Date:
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
>