Resolve client IP-Adresses for the Long Term Data section

yubiuser · May 31, 2022, 5:30am

Keep Query Log details across FTL restart

development ← new/database_reply_replytime_dnssec

opened 08:23PM - 19 Jan 22 UTC

**By submitting this pull request, I confirm the following:** - [X] I have re…ad and understood the [contributors guide](https://github.com/pi-hole/pi-hole/blob/master/CONTRIBUTING.md). - [X] I have checked that [another pull request](https://github.com/pi-hole/FTL/pulls) for this purpose does not exist. - [X] I have considered, and confirmed that this submission will be valuable to others. - [X] I accept that this submission may not be used, and the pull request closed at the will of the maintainer. - [X] I give this submission freely, and claim no ownership to its content. **How familiar are you with the codebase?:** ## 10 --- When restarting FTL, it imports history from the database to repopulate the history. So far, this was only possible with a reduced set of variables to keep the database from growing forever. Recent database optimizations https://github.com/pi-hole/FTL/pull/1255 reduced the database size significantly allowing us to store more data in the database. This PR adds storing all the details necessary for the query log so a restart goes (almost) invisible and without any data loss. *) almost because some queries may not have been completed due to the forced restart and according service interruption.

https://github.com/pi-hole/AdminLTE/pull/2202

https://github.com/pi-hole/AdminLTE/pull/2245