Skip to content

Instantly share code, notes, and snippets.

View janikvonrotz's full-sized avatar
:octocat:

Janik von Rotz janikvonrotz

:octocat:
191 followers · 89 following
View GitHub Profile
@janikvonrotz
janikvonrotz / Install WordPress Blog.md
Created March 3, 2014 08:21
Step by Step: Install WordPress Blog #PHP #MySQL #Nginx #phpMyAdmin #WordPress #Markdown #Ubuntu

Finishing this guide you'll get:

  • A running WordPress installation
  • Nginx proxy with PHP and Fast CGI
  • MySQL server accessible with phpMyAdmin

Specification of latest running installation:

  • Date: 03.03.2014
@janikvonrotz
janikvonrotz / Install HHVM.md
Last active August 26, 2023 06:52
Ubuntu: Install HHVM #PHP #HHVM

Introduction

HHVM is an open-source virtual machine designed for executing programs written in Hack and PHP. HHVM uses a just-in-time (JIT) compilation approach to achieve superior performance while maintaining the development flexibility that PHP provides.

Requirements

  • Ubuntu server

Installation

@janikvonrotz
janikvonrotz / Report-UserPermissions.sql
Created March 20, 2014 09:56
SQL Server: Report User Permissions #SQLServer
USE [Database Name]
GO
-- Server level logins and roles
SELECT sp.name AS LoginName,
sp.type_desc AS LoginType,
sp.default_database_name AS DefaultDBName,
slog.sysadmin AS SysAdmin,
slog.securityadmin AS SecurityAdmin,
@janikvonrotz
janikvonrotz / Install automysqlbackup.md
Last active July 23, 2023 14:33
Ubuntu: Install automysqlbackup #MySQL #Markdown

Introduction

AutoMySQLBackup with a basic configuration will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers.

Requirements

  • Ubuntu server
  • MySQL

Installation

@janikvonrotz
janikvonrotz / Generate CSR (Certificate Signing Request) with OpenSSL.md
Created July 25, 2015 06:59
Generate CSR (Certificate Signing Request) with OpenSSL #OpenSSL #Markdown

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 / alice-to-bob.md
Created May 12, 2023 07:34 
graph LR;
    A[Alice]-->|Hi Bob|B[Bob];
@janikvonrotz
janikvonrotz / Default system variables.md
Last active April 3, 2023 07:11
Windows: Default system variables #Windows
@janikvonrotz
janikvonrotz / Install phpMyAdmin website.md
Last active March 28, 2023 02:56
Ubuntu: Install phpMyAdmin website #phpMyAdmin #Markdown

Requirements

  • Ubuntu server
  • Nginx
  • Nginx minimal website
  • php5-fpm
  • php5-mysql, php5-mcrypt
  • Nginx php5-fpm website
  • MySQL
@janikvonrotz
janikvonrotz / Install Koken website.md
Last active February 18, 2023 19:57
Ubuntu: Install Koken website #Koken #Markdown
@janikvonrotz
janikvonrotz / Assign-TemporaryAdministratorRights.ps1
Last active February 7, 2023 21:31
PowerShell: Assign Temporary Administrator Rights #PowerShell #ActiveDirectory #EmbededPost
<#
$Metadata = @{
Title = "Assign Temporary Administrator Rights"
Filename = "Assign-TemporaryAdministratorRights.ps1"
Description = ""
Tags = "powershell, script, activedirectory, assign, temporary, administrator, rights, computer"
Project = ""
Author = "Janik von Rotz"
AuthorContact = "http://janikvonrotz.ch"
CreateDate = "2013-11-15"