Created attachment 223777 [details] extra patch for pam_mysql.c I maintain a few customer systems with cyrus-sasl-saslauthd / pam_mysql on mysql 5.6. After upgrading to mysql80-server, pam_mysql throws an error stating that make_scrambled_password() as undefined symbol so testsaslauthd failes authentication. This patch is only a workaround to make pam_mysql work again till another sql solution is implemented for sasl authentication in postfix.
Created attachment 223778 [details] Makefile patch add option for extra patch
Created attachment 225532 [details] Updates to 0.8.2 instead Hi I tested an update to 0.8.2 instead. It also fixes the make_scrambled_password() as undefined symbol problem. (It is fixed "upstream") Upstream changed.. since 0.7.x Do you want to / have the opportunity to be the maintainer? Can you perform some testing, in my tests it worked. Note that I do not think that all info in pkg-message is correct. I did not seem to need a symlink in /usr/lib
Created attachment 225550 [details] Updates to 0.8.2 instead
Hi, i tested version 0.8.2, but authentication (testsaslauthd) failed. My installations work with the non crypt()ish MD5 hash in openssl which is not built in by default of pam_mysqls Makefile. I tried to add --with-openssl in the Makefile, but openssl (from base) is not found by the configure script. I reverted back to my old "quick & dirty" version. testsaslauthd is now working again.
(In reply to klaus from comment #4) Thanks for testing! Do mind testing the diff from https://reviews.freebsd.org/D30646 https://reviews.freebsd.org/file/data/gdthqlo7tslktxoucc6y/PHID-FILE-c6eg7wyisfxmvrgmrm3r/D30646.diff It finds openssl in base. Thanks Jesper
Comment on attachment 225550 [details] Updates to 0.8.2 instead see https://reviews.freebsd.org/D30646
Hi, i upgraded my private mail server yesterday and added the new diff. testsaslauthd returns "Success". :-) I do some mail tests in the next days and as sonn as this diff is committed i will upgrade the dbmail server in the company where i work ... :-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=e5e4475fb7f0d2692f668c23014e4aedcd7acff2 commit e5e4475fb7f0d2692f668c23014e4aedcd7acff2 Author: Jesper Schmitz Mouridsen <jsm@FreeBSD.org> AuthorDate: 2021-06-07 13:22:19 +0000 Commit: Jesper Schmitz Mouridsen <jsm@FreeBSD.org> CommitDate: 2021-06-07 13:27:24 +0000 security/pam-mysql: Update to 0.8.2 Old upstream is unmaintained and taken over by github.com/NigelCunningham/pam-MySQL This version supports newer versions of MySQL and MariaDB, that do not define make_scrambled_password(). Since pam now looks in LOCALBASE for modules change pkg-message accordingly PR: 254731 Reviewed_by: koobs (ports) Differential_Revision: 30646 security/pam-mysql/Makefile | 31 +++++++++++++--------- security/pam-mysql/distinfo | 5 ++-- security/pam-mysql/files/patch-acinclude.m4 (gone) | 10 ------- security/pam-mysql/files/pkg-message.in | 8 ------ security/pam-mysql/pkg-descr | 2 +- 5 files changed, 22 insertions(+), 34 deletions(-)
Thanks for testing, and reviewing.