Sign inSign up

jacobblanco/simplewebapp-db

By jacobblanco

•Updated over 7 years ago

Simple Web App Database

Image
0

441

jacobblanco/simplewebapp-db repository overview

⁠Docker WebApp Database Project.

⁠Docker containers, Kubernetes and AKS project.

IMPORTANT:

  • This is a beta project just for testing proposal. DO NOT INSTALL in PRODUCTION ENVIRONMENT.
  • We are not responsible for any lost data or any damage caused by this repo.

This repository was created ONLY to test a LAMP web application and HOWTO deployment on docker, Kubernetes and Azure Kubernetes Services.

⁠HOWTO Deploy this Web App on Docker.

  • Install Docker CE Environment on your computer or server.

  • Create Virtual Network Environment on docker:

    • docker network ls // Shows currently docker networks.
    • docker network create --driver bridge mynetwork // Creates a new bridge network.
    • docker network inspect mynetwork // Shows new network details.

  • Deployment options:

    • You may clone and use Dockerfile attached to the repo.
      • docker build -t simplewebapp-db .
    • Or pulling the container.
      • docker pull jacobblanco/simplewebapp-db

  • Starting container:

    • docker run -p 3306:3306 --name simplewebapp-db --network=mynetwork -e MYSQL_ROOT_PASSWORD=YOUR_PASSWORD_HERE -e MYSQL_ROOT_HOST=% -d jacobblanco/simplewebapp-db

  • Check and get container info:

    • docker ps -a -f status=running || Checks running containers.
    • docker start simplewebapp-db || If it is not running.
    • docker logs simplewebapp-db || Shows container logs.
    • docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' simplewebapp-db || Gets IP address.

  • Edit and configure container:

    • docker exec -it simplewebapp-db mysql -uroot -p || Starts a mysql session.
    • docker exec -it simplewebapp-db /bash || Starts an interactive session.

  • You must deploy app's frontend, if its not already installed:

IMPORTANT: If you want to use Jorani software in PRODUCTION ENVIRONMENT, please check author's references:

⁠Official Jorani App Instructions to deploy. CREATED AND OWNED by Benjamin BALET.

⁠Informations / getting help

Jorani is a Leave Management System developed in PHP/MySQL under an AGPL v3 licence. Jorani is designed to provide simple leave and overtime request workflows for small organizations.

⁠Informations / getting help

⁠Status

This project is stable and ready for production. An online demo is available here : https://demo.jorani.org/⁠ Use bbalet / bbalet for login / password.

⁠Features

  • Comprehensive online documentation (French and English).
  • Notifications by e-mail (requested, accepted, rejected and new user).
  • Leave request approval workflow (1 validator).
  • Overtime request approval workflow (1 validator).
  • Leave balance report (filtered by department).
  • Monthly presence report.
  • Export to XLSX (Excel, LibreOffice) in a click (almost all pages of the application).
  • HR users can edit any leave or overtime request.
  • Set your own contracts and leave types.
  • Calendars of leaves (individual, team, collaborators, etc.).
  • Describe your organization in a tree structure and attach employees to entities, define a supervisor per entity.
  • Non working days (weekends and day offs) can be defined on a contract so as to automatically calculate the duration of a leave and to display them in the calendar.
  • REST API (OAuth2) fully documented and examples with PHP clients.
  • LDAP and SAML Authentication (OpenLDAP, AD, etc.).
  • OAuth2 Authentication (only Google+ at the moment).
  • Available in English, French, Spanish, Italian, Portuguese, German, Dutch, Russian, Ukrainian, Persian, Khmer, Vietnamese, Czech, Arabic and Turkish.

⁠Installation

IMPORTANT: If you want to install Jorani in production, please download it from the Release tab.

See the installation instructions⁠ for advanced configuration. In a nutshell :

  • If you use Apache, mod_rewrite must be activated and the config must allow overwriting settings with .htaccess file.
  • Download or clone Jorani. If you clone, please update the vendor folder with composer.
  • Upload the content of this folder on your server (in /var/www/...).
  • Create a database with /sql/lms.sql script.
  • Create a user with SELECT, INSERT, UPDATE, DELETE, EXECUTE permissions on the database.
  • Update /application/config/database.php according to your database settings.
  • Update the end of /application/config/email.php with your e-mails settings.
  • Update the end of /application/config/config.php if you want to change the default behaviour.
  • It is recommended to change the private and public RSA keys (in assets/keys).
  • Check your installation with the requirements.php page at the root of your installation (e.g. http://localhost/lms/requirements.php⁠).
  • The default user is bbalet and password is bbalet.

⁠Contribute

⁠Credits

⁠Contributors
  • Github and Google groupe users for their ideas and tests.
  • All participants of the Transifex project.
⁠Third party libraries and components

We thank the following open source projects for the components used by Jorani:

⁠Backend
⁠Frontend

Tag summary

Content type

Image

Digest

Size

142.1 MB

Last updated

over 7 years ago

docker pull jacobblanco/simplewebapp-db