@max.bra - I believe it's once/min or 60 times per hour. Still, 1,440 writes in a 24 hour period is the theoretical max. That will add up over time for sure...
Search Criteria
Package Details: pi-hole-ftl 5.25.2-1
Package Actions
| Git Clone URL: | https://aur.archlinux.org/pi-hole-ftl.git (read-only, click to copy) |
|---|---|
| Package Base: | pi-hole-ftl |
| Description: | The Pi-hole FTL engine |
| Upstream URL: | https://github.com/pi-hole/FTL |
| Licenses: | EUPL-1.2 |
| Conflicts: | dnsmasq |
| Provides: | dnsmasq |
| Submitter: | max.bra |
| Maintainer: | max.bra (graysky) |
| Last Packager: | max.bra |
| Votes: | 54 |
| Popularity: | 0.41 |
| First Submitted: | 2017-05-07 15:23 (UTC) |
| Last Updated: | 2024-05-09 11:54 (UTC) |
Dependencies (6)
- gmp (gmp-hgAUR)
- libidn (libidn-gitAUR)
- nettle (nettle-gitAUR)
- cmake (cmake-gitAUR) (make)
- sqlite (sqlite-fossilAUR) (make)
- xxd (vim-minimal-gitAUR, gvim-wayland-lilydjwg-gitAUR, gvim-gitAUR, gvim-gtk2AUR, gvim, tinyxxd, vim) (make)
Required by (63)
- adhocspot-script-git (requires dnsmasq)
- airgeddon (requires dnsmasq) (optional)
- anti-ad-dnsmasq-git (requires dnsmasq)
- appgate-sdp (requires dnsmasq) (optional)
- appgate-sdp-headless (requires dnsmasq) (optional)
- archpxe (requires dnsmasq)
- berate_ap-git (requires dnsmasq)
- blueman-git (requires dnsmasq) (optional)
- corplink-bin (requires dnsmasq)
- create_ap (requires dnsmasq)
- create_ap-git (requires dnsmasq)
- cuttlefish-base-git (requires dnsmasq)
- dns-zone-blacklist-git (requires dnsmasq) (optional)
- dnsmasq-china-list-git (requires dnsmasq)
- dnsmasq-openrc (requires dnsmasq)
- docker-dnsmasq (requires dnsmasq)
- docker-machine-driver-kvm2 (requires dnsmasq)
- easywifi-git (requires dnsmasq) (optional)
- ethoscope-device (requires dnsmasq)
- ethoscope-node (requires dnsmasq)
- Show 43 more...
Sources (7)
graysky commented on 2017-12-11 20:59 (UTC) (edited on 2017-12-11 21:14 (UTC) by graysky)
max.bra commented on 2017-12-11 20:57 (UTC)
where have you see a commit on every query/request?
MartB commented on 2017-12-11 20:51 (UTC) (edited on 2017-12-11 20:51 (UTC) by MartB)
@graysky yeah it is kinda horrible for an sd card system, but its hardcoded in the admin interface so this change must be done over there too. But as its the same maintainer this seems to be alright.
Keep in mind that this database is responsible for the long term data storage though, so the wiki might need an update.
graysky commented on 2017-12-11 20:48 (UTC)
@MartB - OK! This file (/etc/pihole/pihole-FTL.db) has never existed for me until changing ownership of /etc/pihole as you suggested.
@MaxBra - This file seems to be updated each time a new DNS entry is resolved which could be horrible for SD Card based system (raspberry pi for example). Can we relocate this file to tmpfs by modifying one of the upstream provided files as we do for the log files?
MartB commented on 2017-12-11 20:44 (UTC)
@graysky Getting it from /run/log/pihole-ftl/pihole-FTL.log
graysky commented on 2017-12-11 20:43 (UTC)
@MartB - Interesting... I have no such file. What are you getting that log output?
MartB commented on 2017-12-11 20:40 (UTC) (edited on 2017-12-11 20:41 (UTC) by MartB)
@graysky
(1) /etc/pihole/pihole-FTL.db
(2) pihole ftl does it automatically i guess ?
Relevant log:
[2017-12-11 19:37:52.432] db_init() - Cannot open database (14): unable to open database file
[2017-12-11 19:37:52.432] Creating new (empty) database
[2017-12-11 19:37:52.432] db_create() - SQL error (14): unable to open database file
[2017-12-11 19:37:52.432] Database not available
graysky commented on 2017-12-11 20:37 (UTC) (edited on 2017-12-11 20:39 (UTC) by graysky)
@MartB - To be clear 1) What is the database file (full path and file name)? 2) How are you creating the database (ie running a command or ...)? Thanks!
MartB commented on 2017-12-11 20:34 (UTC)
@graysky Yeah but now it cant create the database, it errors out. I fixed it by chowning it to pihole
graysky commented on 2017-12-11 20:33 (UTC)
@MartB - I believe /etc/pihole was root:root under 2.11.x as well as the files within it.
Pinned Comments
max.bra commented on 2018-02-09 16:46 (UTC) (edited on 2019-10-18 23:13 (UTC) by max.bra)
ArchLinux Pi-hole is not officially supported by Pi-hole project. In case of bugs and malfunctions please DO NOT file a report upstream.
First of all check if the wiki (https://wiki.archlinux.org/index.php/Pi-hole) can help then ask here for assistance and tips.
When it will be excluded that the problem does not depend on ArchLinux we will file a bug upstream.