that's the error in error.log of "lighttpd" when I want to write something
at Pi-Hole admin-panel to the Pi-Hole database:
2020-05-27 12:35:44: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 729
2020-05-27 12:35:47: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 729
2020-05-27 12:36:01: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 265
2020-05-27 12:44:35: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 265
How to fix that, please help, thanks!
File-permissions output:
ls -lha /var/www/html
total 16K
drwxr-xr-x 4 root root 4,0K Mai 26 18:22 .
drwxr-xr-x 3 root root 4,0K Mai 26 18:22 ..
drwxr-xr-x 7 root root 4,0K Mai 26 18:22 admin
drwxr-xr-x 2 root root 4,0K Mai 26 18:22 pihole
ls -lha /var/www/html/pihole
total 40K
drwxr-xr-x 2 root root 4,0K Mai 26 18:22 .
drwxr-xr-x 4 root root 4,0K Mai 26 18:22 ..
-rw-r--r-- 1 root root 13K Mai 26 18:22 blockingpage.css
-rw-r--r-- 1 root root 15K Mai 26 18:22 index.php
ls -lha /var/www/html/admin
total 476K
drwxr-xr-x 7 root root 4,0K Mai 26 18:22 .
drwxr-xr-x 4 root root 4,0K Mai 26 18:22 ..
-rw-r--r-- 1 root root 12K Mai 26 18:22 api_db.php
-rw-r--r-- 1 root root 9,3K Mai 26 18:22 api_FTL.php
-rw-r--r-- 1 root root 3,6K Mai 26 18:22 api.php
-rw-r--r-- 1 root root 2,3K Mai 26 18:22 auditlog.php
-rw-r--r-- 1 root root 2,3K Mai 26 18:22 CONTRIBUTING.md
-rw-r--r-- 1 root root 2,2K Mai 26 18:22 db_graph.php
-rw-r--r-- 1 root root 4,2K Mai 26 18:22 db_lists.php
-rw-r--r-- 1 root root 6,4K Mai 26 18:22 db_queries.php
-rw-r--r-- 1 root root 939 Mai 26 18:22 debug.php
-rw-r--r-- 1 root root 3,9K Mai 26 18:22 dns_records.php
drwxr-xr-x 8 root root 4,0K Mai 27 12:50 .git
drwxr-xr-x 3 root root 4,0K Mai 26 18:22 .github
-rw-r--r-- 1 root root 153 Mai 26 18:22 .gitignore
-rw-r--r-- 1 root root 1,3K Mai 26 18:22 gravity.php
-rw-r--r-- 1 root root 3,0K Mai 26 18:22 groups-adlists.php
-rw-r--r-- 1 root root 3,0K Mai 26 18:22 groups-clients.php
-rw-r--r-- 1 root root 6,8K Mai 26 18:22 groups-domains.php
-rw-r--r-- 1 root root 2,7K Mai 26 18:22 groups.php
-rw-r--r-- 1 root root 9,2K Mai 26 18:22 help.php
drwxr-xr-x 3 root root 4,0K Mai 26 18:22 img
-rw-r--r-- 1 root root 8,9K Mai 26 18:22 index.php
-rw-r--r-- 1 root root 14K Mai 26 18:22 LICENSE
-rw-r--r-- 1 root root 2,9K Mai 26 18:22 network.php
-rw-r--r-- 1 root root 1,5K Mai 26 18:22 package.json
-rw-r--r-- 1 root root 178K Mai 26 18:22 package-lock.json
-rw-r--r-- 1 root root 5,4K Mai 26 18:22 queries.php
-rw-r--r-- 1 root root 1,1K Mai 26 18:22 queryads.php
-rw-r--r-- 1 root root 9,0K Mai 26 18:22 README.md
drwxr-xr-x 4 root root 4,0K Mai 26 18:22 scripts
-rw-r--r-- 1 root root 90K Mai 26 18:22 settings.php
drwxr-xr-x 3 root root 4,0K Mai 26 18:22 style
-rw-r--r-- 1 root root 939 Mai 26 18:22 taillog-FTL.php
-rw-r--r-- 1 root root 931 Mai 26 18:22 taillog.php
-rw-r--r-- 1 root root 45 Mai 26 18:22 .user.php.ini
ls -lha /var/www/html/admin/scripts/pi-hole/php/
total 180K
drwxr-xr-x 2 root root 4,0K Mai 26 18:22 .
drwxr-xr-x 4 root root 4,0K Mai 26 18:22 ..
-rw-r--r-- 1 root root 2,5K Mai 26 18:22 add.php
-rw-r--r-- 1 root root 431 Mai 26 18:22 api_token.php
-rw-r--r-- 1 root root 5,0K Mai 26 18:22 auth.php
-rw-r--r-- 1 root root 3,8K Mai 26 18:22 customdns.php
-rw-r--r-- 1 root root 7,5K Mai 26 18:22 database.php
-rw-r--r-- 1 root root 728 Mai 26 18:22 debug.php
-rw-r--r-- 1 root root 3,8K Mai 26 18:22 footer.php
-rw-r--r-- 1 root root 1,4K Mai 26 18:22 FTL.php
-rw-r--r-- 1 root root 1,5K Mai 26 18:22 func.php
-rw-r--r-- 1 root root 1,8K Mai 26 18:22 gravity.php
-rw-r--r-- 1 root root 1,2K Mai 26 18:22 gravity.sh.php
-rwxr-xr-x 1 root root 32K Mai 26 18:22 groups.php
-rw-r--r-- 1 root root 32K Mai 26 18:22 header.php
-rw-r--r-- 1 root root 3,5K Mai 26 18:22 loginpage.php
-rw-r--r-- 1 root root 3,2K Mai 26 18:22 password.php
-rw-r--r-- 1 root root 1,7K Mai 26 18:22 queryads.php
-rw-r--r-- 1 root root 19K Mai 26 18:22 savesettings.php
-rw-r--r-- 1 root root 1,3K Mai 26 18:22 tailLog.php
-rw-r--r-- 1 root root 15K Mai 26 18:22 teleporter.php
-rw-r--r-- 1 root root 2,5K Mai 26 18:22 update_checker.php
ls -lha /var/www/html/admin/scripts/pi-hole/js/
total 208K
drwxr-xr-x 2 root root 4,0K Mai 26 18:22 .
drwxr-xr-x 4 root root 4,0K Mai 26 18:22 ..
-rw-r--r-- 1 root root 4,6K Mai 26 18:22 auditlog.js
-rw-r--r-- 1 root root 2,8K Mai 26 18:22 customdns.js
-rw-r--r-- 1 root root 11K Mai 26 18:22 db_graph.js
-rw-r--r-- 1 root root 7,2K Mai 26 18:22 db_lists.js
-rw-r--r-- 1 root root 12K Mai 26 18:22 db_queries.js
-rw-r--r-- 1 root root 1,8K Mai 26 18:22 debug.js
-rw-r--r-- 1 root root 5,4K Mai 26 18:22 footer.js
-rw-r--r-- 1 root root 2,0K Mai 26 18:22 gravity.js
-rw-r--r-- 1 root root 11K Mai 26 18:22 groups-adlists.js
-rw-r--r-- 1 root root 12K Mai 26 18:22 groups-clients.js
-rw-r--r-- 1 root root 4,1K Mai 26 18:22 groups-common.js
-rw-r--r-- 1 root root 16K Mai 26 18:22 groups-domains.js
-rw-r--r-- 1 root root 7,7K Mai 26 18:22 groups.js
-rw-r--r-- 1 root root 34K Mai 26 18:22 index.js
-rw-r--r-- 1 root root 2,2K Mai 26 18:22 ip-address-sorting.js
-rw-r--r-- 1 root root 6,2K Mai 26 18:22 network.js
-rw-r--r-- 1 root root 16K Mai 26 18:22 queries.js
-rw-r--r-- 1 root root 3,7K Mai 26 18:22 queryads.js
-rw-r--r-- 1 root root 6,7K Mai 26 18:22 settings.js
-rw-r--r-- 1 root root 1,3K Mai 26 18:22 taillog-FTL.js
-rw-r--r-- 1 root root 1,2K Mai 26 18:22 taillog.js
ls -lha /etc/lighttpd
total 40K
drwxr-xr-x 5 lighttpd lighttpd 4,0K Aug 17 2019 .
drwxr-xr-x 146 root root 16K Mai 27 11:16 ..
drwxr-xr-x 2 lighttpd lighttpd 4,0K Aug 17 2019 conf-available
drwxr-xr-x 2 lighttpd lighttpd 4,0K Jul 18 2019 conf-enabled
-rw-r--r-- 1 lighttpd lighttpd 0 Mai 25 12:43 external.conf
-r-------- 1 lighttpd lighttpd 3,9K Sep 22 2019 lighttpd.conf
drwxr-xr-x 3 lighttpd lighttpd 4,0K Aug 16 2019 .pi-hole
ls -lha /var/run/lighttpd
total 0
drwxr-x--- 2 www-data www-data 60 Mai 27 14:41 .
drwxr-xr-x 32 root root 1,2K Mai 27 13:58 ..
srwxr-xr-x 1 www-data www-data 0 Mai 27 14:41 php.socket-0
Are the file permissions wrong?