Skip to content
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

[Bug]: LDAP User and Group Backend - Web UI repeately reports LDAP configuration as incomplete #42475

Closed
6 of 8 tasks
nagmat84 opened this issue Dec 24, 2023 · 3 comments
Closed
6 of 8 tasks
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 28-feedback bug feature: ldap needs info stale Ticket or PR with no recent activity

Comments

@nagmat84
Copy link

⚠️ This issue respects the following points: ⚠️

Bug description

I have configured the LDAP User and Group Backend via the Web UI and it is working. LDAP users and groups are found, LDAP users can login and create shares with other LDAP users and groups. Access to shares with groups are granted according the LDAP group memberships as expected. If I check the LDAP configuration from the CLI, everything looks good, too.

However, when I navigate to Settings -> Admin -> LDAP again, the LDAP configuration is only partially filled and reported as incomplete. Moreover, I cannot neither complete the LDAP configuration nor delete it. If I try to complete the configuration and save it, Nextcloud UI reports that it wan't able to connect to the LDAP server. (But it can, CLI reports otherwise and LDAP logins are still working). If I try to delete the offending allegedly incomplete configuration, it is seemingly deleted without an error, but when I refresh the page or browse somewhere else and then come back to Settings -> Admin -> LDAP the configuration reappears and is reported as incomplete again.

Note, LDAP works and I can also use the CLI to check or modify LDAP settings if I had to, hence it is not a severe issue for me, but the GUI settings should properly work, too.

Screenshot of LDAP Settings (Note: The German text on the lower left says "Configuration incomplete")

LDAPSettingsGUI

Screenshot of LDAP-related commands on CLI:

CLI

And for better searchability, the LDAP config as text (empty value omitted):

+-------------------------------+---------------------------------------------------------------------+
| Configuration                 | s01                                                                 |
+-------------------------------+---------------------------------------------------------------------+
| hasMemberOfFilterSupport      | 0                                                                   |
| lastJpegPhotoLookup           | 0                                                                   |
| ldapAdminGroup                | admins                                                              |
| ldapAgentName                 | uid=nextcloud,ou=users,o=server.mhnnet.de,dc=server,dc=mhnnet,dc=de |
| ldapAgentPassword             | ***                                                                 |
| ldapAttributesForGroupSearch  | cn;displayName;description                                          |
| ldapAttributesForUserSearch   | uid;displayName;mail                                                |
| ldapBase                      | o=famna.de,dc=server,dc=mhnnet,dc=de                                |
| ldapBaseGroups                | ou=groups,o=famna.de,dc=server,dc=mhnnet,dc=de                      |
| ldapBaseUsers                 | ou=users,o=famna.de,dc=server,dc=mhnnet,dc=de                       |
| ldapCacheTTL                  | 600                                                                 |
| ldapConfigurationActive       | 1                                                                   |
| ldapConnectionTimeout         | 15                                                                  |
| ldapEmailAttribute            | mail                                                                |
| ldapExperiencedAdmin          | 1                                                                   |
| ldapGidNumber                 | gidNumber                                                           |
| ldapGroupDisplayName          | displayname                                                         |
| ldapGroupFilter               | (objectclass=groupOfMembers)                                        |
| ldapGroupFilterMode           | 0                                                                   |
| ldapGroupFilterObjectclass    | groupOfMembers                                                      |
| ldapGroupMemberAssocAttr      | member                                                              |
| ldapHost                      | ldapi://%2frun%2fopenldap%2fslapd.sock                              |
| ldapLoginFilter               | (&(objectclass=inetOrgPerson)(|(uid=%uid)(mail=%uid)))              |
| ldapLoginFilterEmail          | 0                                                                   |
| ldapLoginFilterMode           | 0                                                                   |
| ldapLoginFilterUsername       | 1                                                                   |
| ldapMatchingRuleInChainState  | unknown                                                             |
| ldapNestedGroups              | 0                                                                   |
| ldapPagingSize                | 500                                                                 |
| ldapTLS                       | 0                                                                   |
| ldapUserAvatarRule            | default                                                             |
| ldapUserDisplayName           | displayname                                                         |
| ldapUserDisplayName2          | mail                                                                |
| ldapUserFilter                | (objectclass=inetOrgPerson)                                         |
| ldapUserFilterMode            | 0                                                                   |
| ldapUserFilterObjectclass     | inetOrgPerson                                                       |
| ldapUuidGroupAttribute        | auto                                                                |
| ldapUuidUserAttribute         | auto                                                                |
| markRemnantsAsDisabled        | 1                                                                   |
| turnOffCertCheck              | 0                                                                   |
| turnOnPasswordChange          | 1                                                                   |
| useMemberOfToDetectMembership | 0                                                                   |
+-------------------------------+---------------------------------------------------------------------+

Steps to reproduce

  1. Configure LDAP User and Group Backend
  2. Navigate to the settings page for "LDAP User and Group Backend" later
  3. The configuration appears as incomplete

Expected behavior

The GUI setting page for "LDAP User and Group Backend" should show the complete LDAP configuration as it is

Installation method

Community Manual installation with Archive

Nextcloud Server version

28

Operating system

Other

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

PostgreSQL

Is this bug present after an update or on a fresh install?

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.famna.de",
            "cloud.mhnnet.de"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "28.0.1.1",
        "overwrite.cli.url": "https:\/\/cloud.famna.de",
        "htaccess.RewriteBase": "\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0
        },
        "mail_smtpmode": "sendmail",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "maintenance": false,
        "skeletondirectory": "",
        "templatedirectory": "",
        "default_language": "de",
        "default_locale": "de_DE",
        "default_phone_region": "DE",
        "default_timezone": "Europe\/Berlin",
        "enabledPreviewProviders": [
            "OC\\Preview\\BMP",
            "OC\\Preview\\GIF",
            "OC\\Preview\\HEIC",
            "OC\\Preview\\JPEG",
            "OC\\Preview\\Krita",
            "OC\\Preview\\MarkDown",
            "OC\\Preview\\MSOffice2003",
            "OC\\Preview\\MSOffice2007",
            "OC\\Preview\\MSOfficeDoc",
            "OC\\Preview\\Movie",
            "OC\\Preview\\MP3",
            "OC\\Preview\\OpenDocument",
            "OC\\Preview\\PDF",
            "OC\\Preview\\PNG",
            "OC\\Preview\\SVG",
            "OC\\Preview\\TIFF",
            "OC\\Preview\\TXT",
            "OC\\Preview\\WebP",
            "OC\\Preview\\XBitmap"
        ],
        "allow_user_to_change_display_name": false
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - bruteforcesettings: 2.8.0
  - calendar: 4.6.1
  - calendar_resource_management: 0.6.0
  - cloud_federation_api: 1.11.0
  - contacts: 5.5.0
  - dashboard: 7.8.0
  - dav: 1.29.1
  - event_update_notification: 2.3.0
  - federatedfilesharing: 1.18.0
  - federation: 1.18.0
  - files: 2.0.0
  - files_accesscontrol: 1.18.0
  - files_sharing: 1.20.0
  - files_trashbin: 1.18.0
  - files_versions: 1.21.0
  - groupfolders: 16.0.1
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - mail: 3.5.0
  - nextcloud_announcements: 1.17.0
  - notifications: 2.16.0
  - oauth2: 1.16.3
  - password_policy: 1.18.0
  - previewgenerator: 5.4.0
  - provisioning_api: 1.18.0
  - recommendations: 2.0.0
  - related_resources: 1.3.0
  - serverinfo: 1.18.0
  - settings: 1.10.1
  - sharebymail: 1.18.0
  - support: 1.11.0
  - tasks: 0.15.0
  - text: 3.9.1
  - theming: 2.3.0
  - twofactor_backupcodes: 1.17.0
  - updatenotification: 1.18.0
  - user_ldap: 1.19.0
  - user_status: 1.8.1
  - viewer: 2.2.0
  - workflowengine: 2.10.0
Disabled:
  - admin_audit: 1.18.0
  - circles: 28.0.0-dev (installed 28.0.0-dev)
  - comments: 1.18.0 (installed 1.18.0)
  - contactsinteraction: 1.9.0 (installed 1.9.0)
  - encryption: 2.16.0
  - files_external: 1.20.0
  - files_pdfviewer: 2.9.0 (installed 2.9.0)
  - files_reminders: 1.1.0 (installed 1.1.0)
  - firstrunwizard: 2.17.0 (installed 2.17.0)
  - photos: 2.4.0 (installed 2.4.0)
  - privacy: 1.12.0 (installed 1.12.0)
  - survey_client: 1.16.0 (installed 1.16.0)
  - suspicious_login: 6.0.0
  - systemtags: 1.18.0 (installed 1.18.0)
  - twofactor_totp: 10.0.0-beta.2
  - weather_status: 1.8.0 (installed 1.8.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"t5kiCaD77yGqMApQxk35","level":3,"time":"2023-12-22T17:10:01+00:00","remoteAddr":"79.222.238.167","user":"7745f1ae-d552-4a8a-bbd2-1a1fd709edbf","app":"no app in context","method":"PUT","url":"/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json","message":"Exception thrown: OC\\DB\\Exceptions\\DbalException","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0","version":"28.0.1.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(7745f1ae-d552-4a8a-bbd2-1a1fd709edbf) already exists.","Code":7,"Trace":[{"file":"/var/www/famna.de/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":328,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/var/www/famna.de/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":137,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":113,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Controller/HeartbeatController.php","line":100,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/famna.de/nextcloud/ocs/v1.php","line":65,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/famna.de/nextcloud/ocs/v2.php","line":23,"args":["/var/www/famna.de/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/famna.de/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException","Message":"An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(7745f1ae-d552-4a8a-bbd2-1a1fd709edbf) already exists.","Code":7,"Trace":[{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1938,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1880,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1208,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":386,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":137,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":113,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Controller/HeartbeatController.php","line":100,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/famna.de/nextcloud/ocs/v1.php","line":65,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/famna.de/nextcloud/ocs/v2.php","line":23,"args":["/var/www/famna.de/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":53,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(7745f1ae-d552-4a8a-bbd2-1a1fd709edbf) already exists.","Code":7,"Trace":[{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1202,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":386,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":137,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":113,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Controller/HeartbeatController.php","line":100,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/famna.de/nextcloud/ocs/v1.php","line":65,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/famna.de/nextcloud/ocs/v2.php","line":23,"args":["/var/www/famna.de/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(7745f1ae-d552-4a8a-bbd2-1a1fd709edbf) already exists.","Code":"23505","Trace":[{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1202,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":386,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":137,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":113,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/famna.de/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/apps/user_status/lib/Controller/HeartbeatController.php","line":100,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/famna.de/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/famna.de/nextcloud/ocs/v1.php","line":65,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/famna.de/nextcloud/ocs/v2.php","line":23,"args":["/var/www/famna.de/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/famna.de/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"CustomMessage":"Exception thrown: OC\\DB\\Exceptions\\DbalException"}}
{"reqId":"bv5Iy91TvnMZzo7Y6p32","level":2,"time":"2023-12-22T18:43:40+00:00","remoteAddr":"79.222.238.167","user":"01976b91-c1e3-4fe2-9601-66e56ac766d3","app":"no app in context","method":"GET","url":"/settings/admin/groupware","message":"Invalid google_oauth_client_id data provided to provideInitialState by mail","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0","version":"28.0.1.1","data":[]}
{"reqId":"bv5Iy91TvnMZzo7Y6p32","level":2,"time":"2023-12-22T18:43:40+00:00","remoteAddr":"79.222.238.167","user":"01976b91-c1e3-4fe2-9601-66e56ac766d3","app":"no app in context","method":"GET","url":"/settings/admin/groupware","message":"Invalid microsoft_oauth_client_id data provided to provideInitialState by mail","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0","version":"28.0.1.1","data":[]}
{"reqId":"ONa0ZkkAIBpdcHkqaGvs","level":2,"time":"2023-12-22T18:45:09+00:00","remoteAddr":"79.222.238.167","user":"01976b91-c1e3-4fe2-9601-66e56ac766d3","app":"no app in context","method":"GET","url":"/settings/admin/groupware","message":"Invalid google_oauth_client_id data provided to provideInitialState by mail","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0","version":"28.0.1.1","data":[]}
{"reqId":"ONa0ZkkAIBpdcHkqaGvs","level":2,"time":"2023-12-22T18:45:09+00:00","remoteAddr":"79.222.238.167","user":"01976b91-c1e3-4fe2-9601-66e56ac766d3","app":"no app in context","method":"GET","url":"/settings/admin/groupware","message":"Invalid microsoft_oauth_client_id data provided to provideInitialState by mail","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0","version":"28.0.1.1","data":[]}

Additional info

No response

@nagmat84
Copy link
Author

More information which might be the underlying root cause is available in #42474 (comment).

@joshtrichards
Copy link
Member

See #42474 (comment)

@nextcloud-command
Copy link
Contributor

This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions.

@nextcloud-command nextcloud-command added the stale Ticket or PR with no recent activity label Oct 8, 2024
@nextcloud-command nextcloud-command closed this as not planned Won't fix, can't repro, duplicate, stale Oct 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 28-feedback bug feature: ldap needs info stale Ticket or PR with no recent activity
Projects
None yet
Development

No branches or pull requests

3 participants