How to pass environment variables to Docker Hop Server instead of using env.json?

[PierreLoren]

I am running Hop Server in a Docker container to execute workflows and pipelines through the REST API.
Currently, I provide environment variable configuration by mounting a parameter file project-docker-env.json.

I would like to configure these variables directly through system environment variables instead.

I tried setting the HOP_RUN_PARAMETERS parameter like this:
HOP_RUN_PARAMETERS=PG_in1_hostname=host.docker.internal,PG_in1_port=5432,PG_in1_username=postgres
Unfortunately, when I start a process on Hop Server, the declared variables are not recognized, and I get errors such as
src_tab.0 - Unable to parse URL jdbc:postgresql://${PG_in1_hostname}:${PG_in1_port}/${PG_in1_database}
How can I correctly pass such settings to Hop Server?

volumes:
- ./logs:/files/logs
- ./docker-env.json:/files/config/projects/HOPTranslation/project-docker-env.json
environment:
- HOP_ENVIRONMENT_NAME=HT_Prod
- HOP_ENVIRONMENT_CONFIG_FILE_NAME_PATHS=/files/config/projects/HOPTranslation/project-docker-env.json

[NicoDupont]

Hi Pierre,

I do something like that from Apache airflow to pass parameters
'HOP_RUN_PARAMETERS': f'INPUT_DIR=,RUN_LOCATION={HopConfigDocker['RUN_LOCATION']}',

I'm not sure but HOP_RUN_PARAMETER do not set environnement variable for me or only one and she is split to create paramaters for hop run

[PierreLoren]

Do the parameters you pass through HOP_RUN_PARAMETER have to be defined as input parameters for the Workflow?
I use variables, and unfortunately, HOP_RUN_PARAMETER doesn't set them.
I'm interested in correctly passing the env without having to mount the env file.

[KBoersch]

Why don't you just set an environmental variable in your docker-file?

[PierreLoren]

Maybe I’m configuring this incorrectly, but the configuration of variables used by the Hop server is set in an environment variables file (a JSON file). My problem is how to transfer the variables from the host into this environment variables file inside the container. Perhaps my assumption is wrong, and I don’t need to use the file at all. How should this be done then?

[KBoersch]

Sry, I misinterpreted what you wanna do. Although I still don't really understand what you wanna accomplish by setting these environmental variables through the system environment variables vs. setting it through the environmental.json.

The result seems to be the same to me. Maybe, if you elaborate a bit more about the purpose of this, we can figure something out.

[hansva]

Depends on how you are using the Hop server.
If you are using webservices, you will indeed have to mount the files and start the server with a project.
When using hop-run to start workflows/pipelines on a remote run configuration, then all the environment variables are transferred to the server.

[PierreLoren]

Unfortunately, I'm using a hop server with a web service. Thanks for the information.