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]: Users list not shown #48770

Closed
5 of 8 tasks
ilijaculap opened this issue Oct 17, 2024 · 3 comments
Closed
5 of 8 tasks

[Bug]: Users list not shown #48770

ilijaculap opened this issue Oct 17, 2024 · 3 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 30-feedback bug feature: users and groups needs info

Comments

@ilijaculap
Copy link

ilijaculap commented Oct 17, 2024

⚠️ This issue respects the following points: ⚠️

Bug description

If i go to User list there are not users shown. There should be 4 users. It can be seen on the picture i added here. It is on german (i cannot change language, some another bug i will report).

Image

In nextcloud logs there is nothing. But if i switch logging level i get something. It is posted down there.

Steps to reproduce

  1. Login to your nextcloud with admin account
  2. Go to Menu -> Accounts

Expected behavior

There should be all users listed

Nextcloud Server version

30

Operating system

Debian/Ubuntu

PHP engine version

Other

Web server

Other

Database engine version

Other

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

None

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

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

Configuration report

{
    "system": {
        "htaccess.RewriteBase": "\/",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.culap-family.com",
            "84.46.251.252"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.0.14",
        "overwrite.cli.url": "https:\/\/cloud.culap-family.com",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "overwritehost": "cloud.culap-family.com",
        "overwriteprotocol": "https",
        "loglevel": 2,
        "maintenance": false,
        "maintenance_window_start": 1,
        "default_phone_region": "DE",
        "default_language": "de",
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "defaultapp": "files,photos,contacts,calendar",
        "app_install_overwrite": [
            "files_rightclick",
            "circlesdb"
        ]
    }
}

List of activated Apps

Enabled:
  - bruteforcesettings: 3.0.0
  - calendar: 5.0.0
  - circles: 30.0.0-dev
  - cloud_federation_api: 1.13.0
  - comments: 1.20.1
  - contacts: 6.1.0
  - contactsinteraction: 1.11.0
  - dav: 1.31.1
  - federatedfilesharing: 1.20.0
  - federation: 1.20.0
  - files: 2.2.0
  - files_downloadlimit: 3.0.0
  - files_external: 1.22.0
  - files_pdfviewer: 3.0.0
  - files_reminders: 1.3.0
  - files_sharing: 1.22.0
  - files_trashbin: 1.20.1
  - files_versions: 1.23.0
  - firstrunwizard: 3.0.0
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - nextcloud_announcements: 2.0.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - password_policy: 2.0.0
  - photos: 3.0.2
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - recommendations: 3.0.0
  - related_resources: 1.5.0
  - richdocuments: 8.5.0
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - support: 2.0.0
  - survey_client: 2.0.0
  - systemtags: 1.20.0
  - text: 4.1.0
  - theming: 2.5.0
  - twofactor_backupcodes: 1.19.0
  - updatenotification: 1.20.0
  - user_status: 1.10.0
  - viewer: 3.0.0
  - weather_status: 1.10.0
  - webhook_listeners: 1.1.0-dev
  - workflowengine: 2.12.0
Disabled:
  - activity: 3.0.0 (installed 2.17.0)
  - admin_audit: 1.20.0
  - dashboard: 7.10.0 (installed 7.8.0)
  - encryption: 2.18.0
  - files_rightclick: 0.15.1 (installed 0.15.1)
  - mail: 4.0.0 (installed 4.0.0)
  - notes: 4.11.0 (installed 4.11.0)
  - suspicious_login: 8.0.0
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - user_ldap: 1.21.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"U2LA3Wob4xvFwXQn3oC2",
"level":0,
"time":"2024-10-17T16:00:58+00:00",
"remoteAddr":"XX.XX.XX.XX",
"user":"admin",
"app":"no app in context",
"method":"POST",
"url":"/contactsmenu/contacts",
"message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.",
"userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:131.0) Gecko/20100101 Firefox/131.0",
"version":"30.0.0.14",
"exception":{"Exception":"Exception",
"Message":"No parameters in call to OC\\DB\\QueryBuilder\\ExpressionBuilder\\ExpressionBuilder::orX",
"Code":0,
"Trace":[{"file":"/var/www/html/apps/circles/lib/Db/CoreQueryBuilder.php",
"line":1355,
"function":"orX",
"class":"OC\\DB\\QueryBuilder\\ExpressionBuilder\\ExpressionBuilder",
"type":"->",
"args":[]},{"file":"/var/www/html/apps/circles/lib/Db/CoreQueryBuilder.php",
"line":1122,
"function":"limitInitiatorVisibility",
"class":"OCA\\Circles\\Db\\CoreQueryBuilder",
"type":"->",
"args":["cc"]},{"file":"/var/www/html/apps/circles/lib/Db/CircleRequest.php",
"line":166,
"function":"limitToInitiator",
"class":"OCA\\Circles\\Db\\CoreQueryBuilder",
"type":"->",
"args":["cc",["OCA\\Circles\\Model\\FederatedUser"]]},{"file":"/var/www/html/apps/circles/lib/Service/CircleService.php",
"line":525,
"function":"getCircles",
"class":"OCA\\Circles\\Db\\CircleRequest",
"type":"->",
"args":[["OCA\\Circles\\Model\\FederatedUser"],["OCA\\Circles\\Model\\Probes\\CircleProbe"]]},{"file":"/var/www/html/apps/circles/lib/Api/v1/Circles.php",
"line":133,
"function":"getCircles",
"class":"OCA\\Circles\\Service\\CircleService",
"type":"->",
"args":[["OCA\\Circles\\Model\\Probes\\CircleProbe"]]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Principal.php",
"line":573,
"function":"joinedCircles",
"class":"OCA\\Circles\\Api\\v1\\Circles",
"type":"::",
"args":["admin",true]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":130,
"function":"getCircleMembership",
"class":"OCA\\DAV\\Connector\\Sabre\\Principal",
"type":"->",
"args":["principals/users/admin"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line":45,
"function":"OCA\\DAV\\CardDAV\\{closure}",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":102,
"function":"atomic",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/ContactsManager.php",
"line":38,
"function":"getAddressBooksForUser",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":["principals/users/admin"]},{"file":"/var/www/html/apps/dav/lib/AppInfo/Application.php",
"line":262,
"function":"setupContactsProvider",
"class":"OCA\\DAV\\CardDAV\\ContactsManager",
"type":"->",
"args":["*** sensitive parameters replaced ***",
"admin",["OC\\URLGenerator",["OC\\User\\Session"]]]},{"file":"/var/www/html/apps/dav/lib/AppInfo/Application.php",
"line":249,
"function":"setupContactsProvider",
"class":"OCA\\DAV\\AppInfo\\Application",
"type":"->",
"args":["*** sensitive parameters replaced ***",["OC\\AppFramework\\DependencyInjection\\DIContainer"],
"admin"]},{"file":"/var/www/html/lib/private/ContactsManager.php",
"line":190,
"function":"OCA\\DAV\\AppInfo\\{closure}",
"class":"OCA\\DAV\\AppInfo\\Application",
"type":"->",
"args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/ContactsManager.php",
"line":34,
"function":"loadAddressBooks",
"class":"OC\\ContactsManager",
"type":"->",
"args":[]},{"file":"/var/www/html/lib/private/Contacts/ContactsMenu/ContactsStore.php",
"line":118,
"function":"search",
"class":"OC\\ContactsManager",
"type":"->",
"args":["",["FN",
"EMAIL"],[true,true,25]]},{"file":"/var/www/html/lib/private/Contacts/ContactsMenu/Manager.php",
"line":34,
"function":"getContacts",
"class":"OC\\Contacts\\ContactsMenu\\ContactsStore",
"type":"->",
"args":[["OC\\User\\User"],
"",25]},{"file":"/var/www/html/core/Controller/ContactsMenuController.php",
"line":34,
"function":"getEntries",
"class":"OC\\Contacts\\ContactsMenu\\Manager",
"type":"->",
"args":[["OC\\User\\User"],
""]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line":208,
"function":"index",
"class":"OC\\Core\\Controller\\ContactsMenuController",
"type":"->",
"args":[""]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line":114,
"function":"executeController",
"class":"OC\\AppFramework\\Http\\Dispatcher",
"type":"->",
"args":[["OC\\Core\\Controller\\ContactsMenuController"],
"index"]},{"file":"/var/www/html/lib/private/AppFramework/App.php",
"line":161,
"function":"dispatch",
"class":"OC\\AppFramework\\Http\\Dispatcher",
"type":"->",
"args":[["OC\\Core\\Controller\\ContactsMenuController"],
"index"]},{"file":"/var/www/html/lib/private/Route/Router.php",
"line":302,
"function":"main",
"class":"OC\\AppFramework\\App",
"type":"::",
"args":["OC\\Core\\Controller\\ContactsMenuController",
"index",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["core.contactsmenu.index"]]},{"file":"/var/www/html/lib/base.php",
"line":1001,
"function":"match",
"class":"OC\\Route\\Router",
"type":"->",
"args":["/contactsmenu/contacts"]},{"file":"/var/www/html/index.php",
"line":24,
"function":"handleRequest",
"class":"OC",
"type":"::",
"args":[]}],
"File":"/var/www/html/lib/private/DB/QueryBuilder/ExpressionBuilder/ExpressionBuilder.php",
"Line":87,
"message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.",
"exception":[],
"CustomMessage":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon."},
"id":"671134c1ee969"}

Additional info

Everything happend after updating nextcloud to v30. I am using latest docker image for my instance (but from now on i will stick to older versions for some time). Here is my docker-compose file:

version: '3.3'

services:
  db:
    image: mariadb:10.11
    restart: always
    command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
    volumes:
      - ./mariadb:/var/lib/mysql
    networks:
      - default
    environment:
      - MYSQL_ROOT_PASSWORD=XXXXXX
      - MYSQL_PASSWORD=XXXXXX
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud

  app:
    image: nextcloud:30
    restart: always
    links:
      - db
    volumes:
      - ./nextcloud:/var/www/html
    environment:
      - MYSQL_PASSWORD=XXXXXX
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud
      - MYSQL_HOST=db
      - PHP_MEMORY_LIMIT=2048M
      - PHP_UPLOAD_LIMIT=2048M
      - REDIS_HOST=valkey
      - REDIS_HOST_PASSWORD=XXXXXX
    networks:
      - default
      - proxynetwork

  valkey:
    image: valkey/valkey:latest
    restart: always
    command: valkey-server --requirepass XXXXXX
    environment:
      - REDIS_REPLICATION_MODE=master

networks:
  proxynetwork:
    external: true

@ilijaculap ilijaculap added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Oct 17, 2024
@joshtrichards
Copy link
Member

joshtrichards commented Oct 17, 2024

Not able to reproduce.

Please check your browser inspector. Particularly monitoring the Network tab while reproducing this behavior as well as the Console tab.

@ilijaculap
Copy link
Author

Not able to reproduce.

Please check your browser inspector. Particularly monitoring the Network tab while reproducing this behavior as well as the Console tab.

Thank you very much for your tip. Through Console in my web browser i saw that there is error 500. It happend because i defined /ocs/ endpoint in my nginx proxy wrongly. Now i removed that location and i can see my users now. I have to check for other issues i had (maybe they are now resolved)

@joshtrichards
Copy link
Member

Glad to hear it! If you need help troubleshooting something further, please utilize the help forum: https://help.nextcloud.com

@joshtrichards joshtrichards closed this as not planned Won't fix, can't repro, duplicate, stale Oct 17, 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 30-feedback bug feature: users and groups needs info
Projects
None yet
Development

No branches or pull requests

2 participants