squash_tm
Bundle to run Squash TM on Nomad
MariaDB
If running with MariaDB, with vault dynamic credentials, you'll face some problem as the definer of VIEWS and TRIGGERS won't exist anymore once vault expires the user which has created them. To fix this, run this once, as root, on your MariaDB server
# Fix triggers to have root as definer, instead of an ephemeral [[ .instance ]] user
mariadb -Bsre 'SELECT CONCAT("DROP TRIGGER ", trigger_name, ";", " CREATE TRIGGER ", TRIGGER_NAME, " ", ACTION_TIMING, " ", EVENT_MANIPULATION, " ON ", EVENT_OBJECT_SCHEMA, ".", EVENT_OBJECT_TABLE, " FOR EACH ROW ", ACTION_STATEMENT,
";") AS sqlCommand FROM information_schema.triggers WHERE EVENT_OBJECT_SCHEMA = "[[ .instance ]]";' | sed 's/[[ .instance ]]\./`[[ .instance ]]`./g' | mariadb [[ .instance ]]
# Fix view to use the invoker security
mariadb -e 'ALTER SQL SECURITY INVOKER VIEW EXECUTION_ISSUES_CLOSURE AS select `exec`.`EXECUTION_ID` AS `execution_id`,`issue`.`ISSUE_ID` AS `issue_id` from (`[[ .instance ]]`.`EXECUTION` `exec` join `[[ .instance ]]`.`ISSUE` `issue` on(`exec`.`ISSUE_LIST_ID` = `issue`.`ISSUE_LIST_ID`)) union select `eesteps`.`EXECUTION_ID` AS `execution_id`,`issue`.`ISSUE_ID` AS `issue_id` from ((`[[ .instance ]]`.`EXECUTION_EXECUTION_STEPS` `eesteps` join `[[ .instance ]]`.`EXECUTION_STEP` `estep` on(`eesteps`.`EXECUTION_STEP_ID` = `estep`.`EXECUTION_STEP_ID`)) join `[[ .instance ]]`.`ISSUE` `issue` on(`estep`.`ISSUE_LIST_ID` = `issue`.`ISSUE_LIST_ID`)) union select `sn`.`EXECUTION_ID` AS `execution_id`,`[[ .instance ]]`.`ISSUE`.`ISSUE_ID` AS `issue_id` from (`[[ .instance ]]`.`SESSION_NOTE` `sn` join `[[ .instance ]]`.`ISSUE` on(`[[ .instance ]]`.`ISSUE`.`ISSUE_LIST_ID` = `sn`.`ISSUE_LIST_ID`));' [[ .instance ]]
mariadb -e 'ALTER SQL SECURITY INVOKER VIEW RLN_RESOURCE AS select `fold`.`RLN_ID` AS `rln_id`,`fold`.`RES_ID` AS `res_id` from `[[ .instance ]]`.`REQUIREMENT_FOLDER` `fold` union select `req`.`RLN_ID` AS `rln_id`,`req`.`CURRENT_VERSION_ID` AS `res_id` from `[[ .instance ]]`.`REQUIREMENT` `req`;' [[ .instance ]]
Languages
HCL
66.3%
Shell
20.3%
Dockerfile
13.4%