[gdal-dev] RGDAL + sqlite3 = ld: cannot find -lsqlite3

[Doug Niven]

I’m hoping someone might be able to shed some light on how to fix the following message when installing ‘rgdal’:

/opt/rh/devtoolset-8/root/usr/libexec/gcc/x86_64-redhat-linux/8/ld: cannot find -lsqlite3
collect2: error: ld returned 1 exit status

GDAL, PROJ, GEOS, Postgres 9-11, all installed via Yum on Centos 7.

Sqlite3’s lib is in my LD_LIBRARY_PATH:

[root at localhost ~]# echo $LD_LIBRARY_PATH
/usr/sqlite330/lib:/opt/rh/llvm-toolset-7/root/usr/lib64:/opt/rh/devtoolset-8/root/usr/lib64:/opt/rh/devtoolset-8/root/usr/lib:/opt/rh/devtoolset-8/root/usr/lib64/dyninst:/opt/rh/devtoolset-8/root/usr/lib/dyninst:/opt/rh/devtoolset-8/root/usr/lib64:/opt/rh/devtoolset-8/root/usr/lib

And Sqlite3 is on my PATH:

[root at localhost ~]# which sqlite3
/usr/sqlite330/bin/sqlite3

Command to install used in R:

install.packages('rgdal', type = "source", configure.args=c('--with-gdal-config=/usr/gdal31/bin/gdal-config-64','--with-proj-include=/usr/proj71/include','--with-proj-lib=/usr/proj71/lib’))

Many thanks for any assistance with this!

Doug