question Re: Problem to install postgresql odbc driver to configure ambari in Archives of Support Questions (Read Only)

Problem to install postgresql odbc driver to configure ambari

elton_freitas — Wed, 24 May 2017 20:05:51 GMT

Hi guys, I'm trying to install ambari, but I'm having problems with the postgresql driver. I am doing an installation without internet, so I downloaded the packages needed for this task. Here's the mistake I'm having, have anyone been through this?

]# whereis java

java: /usr/bin/java /usr/share/man/man1/java.1

]# rpm -Uhv jpackage-utils-5.0.0-7.2.src.rpm

warning: jpackage-utils-5.0.0-7.2.src.rpm: Header V3 DSA/SHA1 Signature, key ID abde7ce2: NOKEY Updating / installing... 1:jpackage-utils-0:5.0.0-7.2 ################################# [100%]

]# rpm -Uhv postgresql-jdbc-9.2.1002-5.el7.noarch.rpm

warning: postgresql-jdbc-9.2.1002-5.el7.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY error: Failed dependencies: jpackage-utils is needed by postgresql-jdbc-9.2.1002-5.el7.noarch

]# Write failed: Connection reset by peer

Re: Problem to install postgresql odbc driver to configure ambari

amerissa — Thu, 25 May 2017 01:29:52 GMT

So JDBC ships with Ambari server be default I believe.

look into /var/lib/ambari-server/resoruces you will find the JDBC there I believe

If not use this page to down the JDBC

https://jdbc.postgresql.org/download.html

Re: Problem to install postgresql odbc driver to configure ambari

elton_freitas — Wed, 20 Sep 2017 19:22:06 GMT

I have decided as follows:

I downloaded the postgresql-42.1.1.jar file, then put it inside the "/ usr / share / java /" folder.

For security, I also unpacked it inside the JAVA_HOME folder, "= / usr / java / jdk1.8.0_131", the decompression is done with the command "jar -xfv postgresql-42.1.1.jar".

I hope to help someone else who goes through it.

Re: Problem to install postgresql odbc driver to configure ambari

elton_freitas — Wed, 20 Sep 2017 19:25:08 GMT

thanks for the tip, helped me to get the answer.