MariaDB stopped supporting pam_mysql - Cannot send emails! Alternatives?

Discussion in 'Installation/Configuration' started by klonos, Mar 26, 2014.

  1. klonos

    klonos New Member

    It seems that after the latest upgrade of mariadb from 10.0.8 to 10.0.9, PAM support was dropped and a mail server that's been working fine now has the issue of users not being able to send emails:

    Code:
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin Parse the username [email protected]
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin try and connect to a host
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin trying to open db 'mail' on host '127.0.0.1'
    Mar 26 10:13:39 mail postfix/smtpd[3778]: begin transaction
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin create statement from userPassword my_username mydomain.net
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin doing query select password from users where email = '[email protected]';
    Mar 26 10:13:39 mail postfix/smtpd[3778]: commit transaction
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin Parse the username [email protected]
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin try and connect to a host
    Mar 26 10:13:39 mail postfix/smtpd[3778]: sql plugin trying to open db 'mail' on host '127.0.0.1'
    Mar 26 10:13:39 mail saslauthd[3235]: PAM unable to dlopen(pam_mysql.so): /lib/security/pam_mysql.so: undefined symbol: make_scrambled_password_323
    Mar 26 10:13:39 mail saslauthd[3235]: PAM adding faulty module: pam_mysql.so
    Mar 26 10:13:39 mail saslauthd[3235]: DEBUG: auth_pam: pam_authenticate failed: Module is unknown
    Mar 26 10:13:39 mail saslauthd[3235]: do_auth         : auth failure: [[email protected]] [service=smtp] [realm=mydomain.net] [mech=pam] [reason=PAM auth error]
    
    Unfortunately, all my efforts to remove mariadb 10.0.9 to either try to go back to 10.0.8 or even revert back to mysql were futile. Any pointers please?

    Ubuntu 13.10 x64 with a postfix/vmail setup following the "Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 12.10)" HowTo (but replaced mysql with mariadb).
     

Share This Page