help me please... - Mailing list pgsql-general
From | robert sanford |
---|---|
Subject | help me please... |
Date | |
Msg-id | 20020411224419-r01050000-91F5989D-4DC7-11D6-9D8F-003065DE1A58-1013-0108@192.168.1.100 Whole thread Raw |
List | pgsql-general |
okay, i have no idea of a better place to go to for advice so i'm trying here. if this is the wr ong place to go then i apologize. if someone wants to help me off-line then that would be great. i have successfully installed postgresql 7.2 on my OSX box. everything works just grand with pgsql and dbviusalizer as well. now i want to get it up and running with perl so that i can port some existing scripts to use postgres instead of my current database engine. this is where i'm having some serious difficulties. i'm trying to build dbd-pg-1.00 on mac osx and am getting compile errors. i've included information from perl (-v and -V) below as well as the results from downloading the package and running the commands directly from the shell as well as running install DBD::Pg from the cpan module's interactive shell so that you can see where everything is failing. i was able to install MD5 and the inet libraries as well as the most recent cpan modules successfully. this leads me to believe that there is something specifically wrong with the manner in which i am attempting to install the postgresql dbd module. any help is greatly appreciated. many thanks! rjsjr ########## perl -v ########## This is perl, v5.6.0 built for darwin Copyright 1987-2000, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5.0 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using `man perl' or `perldoc perl'. If you have access to the Internet, point your browser at http://www.perl.com/, the Perl Home Page. ########## perl -V ########## [localhost:/documents/football/sql] robertsa% perl -V Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration: Platform: osname=darwin, osvers=1.4, archname=darwin uname='darwin law 1.4 darwin kernel version 1.3: sun jul 22 16:20:35 pdt 2001; aramesh:buildobjrelease_ppc power macintosh powerpc ' config_args='-ds -e -Dprefix=/usr -Dccflags=-g -pipe -Dldflags=' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef Compiler: cc='cc', optimize='-O3', gccversion=Apple devkit-based CPP 6.0 cppflags='-g -pipe -pipe -fno-common -no-cpp-precomp -flat_namespace -DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing' ccflags ='-g -pipe -pipe -fno-common -no-cpp-precomp -flat_namespace -DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing' stdchar='char', d_stdstdio=undef, usevfork=true intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags ='' libpth=/usr/lib libs=-lm -lc libc=/System/Library/Frameworks/System.framework/System, so=dylib, useshrplib=true, libperl=libperl.dylib Dynamic Linking: dlsrc=dl_dyld.xs, dlext=bundle, d_dlsymun=undef, ccdlflags=' ' cccdlflags=' ', lddlflags='-bundle -flat_namespace -undefined suppress' Characteristics of this binary (from libperl): Compile-time options: USE_LARGE_FILES Built under darwin Compiled at Sep 2 2001 17:24:33 @INC: /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Perl /Network/Library/Perl/darwin /Network/Library/Perl /Network/Library/Perl . [localhost:/documents/football/sql] robertsa% ########## building directly ########## [localhost:dev/perl/dbd-pg-1.00] robertsa% env POSTGRES_INCLUDE=/include/ POSTGRES_LIB=/lib/ perl makefile.pl Configuring Pg Remember to actually read the README file ! OS: darwin Using DBI 1.21 installed in /Library/Perl/darwin/auto/DBI Checking if your kit is complete... Looks good Note (probably harmless): No library found for -lpq Writing Makefile for DBD::Pg [localhost:dev/perl/dbd-pg-1.00] robertsa% make mkdir blib mkdir blib/lib mkdir blib/lib/DBD mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/DBD mkdir blib/arch/auto/DBD/Pg mkdir blib/lib/auto mkdir blib/lib/auto/DBD mkdir blib/lib/auto/DBD/Pg mkdir blib/man3 cp Pg.pm blib/lib/DBD/Pg.pm cp dbd-pg.pod blib/lib/DBD/dbd-pg.pod /usr/bin/perl -I/System/Library/Perl/darwin -I/System/Library/Perl /System/Library/Perl/ExtUtils/xsubpp -typemap /System/Library/Perl/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c cc -c -I/include/ -I/Library/Perl/darwin/auto/DBI -g -pipe -pipe -fno-common -no-cpp-precomp -flat_namespace -DHAS_TELLDIR_PROTOTYPE -fno-strict-aliasing -O3 -DVERSION=\"1.00\" -DXS_VERSION=\"1.00\" -I/System/Library/Perl/darwin/CORE Pg.c In file included from Pg.xs:13: Pg.h:17: libpq-fe.h: No such file or directory In file included from /System/Library/Perl/darwin/CORE/perlsdio.h:5, from /System/Library/Perl/darwin/CORE/iperlsys.h:294, from /System/Library/Perl/darwin/CORE/perl.h:1823, from /Library/Perl/darwin/auto/DBI/DBIXS.h:19, from Pg.h:39, from Pg.xs:13: /usr/include/stdio.h:204: warning: `BUFSIZ' redefined Pg.h:34: warning: this is the location of the previous definition In file included from Pg.h:41, from Pg.xs:13: dbdimp.h:22: parse error before `PGconn' dbdimp.h:22: warning: no semicolon at end of struct or union dbdimp.h:25: parse error before `}' dbdimp.h:31: parse error before `PGresult' dbdimp.h:31: warning: no semicolon at end of struct or union dbdimp.h:44: parse error before `}' Pg.xs: In function `XS_DBD__Pg__db_commit': Pg.xs:90: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:90: dereferencing pointer to incomplete type Pg.xs: In function `XS_DBD__Pg__db_rollback': Pg.xs:101: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:101: dereferencing pointer to incomplete type Pg.xs: In function `XS_DBD__Pg__db_disconnect': Pg.xs:112: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:112: dereferencing pointer to incomplete type Pg.xs:116: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:116: dereferencing pointer to incomplete type Pg.xs:117: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:117: dereferencing pointer to incomplete type Pg.xs:118: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:118: dereferencing pointer to incomplete type Pg.xs:122: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:122: dereferencing pointer to incomplete type Pg.xs:122: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:122: dereferencing pointer to incomplete type Pg.xs:123: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:123: dereferencing pointer to incomplete type Pg.xs:125: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:125: dereferencing pointer to incomplete type Pg.xs: In function `XS_DBD__Pg__db_DESTROY': Pg.xs:165: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:165: dereferencing pointer to incomplete type Pg.xs:166: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:166: dereferencing pointer to incomplete type Pg.xs:172: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:172: dereferencing pointer to incomplete type Pg.xs:173: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:173: dereferencing pointer to incomplete type Pg.xs:174: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:174: dereferencing pointer to incomplete type Pg.xs:176: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:176: dereferencing pointer to incomplete type Pg.xs:177: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:177: dereferencing pointer to incomplete type Pg.xs:177: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:177: dereferencing pointer to incomplete type Pg.xs:177: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:177: dereferencing pointer to incomplete type Pg.xs:179: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:179: dereferencing pointer to incomplete type Pg.xs:180: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:180: dereferencing pointer to incomplete type Pg.xs:190: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:190: dereferencing pointer to incomplete type Pg.xs: In function `XS_DBD__Pg__st__prepare': Pg.xs:356: invalid use of incomplete typedef `imp_sth_t' Pg.xs:356: dereferencing pointer to incomplete type Pg.xs: In function `XS_DBD__Pg__st_execute': Pg.xs:447: invalid use of incomplete typedef `imp_sth_t' Pg.xs:447: dereferencing pointer to incomplete type Pg.xs:448: invalid use of incomplete typedef `imp_sth_t' Pg.xs:448: dereferencing pointer to incomplete type Pg.xs:449: invalid use of incomplete typedef `imp_sth_t' Pg.xs:449: dereferencing pointer to incomplete type Pg.xs: In function `XS_DBD__Pg__st_finish': Pg.xs:508: invalid use of incomplete typedef `imp_sth_t' Pg.xs:508: dereferencing pointer to incomplete type Pg.xs:509: invalid use of incomplete typedef `imp_dbh_t' Pg.xs:509: dereferencing pointer to incomplete type Pg.xs:515: invalid use of incomplete typedef `imp_sth_t' Pg.xs:515: dereferencing pointer to incomplete type Pg.xs: In function `XS_DBD__Pg__st_DESTROY': Pg.xs:576: invalid use of incomplete typedef `imp_sth_t' Pg.xs:576: dereferencing pointer to incomplete type Pg.xs:577: invalid use of incomplete typedef `imp_sth_t' Pg.xs:577: dereferencing pointer to incomplete type Pg.xs:582: invalid use of incomplete typedef `imp_sth_t' Pg.xs:582: dereferencing pointer to incomplete type Pg.xs:583: invalid use of incomplete typedef `imp_sth_t' Pg.xs:583: dereferencing pointer to incomplete type Pg.xs:583: invalid use of incomplete typedef `imp_sth_t' Pg.xs:583: dereferencing pointer to incomplete type Pg.xs:583: invalid use of incomplete typedef `imp_sth_t' Pg.xs:583: dereferencing pointer to incomplete type Pg.xs:585: invalid use of incomplete typedef `imp_sth_t' Pg.xs:585: dereferencing pointer to incomplete type Pg.xs: In function `boot_DBD__Pg': Pg.xs:34: sizeof applied to an incomplete type Pg.xs:35: sizeof applied to an incomplete type make: *** [Pg.o] Error 1 ########## cpan module install ########## [localhost:/documents/football/sql] robertsa% sudo env POSTGRESQL_INCLUDE=/include POSTGRESQL_LIB=/lib perl -MCPAN -e shell; Unrecognized escape \C passed through at /Library/Perl/Term/ReadLine/readline.pm line 618. Unrecognized escape \C passed through at /Library/Perl/Term/ReadLine/readline.pm line 620. cpan shell -- CPAN exploration and modules installation (v1.59) ReadLine support enabled cpan> install DBD::Pg CPAN: Storable loaded ok Going to read /Users/robertsa/cache/Metadata Running install for module DBD::Pg Running make for M/ME/MERGL/DBD-Pg-1.01.tar.gz Scanning cache /Users/robertsa/cache/build for sizes CPAN: MD5 loaded ok Checksum for /Users/robertsa/cache/sources/authors/id/M/ME/MERGL/DBD-Pg-1.01.tar.gz ok DBD-Pg-1.01 DBD-Pg-1.01/eg DBD-Pg-1.01/eg/ApacheDBI.pl DBD-Pg-1.01/Changes DBD-Pg-1.01/MANIFEST DBD-Pg-1.01/Makefile.PL DBD-Pg-1.01/Pg.h DBD-Pg-1.01/Pg.pm DBD-Pg-1.01/Pg.xs DBD-Pg-1.01/README DBD-Pg-1.01/README.win32 DBD-Pg-1.01/dbd-pg.pod DBD-Pg-1.01/dbdimp.c DBD-Pg-1.01/dbdimp.h DBD-Pg-1.01/test.pl Removing previously used /Users/robertsa/cache/build/DBD-Pg-1.01 CPAN.pm: Going to build M/ME/MERGL/DBD-Pg-1.01.tar.gz Configuring Pg Remember to actually read the README file ! please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB ! Running make test Make had some problems, maybe interrupted? Won't test Running make install Make had some problems, maybe interrupted? Won't install
pgsql-general by date: