-
-
Notifications
You must be signed in to change notification settings - Fork 385
Database
IPBan saves ip addresses to a local sqlite database in ipban.sqlite. The database is structured as follows:
Table IPAddresses (IPAddress VARBINARY(16) NOT NULL, IPAddressText VARCHAR(64) NOT NULL, LastFailedLogin BIGINT NOT NULL, FailedLoginCount BIGINT NOT NULL, BanDate BIGINT, State INT NOT NULL)
IPAddress is the raw ip address bytes.
IPAddressText is the ip address string.
LastFailedLogin is the last failed login for the ip address, as a Unix UTC millisecond timestamp.
FailedLoginCount is the number of failed logins.
BanDate is the last ban date for the ip address, as a Unix UTC millisecond timestamp. Will be NULL if not yet banned.
State of 0 = banned, 1 = pending ban, 2 = pending unban, 3 = failed login only, no ban or unban pending.
You can query or use this database as you see fit for internal reporting tools, etc.
IPBan (c) 2012-Present Digital Ruby, LLC - https://ipban.com