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