ppoffice

from typing import Tuple

import pyasn1.codec.der.encoder
import pyasn1.type.univ
import base64
import rsa


def private_key_pem(n: int, e: int, d: int, p: int, q: int, dP: int, dQ: int, qInv: int) -> str:
    '''Create a private key PEM file

dekassegui

with separators as ( values (' '), (','), ('-'), ('.') ),
  source (s) as ( select " Will, thought and action." ),
  bag (q) as ( -- POSITIONS OF ALL SEPARATORS
    with dim (len) as ( select length(s) from source ),
    ndx (n) as (
      select 1 union all select n+1 from ndx, dim where n < len
    ) select 0 --> PSEUDO SEPARATOR IN FRONT OF SOURCE STRING
      union all select n from ndx, source where substr(s, n, 1) in separators
      union all select len+1 from dim --> PSEUDO SEPARATOR AT BOTTOM
  ),

dannguyen

Pure SQLite solution to creating a tidy/normalized data table from a column of delimited values

The problem: we have a data table in which one of the columns contains a text string that is meant to be multiple values separated by a delimiter (e.g. a comma). For example, the LAPD crime incidents data has a column named MO Codes (short for modus operandi). Every incident may have several MO's -- for example, a particular RESISTING ARREST incident may have a MO Codes value of 1212 0416, which corresponds, respectively, to: LA Police Officer and Hit-Hit w/ weapon:

![image](https://user-ima

trexx

#!/usr/bin/python

# The .ovpn to .onc converter
# This tool parses an 'inline' OpenVPN profile (certs and keys are included within the .ovpn file)
## and spits out a Open Network Configuration file which can be imported in to ChromeOS.

# Open Network Configuration specs can be found here
## https://chromium.googlesource.com/chromium/src/+/master/components/onc/docs/onc_spec.md

# Original credit goes to Steve Woodrow (https://github.com/woodrow)

pbzona

# Credit to John Creecy
# Original can be found at https://gist.github.com/zugdud/f5453af2c827eba38bb036b19e10b371

AWSTemplateFormatVersion: '2010-09-09'
Description: OpenVPN Stack

Parameters:
  OpenVPNPort:
    Type: Number
    Default: 1194

ammgws

My notes on how I setup OpenVPN server on Edgerouter Lite. Based mostly on this guide from openVPN wiki. This guide assumes easyrsa3 is being used, otherwise substitute whatever the easyrsa2 versions are for the commands below.

This guide will use 3 different machines.

A Public Key Infrastructure (PKI) will be created on each machine:

• 1. Server - openVPN server (Edgerouter in this case).
• 2. Client(s) - the device(s) you will be connecting from.
• 3. CA Server - used to generate and sign certificates for server and clients to use.

lucasrcosta

# -*- coding: utf-8 -*-
# /var/runtime/awslambda/bootstrap.py
"""
aws_lambda.bootstrap.py
Amazon Lambda

Copyright (c) 2013 Amazon. All rights reserved.

Lambda runtime implemention
"""

mojodna

--
-- This will register the "planet" table within your AWS account
--
CREATE EXTERNAL TABLE planet (
  id BIGINT,
  type STRING,
  tags MAP<STRING,STRING>,
  lat DECIMAL(9,7),
  lon DECIMAL(10,7),
  nds ARRAY<STRUCT<ref: BIGINT>>,

jdmar3

#!/usr/bin/python

import argparse
import json
import re
import sys
import uuid


class OpenVPNNetworkConfiguration(object):

jlinoff

#!/usr/bin/env python
'''
Implement openssl compatible AES-256 CBC mode encryption/decryption.

*********************************
UPDATE: 2021-08-28
Apparently this no longer works out of the box. That is probavbly because the
pycrypto package is getting stale.

I found this hacky workaround to get things working but it is likely not safe: