Displaying 1 result from an estimated 1 matches for "emailmanager_domain".
2011 Aug 07
1
SQL passdb lookups not working
...and I think my setup is
correct...config info is below. Any advice on where to look for
debugging 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 emailmana...