J. Garcia jogaco

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

	. ____ _ __ _ _
	/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
	( ( )\___ \| '_ \| '_\| \| '_ \/ _` \| \ \ \ \
	\\/ ___)\| \|_)\| \| \| \| \| \|\| (_\| \| ) ) ) )
	' \|____\| .__\|_\| \|_\|_\| \|_\__, \| / / / /
	=========\|_\|==============\|___/=/_/_/_/
	:: Spring Boot :: (v1.5.3.RELEASE)

	2017-05-21 20:14:25.542 INFO 9085 --- [ main] c.o.g.SpringBootMysqlApplicationTests : Starting SpringBootMysqlApplicationTests on hal9003 with PID 9085 (started by jgarcia in /home/java-projects/spr-boot)
	2017-05-21 20:14:25.544 INFO 9085 --- [ main] c.o.g.SpringBootMysqlApplicationTests : No active profile set, falling back to default profiles: default

	--- hibernate-maven-plugin:2.0.0:drop (default) @ spring-boot-mysql ---
	[INFO] HHH000318: Could not find any META-INF/persistence.xml file in the classpath
	[INFO] Found no META-INF/persistence.xml.
	[INFO] Gathered hibernate-configuration (turn on debugging for details):
	[INFO] hibernate.connection.username = username
	[INFO] hibernate.connection.password = password
	[INFO] hibernate.dialect = org.hibernate.dialect.MySQL5InnoDBDialect
	[INFO] hibernate.connection.url = jdbc:mysql://localhost/game_manager?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
	[INFO] hibernate.hbm2dll.create_namespaces = false
	[INFO] hibernate.connection.driver_class = com.mysql.jdbc.Driver

	# https://docs.spring.io/spring-boot/docs/current/reference/html/howto-properties-and-configuration.html
	# Must use @...@ instead of ${...}
	[email protected]@

	# Needed by Hibernate3 Maven Plugin defined in pom.xml
	hibernate.connection.username= @jdbc.username@
	[email protected]@
	[email protected]@
	[email protected]@

	...
	<build>
	<plugins>
	...
	<plugin>
	<groupId>de.juplo</groupId>
	<artifactId>hibernate-maven-plugin</artifactId>
	<version>2.0.0</version>
	<executions>
	<execution>

	[INFO] --- dbunit-maven-plugin:1.0-beta-3:operation (test-compile) @ spring-boot-mysql ---
	78 [main] INFO org.dbunit.database.DatabaseDataSet -
	database name=MySQL
	database version=5.6.36-82.0
	database major version=5
	database minor version=6
	jdbc driver name=MySQL Connector Java
	jdbc driver version=mysql-connector-java-5.1.35 ( Revision: 5fb9c5849535c13917c2cf9baaece6ef9693ef27 )
	jdbc driver major version=5
	jdbc driver minor version=1

	package com.operatornew.gamemanager;

	import com.operatornew.gamemanager.domain.Game;
	import com.operatornew.gamemanager.repository.GameRepository;
	import java.util.ArrayList;
	import java.util.List;
	import static org.junit.Assert.assertEquals;
	import org.junit.Test;
	import org.junit.runner.RunWith;
	import org.springframework.beans.factory.annotation.Autowired;

	package com.operatornew.gamemanager.repository;

	import com.operatornew.gamemanager.domain.Game;
	import org.springframework.data.repository.PagingAndSortingRepository;

	public interface GameRepository extends PagingAndSortingRepository<Game, Integer> {

	}

	<?xml version="1.0" encoding="UTF-8"?>
	<dataset>
	<table name="game">
	<column>id</column>
	<column>name</column>
	<column>description</column>
	<row>
	<value description="id">-1</value>
	<value description="name">name1</value>
	<value description="description">desc1</value>

	...
	<plugin>
	<groupId>org.codehaus.mojo</groupId>
	<artifactId>dbunit-maven-plugin</artifactId>
	<version>1.0-beta-3</version>
	<configuration>
	<dataTypeFactoryName>${dbunit.dataTypeFactoryName}</dataTypeFactoryName>
	<driver>${jdbc.driverClassName}</driver>
	<username>${jdbc.username}</username>
	<password>${jdbc.password}</password>