I did not see this anywhere, this was just my speculation as
lead to no clients showing up. If these are indeed all clients in your network, then my assumption was simply wrong.
Actually 58 clients using pihole. I excluded just some which doing a lot of requests and not needed for me to seen in statistic
So honestly, this kind of implementation of the new feature doesn't work for me like it is.
Yeah, I get this. We need to find out why so we can get this fixed properly. So thanks for staying in tough with us about this issue. Can you make out specific entries in either excludeClients or excludeDomains causing this?
I still assume it may be the fritz.box entry will all of your clients get a fritz.box suffix. Please try them using anchors, like
^localhost$
^fritz.box$
^iobroker.fritz.box$
^SKY-IPTV-WZ.fritz.box$
^SKY-IPTV-GZ.fritz.box$
^DiskStation.fritz.box$
^pihole-6.fritz.box$
to ensure fritz.box really matches only fritz.box and not also xyz.fritz.box (which does contain fritz,box).
this works
Hi, any chance you can make this branch visible again so I can snag a copy?
sudo pihole checkout ftl new/useWAL
sudo pihole-FTL --config database.useWAL false
My understanding is that WAL isn't supported over network filesystems. It would be nice to have this switch exposed in v6 for those mounting network (or weird-o) filesystems.
It should be up. Which errors have been seeing when running the checkout command?
Sorry, looks like I borked-up Git on my end. I can see new/useWAL now.
Disabling SQLite write-ahead logging resolves my issue.
Is this something you plan to roll into v6?
Thanks for the assist!
D.
Sure, it is awaiting review here:
1 Like
It has been merged. Please go back to development-v6 soon.
I just came across this issue and in my case, I had a corrupted database. Thank you for your steps, they resolved it for me.
In case it's helpful, here's the output of the integrity check against my database:
*** in database main ***
Tree 11 page 36047: btreeInitPage() returns error code 11
Tree 2 page 36048: btreeInitPage() returns error code 11
Tree 2 page 36046: btreeInitPage() returns error code 11
wrong # of entries in index domain_by_id_domain_idx
wrong # of entries in index idx_queries_timestamps
Error: stepping, database disk image is malformed (11)