Webinterface, LTD: Error Connecting to Database

[TheodorNygard]

Hey guys, first of all loving Pi-Hole so far - but I am a sucker for graphs and data, which is where I'm struggling a bit:

Expected Behaviour:

Searching slices of the the Long Term Data via webinterface shows beautiful visualized data for body and soul to enjoy.

Actual Behaviour:

"Error Connecting to Database" upon opening the "Query Log". "Graphics" and "Top Lists" present no data upon query, simply wheels that spin forever.

Querying the .db with the example from the documentation works as expected it seems:

Debug Token:

https://tricorder.pi-hole.net/9f7pzgv54j!

Attempted Steps:

I've run "sudo chown -R pihole /etc/pihole/"

Multiple restarts done

[deHakkelaar]

@TheodorNygard

I’ve run “sudo chown -R pihole /etc/pihole/”

pi@noads:~ $ ps -o fname,user -p $(pidof pihole-FTL)
COMMAND    USER
pihole-FTL pihole

---

pi@noads:~ $ ps -o fname,user -p $(pidof lighttpd)
COMMAND    USER
lighttpd   www-data

---

pi@noads:~ $ stat /etc/pihole/pihole-FTL.db
Access: (0644/-rw-r--r--)  Uid: (  999/  pihole)   Gid: (  996/  pihole)

Try:

sudo chmod +r /etc/pihole/pihole-FTL.db

But by running the chown recursively (-R), you changed ownership of all files contained in that folder:

pi@noads:~ $ ll  /etc/pihole/
total 240276
drwxr-xr-x   2 pihole pihole        4096 Apr 22 20:37 .
drwxr-xr-x 101 root   root         12288 Apr 20 08:38 ..
-rw-r--r--   1 root   root           507 Aug 31  2018 adlists.list
-rw-r--r--   1 root   root           759 Jun  8  2018 adlists.list.old
-rw-r--r--   1 root   root            29 Apr 21 04:22 black.list
-rw-r--r--   1 root   root            29 Dec 27  2017 blacklist.txt
-rw-r--r--   1 pihole pihole         493 Apr 22 20:19 dhcp.leases
lrwxrwxrwx   1 root   root            14 Aug 16  2018 dnsmasq.d -> /etc/dnsmasq.d
-rw-r--r--   1 root   root            18 Apr 22 16:28 GitHubVersions
-rw-r--r--   1 root   root       2970555 Apr 21 04:22 gravity.list
-rw-r--r--   1 root   root          1358 Apr 20 08:38 install.log
-rw-------   1 root   root       1140100 Apr 21 04:22 list.0.raw.githubusercontent.com.domains
-rw-------   1 root   root        595976 Apr 20 08:39 list.1.mirror1.malwaredomains.com.domains
-rw-------   1 root   root        638705 Apr 20 08:39 list.2.sysctl.org.domains
-rw-------   1 root   root          7295 Apr 20 08:39 list.3.zeustracker.abuse.ch.domains
-rw-------   1 root   root           613 Apr 20 08:39 list.4.s3.amazonaws.com.domains
-rw-------   1 root   root         43642 Apr 20 08:39 list.5.s3.amazonaws.com.domains
-rw-------   1 root   root       1772428 Apr 20 08:39 list.6.hosts-file.net.domains
-rw-------   1 root   root         18525 Apr 21 04:22 list.7.dehakkelaar.nl.domains
-rw-------   1 root   root        395154 Apr 21 04:22 list.8.gitlab.com.domains
-rw-r--r--   1 root   root       2970572 Apr 21 04:22 list.preEventHorizon
-rw-r--r--   1 root   root            20 Apr 22 20:30 localbranches
-rw-r--r--   1 root   root            42 Apr 21 04:22 local.list
-rw-r--r--   1 root   root            39 Apr 22 20:30 localversions
-rw-r--r--   1 root   root           234 Apr 20 08:38 logrotate
-rw-rw-r--   1 pihole pihole           0 Aug  8  2018 pihole-FTL.conf
-rw-r--r--   1 pihole pihole   235388928 Apr 22 20:37 pihole-FTL.db
-rw-rw-r--   1 pihole www-data         0 Aug  8  2018 regex.list
-rw-r--r--   1 root   root           529 Apr 20 08:59 setupVars.conf
-rw-r--r--   1 root   root           527 Apr 20 08:38 setupVars.conf.update.bak
-rw-r--r--   1 root   root           236 Aug 21  2018 whitelist.txt