2025-03-11 15:57:59 +01:00
2025-01-31 16:31:41 +01:00
2025-03-11 15:57:59 +01:00
2025-02-24 12:21:14 +01:00
2025-01-31 16:31:41 +01:00
2025-01-31 16:31:41 +01:00
2025-02-24 12:21:14 +01:00
2025-03-11 15:57:59 +01:00
2025-01-31 16:31:41 +01:00
2025-01-27 15:51:44 +01:00
2025-02-01 14:58:02 +01:00
2025-03-11 15:57:59 +01:00

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 ]]
Description
Bundle to run Squash TM on Nomad
Readme MIT 68 KiB
Languages
HCL 66.3%
Shell 20.3%
Dockerfile 13.4%