Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2008 @ 16:51:54 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Perl DBD::Teradata installation issues...

From:		Mike Berkman

Hello everyone,

I am attempting to implement a Perl to Teradata connection to be able to automate some scripts that access the database. However, I cannot get the Perl module *DBD-Teradata-1.50* to work correctly in my home directory.

The following steps were taken:

- Downloaded the .tar.gz from a CPAN repository

- Unpacked and untared the file

- made sure perl recognized my home directory

- Ran the Makefile script, passing the prefix of my home directory

- make

- make install

- ran the included DBD-Teradata test script, test.pl

- ERROR

If anyone could help me decipher the following messages I would greatly appreciate it!

-Mike

     * *
     *$ vi ~/.tcshrc*
     * *

     setenv PERL5LIB
     /users/mberkman/perl/lib/5.8.6:/users/mberkman/perl/lib/site_perl/5.8.6

     * *
     * *

     *$ perl -V
     *
     Characteristics of this binary (from libperl):
        Compile-time options: USE_LARGE_FILES
        Built under linux
        Compiled at Mar 30 2005 09:09:30
        %ENV:

     PERL5LIB="/users/mberkman/perl/lib/5.8.6:/users/mberkman/perl/lib/site_perl/5.8.6"
        @INC:
          /users/mberkman/perl/lib/5.8.6/i686-linux
          /users/mberkman/perl/lib/5.8.6
          /users/mberkman/perl/lib/site_perl/5.8.6/i686-linux
          /users/mberkman/perl/lib/site_perl/5.8.6
          /usr/cis/packages/perl/perl-5.8.6/lib/5.8.6/i686-linux
          /usr/cis/packages/perl/perl-5.8.6/lib/5.8.6
          /usr/cis/packages/perl/perl-5.8.6/lib/site_perl/5.8.6/i686-linux
          /usr/cis/packages/perl/perl-5.8.6/lib/site_perl/5.8.6
          /usr/cis/packages/perl/perl-5.8.6/lib/site_perl
          /usr/cis/packages/cis-perllib
          .

     * *
     **

     *$ perl Makefile.PL PREFIX=/users/mberkman/perl*

       *** Configuring DBD::Teradata (feature-limited free edition)...


     ***************************************************************
     *
     *       !!!NOTE TO INSTALLERS!!!
     *
     *       DBD::Teradata will be built using the following
     *       directives:
     *       Libraries: -L/usr/lib -lcliv2 -lnet -lsocket -lresolv -ltdusr.so
     *       Include files:
     *       Compile flags: -D__error_t_defined=1
     *
     *       If your CLI2 libraries and/or include files are in another
     *       location, please update the TDAT_DBD_CLI_LIB and
     *       TDAT_DBD_CLI_INC environment variables before running
     *       Makefile.PL.
     *
     ***************************************************************


     Checking for DBI, 1.40 or later ... ok
     Checking for Math::BigInt, 1.73 or later ... ok
     Note (probably harmless): No library found for -lnet
     Note (probably harmless): No library found for -lsocket
     Note (probably harmless): No library found for -ltdusr.so
     Writing Makefile for DBD::Teradata


     *$ make*


     cp lib/DBD/Teradata.pm blib/lib/DBD/Teradata.pm
     /auto/usrcis-linux-rhel3.0-x86-32/packages/perl/perl-5.8.6/bin/perl
     /usr/cis/packages/perl/perl-5.8.6/lib/5.8.6/ExtUtils/xsubpp  -typemap
     /usr/cis/packages/perl/perl-5.8.6/lib/5.8.6/ExtUtils/typemap
     Teradata.xs > Teradata.xsc && mv Teradata.xsc Teradata.c
     Please specify prototyping behavior for Teradata.xs (see perlxs manual)
     gcc -c   -D__error_t_defined=1 -O3   -DVERSION=\"1.50\"
     -DXS_VERSION=\"1.50\" -f  pic
     "-I/usr/cis/packages/perl/perl-5.8.6/lib/5.8.6/i686-linux/CORE"   Teradata.c
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_init_dbcarea':
     Teradata.xs:77: warning: passing arg 1 of 'DBCHINI' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_get_connection':
     Teradata.xs:155: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs:179: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs:235: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs:239: warning: passing arg 1 of 'DBCHREL' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_get_tdat_release':
     Teradata.xs:263: warning: passing arg 1 of 'DBCHREL' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_cleanup':
     Teradata.xs:278: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_send_request':
     Teradata.xs:335: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_wait_for_response':
     Teradata.xs:362: warning: passing arg 1 of 'DBCHWAT' from incompatible
     pointer type
     Teradata.xs:362: warning: passing arg 3 of 'DBCHWAT' from incompatible
     pointer type
     Teradata.xs:362: warning: passing arg 4 of 'DBCHWAT' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_get_response':
     Teradata.xs:419: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_end_request':
     Teradata.xs:456: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_abort_request':
     Teradata.xs:483: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_test_leak':
     Teradata.xs:529: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs:548: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Teradata.xs:556: warning: passing arg 1 of 'DBCHCL' from incompatible
     pointer type
     Running Mkbootstrap for DBD::Teradata ()
     chmod 644 Teradata.bs
     rm -f blib/arch/auto/DBD/Teradata/Teradata.so
     LD_RUN_PATH="/usr/lib" gcc  -shared Teradata.o  -o
     blib/arch/auto/DBD/Teradata/Teradata.so   -L/usr/lib -lcliv2 -lresolv
     /usr/local/bin/ld: skipping incompatible /usr/lib/libcliv2.so when
     searching for -lcliv2
     /usr/local/bin/ld: skipping incompatible /usr/lib/libresolv.so when
     searching for -lresolv
     /usr/local/bin/ld: skipping incompatible /usr/lib/libresolv.a when
     searching for -lresolv
     /usr/local/bin/ld: skipping incompatible /usr/lib/libc.so when searching
     for -lc
     /usr/local/bin/ld: skipping incompatible /usr/lib/libc.a when searching
     for -lc
     chmod 755 blib/arch/auto/DBD/Teradata/Teradata.so
     cp Teradata.bs blib/arch/auto/DBD/Teradata/Teradata.bs
     chmod 644 blib/arch/auto/DBD/Teradata/Teradata.bs
     Manifying blib/man3/DBD::Teradata.3


     *$ make install*


     Installing
     /users/mberkman/perl/lib/site_perl/5.8.6/i686-linux/auto/DBD/Teradata/Teradata.so
     Installing
     /users/mberkman/perl/lib/site_perl/5.8.6/i686-linux/auto/DBD/Teradata/Teradata.bs
     Files found in blib/arch: installing files in blib/lib into architecture
     dependent library tree
     Installing
     /users/mberkman/perl/lib/site_perl/5.8.6/i686-linux/DBD/Teradata.pm
     Installing /users/mberkman/perl/man/man3/DBD::Teradata.3
     Writing
     /users/mberkman/perl/lib/site_perl/5.8.6/i686-linux/auto/DBD/Teradata/.packlist
     Appending installation info to
     /users/mberkman/perl/lib/5.8.6/i686-linux/perllocal.pod


     *$ perl t/test.pl /OUR_DB/ /OUR_USERNAME/ /OUR_PASSWORD/*


     Can't load
     '/users/mberkman/perl/lib/site_perl/5.8.6/i686-linux/auto/DBD/Teradata/Teradata.so'

     for module DBD::Teradata:
     /users/mberkman/perl/lib/site_perl/5.8.6/i686-linux/auto/DBD/Teradata/Teradata.so:

     cannot open shared object file: No such file or directory at
     /usr/cis/packages/perl/perl-5.8.6/lib/5.8.6/i686-linux/XSLoader.pm line 68.
       at /users/mberkman/perl/lib/site_perl/5.8.6/i686-linux/DBD/Teradata.pm
     line 5086
     Compilation failed in require at t/test.pl line 12.
     BEGIN failed--compilation aborted at t/test.pl line 12.

Thanks in advance!

Mike


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference