[AMBARI-22580] Streaming Analytics Manager (SAM) not working with PostgreSQL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: ambari-server
• Assignee: Unassigned
• Reporter: Unai P. Mendizabal
• Created: 04/Dec/17 11:59
• Updated: 15/Feb/18 06:27

Description

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.