janikvonrotz

curl -s https://packagecloud.io/install/repositories/github/git-lfs/script.deb.sh | sudo bash

janikvonrotz

Introduction

Configure Python 3 and install pip. Pip allows us to easily manage any Python 3 package we would like to have.

Requirements

• Ubuntu server

Installation

janikvonrotz

function Get-RandomPassword{
    
    $numbers = 1..9
    $consonants = "b","c","d","f","g","h","k","l","m","n","p","r","s","t","v","w","x","z"
    $nopeletters = "j","q","y"
    $vocals = "a","e","i","o","u"
    $dotsandstuff = ",",".","-"
    $nopedotsandstuff = ";",":","_"

    return (Get-Random $consonants).ToString().ToUpper() + 

janikvonrotz

sudo /usr/local/src/duplicity-backup/duplicity-backup.sh -c /etc/duplicity-backup/duplicity-backup.conf --restore-file etc/nginx/conf.d/sebastianvonrotz.ch.conf ~/sebastianvonrotz.ch.conf -t 2015-08-17

sudo /usr/local/src/duplicity-backup/duplicity-backup.sh -c /etc/duplicity-backup/duplicity-backup.conf --list-current-files -t 2015-08-17

janikvonrotz

Introduction

Koken is a content management system and image publishing application for photographers. Head over to http://koken.me/ to learn more about Koken.

Requirements

• Ubuntu server
• Nginx
• Nginx minimal website

janikvonrotz

Import-Module ActiveDirectory

$user1 = "userRef"
$user2 = "userDif"

$members1 = Get-ADPrincipalGroupMembership -Identity $user1 | Select-Object name
$members2 = Get-ADPrincipalGroupMembership -Identity $user2 | Select-Object name

$result = Compare-Object -ReferenceObject $members1 -DifferenceObject $members2 -Property name

janikvonrotz

function Get-RandomHexString {
    param($count)
    $hex = '012345679ABCDEF'.ToCharArray()
    $array = foreach($number in 1..$count ){ $hex | Get-Random}
    return (($array) -join "").ToString().ToLower()

}

function Get-WikiType{
    param($file)

janikvonrotz

Define the following attributes, you have to set them in the wizard when generating the CSR.

• Common Name (the domain name certificate should be issued for)
• Country
• State (or province)
• Locality (or city)
• Organization
• Organizational Unit (Department)
• E-mail address

janikvonrotz

Introduction

Let’s Encrypt is a free, automated, and open certificate authority (CA), run for the public’s benefit. Let’s Encrypt is a service provided by the Internet Security Research Group (ISRG). This guide shows you how you can obtain a free SSL certificate.

Requirements

• Ubuntu server
• Python
• Nginx
• Nginx minimal website

janikvonrotz

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

Datatypes

Text types