User Tools

Site Tools


dndwebapp

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
dndwebapp [2020/02/25 21:45]
benbigmac [Back End Documentation]
dndwebapp [2020/02/28 21:11]
chasty2 [Back End Documentation]
Line 33: Line 33:
 Database schema, version 2: Database schema, version 2:
 __ __
 +
 +**one baseStats per charSheet
  
 {{:​dnd_db_v2.jpg?​nolink&​400|}} {{:​dnd_db_v2.jpg?​nolink&​400|}}
Line 42: Line 44:
 ## Enter these commands in bash on a Linux environment. ## Enter these commands in bash on a Linux environment.
  
-## Pull mysql 5.7 docker image (mysql 8 works, but a bugfix is needed). +## create ​docker image from dockerfile and run itMust be in initDB directory to build lug-mysql image 
- +docker ​build -t lug-mysql . 
-docker pull mysql:5.7 +docker run -d --name=lugdb -e MYSQL_ROOT_PASSWORD=test -p 3306:​3306 ​lug-mysql
- +
-## Insert iptables firewall rule for docker ​container at port 3306 and save. Note that the docker daemon must be started after iptables is running. If iptables or a firewall is not running this is not necessary.  +
- +
-iptables ​-A INPUT -i docker0 -p tcp -m tcp --dport 3306 -j ACCEPT +
- +
-service iptables save +
- +
-## create and start docker image +
- +
-docker run -d --name=lugdb -e MYSQL_ROOT_PASSWORD=test ​-e MYSQL_DATABASE=lugdb ​-p 3306:​3306 ​mysql:5.7 +
- +
-## enter container +
- +
-docker exec -it lugdb -p +
- +
-## (in mysql) Create accounts table. +
- +
-use lugdb +
- +
-CREATE TABLE account(id INT NOT NULL AUTO_INCREMENT,​ accountName VARCHAR(20) NOT NULL, password VARCHAR(100) NOT NULL, email VARCHAR(254) NOT NULL, PRIMARY KEY (id)); +
- +
-## (in mysql) Show table. +
- +
-SELECT * from account;+
  
-## (in myqsl) Exit the container.+## delete image and instance if you need to rebuild  
 +docker rm lugdb 
 +docker image rm lug-mysql
  
-quit+## enter mysql  
 +docker exec -it lugdb mysql -uroot -p  ​
 </​code>​ </​code>​
 ===== Meeting Notes===== ===== Meeting Notes=====
dndwebapp.txt · Last modified: 2020/02/28 21:11 by chasty2