User doesn't exist, can't verify user data

Hello,
NC 12.0.5, the log is full of errors like :
{“reqId”:“WnBvLN9z3sODR6ZpxgHC7wAAAAY”,“level”:3,“time”:“2018-01-30T14:12:12+01:00”,“remoteAddr”:“172.16.4.11”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/cron.php",“message”:“6699347d-be2c11da-80fec46c-dd0624c0 doesn’t exist, can’t verify user data.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; rv:57.0) Gecko/20100101 Firefox/57.0”,“version”:“12.0.5.3”}

{“reqId”:“WnBvSd9z3sODR6ZpxgHC8wAAAAY”,“level”:3,“time”:“2018-01-30T14:12:41+01:00”,“remoteAddr”:“172.16.4.11”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/cron.php",“message”:“6699347f-be2c11da-80fec46c-dd0624c0 doesn’t exist, can’t verify user data.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; rv:57.0) Gecko/20100101 Firefox/57.0”,“version”:“12.0.5.3”}

{“reqId”:“WnB0KcUg9Lif@KvypBcE@wAAAAI”,“level”:3,“time”:“2018-01-30T14:33:30+01:00”,“remoteAddr”:“172.16.4.9”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/cron.php",“message”:“66992cb2-be2c11da-80fec46c-dd0624c0 doesn’t exist, can’t verify user data.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0”,“version”:“12.0.5.3”}

{“reqId”:“WnB3O2CtgplIG6ODbDkRdwAAAAA”,“level”:3,“time”:“2018-01-30T14:46:35+01:00”,“remoteAddr”:“172.16.4.11”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/cron.php",“message”:“66993480-be2c11da-80fec46c-dd0624c0 doesn’t exist, can’t verify user data.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; rv:57.0) Gecko/20100101 Firefox/57.0”,“version”:“12.0.5.3”}

{“reqId”:“WnB3THr1twcfib8usJ3IowAAAAo”,“level”:3,“time”:“2018-01-30T14:46:52+01:00”,“remoteAddr”:“172.16.4.11”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/cron.php",“message”:“66993481-be2c11da-80fec46c-dd0624c0 doesn’t exist, can’t verify user data.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; rv:57.0) Gecko/20100101 Firefox/57.0”,“version”:“12.0.5.3”}

{“reqId”:“WnF5l2CtgplIG6ODbDkTjgAAAAA”,“level”:3,“time”:“2018-01-31T09:08:55+01:00”,“remoteAddr”:“172.16.4.9”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/cron.php",“message”:“66993482-be2c11da-80fec46c-dd0624c0 doesn’t exist, can’t verify user data.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0”,“version”:“12.0.5.3”}

How can clean the database or do something else for users in error.
I’ve already done:
sudo -u apache php occ files:cleanup
sudo -u apache php occ files:scan --all
sudo -u apache php occ files:cleanup

But it’s the same

Can i drop in the “oc_filecache” or “oc_jobs” where i found informations about these users ?

Please help, regards

Hi,

Can you show us your cron-jobs you defined for Nextcloud?
crontab -l -u apache

Can you give us a list of all enabled apps?
sudo -u apache php occ app:list

Hello,
Tnx a lot for help.

The cron:
*/30 * * * * apache php -f /var/www/html/cirrusplan/cron.php >> /var/log/nextcloud_cron.log 2>&1

Apps:
Enabled:

  • activity: 2.6.1
  • admin_audit: 1.3.0
  • bruteforcesettings: 1.0.3
  • calendar: 1.6.0
  • dav: 1.4.6
  • federatedfilesharing: 1.3.1
  • federation: 1.3.0
  • files: 1.8.0
  • files_antivirus: 1.1.0
  • files_external: 1.4.1
  • files_pdfviewer: 1.2.0
  • files_sharing: 1.5.0
  • files_texteditor: 2.5.1
  • files_trashbin: 1.3.0
  • files_versions: 1.6.0
  • firstrunwizard: 2.2.1
  • groupfolders: 1.2.0
  • impersonate: 1.0.2
  • logreader: 2.0.0
  • lookup_server_connector: 1.1.0
  • nextcloud_announcements: 1.2.0
  • notifications: 2.1.2
  • oauth2: 1.1.0
  • password_policy: 1.3.0
  • provisioning_api: 1.3.0
  • serverinfo: 1.3.0
  • sharebymail: 1.3.0
  • spreed: 3.1.0
  • survey_client: 1.1.0
  • theming: 1.4.1
  • twofactor_backupcodes: 1.2.3
  • updatenotification: 1.3.0
  • user_ldap: 1.3.1
  • workflowengine: 1.3.0
    Disabled:
  • comments
  • encryption
  • external
  • files_accesscontrol
  • files_videoplayer
  • gallery
  • quota_warning
  • systemtags
  • tasks
  • user_external

Regards

For each cron-job nextcloud.log is full of these errors about a lot of users.
However, users exist they are find from ldap.
Does an action in the admin user interface like “Clear Username-LDAP User Mapping” can be the reason of this issue ?

Please help, regards

Hi,

My first guess was, that you probably run a cron job for an app which is no longer installed (because of “no app in context”), but that is obviously not the case.
Absolutely possible that ldap user mapping might be the reason here. Unfortunately I don’t use ldap and can’t compare with my system.
Maybe a look into the database helps to find out where the problem is really coming from. I haven’t seen any DB entries with values like “66993482-be2c11da-80fec46c-dd0624c0” (taken from your log).
Would you like to check if the column “UID” in the oc_users table contains such values for your users?
select uid from oc_users;

Possible that such values are written into another table. With MySQL/ MariaDB you could search for ldap tables with:
show tables like '%ldap%';
and execute a query against that table then. (select * from <LDAP-TABLE>;).
When we find similar values in one of these tables we know in which app/ feature we can search for the root cause and also we know which developer we need to contact to help us.

Hi,
The oc_users table contains only one user. This is the admin user on my nextcloud.

I think i have a begenning of explanation, but i don’t know how to correct.
At the first time, if i remember I leaved ldap parameter Internal Username Attribute as default and i probably put UUID Attribute for Usersat cn.
I had a doubt about the possibility of homonyms for the data folders and i used Clear Username-LDAP User Mapping.
Then i changed Internal Username Attribute and UUID Attribute for Users to uid.
I think this operation broke some links and that prevented the database from being updated.
I think database must be cleaned from the previous ldap configuration.

Please thank’s a lot for your help,
Regards

I

1 Like

Hi,
To complete, here is an example of what I find in the table oc_jobs for one of the users in error.
I anonymized some attributes

id class argument last_run last_checked reserved_at execution_duration
41074 OC\Settings\BackgroundJobs\VerifyUserData {“verificationCode”:"",“data”:“MY_USER_EMAIL@MY_DOMAIN.fr”,“type”:“email”,“uid”:“MY_USER_LDAP_UID”,“try”:0,“lastRun”:1517311450} 0 1517311450 0 0
41075 OCA\LookupServerConnector\BackgroundJobs\RetryJob {“dataArray”:{“message”:{“data”:{“federationId”:“MY_USER_LDAP_UID@cirrusplan.MY_DOMAIN.fr”},“type”:“lookupserver”,“signer”:“MY_USER_LDAP_UID@cirrusplan.MY_DOMAIN.fr”,“timestamp”:1517311450},“signature”:“vFWqRGZOzGeRudzUN+l25D7tF3UH9yP6PfvMC61Bba4wH2PUEpnRNSu6QcCfTLOhIzP66SACAG1WC5PPL7Ehxm03rJxus00dTvZVY+\/GG6rOmO7Y2KuLpPZJvy0FTxepRcNAui\/mIJk3iaXE0HMMpyhbboDLplwbnLUrTbZROKmRb1Igz962IjCKmgH8vltIpnWiQ1zmfgiF9CKc9lMtyjlKW49+fzwYODNK2t4gO50R3Kk4PAqnA75qUxLPP\/PBFKDWrFBGizA1R6sCk5JwbaP5idB\/7JceO+ALuspVNmOILkiYp+Hz4jqCpKggzVaoy3bzjCiwrDPEDMr0ccoOzA==”},“retryNo”:0} 0 1517311450 0 0
61798 OCA\LookupServerConnector\BackgroundJobs\RetryJob {“dataArray”:{“message”:{“data”:{“federationId”:“MY_USER_LDAP_CN@cirrusplan.MY_DOMAIN.fr”},“type”:“lookupserver”,“signer”:“MY_USER_LDAP_CN@cirrusplan.MY_DOMAIN.fr”,“timestamp”:1510145718},“signature”:“NfAXGdQo6ANaYcQtlXEFYSEAAPvJTMbtMQxnLuJmyN2zvDbsJP+vR2J+p7DzfDvBSXSpL+DlAPPDteawP6nugX6E1\/V2GdlCSFN0LNuGuKPcuAbCICKlsua8eIAyeasZlrrUTX6L1C7hcsu1dDbv5Gcnqu+NXS4+pYD3we8YJMMBbJr5TnYYrHNZANSsvirgVhlxqGWLYA1y2rqw5hjZC\/hBM8X6X3yObxrtSKRLBNELeCHEBcRZhdoI7aAoATzduuf0ktEGEg3JaleE+smL8kKkoTOUHKgj2h2HQPSWP6bKzEyP4JMvt3\/KVuCdL\/usszpY4+itL5n1VSWit\/noYw==”},“retryNo”:1,“lastRun”:1519374555} 0 1519374555 0 0

For this case, the error log seems to be on the third line (id 61798), which could refer to the first ldap config.
Do you think that removing this entry in the table oc_jobs would correct the error for this user.

Thank’s