hi
is it possible to connect and read pi hole databases with a gui soft like sqlyog ou phpmyadmin.
it would be very useful
what are the name of the user and the passwords of the databases ?
Bee cool if it is a stupid question. I am a newbee ?
thanks
Bernard
First part sure:
pi@ph5:~ $ rm -f /tmp/f; mkfifo /tmp/f
pi@ph5:~ $
pi@ph5:~ $ cat /tmp/f | sqlite3 /etc/pihole/pihole-FTL.db 2>&1 | nc -l -p 3306 > /tmp/f
.
dehakkelaar@laptop:~$ nc 10.0.0.4 3306
.databases
main: /etc/pihole/pihole-FTL.db
.tables
counters message network_addresses
ftl network queries
.schema network_addresses
CREATE TABLE IF NOT EXISTS "network_addresses" ( network_id INTEGER NOT NULL, ip TEXT UNIQUE NOT NULL, lastSeen INTEGER NOT NULL DEFAULT (cast(strftime('%s', 'now') as int)), name TEXT, nameUpdated INTEGER, FOREIGN KEY(network_id) REFERENCES network(id));
SELECT ip FROM network_addresses;
10.0.0.1
10.0.0.109
10.0.0.11
10.0.0.143
10.0.0.193
10.0.0.2
10.0.0.220
10.0.0.3
10.0.0.4
10.0.0.46
10.0.0.9
127.0.0.1
::1
fe80::f9d3:c02b:a14d:3318