Problem installing Pg.pm on FreeBSD - Mailing list pgsql-interfaces
From | Aaron Cutchin |
---|---|
Subject | Problem installing Pg.pm on FreeBSD |
Date | |
Msg-id | 20021030013516.6782.qmail@web14908.mail.yahoo.com Whole thread Raw |
List | pgsql-interfaces |
I am having a problem installing Pg.pm on a new installation of FreeBSD 4.6. I have installed the following ports: p5-DBD-Pg-1.13 p5-Pg-7.2.3 p5-postgresql-plperl-7.2.3 postgresql-7.2.3 p5-DBI-1.28 I am using a test script from http://home.school.net.hk/~hywong/postgres.html. The script is included below. I get the following error message when I try to run the script: Can't locate auto/Pg/new.al in @INC (@INC contains: /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 .) at ./test.pl line 15 I have a directory "/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/Pg", but there is no file named "new.al" in it! Was this file supposed to have been installed? Thanks a lot for the help! Details below: -- Aaron -- aaron.DELETE.cutchin@THESE.yahoo.WORDS.com ------------------------------------------------------ Output of perl -v: ------------------ This is perl, version 5.005_03 built for i386-freebsd Copyright 1987-1999, Larry Wall ... Output of perl -V ----------------- Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=freebsd, osvers=4.0-current, archname=i386-freebsd uname='FreeBSD freefall.FreeBSD.org 4.0-current FreeBSD 4.0-current #0: $Date$' hint=recommended, useposix=true, d_sigaction=define usethreads=undef useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='undef', gccversion=2.95.2 19991024 (release) cppflags='' ccflags ='' stdchar='char', d_stdstdio=undef, usevfork=true intsize=4, longsize=4,ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 alignbytes=4, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags='-Wl,-E -lperl -lm ' libpth=/usr/lib libs=-lm -lc -lcrypt libc=, so=so, useshrplib=true, libperl=libperl.so.3 Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -Wl,-R/usr/lib' cccdlflags='-DPIC -fpic', lddlflags='-Wl,-E -shared -lperl -lm ' Characteristics of this binary (from libperl): Built under freebsd Compiled at Jun 11 2002 03:54:48 @INC: /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 Version of PostGreSQL: ---------------------- I am assuming 7.2.3, because that is the name of the FreeBSD Port I installed. Version of "pgsql-perl5": ------------------------- I don't know what this is. Is this a FreeBSD Port? I do not see it in the tree. If this is the missing link, shouldn't it be installed from the Ports tree? Test Script: ------------ #!/usr/bin/perl use Pg; use CGI qw(:standard); print header; print start_html('A PostgresSQL Example'), h1('A PostgresSQL Example'), start_form, "SQL: select * from test", p, submit, end_form, hr; $conn = Pg::new('','','','','hywong'); $sql = "select * from test"; $result = $conn->exec($sql); $t = '1'; $html3 = $t; $align = $t; $header = $t; $tableOpt = 'Border'; $result->print(stdout, $header, $align, $standard, $html3, $expanded, $pager, $fieldSep, $tableOpt, $caption); print end_html; exit; __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/
pgsql-interfaces by date: