Displaying 1 result from an estimated 1 matches for "emailmanager_userprofile".
2011 Aug 07
1
SQL passdb lookups not working
...or setup of my passwords would be appreciated!
Ben
dovecot-sql.conf:
default_pass_scheme = SSHA.hex
password_query = \
SELECT emailmanager_emailaddresses.account AS username, \
emailmanager_domain.name AS domain, \
CONCAT('{SSHA.hex}', \
emailmanager_userprofile.shadigest, \
emailmanager_userprofile.salt \
) AS password \
FROM emailmanager_emailaddresses \
JOIN emailmanager_domain ON emailmanager_emailaddresses.id =
emailmanager_domain.id \
JOIN emailmanager_userprofile ON
emailmana...