Text only | Text with Images

OPNsense Forum

Archive => 22.1 Legacy Series => Topic started by: cguilford on April 07, 2022, 01:29:11 PM

Title: Resolved - GeoIP Error - with Update_tables
Post by: cguilford on April 07, 2022, 01:29:11 PM
I'm running  OPNsense 22.1.2_1 and noticed my GeoIP hasn't updated since 3/29/2022 so it hasn't updated in over a week.   I created a new license and set it up to verify it's not an issue with the settings, and verified by using the URL that I added to config worked. Just wanted to verify if it was just me or if maybe GeoIP hasn't made any updates as of late?  I also noticed the following in my log files but seems that has been going on for some time.

2022-04-06T11:19:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-04-05T11:18:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-04-04T11:17:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-04-03T11:16:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-04-02T11:15:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-04-01T11:14:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-03-31T11:13:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-03-30T11:12:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-03-29T11:11:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 639076)   
2022-03-28T11:10:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906989)   
2022-03-27T11:09:03-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906989)   
2022-03-26T11:08:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906989)   
2022-03-25T11:07:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906989)   
2022-03-24T11:06:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906989)   
2022-03-23T11:05:03-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906989)   
2022-03-22T11:04:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906526)   
2022-03-21T11:03:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906526)   
2022-03-20T11:02:02-04:00   Error   /update_tables.py   geoip updated (files: 500 lines: 906526)
Title: Re: GeoIP Error - with Update_tables
Post by: danderson on April 07, 2022, 02:07:35 PM
im  running  22.1.4_1 and have the same thing, when downloading the file directly and looking at the dates of the CSV's they all show 3/29. This leads me to belive that all is normal and there has not been a GEO update from them since 3/29
Title: Re: GeoIP Error - with Update_tables
Post by: Manfred.Knick on April 17, 2022, 05:33:30 PM
Running     Version    22.1.6

Still:   "Last updated   2022-03-29T12:39:12"


Download:    GeoLite2-Country-CSV_20220412
All dates:     12. Apr 13:10

"GeoIP settings" -> "Apply":     no change
Title: Re: GeoIP Error - with Update_tables
Post by: danderson on April 18, 2022, 02:41:51 PM
my last updated shows 2022-04-12T11:10:50

Title: Re: GeoIP Error - with Update_tables
Post by: yeraycito on April 18, 2022, 05:55:46 PM
No problem
Title: Re: GeoIP Error - with Update_tables
Post by: cguilford on April 18, 2022, 06:19:16 PM
it's working fine now mine updated
Title: Re: GeoIP Error - with Update_tables
Post by: anicoletti on April 19, 2022, 04:19:47 AM
We recently rebuilt our firewall and the only way we were able to get the GeoIP information to populate and update was to either update or create a new GeoIP Alias and apply it. Once that was done all other GeoIP aliases updated properly.
Title: Re: GeoIP Error - with Update_tables
Post by: Manfred.Knick on April 19, 2022, 07:21:07 PM
CONFIRMATION:

Creating a single Firewall Alias "GeoIP__Deutschland" and "Apply"
changed "Last updated" to "2022-04-19T14:27:40" .
Text only | Text with Images