Re^2: connecting to mssql on rhel7 with new mssql driver

Thank you for your reply! I downloaded 1.56, but running into some issues making the file..

make complains: /bin/sh: gcc: command not found

/efs/dist/perl5/core/5.10/exec/bin/perl Makefile.PL

**********
        Remember to actually *READ* the README file!
        And re-read it if you have any problems.

**********

OSNAME: linux
LANG: en_US.UTF-8
ODBCHOME:
LD_LIBRARY_PATH: /efs/dist/sybase/openclient/15.7-ESD4-build001/exec/D
+ataAccess64/ODBC/lib:/efs/dist/sybase/openclient/15.7-ESD4-build001/e
+xec/DataAccess/ODBC/lib:/efs/dist/sybase/openclient/15.7-ESD4-build00
+1/exec/OCS-15_0/lib:/efs/dist/sybase/openclient/15.7-ESD4-build001/ex
+ec/OCS-15_0/lib3p64:/efs/dist/sybase/openclient/15.7-ESD4-build001/ex
+ec/OCS-15_0/lib3p::/efs/dist/oracledb/client/11.2.0.3/exec/lib:/efs/d
+ist/fsf/gcc/4.1.1/exec/lib;/usr/lib64
DBROOT:
WINDIR:
II_SYSTEM:
Perl: 5.010000
ExtUtils::MakeMaker: 6.42
Command line options:
  u! = undef
  w! = undef
  e! = undef
  g! = 0
  x! = undef
  o=s =


Your LANG environment variable is set to "en_US.UTF-8"
This is known to cause problems in some perl installations - even stop
+ping
this Makefile.PL from running without errors. If you have problems ple
+ase
try re-running with LANG unset or with the utf part of LANG removed.

You are using a Perl configured with threading enabled.
Please read the warnings in DBI about this.

You should also be aware that on non-Windows platforms ODBC drivers co
+me
in two forms, thread-safe and non-thread-safe drivers and you may need
to make sure you are using the right one.

Press return to continue...
Looking for odbc_config in : nowhere
Looking for odbc_config in (PATH) /efs/dist/sybase/openclient/15.7-ESD
+4-build001/exec/OCS-15_0/bin:/efs/dist/efs/core/prod/common/bin:/usr/
+local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/etc:/efs/dist/oracledb/c
+lient/10G/exec/bin:/etma/ixp/bin:/efs/dist/oracle/jdk/1.8.0u92/exec/b
+in
  Found odbc_config (via odbc_config) version 2.3.1

  odbc_config reports --prefix=/usr
  odbc_config reports --include-prefix=/usr/include
  odbc_config reports --lib-prefix=/usr/lib64
  ODBC INC dir set to /usr/include via odbc_config
  ODBC LIB dir set to /usr/lib64 via odbc_config
Using ODBCHOME /usr

This looks like a unixodbc type of driver manager.
Looking for odbcinst
  Found odbcinst in /usr/bin
  odbcinst -j reports:

unixODBC 2.3.1
DRIVERS............: /etma/bin/conf/odbcinst.ini
SYSTEM DATA SOURCES: /etma/bin/conf/odbc.ini
FILE DATA SOURCES..: /etma/bin/conf/ODBCDataSources
USER DATA SOURCES..: /home/etmadev/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

Please note these files as they are where you define your ODBC drivers
+ and data sources.

Looking for odbc_config to get cflags
Adding odbc_config --cflags "-DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_T
+YPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG_INT=8 -I/usr/include " to CC li
+ne

Using DBI 1.616 (for perl 5.010000 on x86_64-linux-thread-multi) insta
+lled in /efs/dist/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/
+auto/DBI/
Using DBI 1.616 (for perl 5.010000 on x86_64-linux-thread-multi) insta
+lled in /efs/dist/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/
+auto/DBI/
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.
[download]

etmadev@DEV08:36:29>make

gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON
+G -DSIZEOF_LONG_INT=8 -I/usr/include  -I/usr/include  -I. -I/efs/dist
+/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT
+RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec
+/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/
+x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p
+erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B
+ITS=64 -O   -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di
+st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE"  -DH
+AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO
+F_LONG_INT=8 -I/usr/include  -I/usr/include ConvertUTF.c
/bin/sh: gcc: command not found
make: *** [ConvertUTF.o] Error 127
[download]

Comment on Re^2: connecting to mssql on rhel7 with new mssql driver Select or Download Code

Replies are listed 'Best First'.
Re^3: connecting to mssql on rhel7 with new mssql driver by hippo (Bishop) on Sep 27, 2017 at 13:02 UTC
make complains: /bin/sh: gcc: command not found There are two possibile reasons for this. Firstly, gcc may not be installed, in which case the solution is to install it. Secondly, gcc may be installed but not in your PATH, in which case the solution is to modify your PATH to include it.	[reply]
Re^4: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 27, 2017 at 20:25 UTC
Thanks guys -- I have not installed modules before.. so appreciate your patience :) I had our sa install gcc: devtoolset-6 .. Getting different errors now... :( What do you think? TYVM >make gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include ConvertUTF.c gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include ODBC.c gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include dbdimp.c dbdimp.c: In function 'odbc_db_STORE_attrib': dbdimp.c:4742:22: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)pars->atrue; ^ dbdimp.c:4744:22: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)pars->afalse; ^ dbdimp.c:4997:18: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)(on ? pars->atrue : pars->afalse); ^ dbdimp.c:5002:18: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)(on ? pars->atrue : pars->afalse); ^ dbdimp.c:5022:27: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] if (vParam == (SQLPOINTER)pars->atrue) { ^ gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include unicode_helper.c Running Mkbootstrap for DBD::ODBC () chmod 644 ODBC.bs rm -f blib/arch/auto/DBD/ODBC/ODBC.so LD_RUN_PATH="/usr/lib64" gcc -shared -O ConvertUTF.o ODBC.o dbdimp.o + unicode_helper.o -o blib/arch/auto/DBD/ODBC/ODBC.so \ -L/usr/lib64 -lodbc \ /opt/rh/devtoolset-6/root/usr/libexec/gcc/x86_64-redhat-linux/6.3.1/ld +: cannot find -lodbc collect2: error: ld returned 1 exit status make: *** [blib/arch/auto/DBD/ODBC/ODBC.so] Error 1 [download]	[reply] [d/l]
Re^5: connecting to mssql on rhel7 with new mssql driver by choroba (Cardinal) on Sep 27, 2017 at 20:37 UTC
> cannot find -lodbc It seems the header file is missing. Install the dev package for the odbc library. ($q=q:Sq=~/;[c](.)(.)/;chr(-\|\|-\|5+lengthSq)`"S\|oS2"`map{chr \|+ord }map{substrSq`S_+\|`\|}3E\|-\|`7**2-3:)=~y+S\|`+$1,++print+eval$q,q,a, [download]	[reply] [d/l]
Re^6: connecting to mssql on rhel7 with new mssql driver by mje (Curate) on Sep 28, 2017 at 08:47 UTC
Re^7: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 28, 2017 at 12:19 UTC
Re^6: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 28, 2017 at 11:50 UTC
Re^7: connecting to mssql on rhel7 with new mssql driver by choroba (Cardinal) on Sep 28, 2017 at 11:52 UTC
Some notes below your chosen depth have not been shown here
Re^5: connecting to mssql on rhel7 with new mssql driver by hippo (Bishop) on Sep 29, 2017 at 13:11 UTC
`/opt/rh/devtoolset-6/root/usr/libexec/gcc/x86_64-redhat-linux/6.3.1/ld: cannot find -lodbc` Why are you not using the system `ld`? This should be `/usr/bin/ld` on RHEL7. Are you sure that the gcc toolchain has been installed properly? Try running `ls -lZH /usr/bin/{gcc,ld}` and see if they exist OK.	[reply] [d/l] [select]
Re^3: connecting to mssql on rhel7 with new mssql driver by marto (Cardinal) on Sep 27, 2017 at 13:02 UTC
"/bin/sh: gcc: command not found" Have you checked you have a working gcc installed and a sane build environment?	[reply]
Re^3: connecting to mssql on rhel7 with new mssql driver by afoken (Chancellor) on Sep 27, 2017 at 18:30 UTC
`/bin/sh: gcc: command not found` As marto++ and hippo++ have told you, your system lacks a C compiler. Unfortunately, this has become quite usual for binary Linux distributions. And most likely, your system not only lacks a C compiler, but perhaps also a lot of headers, libraries and so on. So, making your package manager install gcc is most likely not sufficient. Look up the documentation and FAQs for your distribution for something like "how to I compile a C program". Often, you will read that you should install some kind of "development meta package" that installs gcc and the other missing stuff. Also note that DBD::mysql is said to be in a sad state ("DBD::mysql is dead right now"): https://www.nntp.perl.org/group/perl.dbi.users/2017/08/msg37429.html https://www.nntp.perl.org/group/perl.dbi.users/2017/09/msg37443.html Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply] [d/l]
Re^4: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 28, 2017 at 20:10 UTC
Looks like unixODBC-devel.x86_64 was already installed... :/ rpm -ql unixODBC-devel.x86_64 /usr/include/autotest.h /usr/include/odbcinst.h /usr/include/odbcinstext.h /usr/include/sql.h /usr/include/sqlext.h /usr/include/sqltypes.h /usr/include/sqlucode.h /usr/include/unixodbc_conf.h /usr/include/unixodbc_conf_x86_64.h /usr/include/uodbc_extras.h /usr/include/uodbc_stats.h /usr/lib64/libesoobS.so /usr/lib64/libmimerS.so /usr/lib64/libnn.so /usr/lib64/libodbccr.so /usr/lib64/libodbcdrvcfg1S.so /usr/lib64/libodbcdrvcfg2S.so /usr/lib64/libodbcminiS.so /usr/lib64/libodbcnnS.so /usr/lib64/libodbctxtS.so /usr/lib64/liboplodbcS.so /usr/lib64/liboraodbcS.so /usr/lib64/libsapdbS.so /usr/lib64/libtdsS.so /usr/lib64/libtemplate.so [download]	[reply] [d/l]
Re^5: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 29, 2017 at 12:56 UTC
Monks, please don't give up on me :) heeeelllppp!!! :)	[reply]
Re^6: connecting to mssql on rhel7 with new mssql driver by afoken (Chancellor) on Oct 01, 2017 at 10:52 UTC


Keep It Simple, Stupid
	PerlMonks