Bug 259530 - mail/postfix: Undefined symbol "dict_mysql_open"
Summary: mail/postfix: Undefined symbol "dict_mysql_open"
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Juraj Lutter
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-29 15:58 UTC by Yani Karydis
Modified: 2021-10-30 13:45 UTC (History)
4 users (show)

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


Attachments
Patch file (2.10 KB, patch)
2021-10-29 16:45 UTC, Yasuhiro Kimura
no flags Details | Diff
Updated patch file (5.23 KB, patch)
2021-10-30 06:01 UTC, Yasuhiro Kimura
yasu: maintainer-approval? (otis)
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Yani Karydis 2021-10-29 15:58:02 UTC
Hi,

I'm getting the following error when starting postfix, when compiled with the MYSQL option.

Oct 29 11:52:09 megaserver postfix/postfix-script[15456]: starting the Postfix mail system
Oct 29 11:52:09 megaserver postfix/master[15458]: daemon started -- version 3.6.2, configuration /usr/local/etc/postfix
Oct 29 11:52:09 megaserver postfix/proxymap[15461]: fatal: load_library_symbols: dlsym failure looking up dict_mysql_open in /usr/local/lib/postfix/postfix-mysql.so: Undefined symbol "dict_mysql_open"
Oct 29 11:52:10 megaserver postfix/qmgr[15460]: warning: dict_proxy_open: service proxymap: Application error
Oct 29 11:52:10 megaserver postfix/master[15458]: warning: process /usr/local/libexec/postfix/proxymap pid 15461 exit status 1

postfix-mysql.so seems to be correctly linked to libmysqlclient.so:

ldd /usr/local/lib/postfix/postfix-mysql.so
/usr/local/lib/postfix/postfix-mysql.so:
        libmysqlclient.so.20 => /usr/local/lib/mysql/libmysqlclient.so.20 (0x800e00000)
        libz.so.6 => /lib/libz.so.6 (0x80067f000)
        libm.so.5 => /lib/libm.so.5 (0x80069b000)
        libc.so.7 => /lib/libc.so.7 (0x80024e000)
        libssl.so.111 => /usr/lib/libssl.so.111 (0x8006cd000)
        libcrypto.so.111 => /lib/libcrypto.so.111 (0x8011d2000)
        librt.so.1 => /usr/lib/librt.so.1 (0x800771000)
        libexecinfo.so.1 => /usr/lib/libexecinfo.so.1 (0x80077a000)
        libc++.so.1 => /usr/lib/libc++.so.1 (0x8014c4000)
        libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x800780000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x8007a2000)
        libthr.so.3 => /lib/libthr.so.3 (0x8007bc000)
        libelf.so.2 => /lib/libelf.so.2 (0x801591000)

uname -a

FreeBSD megaserver.pi-greece.eu 12.2-RELEASE-p10 FreeBSD 12.2-RELEASE-p10 12803d8a9(releng/12.2) MEGASERVER12  amd64

Thanks
Comment 1 Juraj Lutter freebsd_committer freebsd_triage 2021-10-29 16:35:55 UTC
Adding yasu@ who did the latest transition to flavors.
Comment 2 Yasuhiro Kimura freebsd_committer freebsd_triage 2021-10-29 16:45:04 UTC
Created attachment 229124 [details]
Patch file

(In reply to Yani Karydis from comment #0)

Sorry for breakage. Would you please try attached patch?
Comment 3 Yani Karydis 2021-10-29 21:50:02 UTC
Hi,

The patch fixes the problem. Many thanks.
Comment 4 elmex7 2021-10-30 01:01:01 UTC
I have had exactly same issue and the patch made it work again

Thanks for fast fix!
Comment 5 Yasuhiro Kimura freebsd_committer freebsd_triage 2021-10-30 06:01:58 UTC
Created attachment 229135 [details]
Updated patch file

* Fix same breakage with mail/postfix-current
* 'ssl' is dropped from USES. So re-add it.
* Bump PORTREVISON to rebuild with correctly modified source files
Comment 6 Matthias Fechner freebsd_committer freebsd_triage 2021-10-30 07:55:47 UTC
The are some PLIST issues left:
====> Checking for pkg-plist issues (check-plist)
===> Parsing plist
===> Checking for items in STAGEDIR missing from pkg-plist
Error: Orphaned: %%ETCDIR%%/access
Error: Orphaned: %%ETCDIR%%/aliases
Error: Orphaned: %%ETCDIR%%/canonical
Error: Orphaned: %%ETCDIR%%/generic
Error: Orphaned: %%ETCDIR%%/header_checks
Error: Orphaned: %%ETCDIR%%/relocated
Error: Orphaned: %%ETCDIR%%/transport
Error: Orphaned: %%ETCDIR%%/virtual
===> Checking for items in pkg-plist which are not in STAGEDIR
===> Error: Plist issues found.
*** Error code 1

Full build log:
https://pkg.fechner.net/data/130amd64-default/2021-10-30_09h53m06s/logs/errors/postfix-3.6.2_3,1.log
Comment 7 commit-hook freebsd_committer freebsd_triage 2021-10-30 12:56:23 UTC
A commit in branch main references this bug:

URL: https://cgit.FreeBSD.org/ports/commit/?id=4c9b48d1b6bb64ee6b27e0ed5a98358266ce74da

commit 4c9b48d1b6bb64ee6b27e0ed5a98358266ce74da
Author:     Juraj Lutter <otis@FreeBSD.org>
AuthorDate: 2021-10-30 12:54:07 +0000
Commit:     Juraj Lutter <otis@FreeBSD.org>
CommitDate: 2021-10-30 12:54:07 +0000

    mail/postfix: Fix multiple build issues

    - Add ssl to USES
    - Fix plist issues
    - Install sample files properly

    PR:             259530

 mail/postfix/Makefile  | 9 ++++++---
 mail/postfix/pkg-plist | 8 ++++++++
 2 files changed, 14 insertions(+), 3 deletions(-)
Comment 8 commit-hook freebsd_committer freebsd_triage 2021-10-30 13:04:26 UTC
A commit in branch main references this bug:

URL: https://cgit.FreeBSD.org/ports/commit/?id=c3f62605c215769ded84e17e3fdbecf2d36c6f3f

commit c3f62605c215769ded84e17e3fdbecf2d36c6f3f
Author:     Juraj Lutter <otis@FreeBSD.org>
AuthorDate: 2021-10-30 13:02:41 +0000
Commit:     Juraj Lutter <otis@FreeBSD.org>
CommitDate: 2021-10-30 13:02:41 +0000

    mail/postfix-current: Update to 3.7-20211023

    - Update to 3.7-20211023
    - Fix plist issues
    - Install sample files properly

    PR:             259530

 mail/postfix-current/Makefile  | 9 ++++++---
 mail/postfix-current/distinfo  | 6 +++---
 mail/postfix-current/pkg-plist | 8 ++++++++
 3 files changed, 17 insertions(+), 6 deletions(-)