sf installation issues on R4.0 / Ubuntu18.04

[technocrat]

I'm on Ubuntu. If I had the 12, I'd rename it temporarily before removing.

[LarsR]

@gab1109

sudo ldconfig -p | grep libproj

sudo ldconfig -p | grep libproj
libproj.so.19 (libc6,x86-64) => /usr/lib/x86_64-linux-gnu/libproj.so.19
libproj.so (libc6,x86-64) => /usr/lib/x86_64-linux-gnu/libproj.so

I removed libproj.so.12 but I get exactly the same error message as before.
Do you have any further suggestions?

[technocrat]

So here's what I did, by way of eating my own dogfood, on my development machine

1. $ sudo apt remove proj-bin1
2. $ sudo apt install proj-bin
3. > install.packages("sf")
4. > library(sf) =Linking to GEOS 3.8.1, GDAL 3.1.3, PROJ 7.1.0

Seems all good.

[LarsR]

I am sorry, but I get exactly the same error message after these operations:
checking GDAL: checking whether PROJ is available for linking:... yes
checking GDAL: checking whether PROJ is available fur running:... ERROR 1: PROJ: proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area

[technocrat]

Grrr. Any chance you’re doing this in terminal under sudo?

[LarsR]

You mean running R under sudo?

[LarsR]

It looks very promising:

checking GDAL: /usr/share/gdal/pcs.csv readable... yes
checking GDAL: checking whether PROJ is available for linking:... yes
checking GDAL: checking whether PROJ is available fur running:... yes
configure: GDAL: 3.0.4
checking proj.h usability... yes
checking proj.h presence... yes
checking for proj.h... yes
checking PROJ: checking whether PROJ and sqlite3 are available for linking:... yes
checking for geos-config... /usr/bin/geos-config
checking geos-config usability... yes
configure: GEOS: 3.8.0
checking GEOS version >= 3.4.0... yes
checking geos_c.h usability... yes
checking geos_c.h presence... yes
checking for geos_c.h... yes
checking geos: linking with -L/usr/lib/x86_64-linux-gnu -lgeos_c... yes
configure: Package CPP flags: -DHAVE_PROJ_H -I/usr/include/gdal -I/usr/include
configure: Package LIBS: -L/usr/lib -lgdal -lproj -L/usr/lib -lgdal -L/usr/lib/x86_64-linux-gnu -lgeos_c
configure: creating ./config.status
config.status: creating src/Makevars
** libs
g++ -std=gnu++11 -I"/usr/share/R/include" -DNDEBUG -DHAVE_PROJ_H -I/usr/include/gdal -I/usr/include -I'/home/larsrh/R/x86_64-pc-linux-gnu-library/4.0/Rcpp/include' -fpic -g -O2 -fdebug-prefix-map=/build/r-base-7BvS0x/r-base-4.0.3=. -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c RcppExports.cpp -o RcppExports.o
g++ -std=gnu++11 -I"/usr/share/R/include" -DNDEBUG -DHAVE_PROJ_H -I/usr/include/gdal -I/usr/include -I'/home/larsrh/R/x86_64-pc-linux-gnu-library/4.0/Rcpp/include' -fpic -g -O2 -fdebug-prefix-map=/build/r-base-7BvS0x/r-base-4.0.3=. -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c bbox.cpp -o bbox.o

[LarsR]

I also ran rstudio under sudo, and it seemed to work. I installed sf and other depending packages. Thanks a lot!