Instalacao Openfire com MySQL Debian 9.3

Pra fechar o ano, vou postar a  Instalação Openfire com MySQL Debian 9.3

# Projeto
https://www.igniterealtime.org/projects/openfire/documentation.jsp

# Database Guide
http://download.igniterealtime.org/openfire/docs/latest/documentation/database.html

# Cenario
IP_LAN: 192.168.254.200
HOST  : openfire
DOMAIN: dominio.local

# Apache && OpenSSL
apt install apache2 openssl

# MySQL
echo -e "deb http://repo.mysql.com/apt/debian/ stretch mysql-5.7\ndeb-src http://repo.mysql.com/apt/debian/ stretch mysql-5.7" > /etc/apt/sources.list.d/mysql.list
wget -O /tmp/RPM-GPG-KEY-mysql https://repo.mysql.com/RPM-GPG-KEY-mysql
apt-key add /tmp/RPM-GPG-KEY-mysql
apt update
apt install mysql-server

# PHP
apt install php php-mysql

# Java
apt install openjdk-8-jre

# CREATE database
mysql -u root -p
CREATE DATABASE openfire;
GRANT ALL PRIVILEGES ON openfire.* TO 'openfire'@'localhost' IDENTIFIED BY 'sua_senha';
FLUSH PRIVILEGES;

# Download Ultima versao
cd /opt ; wget -c https://www.igniterealtime.org/downloadServlet?filename=openfire/openfire_4.2.1_all.deb

# Instalacao
dpkg -i /home/suporte/openfire_4.2.1_all.deb

# Configurando o Openfire
http://seu_servidor:9090

Basta seguir o GUI de instalação, mas é bem intuitivo.