Displaying 2 results from an estimated 2 matches for "joomla_prefix".
2018 Jul 05
1
user/password Authentication via Joomla database
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
2018 Jul 06
0
user/password Authentication via Joomla database
...= 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 = \
>> ?? S...