Pi-Hole - Revision history

Kenneth: /* etc_dnsmasq_d */

2025-12-14T00:03:27Z

etc_dnsmasq_d

← Older revision		Revision as of 00:03, 14 December 2025
Line 184:		Line 184:

	Found under: Web interface -> Settings -> Advanced Settings (toggle) -> All Settings -> Miscellaneous settings		Found under: Web interface -> Settings -> Advanced Settings (toggle) -> All Settings -> Miscellaneous settings
			* /etc/pihole/pihole.toml

	== keywords ==		== keywords ==

Kenneth: /* Whitelist Only */

2025-12-14T00:02:38Z

Whitelist Only

← Older revision		Revision as of 00:02, 14 December 2025
Line 167:		Line 167:

	Ref: https://discourse.pi-hole.net/t/block-everything-allow-whitelisted-only/15782		Ref: https://discourse.pi-hole.net/t/block-everything-allow-whitelisted-only/15782

			== etc_dnsmasq_d ==

			<pre>
			# Should FTL load additional dnsmasq configuration files from /etc/dnsmasq.d/?
			#
			# Warning: This is an advanced setting and should only be used with care.
			# Incorrectly formatted or config files specifying options which can only be defined
			# once can result in conflicts with the automatic configuration of Pi-hole (see
			# /etc/pihole/dnsmasq.conf) and may stop DNS resolution from working.
			#
			# Allowed values are:
			# true or false
			etc_dnsmasq_d = true ### CHANGED, default = false
			</pre>

			Found under: Web interface -> Settings -> Advanced Settings (toggle) -> All Settings -> Miscellaneous settings

	== keywords ==		== keywords ==

Kenneth: /* Install */

2025-12-13T23:17:59Z

Install

@@ Line 17: / Line 17: @@
   or
   http://pi.hole/admin
 == Good List with Auto Updater ==

Kenneth: /* Good List with Auto Updater */

2025-10-12T20:55:22Z

Good List with Auto Updater

← Older revision		Revision as of 20:55, 12 October 2025
Line 31:		Line 31:

	Setup cron:		Setup cron:
	echo -e "0 /12 * *\troot /root/ya-pihole-list/adlists-updater.sh 1 >/dev/null" > /etc/cron.d/ya-pihole-list		echo -e "0 /12 * *\troot\t/root/ya-pihole-list/adlists-updater.sh 1 >/dev/null" > /etc/cron.d/ya-pihole-list

	== Commands ==		== Commands ==

Kenneth: /* Good List with Auto Updater */

2025-10-11T19:29:48Z

Good List with Auto Updater

@@ Line 22: / Line 22: @@
   JavanXD/ya-pihole-list: A bunch of useful pi-hole adlists and a auto updater.
   https://github.com/JavanXD/ya-pihole-list
 == Commands ==

Kenneth: /* Reset Admin Password */

2025-10-11T19:10:50Z

Reset Admin Password

← Older revision		Revision as of 19:10, 11 October 2025
Line 50:		Line 50:

	== Reset Admin Password ==		== Reset Admin Password ==

			Set the web console password

	New method:		New method:

Kenneth: /* Reset Admin Password */

2025-10-11T19:10:40Z

Reset Admin Password

← Older revision		Revision as of 19:10, 11 October 2025
Line 51:		Line 51:
	== Reset Admin Password ==		== Reset Admin Password ==

	pihole ~~-a -p~~		New method:
			pihole setpassword <PASSWORD>

	ref: https://discourse.pi-hole.net/t/how-do-i-set-or-reset-the-web-interface-password/1328		---

			<s>Old method:
			pihole -a -p</s>

			<s>ref: https://discourse.pi-hole.net/t/how-do-i-set-or-reset-the-web-interface-password/1328</s>

	== Reset Stats ==		== Reset Stats ==

Kenneth: /* Reset Password */

2025-02-23T21:40:36Z

Reset Password

← Older revision		Revision as of 21:40, 23 February 2025
Line 49:		Line 49:
	http://10.0.0.10:89/admin/		http://10.0.0.10:89/admin/

	== Reset Password ==		== Reset Admin Password ==

	pihole -a -p		pihole -a -p

Kenneth: /* Query History */

2024-07-29T06:10:50Z

Query History

← Older revision		Revision as of 06:10, 29 July 2024
Line 102:		Line 102:
	Search for domains with GOOGLE in them:		Search for domains with GOOGLE in them:
	$ sqlite3 pihole-FTL.db "SELECT * from queries WHERE domain like '%GOOGLE%' ORDER by timestamp desc"		$ sqlite3 pihole-FTL.db "SELECT * from queries WHERE domain like '%GOOGLE%' ORDER by timestamp desc"

			Show last 100 records with date (formatted), domain, and client
			$ sqlite3 pihole.db "select date(timestamp, 'unixepoch'), domain, client from queries limit 100"
			2024-01-13\|wpad.mydomain.com\|10.0.0.5
			...

	== Clear Logs ==		== Clear Logs ==

Kenneth: /* Reset Stats */

2024-07-29T06:02:52Z

Reset Stats

← Older revision		Revision as of 06:02, 29 July 2024
Line 63:		Line 63:

	Ref: https://discourse.pi-hole.net/t/how-can-i-reset-all-pihole-stats/7749		Ref: https://discourse.pi-hole.net/t/how-can-i-reset-all-pihole-stats/7749

			== Query History ==

			Show tables:
			sqlite3 pihole-FTL.db ".tables"
			<pre>
			addinfo_by_id counters ftl network_addresses
			aliasclient domain_by_id message queries
			client_by_id forward_by_id network query_storage
			</pre>

			Show queries tables schema:
			<pre>
			$ sqlite3 pihole-FTL.db ".schema queries"
			CREATE VIEW queries AS
			SELECT id, timestamp, type, status, CASE typeof(domain)
			WHEN 'integer' THEN (SELECT domain
			FROM domain_by_id d WHERE d.id = q.domain)
			ELSE domain END domain,CASE typeof(client)
			WHEN 'integer' THEN (SELECT ip FROM client_by_id c
			WHERE c.id = q.client) ELSE client END client,CASE typeof(forward)
			WHEN 'integer' THEN (SELECT forward FROM forward_by_id f WHERE f.id = q.forward)
			ELSE forward END forward,CASE typeof(additional_info) WHEN 'integer' THEN (SELECT content
			FROM addinfo_by_id a WHERE a.id = q.additional_info)
			ELSE additional_info END additional_info, reply_type, reply_time, dnssec
			FROM query_storage q
			/* queries(id,timestamp,type,status,domain,client,forward,additional_info,reply_type,reply_time,dnssec) */;
			</pre>

			Show last 10 entries queries table:
			<pre>
			$ sqlite3 pihole-FTL.db "select * from queries limit 10"
			1\|1705181665\|4\|2\|wpad.mydomain.com\|10.0.0.5\|8.8.8.8#53\|\|2\|0.0357\|0
			2\|1705181665\|4\|3\|google.com\|10.0.0.5\|\|\|2\|0.0\|0
			...
			</pre>

			Search for domains with GOOGLE in them:
			$ sqlite3 pihole-FTL.db "SELECT * from queries WHERE domain like '%GOOGLE%' ORDER by timestamp desc"

	== Clear Logs ==		== Clear Logs ==