Bonitasoft-Community/docker_bonita

Azure postgres database

Opened this issue · 2 comments

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!

Hi,
An evolution was kindly proposed by @domtoupin into #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.

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.