From: Andy Allan Date: Wed, 7 Aug 2024 15:22:21 +0000 (+0100) Subject: Merge pull request #5019 from tomhughes/oauth2-cleanup X-Git-Tag: live~971 X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/70cb93a101638596ecae5782575ada2d4d08c8dd?hp=2a649d16df01bcc49ce99c282e9bfbe44063cd9d Merge pull request #5019 from tomhughes/oauth2-cleanup Add expiry for OAuth 2 grants and tokens --- diff --git a/script/cleanup b/script/cleanup index 7601d35cf..e829be176 100755 --- a/script/cleanup +++ b/script/cleanup @@ -6,4 +6,7 @@ OauthNonce.where("timestamp < EXTRACT(EPOCH FROM NOW() - INTERVAL '1 day')").del OauthToken.where("invalidated_at < NOW() - INTERVAL '28 days'").delete_all RequestToken.where("authorized_at IS NULL AND created_at < NOW() - INTERVAL '28 days'").delete_all +Doorkeeper::AccessGrant.where("revoked_at < NOW() - INTERVAL '28 days' OR (created_at + expires_in * INTERVAL '1 second') < NOW() - INTERVAL '28 days'").delete_all +Doorkeeper::AccessToken.where("revoked_at < NOW() - INTERVAL '28 days' OR (created_at + expires_in * INTERVAL '1 second') < NOW() - INTERVAL '28 days'").delete_all + exit 0