From 9a1bd46a568094ff62cfc85bc488b116042718b8 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Fri, 29 Aug 2014 10:54:36 +0200 Subject: Throttle failed login attempts (10/day) --- util/sql/schema.sql | 6 ++++++ util/updates/update_2.23.sql | 6 ++++++ 2 files changed, 12 insertions(+) (limited to 'util') diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 8cc4956e..b8bc7de7 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -86,6 +86,12 @@ CREATE TABLE chars_vns ( role char_role NOT NULL DEFAULT 'main' ); +-- login_throttle +CREATE TABLE login_throttle ( + ip inet NOT NULL PRIMARY KEY, + timeout bigint NOT NULL +); + -- notifications CREATE TABLE notifications ( id serial PRIMARY KEY NOT NULL, diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql index 9327e074..1de44e14 100644 --- a/util/updates/update_2.23.sql +++ b/util/updates/update_2.23.sql @@ -73,3 +73,9 @@ UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 8 AND NO -- New language: Romanian ALTER TYPE language ADD VALUE 'ro' AFTER 'pt-br'; + +-- Login attempt throttling +CREATE TABLE login_throttle ( + ip inet NOT NULL PRIMARY KEY, + timeout bigint NOT NULL +); -- cgit v1.2.3