Skip to content

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

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

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

The author does not allow comments to this entry

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

Markdown format allowed
Form options