Bonitasoft-Community / docker_bonita

:whale: Source of the official Bonita Docker image
https://hub.docker.com/_/bonita/
18 stars 16 forks source link

Azure postgres database #12

Open devcrp opened 5 years ago

devcrp commented 5 years ago

Hi,

I'm trying to make the bonita's docker image to use a posgres database for data persistance, but it seems to have trouble to work with the username format that Azure works with (username@hostname).

If I specify the usernames like username@hostname in the environment variables, then I get an error saying

role "username@hostname" does not exist

because the role is actually "username", without the "@hostname" postfix.

But then, if I just specify the usernames without the hostname part, then all the logins fail.

I can trick it by creating both users, with and without the hostname part, and then the databases are created succesfully, but then I get another login error when trying to create the tables, so I'm assuming it's related.

Any kind of help will be very welcome!

JeremJR commented 5 years ago

Hi, An evolution was kindly proposed by @domtoupin into https://github.com/Bonitasoft-Community/docker_bonita/pull/10 This PR was unfortunately closed due to a mistake with git subtree. You can try to see if he has some time free to finalize that? If not we will try to do that on our side.

devcrp commented 5 years ago

Thanks @JeremJR , glad to see I'm not the only one :) - I'll check on that.

I have been able to make it work by pre-creating users in both formats, so now I'm getting the databases and tables automatically created on init.