OpenOffice 2.3 BASE, PostgreSQL 8.3 with JDB/ODBC: NO SSL possible?
ohartman at zedat.fu-berlin.de
Wed Feb 27 11:09:59 UTC 2008
I got a problem in connecting a BASE Client (OpenOffice DB Client) to a
remote, SSL-secured PostgreSQL server. Both, client and server, running
FreeBSD 7.0, but this does only matter for the OO client side. With OO
under Windows it is either with ODBC or JDBC possible to connect via SSL
to the DB server, but this is not for OO under FreeBSD using JDBC/ODBC
as recently compiled from the ports.
I searched the net and found that because postges-odbc is compiled
against libpg.so on FreeBSD/UNIX and SSL connectivity is therein, it
should be up to the ODBC driver how to connect , but I did not find any
explanation what to switch on or of in odbc.ini.
Even with JDBC (postgres-jdbc), where SSL should be a standard with JDK
1.5, I can not find any information about a knob or even any help on
that so I guess the specific driver, either JDBC or ODBC should be
capable of negotiating the connection type.
This works without problems with Windows clients running OO or M$-Office
using JDBC or ODBC from www.potgresql.org.
Can anybody help or give a hint?
More information about the freebsd-questions