Commit Graph

1417 Commits (master)

Author SHA1 Message Date
DL6ER 57fe3b6621
Merge pull request #3951 from pi-hole/new/gravity_adlist_infos
3 years ago
Christian König 78027bd2bf Add default noname if hostname is empty
3 years ago
Christian König 7dc7cbb80e Add hostname to teleporter backup file if called from cli
3 years ago
Alexander Schmitz 1ab193fa9d
Update piholeDebug.sh
3 years ago
freddii 7c0c30fb0b fixed typos
3 years ago
Andras Tim bfee230c79 scripts/list: User same wildcard regex that the UI use
3 years ago
DL6ER 1791fe22f6
Merge pull request #3912 from mdujava/basic_auth
3 years ago
DL6ER e033ee6664
Fix connection mechanism between Chronometer and FTL
3 years ago
DL6ER 6b33b8b4c0
Store status of downloaded list (downloaded, using cache, some error, ...) and number of (in-)valid domains on this list in the gravity database. This updates the gravity databaes to version 14.
3 years ago
Matej Dujava ef0bdf6470 Fix validation of adlist url
4 years ago
DL6ER 41479524f8
Merge pull request #3900 from ganto/fix/chrono-non-lte
4 years ago
Adam Warner 357b6702ec
Update advanced/Scripts/chronometer.sh
4 years ago
DL6ER 78cdd34992
Merge pull request #3904 from ganto/fix/debug-non-web-2
4 years ago
Reto Gantenbein 9dc539c98b piholeDebug: More detailed diagnostics if Web interface is not found
4 years ago
Reto Gantenbein 18e4eb460c piholeDebug: Fix version check if lighttpd/php are not installed
4 years ago
Reto Gantenbein e841347057 Fix chronometer output if web interface is not installed
4 years ago
Adam Warner 8443262214
Merge pull request #3890 from ganto/fix/x86-64-arch
4 years ago
DL6ER 36937b1913
Strip such lines starting with a #. Do not silently truncate lines if they have a # somewhere in between (like server=127.0.0.1#5353)
4 years ago
Reto Gantenbein d0af1a950b Ensure x86_64 processor architecture is listed as supported
4 years ago
DL6ER a217c75134
Merge pull request #3882 from pi-hole/tweak/conditional_transforms
4 years ago
Adam Warner 454c9a411c
Update advanced/Scripts/webpage.sh
4 years ago
Adam Warner f44b2f6aa3
Update advanced/Scripts/webpage.sh
4 years ago
DL6ER 49810262db
When there is a Pi-hole domain set and "Never forward non-FQDNs" is ticked, we add to tell FTL that this domain is purely local and FTL may answer queries from /etc/hosts or DHCP but should never forward queries on that domain to any upstream servers
4 years ago
Adam Warner 58bc98ca44
Update advanced/Scripts/webpage.sh
4 years ago
Adam Warner 4093959d3e
Appease stickler
4 years ago
Adam Warner 06c5fe2a89
Set REV_SERVER_CIDR in the else condition if it is not in-addr.arpa
4 years ago
Adam Warner 6cb8f3f403
Add some comments
4 years ago
Adam Warner e004d27b28
Fix processing of CONDITIONAL_FORWARDING_REVERSE
4 years ago
Adam Warner d2e9a20d96
Merge pull request #3859 from yubiuser/tweak/debug_pihole-FTL_status
4 years ago
DL6ER d4c33e5188
Include the raw messages from the Pi-hole diagnosis systems in debug logs
4 years ago
Christian König 70c48afc04 Add else statement
4 years ago
Christian König ec5183b553 Rename function
4 years ago
Christian König 50316ee617 Add systemctl status --full --no-pager pihole-FTL.service to the debug log
4 years ago
Adam Warner 1c2c10c4a5
Merge pull request #3761 from BastiG/development
4 years ago
Adam Warner cd8120d33f
Add some output to the --nuke command
4 years ago
Adam Warner 4abd8196ae
Merge pull request #3349 from Forceflow/development
4 years ago
DL6ER 50100017a5
Merge pull request #3794 from pi-hole/security/non_FQDNs_locality
4 years ago
Adam Warner 59b0a6af6f
Remove references to privacy level 4 (no longer functional)
4 years ago
bcambl 47aa1644a8 add debug checking for firewalld
4 years ago
DL6ER 08a84e51d6
Only add local=/<domain>/ when the "only forward FQDN queries" function is enabled to prevent unintended side-effects of this change
4 years ago
DL6ER d631cd8b04
Security enhancement for the "never forward non-FQDNs" feature. This should prevent all local queries from being forwarded (will show up as blocked by regex) as well as any hostname without a domain (for example one word searches from the address bar in browsers). This fixes #3303
4 years ago
Adam Warner 0445559610
Accidentally a number (#3788)
4 years ago
Adam Warner 948337dd8e
Merge pull request #3740 from pi-hole/new/adlist_date_updated
4 years ago
Adam Warner fe463f15b3
Merge pull request #3741 from pi-hole/new/debug_scan_dhcp
4 years ago
Christian König 568ebd67ca Update comment
4 years ago
Christian König c628c970ae Print tail of logs in /var/log/lighttpd in debug run as well
4 years ago
Sebastian Gmeiner 8041bbf443 read REV_SERVER_CIDR from environment
4 years ago
DL6ER 41e899260f
Discover active DHCP servers during debugger run
4 years ago
DL6ER 12b9748c43
Fine-tune adlist:adte_modified trigger and don't default new date_updated column to now but use NULL instead
4 years ago
DL6ER 4fd412d7c3
Add date_updated field in adlist table set when a list changes.
4 years ago
Adam Warner b8cd238fa1
Update advanced/Scripts/piholeDebug.sh
4 years ago
Adam Warner 8e219cb799
Make output more meaningful in case of dig failure.
4 years ago
Dan Schaper ebdb68a47a
display_warning fixes
4 years ago
Dan Schaper 623ce1fe18
Tabs and debug.sh
4 years ago
Adam Warner bb1a6243d6
Merge pull request #3669 from pi-hole/release/v5.1.2
4 years ago
Samuel Boucher d4dd446ba3 Update advanced/Scripts/chronometer.sh
4 years ago
Samuel Boucher 8b4921405a Upercase the temp_unit
4 years ago
Aiden Mitchell 7c53b97004
Updating FAQ_HARDWARE_REQUIREMENTS and FAQ_HARDWARE_REQUIREMENTS_PORTS (#3632)
4 years ago
Adam Warner f50cff54de
*innocent whistling*
4 years ago
Adam Warner 849139176e
fallback to NC if curl fails on uploadgit checkout
4 years ago
Adam Warner b8bba7951f
Just one more newline, give it to me.
4 years ago
Adam Warner 76ce5ec66b
Add additional information about local debug log location
4 years ago
Adam Warner 7b41b99549
Merge pull request #2887 from tlk/fix/reenable
4 years ago
XhmikosR d8822b70cf Fix minor typo
4 years ago
Adam Warner 3205606fc3
Also validate IPV6 in the `setdns` function
4 years ago
Dan Schaper 3aaf9d89b3
Merge pull request #3260 from pi-hole/new/rev-server
4 years ago
DL6ER 2c3aa9ab00
Merge pull request #3491 from pi-hole/fix_ip_address_section
4 years ago
DL6ER 9bf0f2a161
Reduce handholding when trying to foresee the intentions of the user. The code does now preserve legacy behavior and users can open up the subnet manually if they like.
4 years ago
Adam Warner 7ea6d7b92b
remove ; so IFS changes don't stick
4 years ago
Adam Warner 011fa8c6ea
fix sticklr complaint
4 years ago
Adam Warner 0320d85028
Additionally source the install script in webpage.sh to validate IP entered on `pihole -a setdns`
4 years ago
Dan Schaper 5f9dac8d2b
Merge pull request #3434 from pi-hole/new/os_detect
4 years ago
Adam Warner 03a8cff55e
read > mapfile as suggested by @dschaper
4 years ago
DL6ER 2b1bc6a46e
Replace possible "\#" by "#". This fixes AdminLTE#1427
4 years ago
DL6ER 6160eb6894
This regex is too complex for bash's own replacement. Add ignore for the shellcheck rule.
4 years ago
DL6ER 318ca75269
Merge branch 'development' into new/rev-server
4 years ago
Adam Warner 58724a38a9
Improve detection and display of supported/unsupported OS in debug script
4 years ago
XhmikosR 7579ab178a Update links
4 years ago
Thomas L. Kjeldsen 903808a477 Improved explanation of why this script is needed
4 years ago
Thomas L. Kjeldsen 005da06b3d Use PI_HOLE_BIN_DIR as introduced in PR #2886
4 years ago
Thomas L. Kjeldsen 852f6b95f5 Prevent "pihole disable $timeout" from messing up future state changes
4 years ago
DL6ER b60ec8a48f
Merge pull request #3248 from MichaIng/patch-8
4 years ago
DL6ER 27f0fd2372
Merge pull request #3415 from fhriley/reload_privacy
4 years ago
Adam Warner d0e250a616
Ensure pihole-FTL.conf is parsed, as well as external.conf for lighttpd, to rule out any custom modifications.
4 years ago
Adam Warner b2ba55c27b
Show details of any remotes on the git repositories
4 years ago
Frank Riley 9d04c517e6 Reload the lists, which will cause the cached privacy level to be updated.
4 years ago
DL6ER b421e422c2
Merge pull request #3351 from marank/development
4 years ago
MichaIng 5c17e41cf1 Start pihole-FTL after network
4 years ago
Dan Schaper c76435883b
Merge pull request #3360 from dnicolson/fix-github-capitalisation
4 years ago
Dave Nicolson ab753e88a2 Fix GitHub capitalisation
4 years ago
Adam Warner be25b4d9c4
Merge pull request #3352 from pi-hole/merge-master-dev
4 years ago
Adam Warner 9e96ff37de
Fix merge conflicts
4 years ago
DL6ER a9c66c7b45
Implement pihole -a theme option
4 years ago
Matthias Rank 2b9898e9ca Fixed indentation
4 years ago
Matthias Rank 0add5eb291 Added support for CNAME record add/remvoe
4 years ago
Jeroen Baert 4cf241b42b Fix for pihole -w --nuke displaying help info even if command is executed correctly
4 years ago
DL6ER 7cc35d3b04
Add update to gravity database version 12, renaming the Unassociated group to Default group.
4 years ago
DL6ER 78469ee58d
Merge pull request #3255 from pi-hole/tweak/emailregex
4 years ago
Adam Warner 369288cc48
Update advanced/Scripts/webpage.sh
4 years ago
Dan Schaper 017d405b28
Merge pull request #3307 from pi-hole/tweak/debugger_type_display
4 years ago
DL6ER ddb354f78b
Add enable indentation for the domainlist
4 years ago
DL6ER 20ef5e0264
Show associated group IDs in domains/clients/adlists listing. We get the data through a LEFT JOIN followed by a GROUPing by the left list ID and finialized through a GROUP_CONCATenation.
4 years ago
DL6ER ad5802715e
enabled field: Center 0, right-align 1
4 years ago
DL6ER 989bbad37e
Remove pihole -a hostrecord
4 years ago
DL6ER 63f6c6a894
Add indentation for enabled and type fields
4 years ago
Adam Warner d42785a3bf
Merge pull request #3271 from pi-hole/tweak/version
4 years ago
DL6ER 401c029dc4
Improve else condition of branch determination
4 years ago
DL6ER 0343171703
Add correct displaying for detached HEAD state.
4 years ago
DL6ER 176fbaf83b
Ask pihole-FTL for the branch it was compiled from instead of trusting the checkout file to be present.
4 years ago
Adam Warner 471006676c
Merge pull request #3227 from pi-hole/new/CLI_domain_comments
4 years ago
Adam Warner 3cc9ba4ee8
stickler Signed-off-by: Adam Warner <me@adamwarner.co.uk>
4 years ago
Adam Warner 6dc85c3527
Don't display branch name if it is on master.
4 years ago
Adam Warner 851947bbf2
Add branch name to version output
4 years ago
DL6ER 093054a1eb
Automatically convert legacy IP range to Class C network
4 years ago
DL6ER 4130af0aab
Retain rev-server settings when the feature gets disabled.
4 years ago
DL6ER 90a5a13197
Convert CONDITIONAL_FORWARDING to REV_SERVER settings. Try to detect intended CIDR range automatically.
4 years ago
DL6ER 982c1b0059
Merge branch 'release/v5.0' into development
4 years ago
Adam Warner 26f71e4dbe
accidentally a space
4 years ago
Adam Warner b6ac1585ec
add regex attribution
4 years ago
Adam Warner a9b19df4ec
expand email validation regex to catch more valid emails see comments on PR #3254
4 years ago
M4x 2de5362adc
Sanitize email address in case of security issues (#3254)
4 years ago
DL6ER d1caad76d8
Do not flush neigh cache as this is known to create a number of issues. The better aproach to this is to manually flush the ARP cache by either restarting or calling "ip neigh flush all".
4 years ago
Adam Warner 7d19ee1b25
validate blocklist URL before adding to the database (#3237)
4 years ago
DL6ER 277179f150 Remove 19036 trust anchor, now expired: https://www.icann.org/resources/pages/ksk-rollover
4 years ago
DL6ER 15a9d662ac Add option --comment "whatever" for adding comments for new domains through the CLI interface.
4 years ago
XhmikosR 7b8611ced0
Assorted typo fixes. (#3126)
4 years ago
DL6ER 497bfd80a5
Update development from release/v5.0 (#3200)
4 years ago
DL6ER 22ce5c0d70
Fix incorrect type description. (#3201)
4 years ago
Dan Schaper bf4fada3b7
Don't quote inside backticks, use unquoted variable.
4 years ago
Dan Schaper 360d0e4e6b
Loop through array of lists.
4 years ago
Dan Schaper 4f390ce801
Use bash regex instead of awk.
4 years ago
Adam Warner 8ecaaba247
Compare daemons to expected results. (#3158) (#3159)
4 years ago
Adam Warner 4a5f344b09
then
4 years ago
Adam Warner af95e8c250
force `updatchecker.sh` run if any of the three components are updated
4 years ago
Dan Schaper c5c414a7a2
Stickler Lint - quote to prevent splitting
4 years ago
DL6ER d0e29ab7b0 Add human-readable output of time of the last gravity run.
4 years ago
DL6ER 714a79ffce Migrate debugger to domainlist and add printing of client table.
4 years ago
DL6ER cd3ad0bdc7 Show info table instead of counting domains to speed up the debugging process on low-end hardware drastically.
4 years ago
DL6ER 92aa510bda
Add timestamps and comment fields to clients. This updates the gravity database to version 11.
4 years ago
Dan Schaper 52e2a2610e
Merge pull request #3089 from pi-hole/tweak/gravity_db_10
4 years ago
DL6ER 3f9e79f152
Print human-readable timestamps in the debugger's gravity output
4 years ago
DL6ER 633e56e8a9
Add gravity database 9->10 update script.
4 years ago
DL6ER bb30c818ab
Update database version during migration.
5 years ago
Adam Warner c944f6a320
Add a new migration script to fix the previous one
5 years ago
Adam Warner aa4c0ff329
Don't create trigger with duplicate name until after old table is deleted
5 years ago
DL6ER 37217ece73
Merge pull request #3049 from pi-hole/tweak/unique_group_name
5 years ago
DL6ER cda0133dd1
Revert "Change the regex used for domain validation"
5 years ago
DL6ER eda7f40fef
Reinstall trigger that prevents group zero from being deleted.
5 years ago
DL6ER e589e665a7
Also add date_added and date_modified fields to group table.
5 years ago
DL6ER b32b5ad6e9
Update gravity database to version 8. This enforces uniqueness on the group name.
5 years ago
DL6ER e2de199f47
Merge pull request #3037 from pi-hole/new/group_zero
5 years ago
DL6ER a1633123aa
Merge pull request #3035 from pi-hole/fix/query_gravity
5 years ago
DL6ER 2444296348
Again, Mr. Stickler
5 years ago
DL6ER 4be7ebe61f
Scan domainlist instead of view to also catch disabled domains.
5 years ago
DL6ER a720fe1789
Add client trigger.
5 years ago
DL6ER f0439c8d12
Add special group zero to gravity database.
5 years ago
DL6ER 40e8657137
Please Mr. Stickler
5 years ago
DL6ER 52dd72dfa5
Ensure output is always correct and also display if domain has been found but is disabled
5 years ago
DL6ER 922ce7359c
pihole -q should also scan gravity table
5 years ago
DL6ER 69a909fc4c
On modification of lists, we should send real-time signal 0 instead of SIGHUP. This also preserves the DNS cache of not-blocked domains.
5 years ago
DL6ER f482156cca
Merge branch 'development' into new/internal-blocking
5 years ago
DL6ER 807a5cfb23
Merge pull request #3015 from pi-hole/tweak/domainlist_table
5 years ago
Adam Warner eaf1244932
:dominik: Detect binary name before calling FTLcheckUpdate in update.sh
5 years ago
DL6ER b6cd7b8e3d
Use more descriptive names instead of directly using the IDs in list.sh
5 years ago
Adam Warner 869473172c
remove _ from regex descibers
5 years ago
Adam Warner 63e407cfdc
Update advanced/Scripts/list.sh
5 years ago
Adam Warner 0251117c77
Update advanced/Scripts/list.sh
5 years ago
Adam Warner 44e1455b12
Update advanced/Scripts/list.sh
5 years ago
Adam Warner 76460f01e9
Change the regex used for domain validation
5 years ago
Adam Warner 4b8a72fda7
functionise parameter discovery
5 years ago
Adam Warner edaee4e962
remove redundant function and comments
5 years ago
Adam Warner 77bfb3fb67
tidy up variable usage in list.sh Remove some that are redundant
5 years ago
Adam Warner 6a881545b0
tweak wording Signed-off-by: Adam Warner <me@adamwarner.co.uk>
5 years ago
Adam Warner d0de5fda30
Simplify removal of domain from one list when it is requested for another
5 years ago
DL6ER a1f120b2ff
Address stickler's complaint
5 years ago
DL6ER 185319d560
Unite four domain tables into a single domainlist table.
5 years ago
DL6ER 5c6dd3f6f4
Merge pull request #2978 from Mograine/patch-1
5 years ago
Adam Warner edcdf9f619
Merge pull request #3003 from pi-hole/fix/tbd
5 years ago
Mograine c809c34024 Add user feedback
5 years ago
DL6ER 037d52104a
New command "pihole -g -r" recreates gravity.db based on files backed up in /etc/pihole/migration_update. This is useful to restore a working version of the database when the user destroyed the original database. Also, update gravity.db to version 5 because of a fix we needed to implement.
5 years ago
Adam Warner eeb26e3975
Merge pull request #2990 from chrunchyjesus/unix-compliance
5 years ago
Adam Warner 12817c09bb
(Squashed commits)
5 years ago
Mograine b93628acb3 Merge branch 'development' of https://github.com/Mograine/pi-hole into patch-1
5 years ago
DL6ER 7f7b9d089c
Merge pull request #2965 from pi-hole/tweak/BackendChangesForAdlistComments
5 years ago
chrunchyjesus 476975540a
make some shebangs comply to posix standard
5 years ago
Mograine 193ff38ab3 Allow more precise deletion by passing ip as parameter
5 years ago
Pierre Ghiot f9d16c2b15 Update webpage.sh
5 years ago
John Krull c6f9fe3af2 Fix spelling of the word "permitting"
5 years ago
Adam Warner 5bac1ad58b
backend changes to allow comment when adding new adlist
5 years ago
DL6ER d883854aad
Use constant for long path.
5 years ago
DL6ER 756c99653e
Merge branch 'development' into new/internal-blocking
5 years ago
DL6ER 2e0370367c
Print when we upgrade gravity database version. This will make possibly failed upgrades easier to debug.
5 years ago
Adam Warner 61a40c1b43
merge devel into 4.3.2 And Resolve merge conflicts
5 years ago
DL6ER a27c7b1398
regex white- and blacklist views need to be re-created as well as we need the ID for storing internally whether or not we try to match a given regex for a specific client.
5 years ago
DL6ER 7b48431917
Add client_by_group table like we have for the other lists. It stores associations between individual clients and list groups.
5 years ago
DL6ER 1f36ec48e3
Add use-application-dns.net = NXDOMAIN in ProcessDNSSettings rather than in the template so we can ensure that it will survive config-renewals.
5 years ago
DL6ER ff08add7c0
Update vw_whitelist and vw_blacklist to return group_id alongside domain so we can filter if the current client wants to get this domain blocked or not.
5 years ago
DL6ER ffc91a6c81
Update view vw_gravity to only return domains from enabled adlists.
5 years ago
DL6ER a8af2e1837
Store domains without sorting and unifying them first. This allows us to preserve the relationship of the individual domains to the lists they came from.
5 years ago
DL6ER aed2e35bc0
Print messages only after removing possible matches in comments.
5 years ago
DL6ER a7b44426cd
Merge pull request #2838 from pi-hole/new/whitelist-regex-support
5 years ago
Dan Schaper b9fed8fca6
Merge pull request #2891 from niklasea/development
5 years ago
DL6ER d8eee47ca4
Add dhcp-ignore-names option when enabling DHCP service. We currently remove anything that starts with "dhcp-" to have a clean configuration and removed these lines without noticing when enabling the DHCP server.
5 years ago
Niklas Elmose Andersen a3e32d9a15 Properly escape domain regex
5 years ago
Niklas Elmose Andersen 989d1aff60 Restore and improve 'pihole -q' matching
5 years ago
Dan Schaper 03c65dd0e9
Convert hardcoded /usr/local/bin to variable
5 years ago
DL6ER 6faddfcd3d
Print timestamps in local time zone of the Pi-hole.
5 years ago
DL6ER 1820c2c598
Merge branch 'development' into new/whitelist-regex-support
5 years ago
DL6ER 23b688287f
Fix indentation in query.sh. No functional change in this commit.
5 years ago
DL6ER 42ccc1ef24
Add support for regex whitelist in "pihole -q".
5 years ago
DL6ER cc40c18f49
Wrap upgrade script commands in a transaction.
5 years ago
DL6ER b1838512b2
Explicitly select columns (and their order) when listing the databaes tables. Print timestamps translated to strings instead of printing the integer timestamps.
5 years ago
DL6ER 3e78ed95d4
Fix displaying options for table "group" in the debugger.
5 years ago
snapsl 20a839fef5 fixed local declaration before assignment
5 years ago
snapsl b2d8c4374b tweaked code style of webpage.sh
5 years ago
DL6ER dc93462d42
Group table has only two columns
5 years ago
DL6ER 6e2e825a5f
Rename options "pihole --whiteregex" to "pihole --white-regex" for the sake of readability. The same applied for "whitewild" -> "white-wild"
5 years ago
DL6ER af754e3fc4
Rearrange group tables directly next to the tables they refer to.
5 years ago
DL6ER 06860ed5b4
Group tables have only two columns.
5 years ago
DL6ER 09190c1735
Only check once for if this is a regex list or not.
5 years ago
DL6ER a95b473417
Rearranage if statements to ensure the proper output is shown for wildcard-style filters.
5 years ago
DL6ER 6f58d58cae
Add --whitewild to help texts and man pages.
5 years ago
DL6ER 40d0caa70b
Add undocumented --whitewild option that does the same --wild does for the whitelist.
5 years ago
DL6ER 0692be9bae
Fix small mistake in 2->3 upgrade script.
5 years ago
DL6ER 0d28dce326
Print group table contents in debug log.
5 years ago
DL6ER 96031214c6
Add support for whitelist regex filter management via CLI.
5 years ago
Mark Drobnak ab3f6dfcc6
Merge pull request #2831 from pi-hole/fix/block-page-adlists
5 years ago
Mark Drobnak 445127accc
Merge pull request #2832 from pi-hole/new/audit_database
5 years ago
DL6ER 420f60b5c7
Add timeout to migration script (1->2).
5 years ago
DL6ER 65fdbc85d5
Add timeout to migration script (2->3).
5 years ago
DL6ER 87f75c737a
Review comments.
5 years ago
DL6ER 5ff9052200
Review comments
5 years ago
Mcat12 b154dd5f07
Quote calls to read FTL config
5 years ago
DL6ER 0683842ec3
Fix typo in 2->3 migration script.
5 years ago
DL6ER 054c7a2c05
Create new table + view regex_whitelist + rename old regex table to regex_blacklist. This updates the gravity.db version to 3.
5 years ago
DL6ER 3d3fc2947e
Review comments
5 years ago
Mcat12 e8e5d4afda
Get file locations of FTL files from the config
5 years ago
DL6ER 8382f4d727
Rename table to domain_audit and simplify subroutine addAudit().
5 years ago
DL6ER be3e198f9a
Address linting errors.
5 years ago
DL6ER acc50b709e
Only migrate files once (domain and adlist lists druing initial creation of gravity.db auditlog.list on database upgrade from version 1 to 2.
5 years ago
DL6ER efe8216445
Fix further stickler complaint.
5 years ago
DL6ER 0405aaa3da
Review comments and fixing stickler complaints.
5 years ago
DL6ER 2fb4256f84
Rename table to "auditlist"
5 years ago
DL6ER 82476138c1
Instead of calling sqlite3 multiple times within a loop, we use the ability to add multiple rows within one INSERT clause. This is supported since sqlite3 3.7.11 (2012-03-20) and should be available on all systems.
5 years ago
DL6ER 5293beeb77
Update audit script to store domains in new database table.
5 years ago
DL6ER 0c8f5f1221
Remove comment field from audit table
5 years ago
DL6ER 4f4a12bb40
Upgrade database if necessary and store audit domains therein.
5 years ago
DL6ER 1dbe6c83c3
Add database upgrading mechanism for adding the audit table.
5 years ago
Mcat12 8d9ff550d4
Fix blockpage error if whitelisted, blacklisted, or regex filtered
5 years ago
Mark Drobnak 92c3c86be4
Merge pull request #2769 from pi-hole/new/arp-flush
5 years ago
DL6ER 7a1b6fd205
Merge branch 'development' into new/gravity.db_domain_groups
5 years ago
MMotti 04abcb71f6 Fix potential invalid result for pihole -q
5 years ago
DL6ER 1fe3507bc5
Adlists table was renamed to Adlist. Adapt further places in the code to match the new name.
5 years ago
DL6ER 6996ffa451
Also flush network_addresses table
5 years ago
DL6ER c1495b0fa8
Merge branch 'development' into new/arp-flush
5 years ago
MMotti bcf03647ef Add comment and remove blankspace
5 years ago
MMotti a9d0690f4d Change the case of some variables
5 years ago
MMotti 10fbed50f3 Shellcheck
5 years ago
MMotti 785f1fedd9 Tidy regexp queries
5 years ago
MMotti cf21efa103 Minor grammar changes
5 years ago
MMotti 7613e94ef6 Minor tweaks
5 years ago
MMotti b49c702f33 Consistency tweak
5 years ago
MMotti 09532638d5 Read from DB instead of regex.list
5 years ago
MMotti 97df6d7415 Stickler fix
5 years ago
MMotti 54bfaa28c1 Fix for regexp queries through pihole -q
5 years ago
Mark Drobnak d92ced6fb6
Merge pull request #2734 from pi-hole/fix/query_black_and_whitelists_database
5 years ago
DL6ER 9ddce88092
Review comments
5 years ago
DL6ER 44f8fcb600
We can print the table name without any extra check as we already returned early in case there are no results.
5 years ago
Mark Drobnak 814fdcf9b6
Merge pull request #2768 from pi-hole/fix/dhcp-ignore-names
5 years ago
DL6ER 5060605626
Print table name before entering the loop for the sake of simplicity
5 years ago
DL6ER 285e6fe090
Address lint complaints
5 years ago
DL6ER c3023fe681
Add new "pihole arpflush" command to flush both the ARP cache as well as the network table in pihole-FTL.db
5 years ago
DL6ER c5df104a66
Add dhcp-ignore-names option when enabling DHCP service. We currently remove anything that starts with "dhcp-" to have a clean configuration and removed these lines without noticing when enabling the DHCP server.
5 years ago
Mcat12 bfb99c361c
Note that the gravity size does not include the blacklist entries
5 years ago
Mcat12 5796054305
Increase ID column width to 4
5 years ago
Mcat12 a3e1473ac1
Set explicit column widths to prevent text from getting cut off
5 years ago
Mcat12 7b5fc60e00
Improve table formatting
5 years ago
Mcat12 807ce0af4e
Show whitelist, blacklist, and regexlist details
5 years ago
Mcat12 3f05efd60f
Add extra newline
5 years ago
Mcat12 03d93aa19a
Update debug script with gravity DB changes
5 years ago
Dan Schaper 7de6bbca61
Merge branch 'development' into release/v4.3
5 years ago
Mcat12 8e1bf6e3d4
Merge branch 'development' into new/gravitydb
5 years ago
mpiederiet 3220e2b978
Fix for preventing git error message in cron logs
5 years ago
DL6ER a904c183df
Use printf to escape domain content. This prevents possible SQL injection issues
5 years ago
DL6ER 5246b3e496
Explicitly escape backslash in ESCAPE clause. This has been suggested by Stickler bot.
5 years ago
DL6ER f80fdd7e83
Improve comments
5 years ago
DL6ER 6ba58896d2
Simplify code
5 years ago
DL6ER 3aa838bbe4
Implement black- and whitelist searching with SQL statements. We use the ESCAPE clause in the LIKE query as the underscore "_" wildcard matches any single character but we want to suppress this behavior (underscores can be legitimate part of domains)
5 years ago
Dan Schaper 5532df24e4
Pi-hole Debug - tricorder upload function calls
5 years ago
DL6ER 0bc112ce52
Query only those columns we actually use when showing domains on the CLI. Show date of last modification instead of addition date for domains.
5 years ago
DL6ER b372f808dd
Fix lint errors
5 years ago
DL6ER bc9b623638
Modify query.sh to use the gravity database
5 years ago
pvogt09 8a92fb24c4 Incorporates changes requested by @Mcat12
5 years ago
pvogt09 5c575e73c7 Adds world readable attribute to files created by Pi-hole to circumvent #2724
5 years ago
Mark Drobnak 6812e8880e
Merge pull request #2705 from pi-hole/fix/chronometer-refresh-arg
5 years ago
DL6ER efeba594ae
Add support for manipulating adlists from the CLI
5 years ago
DL6ER 126f7101ff
Add (optional) date_modified field and use vw_whitelist view in vw_blacklist
5 years ago
Mcat12 b320e74921
Improve argument handling
5 years ago
Mcat12 add5e4ca5e
Explicitly allow only -r and --refresh in argument handler
5 years ago
DL6ER b4ae142149
Remove printf escaping (we will realize it differently) and ensure we're using single quotes for strings (although double quotes are possible, too)
5 years ago