Ctfreak - Task scheduler for distributed shell and sql script execution

[jypelle]

Live demo

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?

[timconsidine]

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?

[jypelle]

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

[jypelle]

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

[nebulon]

@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/

[jypelle]

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

[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.

[timconsidine]

Thank you. Will take it for a spin later.

[girish]

@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.

[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?

[girish]

@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.

[jypelle]

@girish

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

[girish]

@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

[jypelle]

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.

[girish]

@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.

[marcusquinn]

@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

[jypelle]

Thx @marcusquinn !!