ehb54
commented
5 years ago Similar issue with Sample Data / Sample Value Sets 3.3.2, it seems the tables are not being created following the instructions of the deployment guide.
-->docker ps | grep vss-db 9a65619ea3b8 mysql:5.7 "docker-entrypoint.s…" 19 hours ago Up 35 minutes 33060/tcp, 0.0.0.0:3309->3306/tcp java_vss-db.c2s.com_1 -->docker exec -it 9a65619ea3b8 bash root@9a65619ea3b8:/# cd /java/C2S_PROPS/vss root@9a65619ea3b8:/java/C2S_PROPS/vss# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use vss; Database changed mysql> source vss_db_sample.sql; ERROR 1146 (42S02): Table 'vss.value_set_category_system' doesn't exist ERROR 1146 (42S02): Table 'vss.code_system' doesn't exist ERROR 1146 (42S02): Table 'vss.code_system_version' doesn't exist ERROR 1146 (42S02): Table 'vss.value_set_category' doesn't exist ERROR 1146 (42S02): Table 'vss.value_set' doesn't exist ERROR 1146 (42S02): Table 'vss.coded_concept' doesn't exist ERROR 1146 (42S02): Table 'vss.coded_concept_value_set' doesn't exist mysql>
burcakulug
CindyLiFei
I am setting up a test instance with 3.5.0, using C2S v3 deployment guide. Got thru 3.1.1 *Configure DB Server" & 3.1.2 "Configure App Server" without issue. I skipped the "edge-server security" step since, if I am reading correctly - https://github.com/bhits/consent2share#ssl - this is not needed for testing environments. Got thru 3.1.5, .6 (docker-compose steps) without issue.
ERRORS found following the Populate Sample Data 3.3.1 instructions: -->docker ps | grep pls-db 04d28eade981 mysql:5.7 "docker-entrypoint.s…" 19 hours ago Up 21 minutes 33060/tcp, 0.0.0.0:3308->3306/tcp java_pls-db.c2s.com_1 -->docker exec -it 04d28eade981 bash root@04d28eade981:/# cd /java/C2S_PROPS/pls root@04d28eade981:/java/C2S_PROPS/pls# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use pls; Database changed mysql> source insert_state_code_lookup_data.sql; Database changed ERROR 1146 (42S02): Table 'pls.state_code' doesn't exist mysql> source pls_db_sample.sql; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected (0.00 sec) Database changed ERROR 1146 (42S02): Table 'pls.provider' doesn't exist ERROR 1146 (42S02): Table 'pls.provider' doesn't exist ERROR 1146 (42S02): Table 'pls.provider' doesn't exist ERROR 1146 (42S02): Table 'pls.provider' doesn't exist Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec)