Anaël Ollier xi-ao
xi-ao
/ purge_executions_rundeck.sql
Last active
March 5, 2020 09:27
Purge jobs executions from Rundeck H2 Database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELETE FROM PUBLIC.REFERENCED_EXECUTION; | |
| DELETE FROM PUBLIC.BASE_REPORT; | |
| DELETE FROM WORKFLOW_WORKFLOW_STEP wws | |
| WHERE wws.WORKFLOW_COMMANDS_ID IN ( | |
| SELECT WORKFLOW_id FROM EXECUTION | |
| ); | |
| DELETE FROM WORKFLOW_STEP ws |
xi-ao
/ gist:a3ef6df634da6e3f11a90c92e225d2c6
Last active
August 7, 2018 09:49
— forked from futuremill-ltd/gist:2318876
Building Ruby 1.9.3 package for Debian Squeeze x64
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # From a fresh install of squeeze | |
| apt-get install ruby rubygems # Need ruby to use fpm | |
| gem1.8 install ffi --no-ri --no-rdoc -v 1.9.10 | |
| gem1.8 install fpm --no-ri --no-rdoc -v 1.2.0 | |
| apt-get install build-essential openssl libreadline6 libreadline6-dev zlib1g zlib1g-dev libssl-dev ncurses-dev libyaml-dev | |
| wget http://mirrors.ircam.fr/pub/ruby/1.9/ruby-1.9.3-p125.tar.gz | |
| tar -zxvf ruby-1.9.3-p125.tar.gz | |
| cd ruby-1.9.3-p125 |