Bug 248461

Summary: benchmarks/sysbench with option mysql requires ldconfig assistance
Product: Ports & Packages Reporter: dewayne
Component: Individual Port(s)Assignee: Sunpoet Po-Chuan Hsieh <sunpoet>
Status: New ---    
Severity: Affects Some People CC: dewayne
Priority: --- Flags: bugzilla: maintainer-feedback? (sunpoet)
Version: Latest   
Hardware: Any   
OS: Any   

Description dewayne 2020-08-04 01:30:55 UTC
Building sysbench with all options enabled, and attempt to run with
# sysbench oltp --help
ld-elf.so.1: Shared object "libmariadb.so.3" not found, required by "sysbench"

# ldd `which sysbench`
        libumem.so.2 => /lib/libumem.so.2 (0x80130b000)
        libmariadb.so.3 => not found (0)
        libpq.so.5 => /usr/local/lib/libpq.so.5 (0x80130f000)
        libm.so.5 => /lib/libm.so.5 (0x801555000)

Performing an ldconfig -m /usr/local/lib/mysql enabled sysbench to function correctly.

Perhaps the Makefile needs 
USE_LDCONFIG=       yes
Comment 1 Sunpoet Po-Chuan Hsieh freebsd_committer 2020-08-19 16:15:37 UTC
That means USE_LDCONFIG in mariadb port does not run correctly.
sysbench does not need USE_LDCONFIG.

The result of default configuration (mysql=5.7):

% ldd /usr/local/bin/sysbench
        libumem.so.2 => /lib/libumem.so.2 (0x800846000)
        libmysqlclient.so.20 => /usr/local/lib/mysql/libmysqlclient.so.20 (0x800c00000)
        libz.so.6 => /lib/libz.so.6 (0x8011b9000)
        librt.so.1 => /usr/lib/librt.so.1 (0x8013d2000)
        libexecinfo.so.1 => /usr/lib/libexecinfo.so.1 (0x8015d8000)
        libssl.so.8 => /usr/lib/libssl.so.8 (0x8017db000)
        libcrypto.so.8 => /lib/libcrypto.so.8 (0x801c00000)
        libluajit-5.1.so.2 => /usr/local/lib/libluajit-5.1.so.2 (0x802075000)
        libck.so.0 => /usr/local/lib/libck.so.0 (0x8022fa000)
        libm.so.5 => /lib/libm.so.5 (0x802505000)
        libthr.so.3 => /lib/libthr.so.3 (0x802735000)
        libc.so.7 => /lib/libc.so.7 (0x80295d000)
        libc++.so.1 => /usr/lib/libc++.so.1 (0x802d14000)
        libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x802fde000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x8031fd000)
        libelf.so.2 => /lib/libelf.so.2 (0x803415000)