The issue
If a user would set a custom Redis URL via dynflow_redis_url that is not redis://localhost:6379/6, the Dynflow orchestrator and worker(s) will attempt to connect to the default URL which is set when installing the package foreman-dynflow-sidekiq.
In the current state, implementing Redis authentication with foreman is impossible without manually modifying the state of the needed service file, which in return makes the configuration not idempotent. The solution will allow for better Redis configuration for Dynflow Sidekiq.
The solution
Ensure that puppet is managing the dynflow-sidekiq@.service file and modifying the correct setting so the Redis URL is updated.
Both the orchestrator and worker(s) service files are a symlink to the static file dynflow-sidekiq@.service that is installed with the foreman-dynflow-sidekiq package.