Issues from new install

Hey All,

i am using Dietpi(7.6.2) and have installed Pihole(Pi-holev5.4 WebInterfacev5.6 FTLv5.9) through dietpi's auto installer(also using nginx as web server)

i can access the webpage and login but the adlists are not visible and when i try to add one i get "Error occurred" i also discovered this error "DataTables warning: table id=messagesTable - Ajax error. For more information about this error, please see 7. Warning: Ajax error" when select groups under group management

if i run update gravity it seems to work fine, to i then tried pihole -r and it completed that successfully as well so not sure where to go from here.

[i] Neutrino emissions detected...
[✓] Pulling blocklist source list into range

[✓] Preparing new gravity database
[i] Using libz compression

[i] Target: https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts
[✓] Status: Retrieval successful
[i] Analyzed 94106 domains
[i] List stayed unchanged

[✓] Storing downloaded domains in new gravity database
[✓] Building tree
[✓] Swapping databases
[✓] The old database remains available.
[i] Number of gravity domains: 94106 (94106 unique domains)
[i] Number of exact blacklisted domains: 0
[i] Number of regex blacklist filters: 0
[i] Number of exact whitelisted domains: 1
[i] Number of regex whitelist filters: 0
[✓] Cleaning up stray matter

[✓] DNS service is listening
[✓] UDP (IPv4)
[✓] TCP (IPv4)
[✓] UDP (IPv6)
[✓] TCP (IPv6)

[✓] Pi-hole blocking is enabled

Please upload a debug log and post just the token that is generated after the log is uploaded by running the following command from the Pi-hole host terminal:

pihole -d

or do it through the Web interface:

Tools > Generate Debug Log

Here you go: https://tricorder.pi-hole.net/lNVW2Wnl/

I tried it on a fresh testing system and it works well here with Nginx and Pi-hole: I see the default list by StevenBlack and can add a new list successfully.

To test it as close as possible: Which hardware do you use, an RPi? And which Debian version, Buster or Bullseye?

Something went wrong during the installation

*** [ DIAGNOSING ]: Web version
[i] Web: v5.6 (https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249)
[i] Remotes: origin	https://github.com/pi-hole/AdminLTE.git (fetch)
             origin	https://github.com/pi-hole/AdminLTE.git (push)
[i] Branch: master
[i] Commit: v5.6-0-gf5292a3-dirty
[i] Status:  M .gitattributes
             M .github/ISSUE_TEMPLATE.md
             M .github/PULL_REQUEST_TEMPLATE.md
             M .github/dependabot.yml
             M .github/workflows/codeql.yml
             M .github/workflows/phpstan.yml
             M .github/workflows/test.yml
             M .gitignore
             M .user.php.ini
             M CONTRIBUTING.md
             M LICENSE
             M README.md
             M api.php
             M api_FTL.php
             M api_db.php
             M auditlog.php
             M cname_records.php
             M composer.json
             M composer.lock
             M db_graph.php
             M db_lists.php
             M db_queries.php
             M debug.php
             M dns_records.php
             M gravity.php

...

[i] Diff: diff --git a/.gitattributes b/.gitattributes
          old mode 100644
          new mode 100755
          diff --git a/.github/ISSUE_TEMPLATE.md b/.github/ISSUE_TEMPLATE.md
          old mode 100644
          new mode 100755
          diff --git a/.github/PULL_REQUEST_TEMPLATE.md b/.github/PULL_REQUEST_TEMPLATE.md
          old mode 100644
          new mode 100755
          diff --git a/.github/dependabot.yml b/.github/dependabot.yml
          old mode 100644
          new mode 100755
          diff --git a/.github/workflows/codeql.yml b/.github/workflows/codeql.yml
          old mode 100644
          new mode 100755
          diff --git a/.github/workflows/phpstan.yml b/.github/workflows/phpstan.yml
          old mode 100644
          new mode 100755
          diff --git a/.github/workflows/test.yml b/.github/workflows/test.yml
          old mode 100644
          new mode 100755
          diff --git a/.gitignore b/.gitignore
          old mode 100644
          new mode 100755
          diff --git a/.user.php.ini b/.user.php.ini
          old mode 100644
          new mode 100755
          diff --git a/CONTRIBUTING.md b/CONTRIBUTING.md
          old mode 100644
          new mode 100755
          diff --git a/LICENSE b/LICENSE
          old mode 100644
          new mode 100755
          diff --git a/README.md b/README.md
          old mode 100644
          new mode 100755
          diff --git a/api.php b/api.php
          old mode 100644
          new mode 100755
          diff --git a/api_FTL.php b/api_FTL.php
          old mode 100644
.....


HI Michalng,

i am using a Rpi3b+ and i think the version is Bullseye

Hi YubiUser,

i think from that that i have some older version by that (old mode 100644/new mode 100755) line, i did try a pihole -r, how would i fix that.

Okay, so Bullseye as well. Whether RPi or VM shouldn't make a difference. Looks like the file modes were changed, being all executable now. Try to reset the repo:

cd /var/www/html/admin
git reset --hard

i ran that and got this: HEAD is now at f5292a3 Merge pull request #1850 from pi-hole/release/v5.6

i checked the pihole and its still the same

Are the file modes now correct?

ls -al /var/www/html/admin

Ah, and how about modes/owner of Pi-hole database files?

ls -al /etc/pihole

Hi Michalng,

Here is the output of each.

ls -al /var/www/html/admin

drwxr-xr-x 7 dietpi www-data   4096 Sep 28 05:25 .
drwxr-xr-x 4 dietpi www-data   4096 Sep 12 18:14 ..
-rw-r--r-- 1 dietpi dietpi    12618 Sep 28 05:25 api_db.php
-rw-r--r-- 1 dietpi dietpi     9884 Sep 28 05:25 api_FTL.php
-rw-r--r-- 1 dietpi dietpi     4444 Sep 28 05:25 api.php
-rw-r--r-- 1 dietpi dietpi     2289 Sep 28 05:25 auditlog.php
-rw-r--r-- 1 dietpi dietpi     5204 Sep 28 05:25 cname_records.php
-rw-r--r-- 1 dietpi dietpi      464 Sep 28 05:25 composer.json
-rw-r--r-- 1 dietpi dietpi     2646 Sep 28 05:25 composer.lock
-rw-r--r-- 1 dietpi dietpi     2336 Sep 28 05:25 CONTRIBUTING.md
-rw-r--r-- 1 dietpi dietpi     2362 Sep 28 05:25 db_graph.php
-rw-r--r-- 1 dietpi dietpi     4414 Sep 28 05:25 db_lists.php
-rw-r--r-- 1 dietpi dietpi     8388 Sep 28 05:25 db_queries.php
-rw-r--r-- 1 dietpi dietpi     1004 Sep 28 05:25 debug.php
-rw-r--r-- 1 dietpi dietpi     4798 Sep 28 05:25 dns_records.php
drwxr-xr-x 8 dietpi www-data   4096 Sep 28 09:04 .git
-rw-r--r-- 1 dietpi dietpi       12 Sep 28 05:25 .gitattributes
drwxr-xr-x 3 dietpi www-data   4096 Sep 28 05:25 .github
-rw-r--r-- 1 dietpi dietpi      174 Sep 28 05:25 .gitignore
-rw-r--r-- 1 dietpi dietpi     1332 Sep 28 05:25 gravity.php
-rw-r--r-- 1 dietpi dietpi     3659 Sep 28 05:25 groups-adlists.php
-rw-r--r-- 1 dietpi dietpi     4410 Sep 28 05:25 groups-clients.php
-rw-r--r-- 1 dietpi dietpi     7215 Sep 28 05:25 groups-domains.php
-rw-r--r-- 1 dietpi dietpi     3253 Sep 28 05:25 groups.php
drwxr-xr-x 3 dietpi www-data   4096 Sep 28 05:25 img
-rw-r--r-- 1 dietpi dietpi     9434 Sep 28 05:25 index.php
-rw-r--r-- 1 dietpi dietpi    14164 Sep 28 05:25 LICENSE
-rw-r--r-- 1 dietpi dietpi     1577 Sep 28 05:25 messages.php
-rw-r--r-- 1 dietpi dietpi     2804 Sep 28 05:25 network.php
-rw-r--r-- 1 dietpi dietpi     2522 Sep 28 05:25 package.json
-rw-r--r-- 1 dietpi dietpi   269515 Sep 28 05:25 package-lock.json
-rw-r--r-- 1 dietpi dietpi      120 Sep 28 05:25 phpstan.neon.dist
-rw-r--r-- 1 dietpi dietpi     6169 Sep 28 05:25 queries.php
-rw-r--r-- 1 dietpi dietpi     2195 Sep 28 05:25 queryads.php
-rw-r--r-- 1 dietpi dietpi     8929 Sep 28 05:25 README.md
drwxr-xr-x 4 dietpi www-data   4096 Sep 12 18:09 scripts
-rw-r--r-- 1 dietpi dietpi    97973 Sep 28 05:25 settings.php
drwxr-xr-x 4 dietpi www-data   4096 Sep 28 05:25 style
-rw-r--r-- 1 dietpi dietpi      937 Sep 28 05:25 taillog-FTL.php
-rw-r--r-- 1 dietpi dietpi      929 Sep 28 05:25 taillog.php
-rw-r--r-- 1 dietpi dietpi       45 Sep 28 05:25 .user.php.ini

ls -al /etc/pihole

drwxrwxr-x  3 pihole pihole    4096 Sep 28 09:06 .
drwxr-xr-x 75 root   root      4096 Sep 28 05:35 ..
-rw-r--r--  1 root   root        65 Sep 26 06:46 adlists.list
-rw-r--r--  1 root   root         0 Sep 12 18:10 custom.list
-rw-r--r--  1 pihole pihole       0 Sep 28 09:04 dhcp.leases
-rw-r--r--  1 root   root       618 Sep 28 05:35 dns-servers.conf
-rw-r--r--  1 root   root        14 Sep 28 09:04 GitHubVersions
-rw-rw-r--  1 pihole pihole 5640192 Sep 28 05:35 gravity.db
-rw-rw-r--  1 pihole pihole 5640192 Sep 28 05:35 gravity_old.db
-rw-r--r--  1 root   root      1112 Sep 28 05:35 install.log
-rw-r--r--  1 root   root   1970355 Sep 28 05:35 list.1.raw.githubusercontent.com.domains
-rw-r--r--  1 root   root        95 Sep 28 05:35 list.1.raw.githubusercontent.com.domains.sha1
-rw-r--r--  1 root   root        20 Sep 28 05:40 localbranches
-rw-r--r--  1 root   root        65 Sep 28 05:35 local.list
-rw-r--r--  1 root   root        36 Sep 28 05:40 localversions
-rw-r--r--  1 root   root       234 Sep 12 18:10 logrotate
-rw-r--r--  1 pihole pihole 2732032 Sep 12 18:10 macvendor.db
drwxr-xr-x  2 root   root      4096 Sep 12 18:10 migration_backup
-rw-rw-r--  1 pihole root        45 Sep 28 05:35 pihole-FTL.conf
-rw-r--r--  1 pihole pihole   53248 Sep 28 09:06 pihole-FTL.db
-rw-r--r--  1 root   root       543 Sep 28 05:35 setupVars.conf
-rw-r--r--  1 root   root       543 Sep 28 05:35 setupVars.conf.update.bak

I fixed it!!! i was checking https://docs.pi-hole.net/guides/webserver/nginx/ and see that php7.3-sqlite3 needs to be installed, so i checked my list of installed packages and it was not listed so i installed php7.4-sqlite3 and its all working now

Thanks for your help yubiuser and MichaIng

Interesting, you installed it via dietpi-software? As this module is definitely installed, together with SQLite and PHP :thinking:.

Hi Michalng, here is what i have selected, i selected LEMP with the first install. i dont know why LESP is also ticked.





LESP is ticked because Pi-hole requires SQLite, so you have Enginx, SQLite and PHP installed :wink:. Those stacks are also marked as installed when their individual components have been installed. You require MariaDB for something else?

But strange is that SQLite is not ticket in the same turn. You didn't uninstall it manually, did you? AFAIK the stack is not unticked when one of its components is uninstalled. Actually that would be smart. Same way it would be smart to show at least a warning when a dependency of an installed software title is attempted to be uninstalled. The new dependency system makes this quite easy :thinking:.

Hi Michalng,
i believe wordpress requires MariaDB, i also have not uninstalled anything because i dont know everything that might use a particular package and dont want to mess with the system

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.