chenejac / VIVOTestMigration

0 stars 0 forks source link

VIVO-1680: Connect VIVO with containerized MariaDB #1567

Closed chenejac closed 3 years ago

chenejac commented 5 years ago

Andrew Woods (Migrated from VIVO-1680) said:

This task is to deploy VIVO with an externalized MariaDB, which itself has been deployed via its own Docker container.

chenejac commented 5 years ago

Andrew Woods said:

Documentation: https://hub.docker.com/_/mariadb

Deploy MariaDB Docker container: $ docker run --name vitrodb -p 3306:3306 -v /tmp/awoods/mariadb:/docker-entrypoint-initdb.d -e MYSQL_USER=root -e MYSQL_ROOT_PASSWORD= -d mariadb:10.4-bionic

Where, "/tmp/awoods/mariadb" is a directory that contains the file, "mysql-init.sql":

CREATE DATABASE vitrodb CHARACTER SET utf8;
GRANT ALL ON vitrodb.* TO 'vitrodbUsername'@'%' IDENTIFIED BY 'vitrodbPassword';

Notes: No change required for runtime.properties

VIVO: Using branches: https://github.com/vivo-project/VIVO/tree/sprint-search https://github.com/vivo-project/Vitro/tree/sprint-search

chenejac commented 5 years ago

Andrew Woods said:

This recipe has been built into: https://github.com/vivo-community/vivo-docker2

chenejac commented 5 years ago

Ralph O'Flinn said:

Additional documentation is incoming

chenejac commented 5 years ago

Huda Khan said:

Recipe followed and docker states MariaDB up and running.