[Dovecot] pam mysql authentication

radus at smartpost.ro radus at smartpost.ro
Sat Jun 4 13:06:11 EEST 2005


Hello

I am trying to use pam to authenticate dovecot again a mysql database.
In /etc/pam.d/dovecot i have:
auth     optional       pam_mysql.so host=localhost db=maildb user=mailro \
         passwd=xxx table=users usercolumn=address passwdcolumn=passwd \
         where="disabled is NULL and deleted = ''" crypt=1
account  required       pam_mysql.so host=localhost db=maildb user=mailro \
         passwd=xxx table=users usercolumn=address passwdcolumn=passwd \
         where="disabled is NULL and deleted = ''" crypt=1

I have the same file for smtp and it works ok.

However when i try to log in dovecot i get:
Jun  4 05:02:21 tx07 dovecot-auth: Unknown option: is
Jun  4 05:02:21 tx07 dovecot-auth: Unknown option: NULL
Jun  4 05:02:21 tx07 dovecot-auth: Unknown option: and
Jun  4 05:02:21 tx07 dovecot-auth: Unknown option: deleted
Jun  4 05:02:21 tx07 dovecot-auth: Unknown option: =
Jun  4 05:02:21 tx07 dovecot-auth: Unknown option: ''"
Jun  4 05:02:21 tx07 dovecot-auth: You have an error in your SQL syntax. 
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '"disabled)' at line 1

I am running dovecot 0.99.14

Thanks,
Radu





More information about the dovecot mailing list