Joomla

Joomla (3.9) example preset

The Joomla table prefix should also be given in this case it is 'jos'. I’m not sure if other CMS also uses prefix in the table names?

Hash algorithm: Blowfish (there is a 'Joomla md5 encryption' but that didn`t work for me)

Reverse active column: checked

Usertable

Table name: jos_user
Email: email
Password: password
Display name:  name
Active: blocked

Grouptable

Table name:  jos_groups
Group name: title

User group table

Does only exist with ID numbers so we need to generate a view for this:

Create view Joomla_NC_groupmapping AS select jos_users.usernameASusername,groups.titleASgroupname from ((jos_usersjoinjos_user_usergroup_map map on((jos_users.id=map.user_id))) join jos_usergroups groups on((groups.id=map.group_id))) order by jos_users.username``

Table name:  Joomla_NC_groupmapping
Username: username
Group name: groupname 

Above configuration settings for Joomla can be used in the documentation as well (for the time being?) so that other Joomla and NC user don`t have to re-event.