| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| Country | Alpha-2 code | Alpha-3 code | Numeric code | Latitude (average) | Longitude (average) | |
|---|---|---|---|---|---|---|
| Afghanistan | AF | AFG | 4 | 33 | 65 | |
| Åland Islands | AX | ALA | 248 | 60.116667 | 19.9 | |
| Albania | AL | ALB | 8 | 41 | 20 | |
| Algeria | DZ | DZA | 12 | 28 | 3 | |
| American Samoa | AS | ASM | 16 | -14.3333 | -170 | |
| Andorra | AD | AND | 20 | 42.5 | 1.6 | |
| Angola | AO | AGO | 24 | -12.5 | 18.5 | |
| Anguilla | AI | AIA | 660 | 18.25 | -63.1667 | |
| Antarctica | AQ | ATA | 10 | -90 | 0 |
Following this guide will set up a local Elasticsearch with Kibana and Marvel using Homebrew and Homebrew Cask
If you already have Java installed on your system, skip steps Install Cask and Install Java
If you already have Java and Homebrew installed on your system, skip steps Prerequisites, start at Install Elasticsearch and Kibana after running $ brew update
$ ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
| import socket | |
| hostname, sld, tld, port = 'www', 'integralist', 'co.uk', 80 | |
| target = '{}.{}.{}'.format(hostname, sld, tld) | |
| # create an ipv4 (AF_INET) socket object using the tcp protocol (SOCK_STREAM) | |
| client = socket.socket(socket.AF_INET, socket.SOCK_STREAM) | |
| # connect the client | |
| # client.connect((target, port)) |
| 1 - Install Home Brew. | |
| /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" | |
| 2 - Install aircrack-ng: | |
| brew install aircrack-ng | |
| 3 - Install the latest Xcode, with the Command Line Tools. | |
| //Create the following symlink: | |
| sudo ln -s /System/Library/PrivateFrameworks/Apple80211.framework/Versions/Current/Resources/airport /usr/local/bin/airport//Figure out which channel you need to sniff: |
| #!/bin/bash | |
| #Simple script for VirtuaBox memory extraction | |
| # Usage: vboxmemdump.sh <VM name> | |
| VBoxManage debugvm $1 dumpvmcore --filename=$1.elf | |
| size=0x$(objdump -h $1.elf|egrep -w "(Idx|load1)" | tr -s " " | cut -d " " -f 4) | |
| off=0x$(echo "obase=16;ibase=16;`objdump -h $1.elf|egrep -w "(Idx|load1)" | tr -s " " | cut -d " " -f 7 | tr /a-z/ /A-Z/`" | bc) | |
| head -c $(($size+$off)) $1.elf|tail -c +$(($off+1)) > $1.raw |
*update: TBC, but this new might affect how easy it is to use this technique past August 2024: Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August
This gist, based in part on a gist by Brian Hartvigsen, allows you to export from Authy your TOTP tokens you have stored there.
Those can be "standard" 6-digits / 30 secs tokens, or Authy's own version, the 7-digits / 10 secs tokens.
| ' | |
| ' SYNOPSIS: | |
| ' WMI Persistence method as originally presented by SEADADDY malware | |
| ' (https://github.com/pan-unit42/iocs/blob/master/seaduke/decompiled.py#L887) | |
| ' and further documented by Matt Graeber. | |
| ' | |
| ' The scheduled command will be launched after roughly 3 minutes since system | |
| ' gets up. Also, even if the command shall spawn a window - it will not be visible, | |
| ' since the command will get invoked by WmiPrvSE.exe that's running in Session 0. | |
| ' |
| #!/usr/bin/env bash | |
| # fetch_nike_puls_all_activities.bash | |
| # A simple bash script to fetch all activities and metrics from NikePlus. | |
| # See `nike_plus_api.md` for the API details. | |
| readonly bearer_token="$1" | |
| if [[ -z "$bearer_token" ]]; then | |
| echo "Usage: $0 bearer_token" | |
| exit |