nextcloud/suspicious_login

Huge database table due to login attempts/reconnects from Thunderbird client CalDAV

Tha14 opened this issue · 1 comments

I've got a few alerts of my nextcloud server's database becoming extremely large all of a sudden a few days ago. I am currently using nextcloud 27.1.7 and Suspicious Login 5.0.0. If I shut down thunderbird the entries in the table oc_login_address stop increasing(this is a bug with the thunderbird version I am using as far as I understand). I believe that there should be a value a value set to not allow the database to hold more than a specific amount of entries.

image

oc_login_address is for temporary storage. the data is compressed and transformed into oc_login_ips_aggregated in a background job. Make sure it runs reliably.

https://docs.nextcloud.com/server/stable/admin_manual/configuration_server/background_jobs_configuration.html

I also recommend connecting Thunderbird with an app password, not the login password.