question Re: NI FI problems with postgree server in Support Questions

NI FI problems with postgree server

PavelPrudnikov — Thu, 12 Dec 2019 14:28:06 GMT

Hi, I'm newbie in NIFI and also in java services

yesterday I downloaded nifi-1.10.0 bin version

i run run-nifi.bin

and after i started to work with NIFI

I made a connection to postgree database but it doesn't work

also my colleague made the same thing and everything is ok.

what can goes wrong with my NI FI ?

When I use this password in DBeaver everything is OK.

what have I do to make it right way?

Re: NI FI problems with postgree server

stevenmatison — Thu, 12 Dec 2019 19:05:42 GMT

You will need to add permissions in postgres to allow connection for this user from the NiFi host. You should follow documentation for your version of postgres to complete these steps. If this is a sandbox, or dev setup, I recommend working to give the postgres user "wildcard" or unlimited access from any host. This will remove the requirement of mapping the user permission to a specific host (whatever the nifi host is). Once you get the user opened up you can try to test access from NiFi again.

Re: NI FI problems with postgree server

PavelPrudnikov — Tue, 17 Dec 2019 13:09:09 GMT

Thank you!I resolved the problem

Re: NI FI problems with postgree server

cjervis — Tue, 17 Dec 2019 14:32:21 GMT

I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.