Steps to reproduce
- Login as an administrator => users
- Everyone Group indicates (9) users but they are not displayed
- Previously groups DO display the users in the group
- When attempting to share a file or directory, the user list does not display even when you put in a valid user, therefore you cannot make a share
- You can create a new user and login as the user but once again you cannot display the new user in the Everyone list.
- *** The original server was running php ver 7.3 the new server is running php ver 7.4
Expected behaviour
Tell us what should happen
The admin should see the list of users should display so you may edit them
When sharing the users should be able to be “tagged” to share a file or directory
Actual behaviour
Tell us what happens instead
No user list is displayed and no users are displayed while attempting to share
Server configuration
Operating system:
Debian 10 - VPS
Web server:
Apache
Database:
MariaSQL
PHP version:
7.4
ownCloud version: (see ownCloud admin page)
10.9.1
Updated from an older ownCloud or fresh install:
Migrated from local hosting to VPS - Both Debian 10
Where did you install ownCloud from:
owncloud community website
Signing status (ownCloud 9.0 and above):
Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
No errors have been found.
paste the results into https://gist.github.com/ and puth the link here.
The content of config/config.php:
Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.
or
If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder
{
"system": {
"instanceid": "ocl06yd2d13j",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"localhost",
"********.us",
"www.******.us",
"1***.***.***.***"
],
"datadirectory": "\/var\/www\/html\/owncloud\/data",
"overwrite.cli.url": "http:\/\/***.***.***.***\/owncloud",
"dbtype": "mysql",
"version": "10.9.1.2",
"dbname": "owncloud",
"dbhost": "localhost",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"allow_user_to_change_mail_address": "",
"logtimezone": "UTC",
"apps_paths": [
{
"path": "\/var\/www\/html\/owncloud\/apps",
"url": "\/apps",
"writable": false
},
{
"path": "\/var\/www\/html\/owncloud\/apps-external",
"url": "\/apps-external",
"writable": true
}
],
"installed": true,
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_smtpmode": "smtp",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "25",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***"
}
}
*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.
List of activated apps:
If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.
Enabled:
- calendar:
- Version: 1.6.4
- Path: /var/www/html/owncloud/apps-external/calendar
- dav:
- Version: 0.7.0
- Path: /var/www/html/owncloud/apps/dav
- federatedfilesharing:
- Version: 0.5.0
- Path: /var/www/html/owncloud/apps/federatedfilesharing
- files:
- Version: 1.5.2
- Path: /var/www/html/owncloud/apps/files
- files_external:
- Version: 0.8.0
- Path: /var/www/html/owncloud/apps/files_external
- files_mediaviewer:
- Version: 1.0.5
- Path: /var/www/html/owncloud/apps/files_mediaviewer
- files_sharing:
- Version: 0.14.0
- Path: /var/www/html/owncloud/apps/files_sharing
- files_texteditor:
- Version: 2.4.1
- Path: /var/www/html/owncloud/apps-external/files_texteditor
- files_trashbin:
- Version: 0.9.1
- Path: /var/www/html/owncloud/apps/files_trashbin
- market:
- Version: 0.6.3
- Path: /var/www/html/owncloud/apps-external/market
- updatenotification:
- Version: 0.2.1
- Path: /var/www/html/owncloud/apps/updatenotification
Disabled:
- comments:
- Path: /var/www/html/owncloud/apps/comments
- configreport:
- Path: /var/www/html/owncloud/apps/configreport
- encryption:
- Path: /var/www/html/owncloud/apps/encryption
- external:
- Path: /var/www/html/owncloud/apps/external
- federation:
- Path: /var/www/html/owncloud/apps/federation
- files_versions:
- Path: /var/www/html/owncloud/apps/files_versions
- firstrunwizard:
- Path: /var/www/html/owncloud/apps/firstrunwizard
- notifications:
- Path: /var/www/html/owncloud/apps/notifications
- provisioning_api:
- Path: /var/www/html/owncloud/apps/provisioning_api
- systemtags:
- Path: /var/www/html/owncloud/apps/systemtags
- user_external:
- Path: /var/www/html/owncloud/apps/user_external
Are you using external storage, if yes which one: local/smb/sftp/…
NO Not at this time
Are you using encryption: yes/no
NO
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
NO
LDAP configuration (delete this part if not used)
N/A
With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder
There are no commands defined in the "ldap" namespace.
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.
Client configuration
Browser:
Firefox
Chrome
Operating system:
Windows 10
Logs
Web server error log
Insert your webserver log here
ownCloud log (data/owncloud.log)
owncloud.log excerpt
{“reqId”:“YqAB99qzEyqUSC@A0IPiygAAAAk”,“level”:3,“time”:“2022-06-08T01:57:11+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Exception: {“Exception”:“Doctrine\\DBAL\\Exception\\DriverException”,“Message”:“An exception occurred while executing ‘SELECT DISTINCT a.id AS id, user_id, lower_user_id, display_name, email, last_login, backend, state, quota, home FROM oc_accounts a LEFT JOIN oc_account_terms t ON a.id = t.account_id WHERE (lower_user_id LIKE ?) OR (display_name COLLATE utf8mb4_general_ci LIKE ?) OR (email COLLATE utf8mb4_general_ci LIKE ?) OR (t.term LIKE ?) ORDER BY display_name ASC LIMIT 200’ with params [\”%%\”, \"%%\", \"%%\", \"%%\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’",“Code”:0,“Trace”:"#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(159): Doctrine\\DBAL\\DBALException::wrapException()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(2225): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery()\n#3 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(185): Doctrine\\DBAL\\Connection->handleExceptionDuringQuery()\n#4 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#5 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#6 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#8 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#12 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#13 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#14 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#15 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#16 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:128}"}
{“reqId”:“YqAB99qzEyqUSC@A0IPiygAAAAk”,“level”:3,“time”:“2022-06-08T01:57:11+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Caused by: {“Exception”:“Doctrine\\DBAL\\Driver\\PDO\\Exception”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(119): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#6 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#8 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#12 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#13 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDO\/Exception.php",“Line”:18}"}
{“reqId”:“YqAB99qzEyqUSC@A0IPiygAAAAk”,“level”:3,“time”:“2022-06-08T01:57:11+00:00”,“remoteAddr”:“108.58.17.122”,“user”:“jon.a”,“app”:“index”,“method”:“GET”,“url”:"/owncloud/index.php/settings/users/users?offset=0&limit=200&gid=_everyone&pattern=",“message”:“Caused by: {“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(117): PDOStatement->execute()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(242): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/public\/AppFramework\/Db\/Mapper.php(346): OCP\\AppFramework\\Db\\Mapper->execute()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/User\/AccountMapper.php(176): OCP\\AppFramework\\Db\\Mapper->findEntities()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/User\/Manager.php(307): OC\\User\\AccountMapper->find()\n#6 \/var\/www\/html\/owncloud\/settings\/Controller\/UsersController.php(304): OC\\User\\Manager->find()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(170): OC\\Settings\\Controller\\UsersController->index()\n#8 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(89): OC\\AppFramework\\Http\\Dispatcher->executeController()\n#9 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch()\n#10 \/var\/www\/html\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Route\/Router.php(344): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke()\n#12 \/var\/www\/html\/owncloud\/lib\/base.php(927): OC\\Route\\Router->match()\n#13 \/var\/www\/html\/owncloud\/index.php(54): OC::handleRequest()\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",“Line”:117}"}
Insert your ownCloud log here
Browser log
Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...
. What do you think? I will need to figure out how to replace the database which will be a task in itself. What do you think? capnjb
