PfBlocker
-
Any news on where to find updated lists??
check out this thread https://forum.pfsense.org/index.php?topic=78062.msg426417#msg426417 its a great script but if you prefer to use pfBlocker, you can grab some of the list from it.. Just make sure the list is compilable with pfBlocker
-
I have been using pfblocker for over a year now. I consider pfBlocker and Snort combo an essential part of a firewall. PFBlocker successfully removes entire countries such as China
Hi Kevin,
The Country Database in pfBlocker hasn't been updated for over 2 years now. The data is obsolete. I know they are working on a new service (most likely for paid members) that will provide updates for the Country Lists.
I have written a script that does what pfBlocker does but with a lot of other missing features. You can see more details in the following link:
Its a long forum post, so you need to read all of its posts in their entirety.
https://forum.pfsense.org/index.php?topic=78062.msg426963#msg426963I also wrote a patch for the pfBlocker widget to show when the Alias was last updated and indication of any download failures.
I also write a patch for diag_dns.php which is the "Firewall Log" GUI Screen. This update has the ability to show which Blocklist (Irevelent of the Alias) caused the Block. So even if the Filter Logs clear, you can easily find the IP/Blocklist match. This can also be used from Snort, when you click on the "!" icon which will show you if any of the Snort Alerts are on any of your Blocklists. It will actually show you if any of the IPs are founded in the Alerted IPs Range.
I would recommend that you use "Aliases" as they give you more control than the method that you are currently using.
-
@Hollander:
I just made a URL Table Alias with http://doc.emergingthreats.net/pub/Main/RussianBusinessNetwork/RussianBusinessNetworkIPs.txt on a 2.1-RELEASE Alix nanoBSD. The table loads into pf with 9252 entries. Used it as source in a block rule on WAN and it works. So the list itself is not bad. And you can easily use it anyway without pfBlocker, just using the ordinary URL Table Alias and Firewall Rules features of pfSense.
I still have this list in my firewall rules. But to date it still has the 9252 IP's so I assume it has never been updated since last year. As I am working on the new thread of JFL (https://forum.pfsense.org/index.php?topic=78062.0), I was wondering, are all instructions in this thread obsolete (so I should also delete this large IP-list?)
Hi Hollander,
the ET RBN list has been discontinued. Along with the RBN malvertisers list.
Emerging Threats RBN rules.
THIS RULESET HAS BEEN OBSOLETED!! This file is left to simply note this fact.
More information available at doc.emergingthreats.net/bin/view/Main/RussianBusinessNetwork
Please submit any feedback or ideas to emerging@emergingthreats.net or the emerging-sigs mailing list
-
First of all, pfBlocker is a great package, cheers to the authors! However, it would be very useful (some users already highlighted this) to have more options for "Update frequency". Specifically I would like to see one very short and one longer frequency, like "Every 10 Minutes" and "Once a week". Could you add this?
And just out of curiosity, how is this updating handled, I don't see any crontab entry for pfBlocker?
-
Hi Hollander,
the ET RBN list has been discontinued. Along with the RBN malvertisers list.
Thank you Sir ;D
-
The Country Database in pfBlocker hasn't been updated for over 2 years now. The data is obsolete. I know they are working on a new service (most likely for paid members) that will provide updates for the Country Lists.
I have written a script that does what pfBlocker does but with a lot of other missing features. You can see more details in the following link:
I am prollally stupid once again, BB, but I can't seem to find how to do country blocking with your script. I know it is possible, but have I missed something? I want to block a great deal of countries I consider nothing good to come from ( 8) ;D ). If I overlooked something, could you please point me to the text I must have overlooked?
Thank you ;D
-
@Hollander:
BB, but I can't seem to find how to do country blocking with your script. I know it is possible, but have I missed something? I want to block a great deal of countries I consider nothing good to come from ( 8) ;D ). If I overlooked something, could you please point me to the text I must have overlooked?
Hello Hollander,
First step is to add "unzip" as its a dependency:
pkg_add -r unzip
(See this thread to get 8.3 Package Archive ENV path)
https://forum.pfsense.org/index.php?topic=78935.msg431084#msg431084Code from the Script:
441 # ================================================================ 442 443 # MaxMind GeoIP COUNTRY CODE Blocklist (** Installation STEPS **) 444 # 445 # - Package Dependency (UNZIP) as stated above. 446 # - Uncomment "#" the [ countrycode ] line below, save/exit. 447 # - Run this script from the shell [ ./pfiprep killdb ] 448 # which will create the [ countrycode ] config file. 449 # (Don't run the script when CRON is expected to run) 450 # - When the script exits "EDIT" the [ countrycode ] file and 451 # enter "#" infront of the Countries to Whitelist. 452 # - Re-Run the script [ ./pfiprep ] 453 # 454 # - To remove Country Blocking Completely, re-comment [ #countrycode ] 455 # and run from the shell [ ./pfiprep killdb ] or [ ./pfiprep killdb dskip ] 456 # ================================================================ 457 458 # Maxmind GeoIP Country Code - Blocklist Download 459 # 460 # This will only download on the first Tuesday of Each Month 461 # Any changes to the [ Countrycode ] text file will be done at that time. 462 # When the CSV Database is downloaded it will create a [ cccsv.lock ] file 463 # in the $userfolder path to avoid downloading multiple times. If you 464 # want to bypass, delete the [ cccsv.lock ] file. 465 466 header=CountryBlock 467 group=tier10 468 addr=https://geolite.maxmind.com/download/geoip/database/ 469 infile=GeoIPCountryCSV.zip 470 471 #countrycode 472 # ================================================================( I cleaned up the Text instructions in my Github Gist. So it may not match your existing Script. )
Steps:
- Remove "#" from line 471 ( countrycode ) , and save/exit the script.
- From the "Shell" run [ [b]./pfiprep killdb ]
- This should download the Maxmind Country Code .zip file and automatically extract the .csv country Code Database.
- It will create a file called "countrycode" which is a list of all the countries.
- On First Install, the script will exit and ask you to edit the "countrycode" file.
- Put a "#" infront of the countries to whitelist.
- Save/Exit "countrycode" file.
8.) Re-run the script [ [b]./pfiprep ]
Keep in mind about how the script functions:
-
Block the IPs from the Countries you have Selected (If you enabled Country Blocking Feature)
-
Each additional Blocklist that gets downloaded, the script will check for duplication against all previously downloaded Lists (Including the Country Blocklists) so that you don't add the same Blocked IPs or Ranges that are already on the Masterfile List.
-
Other functionality of the script is "IP Reputation" which looks to see how many Malicious IPs are found in a /24 Range. If the script finds over the "max" variable setting, it will block those particular ranges and remove the individual IPs from each Blocklist. The first Blocklist that contains the "Repeat Offending Range" will get the "x.x.x.0/24" block, while all of the other list have these repeat offenders are removed as the first list is blocking the whole range.
-
If you decide to remove a "Blocklist", it is recommended to refresh the database as you can see from above that all of the Blocklists are essentially tied together to remove duplication and process "IP Reputation".
Refreshing the database can be achieved in two ways:
[ [b]./pfiprep killdb ] This will delete the database and re-download all Blocklists.
or
[ [b]./pfiprep killdb dskip ] Which will kill the database and re-use the existing Download Blocklist Files.
The script will automatically download the Maxmind Country Code Database on the First Tuesday of Each Month. As each Blocklist gets downloaded, it will resync against the updated Country Blocklists as per the schedule settings for each Blocklist. I never considered to perform a [ [b]./pfiprep killdb dskip ] each month, but I think this might be something that I should add to the next version of the script.
At any time, you can edit the "countrycode" file and it will automatically re-configure the Country Blocking at the next scheduled CRON job. (But if you do make changes, I recommend resyncing the database.)
I also added a few additional Blocklists ( from the gist hit the "revision icon" to see the changes)
I hope this is clear. Let me know if you need any more help.
-
Maxmind seems to be a commercial company. Despite the fact their GeoIP files are publicly accessible, is it allowed to just take them? They appear to charge a fee for access to their lists.
-
@KOM:
Maxmind seems to be a commercial company. Despite the fact their GeoIP files are publicly accessible, is it allowed to just take them? They appear to charge a fee for access to their lists.
Yes this is the Free Version of the Maxmind Database that is Updated Once per month. It is 98% accurate for Countries as per their website.
http://dev.maxmind.com/geoip/legacy/geolite/
They have a paid version but you would only need that if you wanted City or other GeoIP data.
-
OK great. Thank you for that. I looked around but didn't see the distinction before I posted. I don't want to take what isn't mine to take, and I admit I'm a little late to this thread.
-
@Hollander:
BB, but I can't seem to find how to do country blocking with your script. I know it is possible, but have I missed something? I want to block a great deal of countries I consider nothing good to come from ( 8) ;D ). If I overlooked something, could you please point me to the text I must have overlooked?
Hello Hollander,
First step is to add "unzip" as its a dependency:
pkg_add -r unzip
(See this thread to get 8.3 Package Archive ENV path)
https://forum.pfsense.org/index.php?topic=78935.msg431084#msg431084Code from the Script:
441 # ================================================================ 442 443 # MaxMind GeoIP COUNTRY CODE Blocklist (** Installation STEPS **) 444 # 445 # - Package Dependency (UNZIP) as stated above. 446 # - Uncomment "#" the [ countrycode ] line below, save/exit. 447 # - Run this script from the shell [ ./pfiprep killdb ] 448 # which will create the [ countrycode ] config file. 449 # (Don't run the script when CRON is expected to run) 450 # - When the script exits "EDIT" the [ countrycode ] file and 451 # enter "#" infront of the Countries to Whitelist. 452 # - Re-Run the script [ ./pfiprep ] 453 # 454 # - To remove Country Blocking Completely, re-comment [ #countrycode ] 455 # and run from the shell [ ./pfiprep killdb ] or [ ./pfiprep killdb dskip ] 456 # ================================================================ 457 458 # Maxmind GeoIP Country Code - Blocklist Download 459 # 460 # This will only download on the first Tuesday of Each Month 461 # Any changes to the [ Countrycode ] text file will be done at that time. 462 # When the CSV Database is downloaded it will create a [ cccsv.lock ] file 463 # in the $userfolder path to avoid downloading multiple times. If you 464 # want to bypass, delete the [ cccsv.lock ] file. 465 466 header=CountryBlock 467 group=tier10 468 addr=https://geolite.maxmind.com/download/geoip/database/ 469 infile=GeoIPCountryCSV.zip 470 471 #countrycode 472 # ================================================================( I cleaned up the Text instructions in my Github Gist. So it may not match your existing Script. )
Steps:
- Remove "#" from line 471 ( countrycode ) , and save/exit the script.
- From the "Shell" run [ [b]./pfiprep killdb ]
- This should download the Maxmind Country Code .zip file and automatically extract the .csv country Code Database.
- It will create a file called "countrycode" which is a list of all the countries.
- On First Install, the script will exit and ask you to edit the "countrycode" file.
- Put a "#" infront of the countries to whitelist.
- Save/Exit "countrycode" file.
8.) Re-run the script [ [b]./pfiprep ]
Keep in mind about how the script functions:
-
Block the IPs from the Countries you have Selected (If you enabled Country Blocking Feature)
-
Each additional Blocklist that gets downloaded, the script will check for duplication against all previously downloaded Lists (Including the Country Blocklists) so that you don't add the same Blocked IPs or Ranges that are already on the Masterfile List.
-
Other functionality of the script is "IP Reputation" which looks to see how many Malicious IPs are found in a /24 Range. If the script finds over the "max" variable setting, it will block those particular ranges and remove the individual IPs from each Blocklist. The first Blocklist that contains the "Repeat Offending Range" will get the "x.x.x.0/24" block, while all of the other list have these repeat offenders are removed as the first list is blocking the whole range.
-
If you decide to remove a "Blocklist", it is recommended to refresh the database as you can see from above that all of the Blocklists are essentially tied together to remove duplication and process "IP Reputation".
Refreshing the database can be achieved in two ways:
[ [b]./pfiprep killdb ] This will delete the database and re-download all Blocklists.
or
[ [b]./pfiprep killdb dskip ] Which will kill the database and re-use the existing Download Blocklist Files.
The script will automatically download the Maxmind Country Code Database on the First Tuesday of Each Month. As each Blocklist gets downloaded, it will resync against the updated Country Blocklists as per the schedule settings for each Blocklist. I never considered to perform a [ [b]./pfiprep killdb dskip ] each month, but I think this might be something that I should add to the next version of the script.
At any time, you can edit the "countrycode" file and it will automatically re-configure the Country Blocking at the next scheduled CRON job. (But if you do make changes, I recommend resyncing the database.)
I also added a few additional Blocklists ( from the gist hit the "revision icon" to see the changes)
I hope this is clear. Let me know if you need any more help.
Thanks BB, you know you are one of my heros on this board, I just hit you with my karma stick again ;D
I will try it, and report back here.
_PS About me learning grep: yes, you are completely right. But: time :-[ Currently I am dividing time between my own job, WIFE complaining ( ;D ), and helping out the poor who are being quite abused by the system in this 'highly developed society we seem to be living in'. Which translates in barely educated, low salary workers, who don't understand all the mumbo-jumbo crap in official letters, being fined hundreds of euros because they underpaid taxes by 2 euros. It seems I can read at least some of these 'government officials' bullshit letters, and as I can't stand injustice, I'm the one writing the legal letters on behalf of my quite illerate co-citizens, which, unfortunately, takes a lot of time.[/i]
I'm now thinking if I am brave enough to execute:
true `yes no`;D
(This seems to be a dangerous command)._
-
I am running into a problem, BB :-\
- Remove "#" from line 471 ( countrycode ) , and save/exit the script.
- From the "Shell" run [ [b]./pfiprep killdb ]
- This should download the Maxmind Country Code .zip file and automatically extract the .csv country Code Database.
- It will create a file called "countrycode" which is a list of all the countries.
- On First Install, the script will exit and ask you to edit the "countrycode" file.
- Put a "#" infront of the countries to whitelist.
The file is created, but nothing is in it (zero bytes). The script issued this:
[2.1.4-RELEASE][root@112]/home/badips(9): ./pfiprep killdb **** UPDATE PROCESS START - Sat Jul 26 17:13:39 CEST 2014 **** Deleting pfIP Rep Databases. Databases have been Deleted! find: /home/badips/countrycodes: No such file or directory rm: /home/badips/cc_csv.lock: No such file or directory find: /home/badips/GeoIPCountryWhois.csv: No such file or directory rm: /home/badips/cc_csv.lock: No such file or directory looking up geolite.maxmind.com connecting to geolite.maxmind.com:443 SSL connection established using RC4-SHA Certificate subject: /serialNumber=dfgdighiofgiodfiogdiofgdjkfq4Js/C=US/O=*.maxmind.com/OU=GT53364002/OU=See www.rap112sl.com/resources/cps (c)11/OU=Domain Control Validated - Rap112SL(R)/CN=*.maxmind.com Certificate issuer: /C=US/O=GeoTrust, Inc./CN=Rap112SL CA requesting https://geolite.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip remote size / mtime: 1444832 / 1404267648 /home/badips/GeoIPCountryCSV.zip 100% of 1410 kB 164 kBps unzip: cannot find or open /home/badipsGeoIPCountryCSV.zip, /home/badipsGeoIPCountryCSV.zip.zip or /home/badipsGeoIPCountryCSV.zip.ZIP. cut: /home/badips/GeoIPCountryWhois.csv: No such file or directory Please edit [ /home/badips/countrycodes ] and comment # the countries to SAFELIST before proceeding with CC Blocking [2.1.4-RELEASE][root@112]/home/badips(10):(I scrambled that serial number there since I don't know if it should be pasted here).
What should I do?
Thank you ;D
-
Hi Hollander, Looks like I missed a "/",
In pfiprepman, Line 416
** $pathunzip -o $userfolder$infile**
change it to:
$pathunzip -o $userfolder/$infile
Sorry about that.
-
First of all, pfBlocker is a great package, cheers to the authors! However, it would be very useful (some users already highlighted this) to have more options for "Update frequency". Specifically I would like to see one very short and one longer frequency, like "Every 10 Minutes" and "Once a week". Could you add this?
And just out of curiosity, how is this updating handled, I don't see any crontab entry for pfBlocker?
Any comments on this?
Also, I would like to ask you if there is any way to manually update the list? Thanks!
-
First of all, pfBlocker is a great package, cheers to the authors! However, it would be very useful (some users already highlighted this) to have more options for "Update frequency". Specifically I would like to see one very short and one longer frequency, like "Every 10 Minutes" and "Once a week". Could you add this?
And just out of curiosity, how is this updating handled, I don't see any crontab entry for pfBlocker?
Any comments on this?
Also, I would like to ask you if there is any way to manually update the list? Thanks!
When you enable pfBlocker, it creates a cron entry
0 * * * * root /usr/local/bin/php /usr/local/www/pfblocker.php cron
The way pfBlocker works is it looks to see if there is an existing file in the:
/usr/local/pkg/pfblocker (folder) for the Blocklist. If its there, it will reload the existing file. If its not there, it will download the file from the URL you entered for the Blocklist. When the CRON job runs, if the list is scheduled to be updated, that file is deleted so that it will download a new file.
So the only way to do that is to manually delete the Blocklist file in that folder. Unfortunately, the file is named after the MD5 hash of the URL making it a little difficult to see which file belongs to which Blocklist.
You could try running this command from the shell to determine what the md5 Hash is and than seeing if a file exists with that hash.txt and delete it. Than you can click "Save" in pfBlocker which should re-download the new file.
md5 -s 'http://www.spamhaus.org/drop/drop.txt'
MD5 ("http://www.spamhaus.org/drop/drop.txt") = d2278c81b67d798693429e4feb04a83a
http://www.freebsd.org/cgi/man.cgi?query=md5&sektion=1
-
The Country Database in pfBlocker hasn't been updated for over 2 years now. The data is obsolete.
I've been recently looking at this and found we have 2 issues.
One is the out of date IP ranges, which you know about.
The other is a few ISO country codes probably need to be updated.I know they are working on a new service (most likely for paid members) that will provide updates for the Country Lists.
I guess it's been a couple of years since CountryIPBlocks went to pay-for-play.
Back then, marcelloc and I both reached out to the CIPB guy and tried to work out a compromise that would allow pfBlocker to keep updating from CIPB.
CIPB's compromise was that each pfBlocker user would pay CIPB for it's repackaged public data.
That didn't seem like much of a compromise so here we are.Anyhoo:
I've found a source of current country IP data yesterday and wrote a short Bash script to push it into pfBlocker.
It looks good but while cross-checking the data I found pfBlocker has a couple of outdated country (ISO 3166-1 alpha-2) codes.Also - I still want to find+vet a couple more data sources.
I'll post what I come up with and we'll see what everyone thinks.Thanks
-
I've found a source of current country IP data yesterday and wrote a short Bash script to push it into pfBlocker.
It looks good but while cross-checking the data I found pfBlocker has a couple of outdated country (ISO 3166-1 alpha-2) codes.Also - I still want to find+vet a couple more data sources.
I'll post what I come up with and we'll see what everyone thinks.Did you take a look at the Maxmind GeoIP Country List. ~98% accurate.
I have also release a script to utilize country Blocking:
https://forum.pfsense.org/index.php?topic=78062.15Would be interested to see what you have come up with.
Maybe you can PM me a copy? Would also be interested in helping getting it off the ground.
-
Did you take a look at the Maxmind GeoIP Country List. ~98% accurate.
That was the site that had a .CSV file of IPs in ranges, right?
I think I saw somewhere in the thread that pfBlocker will work with ranges - something I didn't know.However, I prefer working w/ CIDR (I'd explain why if anyone cares) and am looking at CIDR sources right now.
I'll give another look at Maxmind GeoIP if my 'Plan A' doesn't work out.
-
Did you take a look at the Maxmind GeoIP Country List. ~98% accurate.
That was the site that had a .CSV file of IPs in ranges, right?
I think I saw somewhere in the thread that pfBlocker will work with ranges - something I didn't know.However, I prefer working w/ CIDR (I'd explain why if anyone cares) and am looking at CIDR sources right now.
I'll give another look at Maxmind GeoIP if my 'Plan A' doesn't work out.
Here is a sample.
Its all in one file, and its not too hard to convert to CIDR and break it down in the XX Country Codes with some grep and awk commands.
"223.255.128.0","223.255.191.255","3758063616","3758079999","HK","Hong Kong"
"223.255.192.0","223.255.223.255","3758080000","3758088191","KR","Korea, Republic of"
"223.255.224.0","223.255.231.255","3758088192","3758090239","ID","Indonesia"
"223.255.232.0","223.255.235.255","3758090240","3758091263","AU","Australia"
"223.255.236.0","223.255.239.255","3758091264","3758092287","CN","China"
"223.255.240.0","223.255.243.255","3758092288","3758093311","HK","Hong Kong"
"223.255.244.0","223.255.247.255","3758093312","3758094335","IN","India"
"223.255.252.0","223.255.253.255","3758095360","3758095871","CN","China"
"223.255.254.0","223.255.254.255","3758095872","3758096127","SG","Singapore"
"223.255.255.0","223.255.255.255","3758096128","3758096383","AU","Australia" -
That was the site that had a .CSV file of IPs in ranges, right?
Here is a sample.
Its all in one file, and its not too hard to convert to CIDR and break it down in the XX Country Codes with some grep and awk commands.
"223.255.128.0","223.255.191.255","3758063616","3758079999","HK","Hong Kong"
"223.255.192.0","223.255.223.255","3758080000","3758088191","KR","Korea, Republic of"
"223.255.224.0","223.255.231.255","3758088192","3758090239","ID","Indonesia"
"223.255.232.0","223.255.235.255","3758090240","3758091263","AU","Australia"
"223.255.236.0","223.255.239.255","3758091264","3758092287","CN","China"Your data source seems more trustworthy than what I've found.
I'll PM you the script to d/l+extract the country IPs into .txt files as soon as I puzzle it out.
