/GardenShare

Garden Share Backend Application

Primary LanguageJava

Build Status

MySQL Setup

  1. Download and Install Mysql server and a mysql client

  2. Start the server

  3. Connect as root user (On unix you have to connect as unix root user) mysql -u root

  4. CREATE USER 'gardenshare'@'localhost' IDENTIFIED BY 'somepassword'

  5. Create a new user for gardenshare GRANT ALL PRIVILEGES ON *.* to 'gardenshare'@'localhost';

  6. FLUSH PRIVILEGES;

  7. Create the database CREATE DATABASE gardenshare;

How to build

Locally

  1. Set up a mysql server locally

  2. Create a user and database table in mysql

  3. Create a 'secrets' file in secrets/env.sh

It should look like this (make sure that it has LF endings and not CRLF)

export DB_URL=**************/DB_TABLE_NAME
export DB_USER=**************
export DB_PASS=**************

  1. Run . secrets/env.sh to load the secrets

  2. Run mvn spring-boot:run to start the server

  3. Connect to the server using http://localhost:8080

Dockerfile

  1. Set up a mysql server locally

  2. Create a user and database table in mysql

  3. Run docker build . -t gardenshare

  4. Run docker run -it --network=host -e DB_URL=****/DB_TABLE_NAME -e DB_USER=**** -e DB_PASS=***** gardenshare

  5. Connect to the server using http://localhost:8080