NC27 with Fulltextsearch, only the main admin account can find everything

Hello all,
I’ve just “installed” Elasticsearch 7.17.10 via Docker, indexed all my files an now I’m seeing some problems.

Nextcloud version: 27.0.0
Operating system and version : Ubuntu 22.04.2 LTS
Apache or nginx version: Apache/2.4.56
Database: pgsql PostgreSQL 15.3
PHP version: 8.2.7

The issue you are facing:
tl;dr: A normal user can’t find anything, an user from the admin group can only find files he created.
Only the main admin account can find / search trough “everything”.

Long answer:
We’re using keycloak as an identity provider and to map users to their corresponding groups.
All folders are created trough the local admin account and shared with the users:
grafik

If using the forementioned admin account we can search trough all the files:

If using another account from the admin group we can only find files from the folders shared only with the admin group:


grafik

If using a normal user account the search doesn’t return anything:

Is this the first time you’ve seen this error?: Y

Steps to replicate it:

  1. Install NC27.0.0, Keycloak, Fulltextsearch_Elasticsearch, Fulltextsearch, Fulltextsearch Files, Elasticsearch via Docker
  2. See above

The output of your Nextcloud log in Admin > Logging:
Nothing regarding this behaviour

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

{
    "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
        }
    ],
    "memcache.distributed": "\\OC\\Memcache\\Redis",
    "memcache.locking": "\\OC\\Memcache\\Redis",
    "redis": {
        "host": "***REMOVED SENSITIVE VALUE***",
        "password": "***REMOVED SENSITIVE VALUE***",
        "port": 6379
    },
    "overwritehost": "cloud.epic-empires.de",
    "overwriteprotocol": "https",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "localhost",
        "cloud.epic-empires.de"
    ],
    "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "skeletondirectory": "",
    "dbtype": "pgsql",
    "version": "27.0.0.8",
    "overwrite.cli.url": "https:\/\/cloud.epic-empires.de",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpmode": "smtp",
    "mail_sendmailmode": "smtp",
    "mail_smtpsecure": "tls",
    "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpport": "587",
    "mail_smtpauthtype": "LOGIN",
    "mail_smtpauth": 1,
    "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
    "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
    "mail_from_address": "***REMOVED SENSITIVE VALUE***",
    "mail_domain": "***REMOVED SENSITIVE VALUE***",
    "default_phone_region": "DE",
    "defaultapp": "files",
    "loglevel": 2,
    "maintenance": false,
    "htaccess.RewriteBase": "\/"
}

The output of your Apache/nginx/system log in /var/log/____:

178.202.168.202 - - [20/Jun/2023:16:08:33 +0000] "GET /apps/fulltextsearch/v1/search?request=%7B%22providers%22%3A%22all%22%2C%22options%22%3A%7B%22files_local%22%3A%220%22%2C%22files_external%22%3A%220%22%2C%22files_group_folders%22%3A%220%22%2C%22files_extension%22%3A%22%22%7D%2C%22search%22%3A%22Komet%22%2C%22page%22%3A1%7D HTTP/1.1" 200 1202 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/114.0"

178.202.168.202 - - [20/Jun/2023:16:08:35 +0000] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 863 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/114.0"

see groupfolders and fulltextsearch cannot coexist on 27.0.0 · Issue #2428 · nextcloud/groupfolders · GitHub and linked issues in fulltextsearch - there are more issues with fulltextsearch and 27. Wait until released!

Hi,

We have the same error here.
Fulltextsearch is only working with admin Account or user in admin group.

@Frick have you found a solution?

I’ve really been chasing this bug for 2 weeks now and I can now reproduce it too…

The problem is the username!

test = working
test3 = working
test 3 = not working
Test_3 = not working…

The username has to be a simple string of letters and numbers, as soon as there is a special character, a space or something else, the fulltext search no longer works!