Développer / Develop

Assumptions OS: Ubuntu 16.x edition – up to date Already has MySQL installed that comes default – you can easily install LAMP MySQL Server version: > 5.5 You have OS root privileges Default MySQL is running on port 3306 What will we do Set up 1 more MySQL instances on ports 3407 Each instance will have their own config files, data directories and log directories Stopping default MySQL instance sudo service mysql stop sudo ps -A | grep mysql Creating data directories MySQL cannot share data directories, so we need to set up new ones default basedir = /usr , this can be shared across instances default instance port = 3306 and data dir = /var/lib/mysql new instance        port = 3408 and data dir = /var/lib/mysql3408 MySQL must own data dirs we need to set rules in apparmor to let  MySQL  access the new dirs sudo mkdir /var/lib/mysql3408 sudo chown -R mysql /var/lib/mysql3408 Creating log directories create separate log dirs...

There are different articles on how to setup MySQL with SSL but it’s sometimes difficult to end up with a good simple one. Usually, setting up MySQL SSL is not really a smooth process due to such factors like “it’s not your day”, something is broken apparently or the documentation lies... Read this article : Setting up MySQL SSL and secure connections Pre-requisite : Creating SSL Certificates and Keys Using openssl

JDBC Realm and Form Based Authentication with GlassFish 3.1.2.2 and Primefaces 3.4 One of the most popular posts on eisele blog is the short tutorial about the JDBC Security Realm and form based Authentication on GlassFish with Primefaces. Here we go: http://blog.eisele.net/2013/01/jdbc-realm-glassfish312-primefaces342.html?m=1