Teleporter

Teleporter seems to import only adlists, nothing else.

Processed adlists (13 entries)
Processed audit log (0 entries)
Processed blacklist (exact) (0 entries)
Processed blacklist (regex) (0 entries)
Processed whitelist (exact) (0 entries)
OK

Exported on v4, imported to fresh install and up to date 5beta.

Were there entries in the audit log, blacklist, regex and whitelist?

Yes sir. All these are populated in my regular v4 pi-hole.Running the beta on a small selection of clients to test.

It seems to work for me. Could you send me your Teleporter file via PM? You may need to encapsulate it into another zip container for uploading it here.

pi-hole-teleporter_2020-02-20_02-05-17.tar.zip (3.1 KB)

Using exactly this file, I get the following:
Screenshot from 2020-02-21 19-19-12
The contained exact blacklist is in fact empty, so everything seems to work as excepted for me.

Please provide the output of pihole -v.

v4:
pi@raspberrypi:~ $ pihole -v
Pi-hole version is v4.3.2 (Latest: v4.3.2)
AdminLTE version is v4.3.3 (Latest: v4.3.3)
FTL version is v4.3.1 (Latest: v4.3.1)

v5b:
pi@raspberry:~ $ pihole -v
Pi-hole version is v4.3.2-425-g839fe32 (Latest: v4.3.2)
AdminLTE version is v4.3.2-428-gf13c52f (Latest: v4.3.3)
FTL version is vDev-1344c91 (Latest: v4.3.1)

This is the most recent version. Are there any errors visible in your lighttpd log files?

sudo tail /var/log/lighttpd/error.log
pi@raspberry:~ $ sudo tail /var/log/lighttpd/error.log
2020-02-21 16:20:04: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning:  SQLite3::exec(): cannot start a transaction within a transaction in /var/www/html/admin/scripts/pi-hole/php/database.php on line 102
2020-02-21 20:08:13: (server.c.2059) server stopped by UID = 0 PID = 1
2020-02-21 20:08:14: (server.c.1464) server started (lighttpd/1.4.53)
2020-02-21 20:08:14: (server.c.1493) WARNING: unknown config-key: alias.url (ignored)
2020-02-21 20:08:53: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning:  SQLite3::exec(): no such column: type in /var/www/html/admin/scripts/pi-hole/php/teleporter.php on line 257
2020-02-21 20:08:53: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning:  SQLite3::exec(): no such column: type in /var/www/html/admin/scripts/pi-hole/php/teleporter.php on line 257
2020-02-21 20:08:53: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning:  SQLite3::prepare(): Unable to prepare statement: 1, table domain_audit has no column named comment in /var/www/html/admin/scripts/pi-hole/php/database.php on line 140
2020-02-21 20:08:53: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning:  SQLite3::exec(): cannot start a transaction within a transaction in /var/www/html/admin/scripts/pi-hole/php/database.php on line 102
2020-02-21 20:08:53: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning:  SQLite3::exec(): cannot start a transaction within a transaction in /var/www/html/admin/scripts/pi-hole/php/database.php on line 102
2020-02-21 20:08:53: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning:  SQLite3::exec(): cannot start a transaction within a transaction in /var/www/html/admin/scripts/pi-hole/php/database.php on line 102
pi@raspberry:~ $

Ah, interesting. There is an SQLite3 binding error here. By chance, I've written some code earlier today that should fix this. Please try again importing your file after running

pihole checkout web fix/audit_log

Worked like a charm!

Processed adlists (13 entries)
Processed audit log (1 entries)
Processed blacklist (exact) (0 entries)
Processed blacklist (regex) (16 entries)
Processed whitelist (exact) (178 entries)
OK

1 Like

The fix has been merged into the beta code. Please go back on track using

pihole checkout web release/v5.0