New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

when using LDAP plugin user quota can only be set by manually updating configvalue for 'configkey 'quota' #32479

Closed
davethom opened this Issue Aug 28, 2018 · 2 comments

Comments

Projects
None yet
2 participants
@davethom
Copy link

davethom commented Aug 28, 2018

Steps to reproduce

  1. set up owncloud server, configure LDAP plugin to use corporate AD
  2. change a users quota via admin web panel
  3. user connects via web or client, quota goes back to previous value

Expected behaviour

quota should change and stay changed

Actual behaviour

quota goes back to previous value

Server configuration

Operating system:
CentOS 6.9

Web server:
Apache/2.2.15 (Unix)

Database:
MySQL Community Server 5.6.40

PHP version:
7.1

ownCloud version: (see ownCloud admin page)
10.0.9

Updated from an older ownCloud or fresh install:
updated

Where did you install ownCloud from:
source code tarball

Signing status (ownCloud 9.0 and above):
No errors have been found.

The content of config/config.php:

{
    "system": {
        "instanceid": "513d1f5b0acb8",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "\/data",
        "dbtype": "mysql",
        "version": "10.0.9.5",
        "dbname": "cloud",
        "dbhost": "mysqlhost.******",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "maintenance": false,
        "theme": "",
        "ldapIgnoreNamingRules": false,
        "loglevel": 2,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "localhost",
            "port": 6379
        },
        "trusted_domains": [
            "cloud.maths-stats.gla.ac.uk"
        ],
        "share_folder": "\/Shared",
        "enable_previews": true,
        "preview_max_scale_factor": 10,
        "preview_libreoffice_path": "\/usr\/bin\/oowriter",
        "preview_office_cl_parameters": "",
        "enable_avatars": true,
        "mail_smtpmode": "php",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "trashbin_retention_obligation": "auto",
        "cron.lockfile.location": "\/var\/www\/html\/owncloud\/tmp\/",
        "integrity.excluded.files": [
            ".DS_Store",
            "Thumbs.db",
            ".directory",
            ".webapp",
            ".htaccess",
            ".user.ini",
            "robots.txt"
        ],
        "singleuser": false
    }
}

List of activated apps:
Enabled:

  • activity: 2.3.7
  • calendar: 1.5.7
  • comments: 0.3.0
  • configreport: 0.1.1
  • dav: 0.3.2
  • federatedfilesharing: 0.3.1
  • federation: 0.1.0
  • files: 1.5.1
  • files_external: 0.7.1
  • files_pdfviewer: 0.9.0
  • files_sharing: 0.10.1
  • files_trashbin: 0.9.1
  • files_versions: 1.3.0
  • files_videoplayer: 0.9.8
  • firstrunwizard: 1.1
  • gallery: 16.1.0
  • market: 0.2.5
  • notifications: 0.3.4
  • provisioning_api: 0.5.0
  • systemtags: 0.3.0
  • updatenotification: 0.2.1
  • user_ldap: 0.11.0
    Disabled:
  • encryption
  • external
  • user_external

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP configuration (delete this part if not used)

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

we use LDAP for authentication only there are no values for quota in LDAP settings
I change the users quota via web admin login
(this is reflected in the table oc_accounts quota field)
user connects via client or web, quota resets in oc_account table to previous value, and in client and admin web interface.
it seems to change the user quota I can change the value in the oc_preferences table configvalue for the quota configkey
the configvalue field never gets updated when changing the quota from the admin web interface, changing this by hand in the database make the value stick for the user

@PVince81

This comment has been minimized.

Copy link
Member

PVince81 commented Sep 4, 2018

If you configured an LDAP attribute for quota in the LDAP wizard, it is likely that the LDAP module will import the quota from AD and overwrite whatever was set manually.

If you don't want to read quotas from LDAP and only set locally in the OC web UI, don't read the quota from LDAP by removing the attribute.

cc @jvillafanez @butonic

@davethom

This comment has been minimized.

Copy link
Author

davethom commented Sep 4, 2018

If I configured an LDAP attribute for quota in the LDAP wizard, absolutely I'd expect it to be used first and overwrite any manual settings, maybe you missed the part about "there are no values for quota in LDAP settings". The quota values are coming from the files app entry in oc_preferences.
I seems to have been something left behind during updates as this has been a production server since version 8.
I have fixed the issue by running
occ user:sync "OCA\User_LDAP\User_Proxy"
which seems to have also fixed an issue with "last login" which was also being overwritten from an entry in oc_preferences

@davethom davethom closed this Sep 4, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment