[
https://issues.apache.org/jira/browse/AMBARI-22580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16276743#comment-16276743
]
Doroszlai, Attila commented on AMBARI-22580:
--------------------------------------------
Hi [~unaipme],
Please make sure you configure the JDBC driver for Postgres prior to starting
Ambari Server:
{noformat}
ambari-server setup --jdbc-db=postgres
--jdbc-driver=/usr/share/java/postgresql-jdbc.jar
{noformat}
Install the {{postgresql-jdbc}} (on RHEL/CentOS/SuSE) or
{{libpostgresql-jdbc-java}} (on Debian/Ubuntu) package if
{{/usr/share/java/postgresql-jdbc.jar}} is not available.
> Streaming Analytics Manager (SAM) not working with PostgreSQL
> -------------------------------------------------------------
>
> Key: AMBARI-22580
> URL: https://issues.apache.org/jira/browse/AMBARI-22580
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Reporter: Unai P. Mendizabal
>
> Hi!
> I was trying to install SAM on my Ambari cluster and trying to use the same
> PostgreSQL database I use for Ambari server. The installation fails though,
> with error "KeyError: 'jdbc_driver_jar" coming from the params.py file of the
> Streamline service. I dived into it and realized that variable
> 'jdbc_driver_jar' is never initialized for PostgreSQL databases, while it
> does when it comes to Oracle or MySQL.
> The file is
> /var/lib/ambari-server/resources/common-services/STREAMLINE/0.5.0/package/scripts/params.py,
> you can see the problem from line 192 on. As a workaround, I think it should
> be possible to manually set 'jdbc_driver_jar' to the path to the jdbc driver
> on that same file.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
