Bug 64909 - ODBC or JDBC Base to Heroku PostgreSQL Requires "SSL=true"
Summary: ODBC or JDBC Base to Heroku PostgreSQL Requires "SSL=true"
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.0.2.2 release
Hardware: x86 (IA32) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-05-23 11:35 UTC by Richard Broersma Jr.
Modified: 2013-12-20 15:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Richard Broersma Jr. 2013-05-23 11:35:43 UTC 
As the subject line describes I'm trying to connect to Heroku PostgreSQL via JDBC and ODBC.

However, the required connection string using JDBC yields the following error message:

SQL Status: 08006

SSL error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target


Connecting via ODBC works.  However, for some reason, only the public schema shows.  Other schema are not listed.

Here a few details about my system:
LO: Version 4.0.2.2 (Build ID: 400m0(Build:2))
OS: Ubuntu 13.04
Java:
java version "1.7.0_21"
OpenJDK Runtime Environment (IcedTea 2.3.9) (7u21-2.3.9-1ubuntu1)
OpenJDK Server VM (build 23.7-b01, mixed mode)

Any thoughts?
Comment 1 Joel Madero 2013-12-20 15:47:25 UTC 
Lionel - looks like another tricky one for you to look into?
Comment 2 Lionel Elie Mamane 2013-12-20 15:52:06 UTC 
Well, if Heroku PostgreSQL requires SSL, then enable SSL in the JDBC driver... If the JDBC driver does not support SSL, then I don't see how that is LibreOffice's bug.

As to ODBC, well, maybe your user only has permission to the public schema? Or try setting the PostgreSQL schema path in a "connection command" in the ODBC driver.

You could also try LibreOffice's native PostgreSQL driver.