Skip to content

Temporary fix lot of entries in nextclouds user "Devices & sessions"

Posted by artodeto on

Hello there,

when logged into my nextcloud server as user, I clicked to User Bubble -> Settings -> Security and found a long list of entries below Devices & sessions.

After searching the issue list, I found this issue ticket.

The issue is know but either it is a kind of special issue ore no one really cares about it.

There is currently no real solution but I want to offer a temporary one.

You can create a cronjob that executes the following sql statement once per week or day.

```sql
--- 
--- You have to replace <user_name> with your user name
--- 

DELETE FROM 
  `oc_authtoken` 
WHERE 
  `uid` = <user> 
  AND `last_activity` < UNIX_TIMESTAMP(DATE_SUB(CURRENT_DATE(), INTERVAL 16 DAY));

OPTIMIZE TABLE `oc_authtoken`;
```

From my point of view, it looks like Firefox is doing something strange. Maybe other browsers behave the same.

Best regards, artodeto