Please follow the below template, it will help us to help you!
Expected Behaviour:
I am unsure of the expected behaviour but i expect to see logs when i click "Query Logs". However what i receive is a pop up message showing some errors.
My dashboard also doesn't load. I have tried multiple browsers with no success.
Actual Behaviour:
SqLite3 not found found and dashboard does not load.
Screen shots of the faults can be found here:
I have upgraded my dnsmasq manually which failed to resolve the issue. I then reverted my version which again failed to work. i followed the instructions as stated here:
In Pi-Hole V4 and later, dnsmasq no longer runs as a separate process. The code for dnsmasq is embedded in pihole-FTL, and dnsmasq is running under the pihole-FTL process. Your debug log shows that pihole-FTL is running.
Excellent thank you. However it seems after following the advice that is not the problem.
my output was the following:
pi@raspberrypi:~ $ sudo apt install php-pdo
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'php7.0-common' instead of 'php-pdo'
php7.0-common is already the newest version (7.0.33-0+deb9u3).
0 upgraded, 0 newly installed, 0 to remove and 5 not upgraded.
pi@raspberrypi:~ $ sudo apt install php-sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
php-sqlite3 is already the newest version (1:7.0+49).
0 upgraded, 0 newly installed, 0 to remove and 5 not upgraded.
pi@raspberrypi:~ $
pi@raspberrypi:~ $ sudo apt install --reinstall php7.0-json php7.0-sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 2 reinstalled, 0 to remove and 5 not upgraded.
Need to get 0 B/35.4 kB of archives.
After this operation, 0 B of additional disk space will be used.
(Reading database ... 123956 files and directories currently installed.)
Preparing to unpack .../php7.0-json_7.0.33-0+deb9u3_armhf.deb ...
Unpacking php7.0-json (7.0.33-0+deb9u3) over (7.0.33-0+deb9u3) ...
Preparing to unpack .../php7.0-sqlite3_7.0.33-0+deb9u3_armhf.deb ...
Unpacking php7.0-sqlite3 (7.0.33-0+deb9u3) over (7.0.33-0+deb9u3) ...
Setting up php7.0-sqlite3 (7.0.33-0+deb9u3) ...
Not replacing deleted config file /etc/php/7.0/mods-available/sqlite3.ini
WARNING: Module sqlite3 ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module sqlite3 ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module sqlite3 ini file doesn't exist under /etc/php/7.0/mods-available
php_invoke: Enable module sqlite3 for apache2 sapi
php_invoke: Enable module sqlite3 for cgi sapi
php_invoke: Enable module sqlite3 for cli sapi
Not replacing deleted config file /etc/php/7.0/mods-available/pdo_sqlite.ini
WARNING: Module pdo_sqlite ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module pdo_sqlite ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module pdo_sqlite ini file doesn't exist under /etc/php/7.0/mods-available
php_invoke: Enable module pdo_sqlite for apache2 sapi
php_invoke: Enable module pdo_sqlite for cgi sapi
php_invoke: Enable module pdo_sqlite for cli sapi
Setting up php7.0-json (7.0.33-0+deb9u3) ...
Not replacing deleted config file /etc/php/7.0/mods-available/json.ini
WARNING: Module json ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module json ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module json ini file doesn't exist under /etc/php/7.0/mods-available
php_invoke: Enable module json for apache2 sapi
php_invoke: Enable module json for cgi sapi
php_invoke: Enable module json for cli sapi
Processing triggers for libapache2-mod-php7.0 (7.0.33-0+deb9u3) ...
pi@raspberrypi:~ $ sudo phpenmod json sqlite3
WARNING: Module json ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module json ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module json ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module sqlite3 ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module sqlite3 ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module sqlite3 ini file doesn't exist under /etc/php/7.0/mods-available
pi@raspberrypi:~ $ php -m
[PHP Modules]
Core
date
filter
hash
libxml
openssl
pcntl
pcre
Reflection
session
SPL
standard
zlib
[Zend Modules]
pi@raspberrypi:~ $ sudo service lighttpd restart
pi@raspberrypi:~ $ sudo apt purge php7.0-json php7.0-sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
dh-php imagemagick-6-common libexporter-tiny-perl liblist-moreutils-perl liblqr-1-0 libmagickcore-6.q16-3 libmagickwand-6.q16-3 libpcre3-dev libpcre32-3
libpcrecpp0v5 libssl-dev libssl-doc shtool xml2
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
libapache2-mod-php* libapache2-mod-php7.0* php-cgi* php-imagick* php-memcache* php-pear* php-sqlite3* php7.0* php7.0-cgi* php7.0-cli* php7.0-dev*
php7.0-json* php7.0-sqlite3* pkg-php-tools*
0 upgraded, 0 newly installed, 14 to remove and 5 not upgraded.
After this operation, 20.5 MB disk space will be freed.
Do you want to continue? [Y/n] Y
(Reading database ... 123956 files and directories currently installed.)
Removing libapache2-mod-php (1:7.0+49) ...
Removing php7.0 (7.0.33-0+deb9u3) ...
Removing php-memcache (3.0.9~20160311.4991c2f-5) ...
WARNING: Module memcache ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module memcache ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module memcache ini file doesn't exist under /etc/php/7.0/mods-available
Removing php-imagick (3.4.3~rc2-2) ...
WARNING: Module imagick ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module imagick ini file doesn't exist under /etc/php/7.0/mods-available
WARNING: Module imagick ini file doesn't exist under /etc/php/7.0/mods-available
Removing libapache2-mod-php7.0 (7.0.33-0+deb9u3) ...
Module php7.0 disabled.
apache2_invoke prerm: Disable module php7.0
apache2_reload: Your configuration is broken. Not restarting Apache 2
apache2_reload: /usr/sbin/apache2ctl: 198: /usr/sbin/apache2ctl: /usr/sbin/apache2: not found
Removing php-cgi (1:7.0+49) ...
Removing pkg-php-tools (1.35) ...
Removing php-pear (1:1.10.1+submodules+notgz-9+deb9u1) ...
Removing php-sqlite3 (1:7.0+49) ...
Removing php7.0-cgi (7.0.33-0+deb9u3) ...
apache2_invoke php7.0-cgi prerm: No action required
Removing php7.0-dev (7.0.33-0+deb9u3) ...
Removing php7.0-cli (7.0.33-0+deb9u3) ...
Removing php7.0-json (7.0.33-0+deb9u3) ...
Removing php7.0-sqlite3 (7.0.33-0+deb9u3) ...
Processing triggers for man-db (2.7.6.1-2) ...
(Reading database ... 123323 files and directories currently installed.)
Purging configuration files for php-imagick (3.4.3~rc2-2) ...
Purging configuration files for php7.0-cgi (7.0.33-0+deb9u3) ...
apache2_invoke php7.0-cgi postrm: No action required
Purging configuration files for libapache2-mod-php7.0 (7.0.33-0+deb9u3) ...
apache2_invoke postrm: Purging state for php7.0
Purging configuration files for php7.0-cli (7.0.33-0+deb9u3) ...
Purging configuration files for php7.0-sqlite3 (7.0.33-0+deb9u3) ...
Purging configuration files for php-memcache (3.0.9~20160311.4991c2f-5) ...
Purging configuration files for php7.0-json (7.0.33-0+deb9u3) ...
Purging configuration files for php-pear (1:1.10.1+submodules+notgz-9+deb9u1) ...
pi@raspberrypi:~ $ sudo apt install php7.0-json php7.0-sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
dh-php imagemagick-6-common libexporter-tiny-perl liblist-moreutils-perl liblqr-1-0 libmagickcore-6.q16-3 libmagickwand-6.q16-3 libpcre3-dev libpcre32-3
libpcrecpp0v5 libssl-dev libssl-doc shtool xml2
Use 'sudo apt autoremove' to remove them.
The following NEW packages will be installed:
php7.0-json php7.0-sqlite3
0 upgraded, 2 newly installed, 0 to remove and 5 not upgraded.
Need to get 0 B/35.4 kB of archives.
After this operation, 156 kB of additional disk space will be used.
Selecting previously unselected package php7.0-json.
(Reading database ... 123317 files and directories currently installed.)
Preparing to unpack .../php7.0-json_7.0.33-0+deb9u3_armhf.deb ...
Unpacking php7.0-json (7.0.33-0+deb9u3) ...
Selecting previously unselected package php7.0-sqlite3.
Preparing to unpack .../php7.0-sqlite3_7.0.33-0+deb9u3_armhf.deb ...
Unpacking php7.0-sqlite3 (7.0.33-0+deb9u3) ...
Setting up php7.0-sqlite3 (7.0.33-0+deb9u3) ...
Creating config file /etc/php/7.0/mods-available/sqlite3.ini with new version
Creating config file /etc/php/7.0/mods-available/pdo_sqlite.ini with new version
Setting up php7.0-json (7.0.33-0+deb9u3) ...
Creating config file /etc/php/7.0/mods-available/json.ini with new version
pi@raspberrypi:~ $ sudo phpenmod json sqlite3
pi@raspberrypi:~ $
pi@raspberrypi:~ $ whereis php
php: /usr/lib/php /etc/php /usr/share/php7.0-sqlite3 /usr/share/php7.0-common /usr/share/php7.0-curl /usr/share/php7.0-zip /usr/share/php7.0-json /usr/share/php7.0-opcache /usr/share/php7.0-readline /usr/share/php7.0-imap /usr/share/php7.0-xmlrpc /usr/share/php7.0-mcrypt /usr/share/php7.0-mbstring /usr/share/php7.0-intl /usr/share/php7.0-mysql /usr/share/php7.0-xml /usr/share/php7.0-gd
pi@raspberrypi:~ $ readlink -f /usr/bin/php
/usr/bin/php
pi@raspberrypi:~ $ dpkg -S /usr/bin/php7.0
dpkg-query: no path found matching pattern /usr/bin/php7.0
pi@raspberrypi:~ $ sudo apt install --reinstall php7.0-cli
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
dh-php imagemagick-6-common libexporter-tiny-perl liblist-moreutils-perl liblqr-1-0 libmagickcore-6.q16-3 libmagickwand-6.q16-3 libpcre3-dev libpcre32-3
libpcrecpp0v5 libssl-dev libssl-doc shtool xml2
Use 'sudo apt autoremove' to remove them.
Suggested packages:
php-pear
The following NEW packages will be installed:
php7.0-cli
0 upgraded, 1 newly installed, 0 to remove and 5 not upgraded.
Need to get 0 B/1,052 kB of archives.
After this operation, 3,171 kB of additional disk space will be used.
Selecting previously unselected package php7.0-cli.
(Reading database ... 123337 files and directories currently installed.)
Preparing to unpack .../php7.0-cli_7.0.33-0+deb9u3_armhf.deb ...
Unpacking php7.0-cli (7.0.33-0+deb9u3) ...
Setting up php7.0-cli (7.0.33-0+deb9u3) ...
update-alternatives: using /usr/bin/php7.0 to provide /usr/bin/php (php) in auto mode
update-alternatives: using /usr/bin/phar7.0 to provide /usr/bin/phar (phar) in auto mode
update-alternatives: using /usr/bin/phar.phar7.0 to provide /usr/bin/phar.phar (phar.phar) in auto mode
Creating config file /etc/php/7.0/cli/php.ini with new version
php_invoke: Enable module exif for cli sapi
php_invoke: Enable module intl for cli sapi
php_invoke: Enable module simplexml for cli sapi
php_invoke: Enable module iconv for cli sapi
php_invoke: Enable module ctype for cli sapi
php_invoke: Enable module gettext for cli sapi
php_invoke: Enable module shmop for cli sapi
php_invoke: Enable module ftp for cli sapi
php_invoke: Enable module phar for cli sapi
php_invoke: Enable module mcrypt for cli sapi
php_invoke: Enable module calendar for cli sapi
php_invoke: Enable module mbstring for cli sapi
php_invoke: Enable module opcache for cli sapi
php_invoke: Enable module xmlwriter for cli sapi
php_invoke: Enable module zip for cli sapi
php_invoke: Enable module curl for cli sapi
php_invoke: Enable module xml for cli sapi
php_invoke: Enable module sysvshm for cli sapi
php_invoke: Enable module pdo for cli sapi
php_invoke: Enable module sysvmsg for cli sapi
php_invoke: Enable module pdo_mysql for cli sapi
php_invoke: Enable module xmlrpc for cli sapi
php_invoke: Enable module dom for cli sapi
php_invoke: Enable module readline for cli sapi
php_invoke: Enable module tokenizer for cli sapi
php_invoke: Enable module wddx for cli sapi
php_invoke: Enable module sockets for cli sapi
php_invoke: Enable module xmlreader for cli sapi
php_invoke: Enable module mysqli for cli sapi
php_invoke: Enable module mysqlnd for cli sapi
php_invoke: Enable module imap for cli sapi
php_invoke: Enable module gd for cli sapi
php_invoke: Enable module fileinfo for cli sapi
php_invoke: Enable module sysvsem for cli sapi
php_invoke: Enable module posix for cli sapi
php_invoke: Enable module xsl for cli sapi
Processing triggers for man-db (2.7.6.1-2) ...
pi@raspberrypi:~ $ sudo apt install --reinstall php7.0-cgi
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
dh-php imagemagick-6-common libexporter-tiny-perl liblist-moreutils-perl liblqr-1-0 libmagickcore-6.q16-3 libmagickwand-6.q16-3 libpcre3-dev libpcre32-3
libpcrecpp0v5 libssl-dev libssl-doc shtool xml2
Use 'sudo apt autoremove' to remove them.
Suggested packages:
php-pear
The following NEW packages will be installed:
php7.0-cgi
0 upgraded, 1 newly installed, 0 to remove and 5 not upgraded.
Need to get 0 B/1,019 kB of archives.
After this operation, 6,174 kB of additional disk space will be used.
Selecting previously unselected package php7.0-cgi.
(Reading database ... 123352 files and directories currently installed.)
Preparing to unpack .../php7.0-cgi_7.0.33-0+deb9u3_armhf.deb ...
Unpacking php7.0-cgi (7.0.33-0+deb9u3) ...
Setting up php7.0-cgi (7.0.33-0+deb9u3) ...
update-alternatives: using /usr/bin/php-cgi7.0 to provide /usr/bin/php-cgi (php-cgi) in auto mode
update-alternatives: using /usr/lib/cgi-bin/php7.0 to provide /usr/lib/cgi-bin/php (php-cgi-bin) in auto mode
Creating config file /etc/php/7.0/cgi/php.ini with new version
php_invoke: Enable module exif for cgi sapi
php_invoke: Enable module intl for cgi sapi
php_invoke: Enable module simplexml for cgi sapi
php_invoke: Enable module iconv for cgi sapi
php_invoke: Enable module ctype for cgi sapi
php_invoke: Enable module gettext for cgi sapi
php_invoke: Enable module shmop for cgi sapi
php_invoke: Enable module ftp for cgi sapi
php_invoke: Enable module phar for cgi sapi
php_invoke: Enable module mcrypt for cgi sapi
php_invoke: Enable module calendar for cgi sapi
php_invoke: Enable module mbstring for cgi sapi
php_invoke: Enable module opcache for cgi sapi
php_invoke: Enable module xmlwriter for cgi sapi
php_invoke: Enable module zip for cgi sapi
php_invoke: Enable module curl for cgi sapi
php_invoke: Enable module xml for cgi sapi
php_invoke: Enable module sysvshm for cgi sapi
php_invoke: Enable module pdo for cgi sapi
php_invoke: Enable module sysvmsg for cgi sapi
php_invoke: Enable module pdo_mysql for cgi sapi
php_invoke: Enable module xmlrpc for cgi sapi
php_invoke: Enable module dom for cgi sapi
php_invoke: Enable module readline for cgi sapi
php_invoke: Enable module tokenizer for cgi sapi
php_invoke: Enable module wddx for cgi sapi
php_invoke: Enable module sockets for cgi sapi
php_invoke: Enable module xmlreader for cgi sapi
php_invoke: Enable module mysqli for cgi sapi
php_invoke: Enable module mysqlnd for cgi sapi
php_invoke: Enable module imap for cgi sapi
php_invoke: Enable module gd for cgi sapi
php_invoke: Enable module fileinfo for cgi sapi
php_invoke: Enable module sysvsem for cgi sapi
php_invoke: Enable module posix for cgi sapi
php_invoke: Enable module xsl for cgi sapi
Processing triggers for man-db (2.7.6.1-2) ...
pi@raspberrypi:~ $