Description of problem: Any use of pam_mysql on Fedora 35 fails with the following message in the system journal: PAM unable to dlopen(/usr/lib64/security/pam_mysql.so): /usr/lib64/security/pam_mysql.so: undefined symbol: compat_make_scrambled_password_323 PAM adding faulty module: /usr/lib64/security/pam_mysql.so Version-Release number of selected component (if applicable): pam_mysql-0.8.1-0.10.fc35.x86_64.rpm How reproducible: Always Steps to Reproduce: 1. Create database, e.g. CREATE database vpn_db; CREATE TABLE tbl_user ( username varchar(128), password varchar(128) NOT NULL, PRIMARY KEY (username) ); INSERT INTO vpn_db.tbl_user (username, password) VALUES ('test', sha2('test', 512)); 2. Create /etc/pam.d/mysql with the following content auth optional pam_mysql.so config_file=/etc/pam_mysql.conf verbose=1 account required pam_mysql.so config_file=/etc/pam_mysql.conf verbose=1 3. Create /etc/pam_mysql.conf (change username/password/host/port accordingly) users.host = 127.0.0.1:3306 users.database = vpn_db users.db_user = root users.db_passwd = my-secret-pw users.table = tbl_user users.user_column = tbl_user.username users.password_column = tbl_user.password users.password_crypt = 8 Note: These match the default of the official mysql and maraidb containers, so one can quickly test this by running docker run --name some-mariadb --network=host -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mariadb 4. Run pamtester: echo "test" | pamtester -v mysql test authenticate Actual results: pamtester: invoking pam_start(mysql, test, ...) pamtester: performing operation - authenticate pamtester: Permission denied Expected results: pamtester: invoking pam_start(mysql, test, ...) pamtester: performing operation - authenticate Password:pamtester: successfully authenticated Additional info: Seems like anything before https://github.com/NigelCunningham/pam-MySQL/commit/f3d32aa9fb121e51a2168871a7b0856c2cdcf0ab works fine (test builds at https://copr.fedorainfracloud.org/coprs/spike/pam-MySQL/)
This could be fixed with https://src.fedoraproject.org/rpms/pam_mysql/pull-request/2
FEDORA-2021-87f7b6b10e has been submitted as an update to Fedora 33. https://bodhi.fedoraproject.org/updates/FEDORA-2021-87f7b6b10e
FEDORA-2021-8f605d9ac3 has been submitted as an update to Fedora 34. https://bodhi.fedoraproject.org/updates/FEDORA-2021-8f605d9ac3
FEDORA-2021-f118399480 has been submitted as an update to Fedora 35. https://bodhi.fedoraproject.org/updates/FEDORA-2021-f118399480
FEDORA-2021-87f7b6b10e has been pushed to the Fedora 33 testing repository. Soon you'll be able to install the update with the following command: `sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-87f7b6b10e` You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-87f7b6b10e See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.
FEDORA-2021-f118399480 has been pushed to the Fedora 35 testing repository. Soon you'll be able to install the update with the following command: `sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-f118399480` You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-f118399480 See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.
FEDORA-2021-8f605d9ac3 has been pushed to the Fedora 34 testing repository. Soon you'll be able to install the update with the following command: `sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-8f605d9ac3` You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-8f605d9ac3 See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.
FEDORA-2021-8f605d9ac3 has been pushed to the Fedora 34 stable repository. If problem still persists, please make note of it in this bug report.
FEDORA-2021-87f7b6b10e has been pushed to the Fedora 33 stable repository. If problem still persists, please make note of it in this bug report.
FEDORA-2021-f118399480 has been pushed to the Fedora 35 stable repository. If problem still persists, please make note of it in this bug report.