rchupp

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

fntlnz

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -des3 -out rootCA.key 4096

lightonphiri

Install Google Fonts

Download desired fonts

https://fonts.google.com/?selection.family=Open+Sans

Install Google Fonts on Ubuntu

cd /usr/share/fonts
sudo mkdir googlefonts
cd googlefonts
sudo unzip -d . ~/Downloads/Open_Sans.zip

passatgt

preLoginHandler: function(formData, req, res, next) {
  var authRequest = {
    username: formData.login,
    password: formData.password
  };

  //Try to authenticate the user
  req.app.get('stormpathApplication').authenticateAccount(authRequest, function(err, result) {
    //if (err) return helpers.handleError(err,res);
    if (err && err.code == 7100) {

jbenet

Articles discussing cloud services shutting down:

• http://www.archiveteam.org/index.php?title=Deathwatch
  • http://www.archiveteam.org/index.php?title=Deathwatch#Dead_as_a_Doornail
• http://fortune.com/2016/02/12/verizon-closes-two-public-cloud-services/
• http://www.androidpolice.com/2016/02/01/barracuda-is-shutting-down-the-copy-cloud-storage-service-on-may-1st/
• http://lifehacker.com/near-unlimited-cloud-storage-service-copy-com-is-shutti-1756413619
• Even google: http://www.networkworld.com/article/2173255/cloud-computing/cloud-s-worst-case-scenario-what-to-do-if-your-provider-goes-belly-up.html
• http://www.nytimes.com/2016/04/22/technology/apple-no-longer-immune-to-chinas-scrutiny-of-us-tech-firms.html (no longer loads! ironic!)
• http://www.techrepublic.com/blog/the-enterprise-cloud/what-happens-when-your-cloud-provider-goes-out-of-business/

OlivierBlanvillain

Revisiting Tagless Final Interpreters

Tageless Final interpreters are an alternative to the traditional Algebraic Data Type (and generalized ADT) based implementation of the interpreter pattern. This document presents the Tageless Final approach with Scala, and shows how Dotty with it's recently added implicits functions makes the approach even more appealing. All examples are direct translations of their Haskell version presented in the Typed Tagless Final Interpreters: Lecture Notes (section 2).

The interpreter pattern has recently received a lot of attention in the Scala community. A lot of efforts have been invested in trying to address the biggest shortcomings of ADT/GADT based solutions: extensibility. One can first look at cats' Inject typeclass for an implementation of [Data Type à la Carte](http://www.cs.ru.nl/~W.Swierstra/Publications/DataTypesA

ageis

security and hardening options for systemd service units

A common and reliable pattern in service unit files is thus:

NoNewPrivileges=yes
PrivateTmp=yes
PrivateDevices=yes
DevicePolicy=closed
ProtectSystem=strict

mkg20001

const fs = require("fs")
module.exports = AppManifestParser

function isNumeric(n) {
  return !isNaN(parseFloat(n)) && isFinite(n);
}

function recInt(obj) { //replace numeric strings with integers
  for (var p in obj)
    if (typeof obj[p] == "object") obj[p] = recInt(obj[p]);

evilsocket

/*
 * This tool will decrypt files encrypted by the Magniber ransomware with
 * AES128 ( CBC mode ) algorithm.
 *
 * RE and report by MalwareBytes ( @hasherezade )
 *
 *  https://blog.malwarebytes.com/threat-analysis/2017/10/magniber-ransomware-exclusively-for-south-koreans/
 *
 * Decryptor written by Simone 'evilsocket' Margaritelli
 *  

TylerLeonhardt

# Importing Scripts directly from Tweets! #280characters 
#
# NOTE: This should not be used for any production environment. Or any environment for that matter. Use https://PowerShellGallery.com
#
#
####################################
#            Example               #
####################################
#
#