mcupak’s gists

mcupak / access-log-read-resource.out

Created October 9, 2017 05:22

/subsystem=undertow/server=default-server/host=default-host/setting=access-log:read-resource-description

	[standalone@localhost:9990 /] /subsystem=undertow/server=default-server/\
	host=default-host/setting=access-log:read-resource-description
	{
	"outcome" => "success",
	"result" => {
	"description" => "The access log configuration for this virtual\
	server.",
	"access-constraints" => {"sensitive" => {"web-access-log" =>\
	{"type" => "undertow"}}},
	"attributes" => {

mcupak / .travis.yml

Created October 9, 2017 05:26

LaTeX Travis setup.

	sudo: required
	dist: trusty
	before_install:
	- sudo apt-get -qq update && sudo apt-get install -y --no-install-recommends texlive-full
	script:
	- pdflatex -interaction=nonstopmode -halt-on-error *.tex

mcupak / mysql-connect.sh

Created October 9, 2017 05:28

Connecting to MySQL.

mysql -u foo -p -h 1.1.1.1 --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem

mcupak / keytool.sh

Created October 9, 2017 05:29

Creating trustore.jks and importing server-ca.pem.

keytool -import -alias server -file server-ca.pem -keystore truststore.jks -storepass password

mcupak / openssl.sh

Created October 9, 2017 05:30

Certificate processing with OpenSSL.

openssl pkcs12 -export -in client-cert.pem -inkey client-key.pem -out client.p12 -name client

mcupak / keytool-import.sh

Created October 9, 2017 05:31

keytool-import

keytool -importkeystore -deststorepass password -destkeystore keystore.jks -srckeystore client.p12 -srcstoretype PKCS12 -srcstorepass password -alias client

mcupak / export-keystore-truststore-java-opts.sh

Created October 9, 2017 06:21

Setting up Keystore and Truststore for WildFly.

export JAVA_OPTS="-server -Xms64m -Xmx512m -XX:MetaspaceSize=96M -XX:MaxMetaspaceSize=256m -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true -Djavax.net.ssl.keyStore=keystore.jks -Djavax.net.ssl.keyStorePassword=password -Djavax.net.ssl.trustStore=truststore.jks -Djavax.net.ssl.trustStorePassword=password"

mcupak / setup-mysql-jdbc.out

Created October 9, 2017 06:22

Set up MySQL in WildFly.

	[standalone@localhost:9990 /] module add --name=com.mysql\
	--resources=mysql-connector-java.jar\
	--dependencies=javax.api,javax.transaction.api
	[standalone@localhost:9990 /] /subsystem=datasources/jdbc-driver=mysql:\
	add(driver-name=mysql,driver-module-name=com.mysql,\
	driver-xa-datasource-class-name=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource)
	{"outcome" => "success"}

mcupak / create-datasource.out

Created October 9, 2017 06:23

Create a data source on WildFly.

	[standalone@localhost:9990 /] data-source add --name=MySqlDS --driver-name=mysql \
	--jndi-name=java:jboss/datasources/MySqlDS \
	--connection-url=jdbc:mysql://1.1.1.1:3306/test?useSSL=true&requireSSL=true&verifyServerCertificate=true \
	--user-name=foo --password=bar --enabled=true

mcupak / test-connection.out

Created October 9, 2017 06:24

data-source test-connection-in-pool

	[standalone@localhost:9990 /] data-source test-connection-in-pool --name=MySqlDS
	true

Miro Cupak mcupak