OAuth via Social Login does not update "last login date"

đŸ± Features & apps
1

Bug description

When a user logs in to Nextcloud via OAuth (the feature is provided by the Social Login app) (in my case using Mailcow as OAuth Provider), this does not seem to update the “last login date”. This Date is set to the creation date (when logged in first).
If I as admin user log in regularly to NC, the date gets updated. Somehow there is one Mailcow user which seems to get its last login date updated when he logs in to NC using Mailcow, but maybe this was to some other reason. To check the users actually did log in I logged in to NC via Mailcow and yes, the last login date got not updated.

I checked the last login date using the Nextcloud Interface as Admin > Users > View Last Login Date, using occ user:lastseen and even occ usage-report:generate --last-login-date (with the respective app installed.

I installed Nextcloud a week ago using the docker AIO solution, everything is up to date, the Social Login App update did not solve the problem.

Steps to reproduce

  1. Activate the Social Login App.
  2. Set up an OAuth Provider (Mailcow) for the Social Login.
  3. Log in to Nextcloud using the OAuth Provider without having an account with that mail adress before and thereby create a new account. (last login date gets set to this moment)
  4. Log out.
  5. Log in later again.
  6. Check last login date of the OAuth authentificated user. (Will still show just creation date)

Expected behavior

Last Login Date also works for OAuth Lpgins using the Social Login App and will show time and date of the second login.

System Information 
Installation method:      Docker AIO
Operating system:         Debian 11 Buster
PHP engine version:       PHP 7.4
Web server:               Nginx
Database engine version:  PostgreSQL
Config

{
“system”: {
“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”: “REMOVED SENSITIVE VALUE*”,
“overwriteprotocol”: “https”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“localhost”,
“REMOVED SENSITIVE VALUE*”
],
“datadirectory”: “REMOVED SENSITIVE VALUE”,
“dbtype”: “pgsql”,
“version”: “25.0.2.3”,
“overwrite.cli.url”: “REMOVED SENSITIVE VALUE*”,
“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”,
“loglevel”: “2”,
“log_type”: “file”,
“logfile”: “/var/www/html/data/nextcloud.log”,
“log_rotate_size”: “10485760”,
“log.condition”: {
“apps”: [
“admin_audit”
]
},
“preview_max_x”: “2048”,
“preview_max_y”: “2048”,
“jpeg_quality”: “60”,
“enabledPreviewProviders”: {
“1”: “OC\Preview\Image”,
“2”: “OC\Preview\MarkDown”,
“3”: “OC\Preview\MP3”,
“4”: “OC\Preview\TXT”,
“5”: “OC\Preview\OpenDocument”,
“6”: “OC\Preview\Movie”,
“0”: “OC\Preview\Imaginary”
},
“enable_previews”: true,
“upgrade.disable-web”: true,
“mail_smtpmode”: “smtp”,
“trashbin_retention_obligation”: “auto, 30”,
“versions_retention_obligation”: “auto, 30”,
“activity_expire_days”: “30”,
“simpleSignUpLink.shown”: false,
“share_folder”: “/Shared”,
“tempdirectory”: “/mnt/ncdata/tmp/”,
“one-click-instance”: true,
“one-click-instance.user-limit”: 100,
“one-click-instance.link”: “https://nextcloud.com/all-in-one/”,
“htaccess.RewriteBase”: “/”,
“files_external_allow_create_new_local”: true,
“trusted_proxies”: “REMOVED SENSITIVE VALUE”,
“allow_local_remote_servers”: true,
“preview_imaginary_url”: “http://nextcloud-aio-imaginary:9000”,
“mail_smtpauthtype”: “LOGIN”,
“mail_sendmailmode”: “smtp”,
“mail_smtpauth”: 1,
“mail_smtpsecure”: “tls”,
“mail_from_address”: “REMOVED SENSITIVE VALUE”,
“mail_domain”: “REMOVED SENSITIVE VALUE”,
“mail_smtphost”: “REMOVED SENSITIVE VALUE”,
“mail_smtpport”: “587”,
}
}

Apps

Enabled:

  • activity: 2.17.0
  • admin_audit: 1.15.0
  • announcementcenter: 6.4.0
  • auto_groups: 1.5.0
  • bruteforcesettings: 2.5.0
  • calendar: 4.2.1
  • cfg_share_links: 3.0.2
  • circles: 25.0.0
  • cloud_federation_api: 1.8.0
  • co2clock: 0.1.3
  • comments: 1.15.0
  • contacts: 5.0.2
  • contactsinteraction: 1.6.0
  • dashboard: 7.5.0
  • data_request: 1.12.0
  • dav: 1.24.0
  • deck: 1.8.3
  • external: 5.0.0
  • externalpassword: 1.1.0
  • federatedfilesharing: 1.15.0
  • federation: 1.15.0
  • files: 1.20.1
  • files_antivirus: 4.0.2
  • files_fulltextsearch: 25.0.0
  • files_mindmap: 0.0.27
  • files_pdfviewer: 2.6.0
  • files_rightclick: 1.4.0
  • files_sharing: 1.17.0
  • files_trashbin: 1.15.0
  • files_versions: 1.18.0
  • firstrunwizard: 2.14.0
  • forms: 3.0.3
  • fulltextsearch: 25.0.0
  • fulltextsearch_elasticsearch: 25.0.0
  • groupfolders: 13.1.0
  • guests: 2.3.0
  • holiday_calendars: 0.2.1
  • login_notes: 1.1.0
  • logreader: 2.10.0
  • lookup_server_connector: 1.13.0
  • maps: 0.2.4
  • metadata: 0.17.0
  • nextcloud-aio: 0.3.0
  • nextcloud_announcements: 1.14.0
  • notifications: 2.13.1
  • notify_push: 0.5.0
  • oauth2: 1.13.0
  • password_policy: 1.15.0
  • photos: 2.0.1
  • polls: 4.0.0
  • privacy: 1.9.0
  • provisioning_api: 1.15.0
  • quota_warning: 1.15.0
  • recommendations: 1.4.0
  • related_resources: 1.0.3
  • richdocuments: 7.0.2
  • serverinfo: 1.15.0
  • settings: 1.7.0
  • sharebymail: 1.15.0
  • sociallogin: 5.1.5
  • spreed: 15.0.2
  • support: 1.8.0
  • survey_client: 1.13.0
  • suspicious_login: 4.3.0
  • systemtags: 1.15.0
  • tasks: 0.14.5
  • text: 3.6.0
  • theming: 2.0.1
  • twofactor_backupcodes: 1.14.0
  • user_status: 1.5.0
  • user_usage_report: 1.9.0
  • viewer: 1.9.0
  • weather_status: 1.5.0
  • workflowengine: 2.7.0

Any ideas how to fix this?
If there is any way I need to be able knowing last login time
Greetings, h05

2

Hi @h05 - This would be an issue to bring up with the sociallogin app developer:

3

Oh, yes I did, I’m sorry I didn’t tell this here.
The developer fixed it seven months ago.

4

If you want to see as much activity information as possible, install → nc-who ←

It monitors activities live and “last login” for all users ordered by last seen date.

If you want to see more table values, just tell me, I will do my best to implement them.

I don’t know, if the script works on AIO, it is not tested.

Hope that helps,
much luck!