Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. App Wishlist
  3. Ctfreak - Task scheduler for distributed shell and sql script execution

Ctfreak - Task scheduler for distributed shell and sql script execution

Scheduled Pinned Locked Moved Solved App Wishlist
task scheduling
17 Posts 5 Posters 2.7k Views 6 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • jypelleJ Offline
    jypelleJ Offline
    jypelle
    wrote on last edited by
    #1

    Live demo

    efbb1ef4-cda5-49b0-b473-0295ee51256b-image.png

    Hello everyone,

    Ctfreak allows for the centralized execution of various types of tasks:

    • Shell scripts (bash/powershell) on multiple servers concurrently via SSH
    • SQL scripts on multiple databases concurrently (mysql/mariadb/postgresql)
    • HTTP request calls
    • Workflows (to launch other tasks)

    It also provides the ability to send notifications based on the results.

    Some use cases include:

    • Replacing all the crontabs on your servers
    • Running your scripts through a nice and responsive web app
    • Regularly checking if your website is still up
    • ...

    The FREE Edition has some restrictions but does the job for personal use or small and medium-sized enterprises.

    I'm offering to package it for Cloudron (it's easier for me since I'm the author 😉 ), but before that, I would like to know if you're interested?

    1 Reply Last reply
    5
    • timconsidineT Offline
      timconsidineT Offline
      timconsidine
      App Dev
      wrote on last edited by
      #2

      Yes, I can see a use case for it for me.
      I have 6 servers with some reporting scripts.
      Currently I have to maintain them inidividually.
      Would Ctfreak allow me to manage that ?
      Did I understand correctly?

      1 Reply Last reply
      1
      • jypelleJ Offline
        jypelleJ Offline
        jypelle
        wrote on last edited by
        #3

        From the moment you have SSH access to your servers, yes, no problem

        1 Reply Last reply
        0
        • jypelleJ Offline
          jypelleJ Offline
          jypelle
          wrote on last edited by
          #4

          While waiting for me to start packaging, you can perform a quick test using:

          docker run --name ctfreak -p 6700:6700 -e TZ=Europe/Paris jypsoftware/ctfreak

          1 Reply Last reply
          2
          • nebulonN Offline
            nebulonN Offline
            nebulon
            Staff
            wrote on last edited by
            #5

            @jypelle welcome here on the forum! We will happily add your app to the library if a package is provided. We will also help you out with the packaging questions.

            We have some packaging docs with references to packages for various frameworks/languages at https://docs.cloudron.io/packaging/cheat-sheet/

            1 Reply Last reply
            1
            • jypelleJ Offline
              jypelleJ Offline
              jypelle
              wrote on last edited by
              #6

              Thx @nebulon, I will not hesitate to come back to you if I have any questions.

              1 Reply Last reply
              1
              • jypelleJ Offline
                jypelleJ Offline
                jypelle
                wrote on last edited by jypelle
                #7

                Hi

                @nebulon

                I tried to package ctfreak for cloudron:

                https://github.com/jypsoftware/ctfreak-cloudron

                I was able to test it successfully on my test Cloudron instance.

                girishG 1 Reply Last reply
                3
                • timconsidineT Offline
                  timconsidineT Offline
                  timconsidine
                  App Dev
                  wrote on last edited by
                  #8

                  Thank you. Will take it for a spin later.

                  1 Reply Last reply
                  0
                  • jypelleJ jypelle

                    Hi

                    @nebulon

                    I tried to package ctfreak for cloudron:

                    https://github.com/jypsoftware/ctfreak-cloudron

                    I was able to test it successfully on my test Cloudron instance.

                    girishG Offline
                    girishG Offline
                    girish
                    Staff
                    wrote on last edited by
                    #9

                    @jypelle Are you able to add a license at https://github.com/jypsoftware/ctfreak-cloudron ? Preferably MIT/GPL or similar.

                    I will then move the repo over to git.cloudron.io where we maintain our packages and can then publish the package.

                    1 Reply Last reply
                    1
                    • jypelleJ Offline
                      jypelleJ Offline
                      jypelle
                      wrote on last edited by jypelle
                      #10

                      @girish license file is here: https://github.com/jypsoftware/ctfreak-cloudron/blob/master/ctfreak-app/LICENSE

                      Would you prefer me to move the file to the root directory?

                      girishG 1 Reply Last reply
                      1
                      • jypelleJ jypelle

                        @girish license file is here: https://github.com/jypsoftware/ctfreak-cloudron/blob/master/ctfreak-app/LICENSE

                        Would you prefer me to move the file to the root directory?

                        girishG Offline
                        girishG Offline
                        girish
                        Staff
                        wrote on last edited by
                        #11

                        @jypelle It's fine, I will restructure the repo when I move it over shortly.

                        If you have an account in git.cloudron.io, I can also give you permissions to the package repo I create.

                        1 Reply Last reply
                        1
                        • jypelleJ Offline
                          jypelleJ Offline
                          jypelle
                          wrote on last edited by
                          #12

                          @girish

                          Alright. Here is my account: https://git.cloudron.io/jypelle

                          1 Reply Last reply
                          2
                          • girishG Offline
                            girishG Offline
                            girish
                            Staff
                            wrote on last edited by
                            #13

                            @jypelle repo is at https://git.cloudron.io/cloudron/ctfreak-app and you are also a maintainer there. I was able to build the app and works fine.

                            I noticed that app has OIDC already. Is it possible to script this? We have an oidc addon . Just put this under "addons" in CloudronManifest.json and you will have a bunch of env variables . See https://docs.cloudron.io/packaging/addons/#oidc

                            1 Reply Last reply
                            2
                            • jypelleJ Offline
                              jypelleJ Offline
                              jypelle
                              wrote on last edited by
                              #14

                              Great!

                              For OIDC configuration, unfortunately, at the moment, it can only be done through the web interface. However, I'll make a note of it as a possible future enhancement.

                              1 Reply Last reply
                              1
                              • girishG Offline
                                girishG Offline
                                girish
                                Staff
                                wrote on last edited by
                                #15

                                @jypelle Thanks, I have pushed as unstable. We will add some tests before making it stable. There's also a separate forum category to discuss further.

                                1 Reply Last reply
                                3
                                • girishG girish marked this topic as a question on
                                • girishG girish has marked this topic as solved on
                                • robiR robi referenced this topic on
                                • marcusquinnM Offline
                                  marcusquinnM Offline
                                  marcusquinn
                                  wrote on last edited by
                                  #16

                                  @jypelle Welcome, great work, and thank you for your open-source spirit. I'm sure you'll be much appreciated and well promoted with Cloudron and its community here. 👍 from me 🙂

                                  Web Design https://www.evergreen.je
                                  Development https://brandlight.org
                                  Life https://marcusquinn.com

                                  1 Reply Last reply
                                  2
                                  • jypelleJ Offline
                                    jypelleJ Offline
                                    jypelle
                                    wrote on last edited by
                                    #17

                                    Thx @marcusquinn !!😃

                                    1 Reply Last reply
                                    2
                                    • girishG girish forked this topic on
                                    • girishG girish locked this topic on
                                    Reply
                                    • Reply as topic
                                    Log in to reply
                                    • Oldest to Newest
                                    • Newest to Oldest
                                    • Most Votes


                                    • Login

                                    • Don't have an account? Register

                                    • Login or register to search.
                                    • First post
                                      Last post
                                    0
                                    • Categories
                                    • Recent
                                    • Tags
                                    • Popular
                                    • Bookmarks
                                    • Search