Bug #80710 Workbench can't find libproj in it's default location on Fedora 23
Submitted: 12 Mar 2016 10:51 Modified: 29 May 2018 20:49
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: geo, geospatial viewer, libproj, spatial

[12 Mar 2016 10:51] Daniël van Eeden
Description:
On Fedora 23 with proj-4.9.1-3.fc23.x86_64 installed I get this:

Unable to initialize Spatial Viewer
Spatial support requires the PROJ.4 library (libproj). If you already have it installed, please set the PROJSO environment variable to its location before starting Workbench.

It does work after I do this:
export PROJSO=/usr/lib64/libproj.so.9

How to repeat:
Try to use the spatial viewer on Fedora 23

From strace:
[pid  2774] open("/usr/lib64/mysql-workbench/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] open("/usr/lib64/mysql-workbench/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 33
[pid  2774] open("/lib64/tls/x86_64/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] stat("/lib64/tls/x86_64", 0x7ffea58e87c0) = -1 ENOENT (No such file or directory)
[pid  2774] open("/lib64/tls/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] stat("/lib64/tls", {st_mode=S_IFDIR|0555, st_size=4096, ...}) = 0
[pid  2774] open("/lib64/x86_64/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] stat("/lib64/x86_64", 0x7ffea58e87c0) = -1 ENOENT (No such file or directory)
[pid  2774] open("/lib64/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] stat("/lib64", {st_mode=S_IFDIR|0555, st_size=143360, ...}) = 0
[pid  2774] open("/usr/lib64/tls/x86_64/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] stat("/usr/lib64/tls/x86_64", 0x7ffea58e87c0) = -1 ENOENT (No such file or directory)
[pid  2774] open("/usr/lib64/tls/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] stat("/usr/lib64/tls", {st_mode=S_IFDIR|0555, st_size=4096, ...}) = 0
[pid  2774] open("/usr/lib64/x86_64/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
[pid  2774] stat("/usr/lib64/x86_64", 0x7ffea58e87c0) = -1 ENOENT (No such file or directory)
[pid  2774] open("/usr/lib64/libproj.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)

$ find / -name libproj.so 2> /dev/null
$

Suggested fix:
Make sure it is able to use the system version of libproj
[15 Mar 2016 10:14] MySQL Verification Team
Hello Daniël,

Thank you for the report.
Observed this on fc23 with WB 6.3.6 installed using repository.

Thanks,
Umesh
[15 Mar 2016 10:16] MySQL Verification Team
test results

Attachment: 80710.results (application/octet-stream, text), 11.62 KiB.

[23 May 2018 13:31] Miguel Tadeu Mota
Posted by developer:
 
commit id: 955bb7350c9502071c81a3d3241faf54a6a8599a
[29 May 2018 20:49] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

The PROJ.4 library (libproj) was not found, which prevented the
initialization of Spatial Viewer.

Thank you for the bug report.