Category Archives: Tools

Let’s Encrypt Setup

The “Let’s Encrypt” setup process is very painless – Just clone a Git repo, run a comand, and edit some apache config files.

  1. sudo apt-get install git
  2.  sudo git clone https://github.com/letsencrypt/letsencrypt /opt/letsencrypt
  3. cd /opt/letsencrypt
  4. ./letsencrypt-auto –apache -d ccrossan.com -d www.ccrossan.com
  5. edit the sites-enabled config files so that the appropriate virtual host uses the correct ssl certs.
  6. delete the newly generated ssl.conf file
  7. restart apache
  8. [Optional] Set up Cron for auto-renew
  9. sudo crontab -e
  10. 30 2 * * 1 /opt/letsencrypt/letsencrypt-auto renew >> /var/log/le-renew.log

 

These commands taken from the DigitalOcean Let’s Encrypt Setup Guide

Unprotect an Excel Worksheet

C/O: https://uknowit.uwgb.edu/page.php?id=28850

  1. Press ALT+F11
  2. Double Click the worksheet in question
  3. Paste the Following Code:
    
    Sub PasswordBreaker()
    
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
    Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
    MsgBox "One usable password is " & Chr(i) & Chr(j) & _
    Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
    End Sub
    
  4. Press the Run button
  5. The password to unlock the form is displayed, and the sheet is no longer password protected

Stay up to date with RSS

Staying Up-To-Date

I spend spent a lot of time watching various blogs, web pages, and other online sources for updates to the many platforms I’m responsible for supporting.  Windows has a new security patch. Mac OSX needs heart-bleed remediation.  SharePoint has a new Cumulative Update.  There’s a new Linux Kernel out, and 52 commits have occurred for the ROM on my phone.

That’s a lot of moving targets, with many different pages to remember to check on a semi-regular basis.  With probability against me, the time spent loading a page (and possibly googling it if I forgot to bookmark it) and deciphering what’s changed since I last visited generally resulted in a lot of lost time.

My Solution

Recently, a co-worker turned me on to RSS feeds.  They’ve been around forever, and yet, I’ve never really used them.  That is, until I realized how valuable they can be.   Just think: superbookmarks! One “Single Pane of Glass” to view all of the content updates. Feedly is a web based RSS reader.  You can use various authentication methods ( I prefer logging in with my Google Account) to access your list of “Subscribed” RSS feeds.

Whenever new content is posted, it shows up in your “unread” subscriptions.  Just make it your homepage, and enjoy the easy reading!

Subscribing to Content

After you’ve found a content source you’d like to stay current on, You’ll need to:

  1. Identify the RSS Feed URL
    1. Most sites will have an RSS button.  It should look like this: However, some sites do not publish the RSS feed, but still make it available.
    2. The RSS Feed for WordPress sites can be accessed via http://<sitename>/feed or http://<sitename>/?feed=rss2.
    3. Reddit publishes RSS Feeds for subreddits in the form of http://reddit.com/r/<subreddit>/.rss
  2. Point Feedly at the URL
    Click the “Add Content” button in Feedly, and provide the URL you discovered in step 1.

  3. Add the Feed to one of your collections
    Click the green “+”

  4. Choose a Collection

  5. Enjoy!
    New posts from this content source will now automagically show up when you open Feedly!

My Feeds

If you’re curious what I’m following, here’s a list of the RSS feeds I choose to follow.  You could also download, and import my feeds directly into your Feedly!

  • Ars Technica
    • http://feeds.arstechnica.com/arstechnica/index/
  • Michael Niehaus’ Windows and Office deployment ramblings
    • http://blogs.technet.com/mniehaus/rss.xml
  • Reddit /r/sysadmin
    • http://www.reddit.com/r/sysadmin/.rss
  • codeinsecurity
    • http://codeinsecurity.wordpress.com/feed/
  • Krebs on Security
    • http://krebsonsecurity.com/feed/
  • In the Cloud
    • http://blogs.technet.com/b/in_the_cloud/rss.aspx
  • Ask Premier Field Engineering (PFE) Platforms
    • http://blogs.technet.com/b/askpfeplat/rss.aspx
  • Errata Security
    • http://blog.erratasec.com/feeds/posts/default
  • NPR News
    • http://www.npr.org/rss/rss.php?id=1001
  • XKCD
    • http://xkcd.com/rss.xml
  • LifeHacker
    • http://feeds.gawker.com/lifehacker/vip
  • Todd Klindt’s Blog Posts (SharePoint Patches)
    • http://www.toddklindt.com/blog/_layouts/listfeed.aspx?List={56F96349-3BB6-4087-94F4-7F95FF4CA81F}
  • Reddit /r/sharepoint
    • http://www.reddit.com/r/sharepoint/.rss
  • Stefan Goßner (SharePoint)
    • http://blogs.technet.com/b/stefan_gossner/rss.aspx