Skip to content

Instantly share code, notes, and snippets.

View xavierzwirtz's full-sized avatar

Xavier Zwirtz xavierzwirtz

  • BirdDog Software
  • Oklahoma City
View GitHub Profile
@xavierzwirtz
xavierzwirtz / gist:d2e56640922320f0d944750ac65fa727
Created March 25, 2020 23:02
include "/etc/bind/rndc.key";
controls {
inet 127.0.0.1 allow {localhost;} keys {"rndc-key";};
};
acl cachenetworks { 127.0.0.0/24; ::1/128; localhost; 192.168.1.0/24; };
acl badnetworks { };
options {
listen-on { any; };
@xavierzwirtz
xavierzwirtz / gist:e6fd42cf50f3d295ec9792f1a895ecd8
Created March 25, 2020 22:50
include "/etc/bind/rndc.key";
controls {
inet 127.0.0.1 allow {localhost;} keys {"rndc-key";};
};
acl cachenetworks { 127.0.0.0/24; };
acl badnetworks { };
options {
listen-on { any; };
@xavierzwirtz
xavierzwirtz / gist:8948b1a95e3200dd3da2a4810a2d679b
Created March 25, 2020 22:36
include "/etc/bind/rndc.key";
controls {
inet 127.0.0.1 allow {localhost;} keys {"rndc-key";};
};
acl cachenetworks { 127.0.0.0/24; };
acl badnetworks { };
options {
listen-on { any; };
@xavierzwirtz
xavierzwirtz / gist:ac90f7cfcd70bbdb234c955c61982c4b
Created March 25, 2020 22:27
dig demoalias.atlas.birddogsw.local 192.168.1.25
; <<>> DiG 9.14.9 <<>> demoalias.atlas.birddogsw.local 192.168.1.25
;; global options: +cmd
;; Got answer:
;; WARNING: .local is reserved for Multicast DNS
;; You are currently testing what happens when an mDNS query is leaked to DNS
;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 26799
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1
@xavierzwirtz
xavierzwirtz / gist:dbe90b4336e0845d944eab9cb0808727
Created March 25, 2020 22:25
dig demoalias.atlas.birddogsw.local
; <<>> DiG 9.10.3-P4-Ubuntu <<>> demoalias.atlas.birddogsw.local
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 14934
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4000
@xavierzwirtz
xavierzwirtz / gist:966ab0193ed5e3b5e1d7344a086827e4
Created March 25, 2020 22:14
dig demoalias.atlas.birddogsw.local atlas.birddogsw.local
; <<>> DiG 9.14.9 <<>> demoalias.atlas.birddogsw.local atlas.birddogsw.local
;; global options: +cmd
;; Got answer:
;; WARNING: .local is reserved for Multicast DNS
;; You are currently testing what happens when an mDNS query is leaked to DNS
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 54741
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1
@xavierzwirtz
xavierzwirtz / gist:3fae10ceadb9aa848b388c22111c7114
Created March 25, 2020 21:55
[nix-shell:~]$ dig nix-cache.atlas.birddogsw.local atlas.birddogsw.local
; <<>> DiG 9.14.9 <<>> nix-cache.atlas.birddogsw.local atlas.birddogsw.local
;; global options: +cmd
;; Got answer:
;; WARNING: .local is reserved for Multicast DNS
;; You are currently testing what happens when an mDNS query is leaked to DNS
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 43720
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1
@xavierzwirtz
xavierzwirtz / gist:693b755fa333e0381d8a6c9871a40092
Created March 25, 2020 21:43
; <<>> DiG 9.14.9 <<>> nix-cache.atlas.birddogsw.local 192.168.1.180
;; global options: +cmd
;; Got answer:
;; WARNING: .local is reserved for Multicast DNS
;; You are currently testing what happens when an mDNS query is leaked to DNS
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 50284
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4000
@xavierzwirtz
xavierzwirtz / doc.md
Created January 29, 2020 00:58

So your system is on fire

First, check the BDTriggerAudit tables record counts:

select @sql
EXEC (@SQL)
GO
--SET ANSI_NULLS ON
--GO
@xavierzwirtz
xavierzwirtz / gist:dc6a81ec2759979563995b77448e150b
Created January 29, 2020 00:07
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[bd_purge_audit]
AS
DECLARE @SQL varchar(max)=''
select @SQL = @SQL + '
SET NOCOUNT ON;