Skip to content

Instantly share code, notes, and snippets.

Janik Vonrotz janikvonrotz

Block or report user

Report or block janikvonrotz

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@janikvonrotz
janikvonrotz / Generate CSR (Certificate Signing Request) with OpenSSL.md
Created Jul 25, 2015
Generate CSR (Certificate Signing Request) with OpenSSL #OpenSSL #Markdown
View Generate CSR (Certificate Signing Request) with OpenSSL.md

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
janikvonrotz / Install Lets Encrypt and create a free SSL certificate.md
Last active Dec 7, 2015
Install Let's Encrypt and create a free SSL certificate #OpenSSL #Markdown
View Install Lets Encrypt and create a free SSL certificate.md

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

@janikvonrotz
janikvonrotz / SQL Cheat Sheet.md
Last active Jan 21, 2020
SQL Cheat Sheet#SQL#Markdown
View SQL Cheat Sheet.md

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

@janikvonrotz
janikvonrotz / Enable-PowerShellISEWindowsServer.ps1
Last active Aug 29, 2015
Enable PowerShell ISE for Windows Server #PowerShell #WindowsServer
View Enable-PowerShellISEWindowsServer.ps1
Import-Module ServerManager
Add-WindowsFeature PowerShell-ISE
@janikvonrotz
janikvonrotz / map.geojson
Last active Jan 4, 2018
Places I've been to #JanikVonrotz
View map.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@janikvonrotz
janikvonrotz / Add-RemoteDesktopUser.ps1
Created Jun 1, 2015
Add Remote Desktop User #PowerShell #Windows
View Add-RemoteDesktopUser.ps1
$computername = "hostname"
Invoke-Command -ComputerName $computername -ScriptBlock {
$computer = $env:COMPUTERNAME
$domain = "domain"
$user = "username"
$group = [ADSI]"WinNT://$computer/Remote Desktop Users,group"
$group.psbase.Invoke("add",([ADSI]"WinNT://$domain/$user").Path)
}
@janikvonrotz
janikvonrotz / Enable Piwik for LimeSurvey.md
Created Apr 9, 2015
Ubuntu: Enable Piwik for LimeSurvey #LimeSurvey
View Enable Piwik for LimeSurvey.md
@janikvonrotz
janikvonrotz / Install LimeSurvey webapp.md
Last active Nov 13, 2015
Ubuntu: Install LimeSurvey webapp #LimeSurvey
View Install LimeSurvey webapp.md
@janikvonrotz
janikvonrotz / Add-WPAdminUser.sql
Created Mar 23, 2015
Wordpress add administrator user with sql only #WordPress #MySQL
View Add-WPAdminUser.sql
USE <database>;
SET @username = '<username>';
SET @password = MD5('<password>');
SET @fullname = '<Firstname Lastname>';
SET @email = '<login@example.com>';
SET @url = '<http://example.com/>';
INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_status`, `display_name`) VALUES (@username, @password, @fullname, @email, @url, NOW(), '0', @fullname);
@janikvonrotz
janikvonrotz / footer.blade.php
Last active Jul 4, 2017
Laravel default templates #Laravel
View footer.blade.php
You can’t perform that action at this time.