TheRockStarDBA

async function scrollDown() {
  const wrapper = document.querySelector("#search-page-list-container");
  await new Promise((resolve, reject) => {
    var totalHeight = 0;
    var distance = 600;

    var timer = setInterval(async () => {
      var scrollHeightBefore = wrapper.scrollHeight;
      wrapper.scrollBy(0, distance);
      totalHeight += distance;

TheRockStarDBA

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

• There are always 24 hours in a day.
• February is always 28 days long.
• Any 24-hour period will always begin and end in the same day (or week, or month).

TheRockStarDBA

Python

This is my recommended Python setup, as of Fall 2022. The Python landscape can be a confusing mess of overlapping tools that sometimes don't work well together. This is an effort to standardize our approach and environments.

Tools and helpful links:

• Python docs: https://docs.python.org/3/
• Python Standard Library: https://docs.python.org/3/library/index.html - Start here when you're trying to solve a specific problem
• pip: https://pip.pypa.io/en/stable/ - Python's standard package installer, included with the language itself
• pipx: https://pipxproject.github.io/pipx/ - Global script installer, built on top of pip

TheRockStarDBA

#!/usr/bin/env python3


import argparse
import sys
import mmap
import logging

from collections import defaultdict

TheRockStarDBA

function Test-FileHash {
    <#
        .Synopsis
            This is a simple file hash comparison tool that writes to Windows Events when changes are detected

        .Description
            This is a simple file hash comparison tool that writes to Windows Events when changes are detected

        .PARAMETER FilePath
            The path to the file to hash and compare

TheRockStarDBA

"""An example of a cache decorator."""

import json
from functools import wraps
from redis import StrictRedis


redis = StrictRedis()

def cached(func):

TheRockStarDBA

log4j RCE Exploitation Detection

You can use these commands and rules to search for exploitation attempts against log4j RCE vulnerability CVE-2021-44228

Grep / Zgrep

This command searches for exploitation attempts in uncompressed files in folder /var/log and all sub folders

sudo egrep -I -i -r '\$(\{|%7B)jndi:(ldap[s]?|rmi|dns|nis|iiop|corba|nds|http):/[^\n]+' /var/log

TheRockStarDBA

REGION=eu-west-1
VER=1.7.3
RUNTIME=python3.7

docker run -v $(pwd):/out -it lambci/lambda:build-$RUNTIME \
    pip install scrapy==$VER -t /out/build/scrapy/python

cd build/scrapy
zip -r ../../scrapy.zip python/
cd ../..

TheRockStarDBA

(After cloning the wiki locally)

Adding Images to a GitHub Wiki Page

• Add images to an images directory (or subdirectory below it) in your wiki repo.

• In wiki page markup embed an image with this link format:

  [[/images/path/to/image.ext|ALT TEXT]]

TheRockStarDBA

$path = 'C:\text.txt'
$output = 'This is an output string'

# This works...
[System.IO.File]::WriteAllLines($path, $output)

# But this doesn't. WTF!
[System.IO.File]::AppendAllLines($path, $output)
# Result: 'Cannot find an overload for "AppendAllLines" and the argument count: "2".'