Hi!
Not sure if it's the right place, but i wanted to share this:
I've vibecoded a script that generate a geoIP database from scratch that matches the requirements in terms of format for Opnsense.
(https://private-user-images.githubusercontent.com/60965766/674740161-dc16df01-9a59-4f8a-bc44-9f1750a7b26c.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3OTIwNzUwNzYsIm5iZiI6MTc5MjA3NDc3NiwicGF0aCI6Ii82MDk2NTc2Ni82NzQ3NDAxNjEtZGMxNmRmMDEtOWE1OS00ZjhhLWJjNDQtOWYxNzUwYTdiMjZjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjEwMTUlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYxMDE1VDE0MzI1NlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWE1NDA3ODU4NTljNjBiZDZkODdlZjQ3OTlmOThhNjFhNDcxM2MzMmMyZGY5M2M5ZDIzMjlhOTY3ZGVjYTRlM2QmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JnJlc3BvbnNlLWNvbnRlbnQtdHlwZT1pbWFnZSUyRnBuZyJ9.TbmZ_h6gYPBlRPPEAjb-r7DgBWHiI6ddOC0amaK25BM)
- It's fully open sources
- Based on the internet registries database
- Automatically updated everyday using a workflow
The database here will be automatically updated:
https://github.com/Tontonjo/opnsense/releases/download/geoip/GeoLite2-Country-CSV.zip
Find the scripts for both bash and Powershell usage if you need to self-host here:
https://github.com/Tontonjo/opnsense/tree/main/geoip
Let me know if you find this usefull :)
Regards
Jo