清理 user_auth_token_logs？

Osama · 2024 年9 月 16 日 20:15

是的，我认为我们可以清理大部分日志，但其中一些必须保留。具体来说，我认为任何操作包含 suspicious、generate 或 rotate 的记录都需要保留，因为它们用于检测和生成可疑登录的报告。

app/models/concerns/reports/suspicious_logins.rb

501f07ab1


      
              title: I18n.t("reports.suspicious_logins.labels.login_time"),
            },
          ]
          
          report.data = []
          
          sql = <<~SQL
            SELECT u.id user_id, u.username, u.uploaded_avatar_id, t.client_ip, t.user_agent, t.created_at login_time
            FROM user_auth_token_logs t
            JOIN users u ON u.id = t.user_id
            WHERE t.action = 'suspicious'
              AND t.created_at >= :start_date
              AND t.created_at <= :end_date
            ORDER BY t.created_at DESC
          SQL
          
          DB
            .query(sql, start_date: report.start_date, end_date: report.end_date)
            .each do |row|
              data = {}

github.com/discourse/discourse

app/models/user_auth_token.rb

501f07ab1


      
              Math.sin((lat2_rad - lat1_rad) / 2)**2 +
                Math.cos(lat1_rad) * Math.cos(lat2_rad) * Math.sin((lon2_rad - lon1_rad) / 2)**2
            c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a))
          
            c * EARTH_RADIUS_KM
          end
          
          def self.is_suspicious(user_id, user_ip)
            return false unless User.find_by(id: user_id)&.staff?
          
            ips = UserAuthTokenLog.where(user_id: user_id).pluck(:client_ip)
            ips.delete_at(ips.index(user_ip) || ips.length) # delete one occurrence (current)
            ips.uniq!
            return false if ips.empty? # first login is never suspicious
          
            if user_location = login_location(user_ip)
              ips.none? do |ip|
                if location = login_location(ip)
                  distance(user_location, location) < SiteSetting.max_suspicious_distance_km
                end
              end

话题		回复	浏览量
User anonymization and staff_action_logs Support	7	701	2021 年9 月 8 日
Logging checked_for_custom_avatar Bug	8	1086	2015 年1 月 2 日
How to remove admin logs Support	15	2480	2023 年11 月 15 日
Is there a limit to user_auth_token? Support	4	545	2021 年7 月 9 日
Reset all login tokens Feature	7	2160	2016 年5 月 20 日

清理 user_auth_token_logs？

相关话题