palinkas-jo-reggelt
commented
2 years ago I stopped using this about a year ago after it became apparent that it was only useful for a tiny fraction of repeat offenders. It's just too cumbersome to maintain. The statistics were more useful than the actual banning. But you don't need to collect your own statistics because I can simply tell you: 60% of firewall banned IPs never ever returned to try again and only 1 or 2 percent returned more than a few times. My advice is to simply use autoban.
With respect to your GeoLite2SQL issue, it appears that your table structure is probably wrong - could be based on the old version? If you're using the latest version, it includes queries for dropping old tables and recreating them new. It should just work IF you're using the current code.
Are you getting any errors?
<# Drop and add database tables #>
Debug "----------------------------"
Debug "Drop and recreate database tables"
Try {
If ($Type -match "country") {
$GCQuery = "
DROP TABLE IF EXISTS geocountry;
CREATE TABLE geocountry (
network_start VARBINARY(16) NOT NULL,
network_end VARBINARY(16) NOT NULL,
geoname_id INT NOT NULL,
registered_country_geoname_id INT,
represented_country_geoname_id INT,
is_anonymous_proxy TINYINT,
is_satellite_provider TINYINT,
KEY geoname_id (geoname_id),
KEY network_start (network_start),
PRIMARY KEY network_end (network_end)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
"
} Else {
$GCQuery = "
DROP TABLE IF EXISTS geocity;
CREATE TABLE geocity (
network_start VARBINARY(16) NOT NULL,
network_end VARBINARY(16) NOT NULL,
geoname_id INT NOT NULL,
registered_country_geoname_id INT,
represented_country_geoname_id INT,
is_anonymous_proxy TINYINT,
is_satellite_provider TINYINT,
postal_code TINYINT,
latitude DECIMAL(7,4),
longitude DECIMAL(7,4),
accuracy_radius TINYINT,
KEY geoname_id (geoname_id),
KEY network_start (network_start),
PRIMARY KEY network_end (network_end)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
"
}
MySQLQuery $GCQuery
If ($Type -match "country") {
$GLQuery = "
DROP TABLE IF EXISTS countrylocations;
CREATE TABLE countrylocations (
geoname_id INT NOT NULL,
locale_code TINYTEXT,
continent_code TINYTEXT,
continent_name TINYTEXT,
country_code TINYTEXT,
country_name TINYTEXT,
is_in_european_union TINYINT,
KEY geoname_id (geoname_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
"
} Else {
$GLQuery = "
DROP TABLE IF EXISTS citylocations;
CREATE TABLE citylocations (
geoname_id INT NOT NULL,
locale_code TINYTEXT,
continent_code TINYTEXT,
continent_name TINYTEXT,
country_code TINYTEXT,
country_name TINYTEXT,
subdivision_1_iso_code TINYTEXT,
subdivision_1_name TINYTEXT,
subdivision_2_iso_code TINYTEXT,
subdivision_2_name TINYTEXT,
city_name TINYTEXT,
metro_code TINYINT,
time_zone TINYTEXT,
is_in_european_union TINYINT,
KEY geoname_id (geoname_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
"
}
MySQLQuery $GLQuery
Debug "Database tables successfully dropped and created"
Email "[OK] Database tables dropped & recreated"
}
Catch {
Debug "[ERROR] : Unable to drop/create database tables : $($Error[0])"
Debug "[ERROR] : Quitting Script"
Email "[ERROR] Failed to drop/create database tables. See error log."
EmailResults
Exit
}
EmEiBee
Hello again, I'm shure I've got again the old files... Downloadet yesterday at this place... Am I wrong?
1st: many include_once point to different files like "{filename}data.php" but they don't exist. But same files without the "...data" at the are present so I think that are just a "ohhh, forget to edit" thingy.
2nd: PHP Notice: Undefined variable: redTo in .\dialtodayhits.php on line 27
3rd: PHP Fatal error: Cannot redeclare ip_country() (previously declared in .\functions.php:204) in .\functions.php on line 204
_OT-BTW: GeoLite2SQL now runs GeoLite is now running except that the data in "network_start" and "networkend" are hieroglyphs