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)
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.3.6
• OS: Any
• 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.