Bug 709534 - Error pam_mysql
Summary: Error pam_mysql
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: pam_mysql
Version: 15
Hardware: x86_64
OS: Linux
unspecified
urgent
Target Milestone: ---
Assignee: Paul P Komkoff Jr
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
: 712132 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-05-31 22:11 UTC by Bruno
Modified: 2017-12-10 10:13 UTC (History)
5 users (show)

Fixed In Version: pam_mysql-0.7-0.12.rc1.fc15
Clone Of:
Environment:
Last Closed: 2011-07-04 18:51:43 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)
Patch (970 bytes, patch)
2011-06-10 06:14 UTC, Jan ONDREJ
no flags Details | Diff
changes for fedora 27 in spec file (791 bytes, patch)
2017-12-10 10:11 UTC, Dietmar Kling
no flags Details | Diff
add missing function in fedora 27 pam_mysql (865 bytes, patch)
2017-12-10 10:13 UTC, Dietmar Kling
no flags Details | Diff

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


Note You need to log in before you can comment on or make changes to this bug.