[R-pkg-devel] Debugging RODBC installation problems on FreeBSD (unixodbc library path)

[Rasmus Liland]

Dirk, I did not realize libiodbc[1] is an 
alternative to unixODBC, how are you 
able to see this?  

I also did not realize I had both of 
them installed ... 

Uninstalling libiodbc, keeping unixODBC, 
adding the flag (I only suppose this is 
how the flag is added), does nothing:

	rasmus using iselin ~/src/RODBC % R CMD INSTALL RODBC --with-odbc-manager=odbc
	Warning: unknown option ‘--with-odbc-manager=odbc’
	* installing to library ‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0’
	* installing *source* package ‘RODBC’ ...
	files ‘configure’, ‘configure.ac’ have the wrong MD5 checksums
	** using staged installation
	checking for gcc... cc
	checking whether the C compiler works... yes
	checking for C compiler default output file name... a.out
	checking for suffix of executables...
	checking whether we are cross compiling... no
	checking for suffix of object files... o
	checking whether we are using the GNU C compiler... yes
	checking whether cc accepts -g... yes
	checking for cc option to accept ISO C89... none needed
	checking how to run the C preprocessor... cc -E
	checking for grep that handles long lines and -e... /usr/bin/grep
	checking for egrep... /usr/bin/grep -E
	checking for ANSI C header files... yes
	checking for sys/types.h... yes
	checking for sys/stat.h... yes
	checking for stdlib.h... yes
	checking for string.h... yes
	checking for memory.h... yes
	checking for strings.h... yes
	checking for inttypes.h... yes
	checking for stdint.h... yes
	checking for unistd.h... yes
	checking sql.h usability... yes
	checking sql.h presence... yes
	checking for sql.h... yes
	checking sqlext.h usability... yes
	checking sqlext.h presence... yes
	checking for sqlext.h... yes
	checking for library containing SQLTables... no
	configure: error: "no ODBC driver manager found"
	ERROR: configuration failed for package ‘RODBC’
	* removing ‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0/RODBC’

The other way around, uninstalling 
unixODBC, keeping libiodbc, brings me 
one step backwards: 

	rasmus using iselin ~/src/RODBC % R CMD INSTALL RODBC --with-odbc-manager=iodbc
	Warning: unknown option ‘--with-odbc-manager=iodbc’
	* installing to library ‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0’
	* installing *source* package ‘RODBC’ ...
	files ‘configure’, ‘configure.ac’ have the wrong MD5 checksums
	** using staged installation
	checking for gcc... cc
	checking whether the C compiler works... yes
	checking for C compiler default output file name... a.out
	checking for suffix of executables...
	checking whether we are cross compiling... no
	checking for suffix of object files... o
	checking whether we are using the GNU C compiler... yes
	checking whether cc accepts -g... yes
	checking for cc option to accept ISO C89... none needed
	checking how to run the C preprocessor... cc -E
	checking for grep that handles long lines and -e... /usr/bin/grep
	checking for egrep... /usr/bin/grep -E
	checking for ANSI C header files... yes
	checking for sys/types.h... yes
	checking for sys/stat.h... yes
	checking for stdlib.h... yes
	checking for string.h... yes
	checking for memory.h... yes
	checking for strings.h... yes
	checking for inttypes.h... yes
	checking for stdint.h... yes
	checking for unistd.h... yes
	checking sql.h usability... no
	checking sql.h presence... no
	checking for sql.h... no
	checking sqlext.h usability... no
	checking sqlext.h presence... no
	checking for sqlext.h... no
	configure: error: "ODBC headers sql.h and sqlext.h not found"
	ERROR: configuration failed for package ‘RODBC’
	* removing ‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0/RODBC’

... the sql.h and sqlext.h header files 
are there, libiodbc provides them both:

	root using iselin /usr/home/rasmus # pkg info -l libiodbc | egrep 'sql.h|sqlext.h'
	        /usr/local/include/libiodbc/isql.h
	        /usr/local/include/libiodbc/isqlext.h
	        /usr/local/include/libiodbc/sql.h
	        /usr/local/include/libiodbc/sqlext.h

... also when having unixodbc installed:

	root using iselin /usr/home/rasmus # pkg info -l unixODBC-2.3.9 | egrep 'sql.h|sqlext.h'
	        /usr/local/include/sql.h
	        /usr/local/include/sqlext.h

Rasmus

[1] https://www.freshports.org/databases/libiodbc/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <https://stat.ethz.ch/pipermail/r-package-devel/attachments/20210330/60b98b81/attachment.sig>