Problem with deploy on Rancher with external DB

Question

Problem with deploy on Rancher with external DB

AndreaNocciolini opened this issue 2 years ago · 10 comments

Hello!
I'm opening this issue because I'm having serious problems deploying nominatim on Rancher using an external database. I've change the yaml file following the instructions on the readme file (), but that doesn't work. After a while the installation started, it tries to drop the database just created and it goes in error. If i delete the database while is restarting, it seems to overcome this step, but then another error appear, saying that it miss a www-data user.
I'm trying since a while now, and i don't really know how to solve those problems, can i have any help? I am attaching a facsimile of the yaml with which I overwrite the data during initialization

.

Answer 1 · 2022-07-21T09:07:45.000Z

I will take a look W dniu czw., 21.07.2022 o 11:05 AndreaNocciolini ***@***.***> napisał(a):

…

Hello! I'm opening this issue because I'm having serious problems deploying nominatim on Rancher using an external database. I've change the yaml file following the instructions on the readme file ( <https://github.com/robjuz/helm-charts/tree/master/charts/nominatim#readme>), but that doesn't work. *After a while the installation started, it tries to drop the database just created and it goes in error. If i delete the database while is restarting, it seems to overcome this step, but then another error appear, saying that it miss a www-data user*. I'm trying since a while now, and i don't really know how to solve those problems, can i have any help? I am attaching a facsimile of the yaml with which I overwrite the data during initialization [image: Schermata 2022-07-21 alle 11 04 41] <https://user-images.githubusercontent.com/80393968/180175353-6c1100fc-5b96-4481-931e-eeebd60c4e7a.png> . — Reply to this email directly, view it on GitHub <#19>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACFLPUDNOPT2I3ZVVYTH6EDVVEHGBANCNFSM54G3BBVQ> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

Answer 2 · 2022-07-21T09:14:39.000Z

Thank you very much!

Answer 3 · 2022-07-23T14:35:00.000Z

Hallo @AndreaNocciolini

First of all thanks for interests in using this chart.

I was able to perform a standard installation, so the install process is working 😄

Looking into the code I found, that the database name is hardcoded. I will fix it today.

Im the meantime could you provide me some additional informations about your database instance? How you installed it? Does it have the necessary nominatim extension?

Answer 4 · 2022-07-24T16:18:41.000Z

Hi @robjuz,
I'm glad that you're helping me!
About my database instance, unfortunately I can't provide much information because it was prepared for me by one of my colleagues. He installed the database on one of the amazon services (EC2) and he give me the data to connect to it. Once you've fix the problem I'll try again the installation, can you please tell me which extension are needed for Nominatim?

Answer 5 · 2022-07-24T16:25:31.000Z

https://nominatim.org/release-docs/latest/admin/Advanced-Installations/#using-an-external-postgresql-database

Answer 6 · 2022-07-25T06:17:00.000Z

@AndreaNocciolini
I releases a update. Please try now.

Some important things:

The database is always nominatim. This comes from nominatim itself.
The database user need superuser privilages to be able to create the postgis and hstore extension

Answer 7 · 2022-07-28T13:11:30.000Z

@AndreaNocciolini Any progress?

Answer 8 · 2022-07-29T08:24:21.000Z

Hi @robjuz !
Sorry for the late reply, but I couldn't try as geofabrik blocked my IP :(. I'm trying to get in touch with them to get unblocked, once solved I'll let you know right away!

Answer 9 · 2022-09-23T13:40:14.000Z

@AndreaNocciolini Have you successes with the installation?

Answer 10 · 2022-09-23T13:59:59.000Z

hello @robjuz , yes, we finish yestarday! The installation has been completed by my CTO, he was able to make it work (I messed up a bit with postgres DBs because of my inexperience :P)!