Group Management is not working after upgrade to V5

Help Community Help
1

Expected Behaviour:

Group Management list groups, can add groups or change groups

Actual Behaviour:

Error message about DataTables and can't create groups.

Debug Token:

https://tricorder.pi-hole.net/mlvevt5c4p

Thinks i already did

  • Add pihole to the group www-data
  • Add www-data user to the group pihole
  • Can't access the table group in 'sqlite3 /etc/pihole/gravity.db'
  • Uninstalled Pi-Hole and reinstalled

Env

  • Rarsp 3+
  • NGINX Frondend webserver
  • PHP 7.3
2

Do you use lighttpd (installed by Pi-hole) as web server? If so, are there errors in /var/log/lighttpd/error.log ?

Also note that after

you need to reboot the device.

3

Do you use lighttpd (installed by Pi-hole) as web server? If so, are there errors in /var/log/lighttpd/error.log ?

i don't use lighttpd, but nginx.

you need to reboot the device.

Yes i did this after i added the group.

5

He already added the user www-data to group pihole. While the other one isn't necessary, it is also not harmful. He already restarted nginx by rebooting his device so this cannot be the solution here.

6

Still not working! many reboots and restarts later.

Nginx is running on www-data, php-fpm is running under www-data.

listen.owner = www-data
listen.group = www-data

7

all requests to https://ipaddress/scripts/pi-hole/php/groups.php end with an 500 error.

9

https://192.168.178.5/admin/scripts/pi-hole/php/groups.php
https://192.168.178.5/admin/

has the same error message.

i configured nginx with de guide Redirecting...

but have also a seperated website directly to the admin page. both websites does not work.

10

i found it! php7.3-sqlite was not installed! Stupid me!

1 Like
12

What is the difference between a domain name pi-hole and an ip address? If you look closely at the configuration at Redirecting...

http://192.168.178.5 is the same as http://pi-hole because pi-hole resolves to 192.168.178.5 and the nginx site config has the default_server tag.

And HTTPS even if it is an internal website, it just needs to be secured with an HTTPS connection. But we are not going to have this discussion here.

14

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