Install MYSQL, JIRA, CONFLUENCE

gistfile1.txt

	#DB on AWS ubuntu/images/hvm-ssd/ubuntu-focal-20.04-amd64-server-20200423 (ami-05c26ae4789875080)
		sudo apt install mysql-server
		sudo mysql_secure_installation
		>>pwd 4 root mysq
		sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf # change bind address to 0.0.0.0
		sudo systemctl restart mysql 
		sudo systemctl enable mysql
		ss -ltn
		sudo ufw allow from any to any port 3306 proto tcp
		#Manage DB
			sudo mysql
			DROP DATABASE jiradb;
			CREATE DATABASE jiradb;
			CREATE USER 'jirabot'@'%' IDENTIFIED BY 'j1r@b0tS3CR3T';
			GRANT ALL PRIVILEGES ON jiradb.* to jirabot@'%';
			FLUSH PRIVILEGES;

			DROP DATABASE confdb;
			CREATE DATABASE confdb;
			CREATE USER 'confbot'@'%' IDENTIFIED BY 'c0nfb0t$3CR3T';
			GRANT ALL PRIVILEGES ON confdb.* to confbot@'%';
			FLUSH PRIVILEGES;
			
			ALTER DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
			ALTER DATABASE confdb CHARACTER SET utf8 COLLATE utf8_bin;

			SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
			exit

	#JIRA on AWS ubuntu/images/hvm-ssd/ubuntu-focal-20.04-amd64-server-20200423 (ami-05c26ae4789875080)
	#serverkey:
		wget https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-software-7.8.2-x64.bin
		chmod a+x atlassian-jira-software-7.8.2-x64.bin
		./atlassian-jira-software-7.8.2-x64.bin

		sudo apt install ufw
		sudo ufw allow from any to any port 8080 proto tcp
		sudo ufw allow from any to any port 8181 proto tcp
		sudo ufw allow from any to any port 8005 proto tcp
		sudo iptables -A PREROUTING -t nat -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8080

		ufw status
		iptables -t nat -A OUTPUT -o lo -p tcp --dport 80 -j REDIRECT --to-port 8080
		
		wget https://dev.mysql.com/get/archives/mysql-connector-java-5.1/mysql-connector-java-5.1.36.zip
		unzip mysql-connector-java-5.1.36.zip
		cp mysql-connector-java-5.1.36/mysql-connector-java-5.1.36-bin.jar /home/ubuntu/atlassian/jira/lib/mysql-connector-java.jar
		
		/etc/init.d/jira stop
		/etc/init.d/jira start

# Confluence

		wget https://downloads.atlassian.com/software/confluence/downloads/atlassian-confluence-7.5.1-x64.bin
		chmod 755 atlassian-confluence-6.2.0-x64.bin
		./atlassian-confluence-6.2.0-x64.bin
		cd atlassian/confluence/conf
		nano server.xml 
		cd ../bin/
		./start-confluence.sh 
		sudo ufw allow from any to any port 8090 proto tcp
		sudo ufw allow from any to any port 8000 proto tcp
		sudo iptables -A PREROUTING -t nat -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8090
		ufw status
		sudo iptables -t nat -A OUTPUT -o lo -p tcp --dport 80 -j REDIRECT --to-port 8090

	http://confluence.dev4any1.net/setup/connecttojira-start.action