Rendi Kasigi rkasigi

Setting up a SSL Cert from Comodo

Purchasing a Comodo PositiveSSL cert via gogetssl.com and installing it on an Nginx server.

Purchase the cert

Prior to purchasing a cert, you need to generate a private key, and a CSR file

How to setup your own CA with OpenSSL

For educational reasons I've decided to create my own CA. Here is what I learned.

First things first

Lets get some context first.

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

Multiple MySQL versions on MacOS with Homebrew

At the time of writing (december 2018), there aren’t any up-to-date and easy to apply guides on how to switch between different MySQL version on a Mac using Homebrew . Or at least, I didn’t find any.

So I picked up a few things here and there and finally managed to connect all the pieces of the puzzle. I hope this guide can help you and the future me. If anyone knows of a better way to accomplish this, I do hope they will share their insight :)

The basic idea here is that you need to install all MySQL versions one at a time and assign each its own data directory.

I am using Homebrew 1.8.5. (brew -v)

Multiple MySQL Versions with Homebrew

For homebrew version 1.5.12 - WIP... not quite working yet.

brew -v # => Homebrew 1.5.12

Install the current version of mysql.

# Install current mysql version

brew install mysql

Dokku ACL Plugin troubleshoot and configuration

Dokku Acl Config

config file at /home/dokku/.dokkurc/acl

export DOKKU_SUPER_USER=root
export DOKKU_ACL_USER_COMMANDS="help version mariadb:connect"
export DOKKU_ACL_PER_APP_COMMANDS="logs urls enter ps:rebuild ps:restart ps:stop ps:start git-upload-pack git-upload-archive config config:set git-receive-pack git-hook storage:list"

Install PHP Oracle oci8 and pdo_oci on Mac OSX

This procedure is tested on Mac OS X 10.10.5 with Developpers tools installed (xCode).

PHP 5.6 installed with Homebrew.

Preparation

Download the following files from Oracle website (yes, you need to create an account and accept terms):

instantclient-basic-macos.x64-11.2.0.4.0.zip

	openssl rand -base64 6

	openssl rand -hex 4

	openssl rand -base64 8 \| md5 \| head -c8;echo

	openssl rand -base64 6

	ping -c 1 yahoo.com \|md5 \| head -c8; echo

	location /alias-name {
	alias /data/path-alias-name;

	location ~ \.php$ {
	fastcgi_split_path_info ^(.+?\.php)(/.*)?$;
	fastcgi_pass 127.0.0.1:9000;
	#fastcgi_pass unix:/var/run/php5-fpm.sock;
	fastcgi_index index.php;
	fastcgi_param SCRIPT_FILENAME $request_filename;
	include fastcgi_params;

	@Configuration
	public class MultiConnectionSupport {
	@Value("${server.port}")
	private int serverPort;

	@Value("${server.http.port}")
	private int httpServerPort;

	@Bean
	public EmbeddedServletContainerFactory servletContainer() {