- Java : OpenJDK version "1.8.0_265 (and Oracle Java 1.8.0_211 by request)
- Spring Boot Microservices
- Apache Tomcat 9.0.37
- Database technologies:
-
- Maria DB Ver 15.1 Distrib 10.5.5-MariaDB
- MySQL
- Percona MySQL
The WAR file delivered can be run as a stand-alone application with built-in Tomcat or it can be deployed in a Tomcat Server
This code is ready for usage
We intend to migrate our JDK to OpenJDK 11 and rebuild this project
MySQL ,MariaDB, and PerconaMySql are supported
Although the code was originally written for MYSQL it was decided to use MariaDB There will be backward compatibility
In the folder : /src/main/resources/sql_scripts you will find these files :
- create_db_and_tables_4mysql.sql
- insert_data_4mysql.sql
**The insert_data_4mysql.sql can save you time creating users **
Please note the passwords are encrypted so dont set them in the query
You will need to edit and run the Insert Query at the bottom of this sql script
to give your administrator user the needed logon credentials .
once you have locked in with that employees user Id and password create another Employee with a diferent userId and password and assign the Admin role then delete the previous userID
We recommend that you create a Shell script : mysql-terminal |
---|
run the following command in the terminal: |
sudo nano /usr/bin/mysql-terminal |
place the following code into this shell script: |
#!/bin/bash |
sudo mysql -u root -pPasswordForRootUserOfMySqlServer |
Now every time you want open the MSQL terminal you you have a quicker way to get in just open the bash terminal and run this command : mysql-terminal
here: https://github.com/nic0michael/KanbanBoardMicroservice/tree/master/Files
Copy to a folder named : kanban-board
Run the following command from a terminal in that folder:
java -jar spring-boot-kanban-board_V1_0_1.jar
You can run shell script start.sh or batch file start.BAT