DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:authpdo:nextcloud

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
plugin:authpdo:nextcloud [2019-02-18 01:02]
reinhold Nicely format the SQL code
plugin:authpdo:nextcloud [2019-02-18 01:04] (current)
reinhold
Line 37: Line 37:
 WHERE WHERE
     oc_users.uid = :user</code> |     oc_users.uid = :user</code> |
-| plugin>authpdo>select-user-groups   | SELECT gid AS 'group' FROM oc_group_user WHERE uid=:user |+| plugin>authpdo>select-user-groups   <code>SELECT gid AS 'group' FROM oc_group_user WHERE uid=:user</code> |
 | Other fields   | Leave empty | | Other fields   | Leave empty |
  
 Note: Make sure not to add quotes around :user, as the authpdo plugin will automatically wrap strings like the user id in quotes. Note: Make sure not to add quotes around :user, as the authpdo plugin will automatically wrap strings like the user id in quotes.
  
-Note2: Instead of using the same PostgreSQL user as Nextcloud, it might be advisable to create a new 'read-only' user as we will not be doing any writing to the Nextcloud database.+Note2: Instead of using the same database user as Nextcloud, it might be advisable to create a new 'read-only' user as we will not be doing any writing to the Nextcloud database.
  
 In the Authentication section: In the Authentication section:
plugin/authpdo/nextcloud.txt ยท Last modified: 2019-02-18 01:04 by reinhold