implementation of yellowfin-app-only docker image - repository database access problem

Junya Fujiyoshi shared this question 48 days ago
Answered

I am trying to implement Docker container "yellowfin-app-only" in Docker Hub into my local Docker environment.

https://hub.docker.com/r/yellowfinbi/yellowfin-app-only


I am facing a trouble to connect to the repository database installed in my host OS from this container.

I have installed repository database into PostgreSQL database in my host OS.

However, when trying to implement yellowfin-app-only container using this repository database with the attached docker-compose.yml configuration file, yellowfin service does not start with "Performing JDBC connections...ERROR". As a result, when accessing to yellowfin, startuperror.jsp is shown (http://localhost:8081/startuperror.jsp).

Meanwhile ,when connecting to this repository database using psql command from the container with the following command, I can access to repository database and can see all the tables.

psql -h host.docker.internal -p 5432 -U yellowfin -d yellowfin


Could anyone give me advices how to improve this situation?


Regards,Junya

Comments (6)

photo
1

Please see the attached image to help understanding the environment.

photo
1

Hi Junya,

Hope you're doing well.

If the PostgreSQL database is not installed within a separate Docker container, but rather on the host computer itself, can I ask why you're using host.docker.internal?

For my app-only image, I would normally write the connection string with my machine's IP address:

e.g.

jdbc:postgresql://192.168.1.130:5432/yf_9711_20220406

Kind regards,

Chris

photo
1

Hi Chris.

Thank you for your reply.

Referring the previous post you answered to Hiroyuki's question, I also tried the connection string with my machine's IP address. He actually helped me to solve this matter. However, the result was the same.

https://community.yellowfinbi.com/topic/error-when-starting-docker-app-only-container

I guess this matter is related to my computer's environment.

I will change the environment such as using VM in AWS/Azure, or different PC.

Regards,

Junya

photo
1

Hi Junya,

Ah yes, I remember Hiroyuki's problem now.

Okay, please do give another environment a try. Let me know if you want to keep this ticket open.

Kind regards,

Chris

photo
1

Hi Chris,

I could connect to PostgreSql DB from container after changing the test environment.

It seems this was a problem related to my computer's environment.

regards,

Junya

photo
1

Hi Junya,

Thanks for letting me know that you were successful when trying a different environment. I'll close this ticket off.

Kind regards,

Chris