db perf issue with auth errors

Open ThomasWaldmann opened this issue 6 years ago • 2 comments

some bad dyndns clients just retry again and again in case of e.g. authentication errors.

as we count auth errors in the Host record, this writes to the DB all the time ...

workaround: kill the Host record for such abusers, so there is no record to count something in.

fix: don't count.

Apr 09 '19 08:04 ThomasWaldmann

there is also an issue with the recorded api_auth_result_msg - due to the timestamp in there, this is always a new message that also needs a db write.

Apr 09 '19 10:04 ThomasWaldmann

also added BAD_HOSTS set in configuration, to block abusive hosts early, before they access the database.

Apr 15 '19 21:04 ThomasWaldmann