search for: _user_usergroup_map

Hello, did anyone ever set up Authentication via lookups to a Joomla (mysql) database? What I'd like to do is lookup Joomla users (who are in specific/multiple groups) in the Joomla database and then fallback to /etc/passwd authentication to let system users authenticate. I'm running : # 2.2.35 (b1cb664): /usr/local/etc/dovecot/dovecot.conf # OS: FreeBSD 11.1-RELEASE-p10 amd64 Thanks

...username> password=<password> >> >> default_pass_scheme = BLF-CRYPT >> password_query = \ >> ?? SELECT \ >> ???????? u.username, \ >> ???????? u.password, \ >> ?? FROM <JOOMLA_PREFIX>_users u \ >> ???????? LEFT JOIN <JOOMLA_PREFIX>_user_usergroup_map g ON u.id = >> g.user_id \ >> ?? WHERE \ >> ???????? u.username = '%u' AND u.block = 0 AND g.group_id = <ID OF THE >> JOOMLA GROUP> >> >> user_query = \ >> ?? SELECT \ >> ???????? u.username, \ >> ???????? u.password, \ >> ??...