Perl DBD::ODBC installation Problem

magk · 11-12-2010, 04:22 AM

Hi

Im using RHEL 5.5 Server System for my project.

I tried to install Perl DBD::ODBC module thro CPAN (perl -MCPAN -e 'install DBD::ODBC') and i got the following error messages

Code:

Writing Makefile for DBD::ODBC
Warning: not all required environment variables are set.

Warning: Will not be able to run tests as you have not defined
all of DBI_DSN, DBI_USER and DBI_PASS environment variables.
cp Changes blib/lib/DBD/ODBC/Changes.pm
cp FAQ blib/lib/DBD/ODBC/FAQ.pm
cp ODBC.pm blib/lib/DBD/ODBC.pm
gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG=4  -I/usr/include  -I. -I/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables   -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE"  -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG=4  -I/usr/include ConvertUTF.c
/bin/sh: gcc: command not found
make: *** [ConvertUTF.o] Error 127
  /usr/bin/make  -- NOT OK
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible

DBI 1.52 and gcc 4.4 are installed in the system. gcc 4.4 is available under /usr/bin/gcc and path is set to this location under /etc/profile
Kindly suggest any workarounds for this issue.

Thanks & Regards
magk

TB0ne · 11-12-2010, 07:06 AM

Quote:

Originally Posted by magk

Hi
Im using RHEL 5.5 Server System for my project.
I tried to install Perl DBD::ODBC module thro CPAN (perl -MCPAN -e 'install DBD::ODBC') and i got the following error messages

Code:

Writing Makefile for DBD::ODBC
Warning: not all required environment variables are set.

Warning: Will not be able to run tests as you have not defined
all of DBI_DSN, DBI_USER and DBI_PASS environment variables.
cp Changes blib/lib/DBD/ODBC/Changes.pm
cp FAQ blib/lib/DBD/ODBC/FAQ.pm
cp ODBC.pm blib/lib/DBD/ODBC.pm
gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG=4  -I/usr/include  -I. -I/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables   -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE"  -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG=4  -I/usr/include ConvertUTF.c
/bin/sh: gcc: command not found
make: *** [ConvertUTF.o] Error 127
  /usr/bin/make  -- NOT OK
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible

DBI 1.52 and gcc 4.4 are installed in the system. gcc 4.4 is available under /usr/bin/gcc and path is set to this location under /etc/profile

Well, did you read the error??

Quote:

Warning: not all required environment variables are set.
Warning: Will not be able to run tests as you have not defined
all of DBI_DSN, DBI_USER and DBI_PASS environment variables.

So, set those environment variables, and run the make again. If you're in the BASH shell, it's "export DBI_DSN="<whatever>"". Read the instructions that came with the program, too, as it'll tell you these things. And since you're using RHEL, then CALL REDHAT SUPPORT, since you're paying for it.

magk · 11-16-2010, 03:47 AM

Hi

I have set those 3 environment variables using export as you had mentioned.
for example this is how i set for DBI_DSN

Code:

export DBI_DSN=dbi:ODBC:<dsn_name>

But still the warning is persistent.

Code:

Warning: Will not be able to run tests as you have not defined
all of DBI_DSN, DBI_USER and DBI_PASS environment variables.

Thanks

knudfl · 11-16-2010, 03:53 AM

.... And may be it's easier to install with yum ? ?

# yum install perl-DBD-ODBC

The package 'perl-DBD-ODBC' is in the 'rpmforge.repo .

..

TB0ne · 11-16-2010, 07:26 AM

Quote:

Originally Posted by magk

Hi
I have set those 3 environment variables using export as you had mentioned.
for example this is how i set for DBI_DSN

Code:

export DBI_DSN=dbi:ODBC:<dsn_name>

But still the warning is persistent.

Code:

Warning: Will not be able to run tests as you have not defined
all of DBI_DSN, DBI_USER and DBI_PASS environment variables.

From my first response:

Quote:

Read the instructions that came with the program, too, as it'll tell you these things. And since you're using RHEL, then CALL REDHAT SUPPORT, since you're paying for it.

Did you read the instructions? Call RedHat support? knudfl makes a good point that installing from repository would be better...but again, RedHat support could walk you through this, but if you're NOT paying for support, you won't be able to access the online repos.

And there is a README that came with the file, which covers how to install/set up the software. If your example is verbatim, you're missing the quotes around the definition.