Hi, this shouldn't be to hard.
Your dovecot-sql.conf.ext could look something like this:
---
driver = mysql
connect = host=<host> dbname=<dbname> user=<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, \
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>
iterate_query = SELECT username AS user FROM <JOOMLA_PREFIX>_users u \
LEFT JOIN <JOOMLA_PREFIX>_user_usergroup_map g ON u.id = g.user_id \
WHERE \
u.block = 0 AND g.group_id = <ID OF THE JOOMLA GROUP>
---
But I'm not sure if dovecot supports Blowfish $2y$ Version used by
Joomla as default.
Also I didn't tested this configuration, so there maybe someflaws in it.
bye
Harald
Am 05.07.2018 um 16:05 schrieb Graham S. Jarvis:
> 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 in advance,
>
> -Graham-
--
Harald Leithner
ITronic
Wiedner Hauptstraße 120/5.1, 1050 Wien, Austria
Tel: +43-1-545 0 604
Mobil: +43-699-123 78 4 78
Mail: [email protected] | itronic.at
signature.asc
Description: OpenPGP digital signature
