diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2017-01-25 08:22:54 +0100 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2017-01-25 18:42:34 +0100 |
| commit | f8916d7e9bda129a57143d769f7eb1f596614c80 (patch) | |
| tree | 1eda89a37f44d91397c3ee382ff1fd5bf3b8c2b1 /upgrading | |
| parent | b8df10e22732fd678a6d30e2bf4ac5eb14cf898e (diff) | |
| download | aur-f8916d7e9bda129a57143d769f7eb1f596614c80.tar.gz aur-f8916d7e9bda129a57143d769f7eb1f596614c80.tar.xz | |
git-serve: Save last SSH login date and IP address
In addition to logging the last login date and IP address on the web
interface, store the time stamp and IP address of the last SSH login in
the database.
This simplifies user banning if one of the new SSH interface features,
such as the voting mechanism implemented in 7ee2fdd (git-serve: Add
support for (un-)voting, 2017-01-23), is abused.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading')
| -rw-r--r-- | upgrading/4.5.0.txt | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/upgrading/4.5.0.txt b/upgrading/4.5.0.txt index 6c4ce807..5cf0888c 100644 --- a/upgrading/4.5.0.txt +++ b/upgrading/4.5.0.txt @@ -2,4 +2,12 @@ --- ALTER TABLE Users ADD COLUMN Timezone VARCHAR(32) NOT NULL DEFAULT 'UTC'; ----
\ No newline at end of file +--- + +2. Add LastSSHLogin and LastSSHLoginIPAddress columns to the Users table: + +--- +ALTER TABLE Users + ADD COLUMN LastSSHLogin BIGINT UNSIGNED NOT NULL DEFAULT 0, + ADD COLUMN LastSSHLoginIPAddress VARCHAR(45) NULL DEFAULT NULL; +--- |