Arch Linux

Gregosky

Member

From: UK

Registered: 2013-07-26

Posts: 174

[closed] PAM won't authenticate with mysql (make_scrambled_password)

Hi all,

I have spent some time searching for this and it seems I'm the only one having problem with PAM not authenticating through mysql so I thought I will post my problem here and if I find solution I will post here as well for others to follow.

In short - I'm running postfix with saslauthd and dovecot. Both are authenticating through pam employing mysql as credentials source.

Everything was working fine until today update - I can't connect to mail server any more and here is what I see in logs:

PAM unable to dlopen(/usr/lib/security/pam_mysql.so): /usr/lib/security/pam_mysql.so: undefined symbol: make_scrambled_password
PAM adding faulty module: /usr/lib/security/pam_mysql.so
DEBUG: auth_pam: pam_authenticate failed: Module is unknown
do_auth         : auth failure: [user=xxxx] [service=smtp] [realm=xxxx] [mech=pam] [reason=PAM auth error]

So I may be wrong but to my understanding pam_mysql.so is using deprecated make_scrambled_password that is not supported by mysql any more.

I don't know what the solution would be and will appreciate if anybody can advice.

Many thanks in advance,
Greg

Last edited by Gregosky (2014-03-01 22:41:53)

loafer

Member

From: the pub

Registered: 2009-04-14

Posts: 1,772

Re: [closed] PAM won't authenticate with mysql (make_scrambled_password)

A quick Google shows several threads and bug reports from various distros - some quite recent - with a similar error.  Did you check those?

---

All men have stood for freedom...
For freedom is the man that will turn the world upside down.
Gerrard Winstanley.

Gregosky

Member

From: UK

Registered: 2013-07-26

Posts: 174

Re: [closed] PAM won't authenticate with mysql (make_scrambled_password)

Thanks, I have seen them but I thought this should be patched at source so no other Arch user would come across it.

I'm wondering why am I seeing this error now, after such a long time of using my postfix setup.. This must have been caused by latest update I ran yesterday as I have not modified any configuration.

I still did not find solution to this.

I submitted  bug report on project page, hopefully some hints will arrive from there.

Now also submitted on Arch bug tracker.

---

Support for pam_mysql dropped. I will move to another backend. Case closed however there is no solution for pam_mysql.

Last edited by Gregosky (2014-03-01 22:40:54)