Booe North Carolina genealogy books

My grandmother Sarah Alexander Pearce enjoyed genealogy. She most enjoyed researching the Booe surname (mostly from North Carolina), and created four books on the Booe surname.

They feature her ancestors:

Booe Genealogy Book Red Binding

SaAlPe Booe Genealogy red book (2015 May)

Booe Genealogy Book Blue Binding

SaAlPe Booe Genealogy blue book (2015 May)

Booe Genealogy Book III

SaAlPe Booe Genealogy book III (2015 May)

Booe Genealogy Book: Booe Who

SaAlPe Booe Genealogy Booe! Who? (2015 May)

Chinanethost.org Domain Registration Scam

This scam is so old I forgot about it. Goes back to at least 2010.

Basically, the scammer says they run a domain name registrar and noticed someone trying to buy .cn, .net.cn, .org.cn, and other variations of a domain name you already own.

At first, they imply that they want confirmation from you to block the sale of similar domain names. In reality, they want you to block the sale by buying the domains from them yourself.

Don’t fall for it. Very few can afford to by every top level domain variation of their domain name. Learn more about this scam here and here.

This is the version of the scam I received in 2022 July:

Subject: exampledomain From: [email protected] (It’s very urgent, therefore we kindly ask you to forward this email to your CEO. If you believe this has been sent to you in error, please ignore it. Thanks) Dear CEO, This is a formal email. We are the Domain Registration Service company in Shanghai, China. Here I have something to confirm with you. On July 7, 2022, we received an application from Hongmei Ltd requested “exampledomain” as their internet keyword and China (CN) domain names (exampledomain.cn, exampledomain.com.cn, exampledomain.net.cn, exampledomain.org.cn). But after checking it, we find this name conflict with your company name or trademark. In order to deal with this matter better, it’s necessary to send email to you and confirm whether this company is your distributor in China? Best Regards Robert Liu | Service & Operations Manager China Registry (Head Office) Tel: +86-2161918696 Fax: +86-2161918697 Mob: +86-13816428671 6012, Xingdi Building, No. 1698 Yishan Road, Shanghai 201103, China This email contains privileged and confidential information intended for the addressee only. If you are not the intended recipient, please destroy this email and inform the sender immediately. We appreciate you respecting the confidentiality of this information by not disclosing or using the information in this email.

If you want to setup mail filtering rules to block this particular scammer, here’s some email header information:

As you can see, this particular scammer is using valid SPF, DKIM, and DMARC records.

Keyboard Shortcuts for InPrivate, Incognito, and Private browsers on Windows

Most browsers have a mode you may use that will not remember your history or cookies when closed. For a Windows machine, these are their keyboard shortcuts.

How to Disable Ads on the Roku Home Screen

If you own a Roku streaming media player or Roku TV and want to disable the advertisements that occupy one-third of the Home screen, you will discover that Roku does not provide you a way to opt out.

According to How-To Geek, Roku makes more money from ads than it does selling hardware ($740 million in ad revenue in 2019).

Don’t be deterred. If you are technically savvy and motivated, this article documents how to engineer an ad-free Roku home screen — like this one.

Roku without ads on Home screen

A summary of what needs to be done (overview)

There is more than one way to remove Roku ads. If you are a talented technical engineer, this is what you are trying to accomplish.

  • Prevent your Roku from reaching a list of domains (see below)
  • Provide your Roku a fixed/static IP address
  • Prevent your Roku from using DNS port 53 for LAN to WAN queries

Settings within the Roku (easy)

Most of the steps that you will take to remove ads resides outside of the Roku. If you simply want a little more privacy and fewer customized ads, at least perform these easy steps on your Roku.

Roku Features to Disable:

  • Roku TV > Settings > Privacy > Advertising > Limit ad tracking (enabled)
  • Roku TV > Settings > Privacy > Advertising > Reset advertising identifier (do this often)
  • Roku TV > Settings > Privacy > Smart TV experience > Use info from TV inputs (not selected)
  • Roku TV > Settings > Privacy > Smart TV experience > Enable auto notification (not selected)
  • Roku TV > Settings > Home Screen > Featured Free > Hide
  • Roku TV > Settings > Home Screen > Movie Store and TV Store > Hide
  • Roku TV > Settings > Home Screen > My Offers > Hide

Block these domains (medium)

Using some network capturing tools, I logged about fifty unique IP addresses the Roku attempts to access within the first two minutes of it powering on. Blocking them all would result in a loss of functionality. Instead, you want to prevent the Roku from accessing just the following domains (LAN to WAN traffic).

  • ads.roku.com
  • amarillo.logs.roku.com
  • amoeba-plus.web.roku.com
  • austin.logs.roku.com
  • bryan.logs.roku.com
  • camden.logs.roku.com
  • cloudservices.roku.com
  • cooper.logs.roku.com
  • customer-feedbacks.web.roku.com
  • digdug-g2.logs.roku.com
  • digdug.logs.roku.com
  • display.ravm.tv
  • esp.logs.roku.com
  • giga.logs.roku.com
  • gilbert.logs.roku.com
  • griffin.logs.roku.com
  • hereford.logs.roku.com
  • i.ads.roku.com
  • identity-dev.ads.roku.com
  • identity.ads.roku.com
  • lagrange.logs.roku.com
  • liberty.logs.roku.com
  • littlefield.logs.roku.com
  • logs.roku.com
  • longview.logs.roku.com
  • midland.logs.roku.com
  • mobile.logs.roku.com
  • p.ads.roku.com
  • paolo.logs.roku.com
  • raps-perf.ravm.tv
  • raps.ravm.tv
  • ravm.tv
  • richmond.logs.roku.com
  • rollingwood.logs.roku.com
  • rxr.ravm.tv
  • samples.voice.cti.roku.com
  • scribe.logs.roku.com
  • sugarland.logs.roku.com
  • traces.sr.roku.com
  • track.sr.roku.com
  • tyler.logs.roku.com
  • victoria.logs.roku.com
  • windsor.logs.roku.com
  • wwwimg.roku.com

Perhaps the easiest way to do this is to use either NextDNS.io or a Raspberry Pi Pi-Hole as your DNS provider, and subscribe to the Lightswitch05 Ads & Tracking block list. All of the domains above, except for amoeba-plus.web.roku.com and wwwimg.roku.com (in bold) were already included in Lightswitch05’s block list at the time of writing.

I accomplished DNS filtering by installing ASUSwrt-Merlin on my home router. I then configured my router to use NextDNS.io as the router’s DNS-over-TLS / DNS-over-HTTPS source. Using NextDNS.io at the router level will help you block ads for all devices on your home network, not just your Roku.

Here’s how I configured my home router to use NextDNS.io.

ASUS Merlin NextDNS.io settings

And how I configured NextDNS.io to filter out most Roku ads and tracking.

  • NextDNS.io > Privacy > Blocklists > Add > Lightswitch05 Ads & Tracking
  • NextDNS.io > Privacy > Native Tracking Protection > Add > Roku
  • NextDNS.io > Denylist > Add > amoeba-plus.web.roku.com (missing from Lightswitch05)
  • NextDNS.io > Denylist > Add > wwwimg.roku.com (missing from Lightswitch05)

NextDNS Roku Settings

Optionally, if you prefer to roll your own DNS filtering solution, build a Pi-Hole or install Diversion via AMTM on your ASUSwrt-Merlin router.

Once you have a DNS filtering solution in place and have configured your home router to use it, all devices on your network should (by default) have their DNS traffic filtered. Except for the Roku, of course, which has hard coded its own public DNS source for some of its queries.

Provide your Roku a static/fixed IP address (medium)

To perform the last step, which involves creating firewall rules, you need to first provide your Roku a static IP address. I accomplish this by letting DHCP provide the Roku a dynamic IP address, and then configure my router to always reserve that IP for the Roku.

ASUS merlin manually assigned IP

Firewall LAN to WAN Port 53 (hard)

DNS queries traditionally use Port 53 via TCP or UDP. You want to force your Roku to always use your router (and thus NextDNS or Pi-Hole) for all of its DNS queries.

In order to prevent your Roku from quering Google’s public DNS servers at 8.8.8.8 and 8.8.4.4 directly, you’ll need to configure a network firewall to block LAN to WAN traffic over Port 53 (TCP and UDP).

How to do this differs for each router. Here’s how I did it using ASUSwrt-Merlin.

  • ASUSwrt-Merlin > Firewall > Network Services Filter > Enable
  • ASUSwrt-Merlin > Firewall > Network Services Filter Table > add these two entries
  • Entry 1 > Source IP (the static LAN IP address of your Roku), Destination Port Range 53, Protocol TCP
  • Entry 2 > Source IP (the static LAN IP address of your Roku), Destination Port Range 53, Protocol UDP

Asus Merlin Network Service Filter Port 53

That should do it. Reboot your router to clear your DNS cache then reboot your Roku. Hopefully you will be rewarded with an ad-free Roku.

Closing

Removing Roku ads will take some work. And for some of these steps, like installing ASUSwrt-Merlin or a Pi-Hole, take some effort and require specific hardware you might not yet own. There are likely other ways to perform these steps on your own hardware — but I leave that to you. You know what needs to be done, and now just have to figure out how to do so if you want an ad-free Roku.

EFF Dice-Generated Passphrases via Microsoft Excel or Google Sheets

In 2016, the Electronic Frontier Foundation created some enhancements over the original Diceware Passphrase list by creating the EFF Dice-Generated Passphrases list. This post is my effort to use Microsoft Excel or Google Sheets to semi-randomly generate random passwords by using the EFF’s Long Wordlist [.txt].

Please note, while I am an IT professional, I’m not a cryptographer or mathematician. The passwords generated via these Microsoft Excel formulas are semi-random. They represent a good-enough approach to creating passwords users can memorize. Use passed.pw or LastPass’ Password Generator for longer passwords that contain more entropy. As always, use a good password manager and enable multi-factor authentication when available.

TL/DR: Links to the live Microsoft Excel and Google Sheets worksheets

If you just want some semi-randomly generated passphrases based on the EFF Large Wordlist, select either of these read-only publicly-accessible links.

Results

This is what you’ll find: 10- to 16-character easy-to-remember semi-random passphrases. Refresh your browser (F5) to generate a new round of passphrases.

Screenshot

A screenshot of the EFF Dice-Generated Passphrases via Microsoft Excel.

EFF Dice-Generated Passphrase via Microsoft Excel
EFF Dice-Generated Passphrase via Microsoft Excel

Example

Here is a static example of the semi-random passphrases these worksheets randomly create.

14Good14Better15Good15Better16Good16Better
DarnLungScuff1stoic-UNWIND-8GoryKudosStove0tidbit-FOOTSIE-4GiftRelicHuddle6baggie-WOMANLY-1
IckyLionCacti1pagan-PRECUT-9EpicAlbumVerse4stingy-ARMBAND-8ShunWharfBootie3varied-SCALLOP-8
GrubLifeSkies8humid-STINKY-2MoveClassPurge3sudoku-HAGGLER-0IconGauzeEclair5lively-SHELTER-8
RushWindZesty7shape-JAILER-9OvenAptlyFruit5tattoo-SLOUCHY-9DawnVersePurple6affirm-CONDONE-4
RiftLateTweak7mummy-CLAMMY-9JeepPhonyFetal5drudge-CLOTHES-0OmitBakedStress9idiocy-SWOONED-5
TallBlipUsher2crock-CUDDLE-0WishCacheChest1tinker-PROWLER-2VoidAtlasGravel1panama-IMPLANT-6
BathHaltKooky8shock-DELETE-8HateBootsPesky0violet-RUBDOWN-9DialEruptTaking2deeply-SCROOGE-1
JawsLarkSandy0grape-CIRCUS-2RakeEruptRigor0myself-SKYWARD-3DoleUsherTissue0idiocy-MUSTANG-6
DarnLeftChaos6visor-WANTED-6HateDingoIdiom4saloon-CLATTER-4LurkTiaraHarbor2awaken-DENSITY-8
HurtEbayYield0couch-GANDER-4GulpBunnyDecaf9unholy-PROWESS-5OozyJuicyGrudge1specks-OUTLOOK-5

How it works

The essential components to using Microsoft Excel or Google Sheets to generate semi-random passphrases are:

You will find a few more hidden sheets of data (like city names or shorter versions of the EFF dice words) that you may use if you want to customize your own formulas. Please, do make a copy of either worksheet and modify to meet your needs.

Formulas

My files generate 10- to 16-character passphrases. The 10Good column contains a 10-character passphrase of lowercase, uppercase and numbers. The 10Better column simply adds punctuation. Please look at the examples above to get a good idea.

Good Formula

This Excel formula does not include punctuation.

=INDEX(DataEFFLong1!$F$84:$F$550,RANDBETWEEN(1,ROWS(DataEFFLong1!$F$84:$F$550)),1)
&INDEX(DataEFFLong1!$F$551:$F$1478,RANDBETWEEN(1,ROWS(DataEFFLong1!$F$551:$F$1478)),1)
&CHAR(RANDBETWEEN(48,57))

There are two INDEX functions that use the RANDBETWEEN function to select a random EFF word from a range of words that are pre-sorted by how many characters are in each word; followed by a CHAR function that uses the RANDBETWEEN function to select a random number.

Better Formula

This Excel formula adds punctuation. In cell B14, I use this formula to select a semi-random delimiter from the ASCII table (characters , – . /).

=CHAR(RANDBETWEEN(44,47))

Then I simply include this semi-randomly selected punctuation into the formula.

=INDEX(DataEFFLong1!$E$2:$E$83,RANDBETWEEN(1,ROWS(DataEFFLong1!$E$2:$E$83)),1)
&$B$14
&INDEX(DataEFFLong1!$D$84:$D$550,RANDBETWEEN(1,ROWS(DataEFFLong1!$D$84:$D$550)),1)
&$B$14
&CHAR(RANDBETWEEN(48,57))

The result is that the user must only memorize a single punctuation value and number — along with the EFF dice words — to memorize their password.

Again, these passphrases have less entropy than passed.pw randomly-generated passwords like “U7p2uk>R,v)]HTRc”; but they are easier to memorize and should be sufficient when also protected by multi-factor authentication.

Google Sheets formulas

The formulas that Google Sheets’ uses to produce the same results as Microsoft Excel are different, but the concept is the same. Google uses ARRAY_CONSTRAIN and ARRAYFORMULA to wrap the original Excel formulas.

=ARRAY_CONSTRAIN(ARRAYFORMULA(INDEX(DataEFFLong1!$F$84:$F$550,RANDBETWEEN(1,ROWS(DataEFFLong1!$F$84:$F$550)),1)
&INDEX(DataEFFLong1!$F$551:$F$1478,RANDBETWEEN(1,ROWS(DataEFFLong1!$F$551:$F$1478)),1)
&CHAR(RANDBETWEEN(48,57))), 1, 1)

Closing

Feel free to use these worksheets as is. Optionally, add your own data sources and modify the formulas to better meet your needs.