Geo update fails once per day

doteater

Once per day I suddenly can't access services where access is controller by GeoIP pfblocker alias. If I manually push an update in pfblocker it fixes it. I think I found a log that might hint at what's going on:


 CRON  PROCESS  START [ 02/06/17 18:00:00 ]
 UPDATE PROCESS START

Clearing all DNSBL Feeds...
** DNSBL Disabled **

===[  Continent Process  ]============================================

[ pfB_Asia_v4 ]          exists.
[ pfB_Asia_v6 ]          exists.
[ pfB_Europe_v4 ]        exists. [ 02/06/17 18:00:01 ]
Could not open ISO [ ES_v6 ]

Could not open ISO [ GB_v6 ]

[ pfB_Europe_v6 ]        Changes found... Updating
[ pfB_Europe_v6 ] Found no unique IPs, adding '1.1.1.1' to avoid empty file

Could not open ISO [ CA_v4 ]

Could not open ISO [ MX_v4 ]

Could not open ISO [ US_v4 ]

[ pfB_NAmerica_v4 ]      Changes found... Updating
[ pfB_NAmerica_v4 ] Found no unique IPs, adding '1.1.1.1' to avoid empty file

Could not open ISO [ CA_v6 ]

Could not open ISO [ MX_v6 ]

Could not open ISO [ US_v6 ]
[ pfB_NAmerica_v6 ]      Changes found... Updating
[ pfB_NAmerica_v6 ] Found no unique IPs, adding '1.1.1.1' to avoid empty file

Could not open ISO [ AU_v4 ]

Could not open ISO [ NZ_v4 ]

[ pfB_Oceania_v4 ]       Changes found... Updating
[ pfB_Oceania_v4 ] Found no unique IPs, adding '1.1.1.1' to avoid empty file

Could not open ISO [ AU_v6 ]

Could not open ISO [ NZ_v6 ]

[ pfB_Oceania_v6 ]       Changes found... Updating
[ pfB_Oceania_v6 ] Found no unique IPs, adding '1.1.1.1' to avoid empty file

Anyone know what's happening? Seems like this same issue happens every day at 18:00…every other hourly update works fine. Please let me know if I can provide any more info!

BBcan177

Run the following command to download the MaxMind database and follow that with a Force Reload:

/usr/local/www/pfblockerng/pfblockerng.php dc

doteater

Thanks! Looks like that ran successfully.

Normally that should happen on the first Tuesday, right?:

0       19      1,2,3,4,5,6,7   *       2       root    /usr/local/bin/php /usr/local/www/pfblockerng/pfblockerng.php dc >> /var/log/pfblockerng/geoip.log 2>&1
0       18      1,2,3,4,5,6,7   *       2       root    /usr/local/bin/php /usr/local/www/pfblockerng/pfblockerng.php dc >> /var/log/pfblockerng/extras.log 2>&1

Do I have to have it run more often to prevent this issue from cropping up again in the future?

BBcan177

For some reason you have two Cron entries to update MaxMind…

What version of pfBlockerNG are your using? Delete one of those cron entries.... Its probably what caused this issue....

doteater

Upgraded from 2.2, maybe I ended up with both. I'll try removing one.