Huge database table due to login attempts/reconnects from Thunderbird client CalDAV
Tha14 opened this issue · 1 comments
Tha14 commented
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.
ChristophWurst commented
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.
I also recommend connecting Thunderbird with an app password, not the login password.