Bug 197008 - databases/p5-DBD-mysql SSL option broken and USE_OPENSSL
Summary: databases/p5-DBD-mysql SSL option broken and USE_OPENSSL
Status: Closed Feedback Timeout
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Some People
Assignee: freebsd-perl (Nobody)
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-22 21:04 UTC by Bernard Spil
Modified: 2016-07-06 10:36 UTC (History)
0 users

See Also:
bugzilla: maintainer-feedback? (perl)


Attachments
Build log + showconfig + ldd -a (19.00 KB, text/plain)
2015-01-23 10:58 UTC, Bernard Spil
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bernard Spil freebsd_committer freebsd_triage 2015-01-22 21:04:20 UTC
p5-DBD-mysql requires OpenSSL yet does not define USE_OPENSSL

Thought I had fixed it but there's more trouble, even though SSL is not defined I get (only relevant output of ldd)

/usr/ports/databases/p5-DBD-mysql/work/stage/usr/local/lib/perl5/site_perl/mach/5.18/auto/DBD/mysql/mysql.so:
        libssl.so.30 => /usr/local/lib/libssl.so.30 (0x802556000)
        libcrypto.so.30 => /usr/local/lib/libcrypto.so.30 (0x8027b6000)

Will try to craft a patch tomorrow.
Comment 1 Bugzilla Automation freebsd_committer freebsd_triage 2015-01-22 21:04:20 UTC
Auto-assigned to maintainer perl@FreeBSD.org
Comment 2 Mathieu Arnold freebsd_committer freebsd_triage 2015-01-23 10:19:49 UTC
Hum, ldd will not get you any relevant information, as it resolves dependencies and tell you all that the .so will need.

# readelf -d         /usr/local/lib/perl5/site_perl/mach/5.18/auto/DBD/mysql/mysql.so|grep NEEDED
 0x0000000000000001 (NEEDED)             Shared library: [libperl.so.5.18]
 0x0000000000000001 (NEEDED)             Shared library: [libmysqlclient.so.18]
 0x0000000000000001 (NEEDED)             Shared library: [libz.so.6]
 0x0000000000000001 (NEEDED)             Shared library: [libm.so.5]
 0x0000000000000001 (NEEDED)             Shared library: [libc.so.7]

So, it does *not* need ssl/crypto.  Though, on a clean system, ldd does not resolve any of libcrypto or libssl:

# ldd        /usr/local/lib/perl5/site_perl/mach/5.18/auto/DBD/mysql/mysql.so
/usr/local/lib/perl5/site_perl/mach/5.18/auto/DBD/mysql/mysql.so:
        libperl.so.5.18 => /usr/local/lib/perl5/5.18/mach/CORE/libperl.so.5.18 (0x80161c000)
        libmysqlclient.so.18 => /usr/local/lib/mysql/libmysqlclient.so.18 (0x80199e000)
        libz.so.6 => /lib/libz.so.6 (0x801f0b000)
        libm.so.5 => /lib/libm.so.5 (0x802121000)
        libc.so.7 => /lib/libc.so.7 (0x80081f000)
        libcrypt.so.5 => /lib/libcrypt.so.5 (0x802349000)
        libutil.so.9 => /lib/libutil.so.9 (0x802569000)
        libc++.so.1 => /usr/lib/libc++.so.1 (0x80277b000)
        libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x802a3b000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x802c57000)
        libthr.so.3 => /lib/libthr.so.3 (0x802e65000)

did you by chance disable the SSL option in mysql-client ?
Comment 3 Bernard Spil freebsd_committer freebsd_triage 2015-01-23 10:30:39 UTC
Hi Mat,

My mariadb100-client is built with OpenSSL support. Discovered this after upgrading my LibreSSL to 2.1.3 which comes with a shlib version bump. spamassassin started emitting errors at startup related to the .so.29 shlib not being available. Build/package/install of p5-DBD-mysql solved the issue.
This is how I came to the conclusion that p5-DBD-mysql missed a dependency on OpenSSL and then to the conclusion that the port does not honor the SSL option.
Comment 4 Bernard Spil freebsd_committer freebsd_triage 2015-01-23 10:34:47 UTC
Looked at the port this morning and saw a lot of warnings/errors from mysql_config which is called with --testdb which is not available in at least the mariadb port.
Config output says 'ssl=yes (guessed)' probably due to detecting it from the mysql_config output indicating ssl support in the mysql client.
Comment 5 Bernard Spil freebsd_committer freebsd_triage 2015-01-23 10:58:00 UTC
Created attachment 152051 [details]
Build log + showconfig + ldd -a