Bug 709534

Summary: Error pam_mysql
Product: [Fedora] Fedora Reporter: Bruno <kidboy>
Component: pam_mysqlAssignee: Paul P Komkoff Jr <i>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 15CC: baldur, i, manuel.wolfshant, ondrejj, tomboland
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: pam_mysql-0.7-0.12.rc1.fc15 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-07-04 18:51:43 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Patch
none
changes for fedora 27 in spec file
none
add missing function in fedora 27 pam_mysql none

Description Bruno 2011-05-31 22:11:09 UTC
Description of problem:

Hi, i have a Fedora 15 x64 with postfix, courier-imap, mysql, and i have a problem with module pam_mysql. Every time i try authenticate for smtp i recive this error from /var/log/secure:
PAM unable to dlopen(/lib64/security/pam_mysql.so): /lib64/security/pam_mysql.so: undefined symbol: make_scrambled_password

Comment 1 Paul P Komkoff Jr 2011-05-31 23:00:32 UTC
Will try to fix this tomorrow.

Comment 2 Bruno 2011-06-01 20:10:07 UTC
(In reply to comment #1)
> Will try to fix this tomorrow.

Ok, i thin the problem is in libmysqlclient version 1.8

Comment 3 Tom Boland 2011-06-08 16:05:26 UTC
This is a more widespread problem with more than one *_mysql.so module with the new libmysqlclient.so.18. 

The affected *_mysql.so's all are making the deprecated make_scrambled_password call. The f14 version of libmyclient.so (.16) allowed the call even though it was deprecated. The new version version (.18) does not. 

Any mysql module that is making the call is failing to load (like apache's mod_auth_mysql) or failing on use (like this one - pam_mysql.)

This is pretty serious in that nobody can authenticate against a mySql database anywhere. I run almost strictly mySql-based virtual users, so my FTP and web server is pretty much toast until this is fixed.

Comment 4 Tom Boland 2011-06-09 14:59:12 UTC
*** Bug 712132 has been marked as a duplicate of this bug. ***

Comment 5 Tom Boland 2011-06-09 15:02:06 UTC
Look at https://bugzilla.redhat.com/show_bug.cgi?id=708287 for more details. There was a similar bug with PureFTP that was fixed in Beta.

Comment 6 Jan ONDREJ 2011-06-10 06:14:20 UTC
Created attachment 504018 [details]
Patch

Paul, please try to use this patch.

Comment 7 Fedora Update System 2011-06-13 20:11:45 UTC
pam_mysql-0.7-0.12.rc1.fc15 has been submitted as an update for Fedora 15.
https://admin.fedoraproject.org/updates/pam_mysql-0.7-0.12.rc1.fc15

Comment 8 Fedora Update System 2011-06-15 05:43:29 UTC
Package pam_mysql-0.7-0.12.rc1.fc15:
* should fix your issue,
* was pushed to the Fedora 15 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing pam_mysql-0.7-0.12.rc1.fc15'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/pam_mysql-0.7-0.12.rc1.fc15
then log in and leave karma (feedback).

Comment 9 Fedora Update System 2011-07-04 18:51:37 UTC
pam_mysql-0.7-0.12.rc1.fc15 has been pushed to the Fedora 15 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 10 Dietmar Kling 2017-12-10 10:09:32 UTC
Should be reopened. mysql-libs has stopped exporting my_make_scrambled_password.
Therefore the package is broken on fedora 27 (and probably also fedora 26).

Comment 11 Dietmar Kling 2017-12-10 10:11:29 UTC
Created attachment 1365552 [details]
changes for fedora 27 in spec file

This changes the spec file to apply a patch ("pam_mysql-my_make_scrambled_Password")  to the code

Comment 12 Dietmar Kling 2017-12-10 10:13:49 UTC
Created attachment 1365555 [details]
add missing function in fedora 27 pam_mysql

This introduces a new function in Pam_mysql, which does the same as the original function in the mysql libs. As this function is not exported anymore, this is needed. 
Works for me (TM) but is not backwards compatible