From owner-freebsd-questions@FreeBSD.ORG Wed Feb 27 11:09:59 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 42C991065764 for ; Wed, 27 Feb 2008 11:09:59 +0000 (UTC) (envelope-from ohartman@zedat.fu-berlin.de) Received: from outpost1.zedat.fu-berlin.de (outpost1.zedat.fu-berlin.de [130.133.4.66]) by mx1.freebsd.org (Postfix) with ESMTP id CF1D88FC2E for ; Wed, 27 Feb 2008 11:09:53 +0000 (UTC) (envelope-from ohartman@zedat.fu-berlin.de) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost1.zedat.fu-berlin.de (Exim 4.69) for freebsd-questions@freebsd.org with esmtp (envelope-from ) id <1JUKAa-00072H-Ep>; Wed, 27 Feb 2008 12:09:52 +0100 Received: from telesto.geoinf.fu-berlin.de ([130.133.86.198]) by inpost2.zedat.fu-berlin.de (Exim 4.69) for freebsd-questions@freebsd.org with esmtpsa (envelope-from ) id <1JUKAa-0003Cr-E2>; Wed, 27 Feb 2008 12:09:52 +0100 Message-ID: <47C544EE.3030401@zedat.fu-berlin.de> Date: Wed, 27 Feb 2008 11:09:34 +0000 From: "O. Hartmann" Organization: Freie =?ISO-8859-15?Q?Universit=E4t_Berlin?= User-Agent: Thunderbird 2.0.0.9 (X11/20080122) MIME-Version: 1.0 To: freebsd-questions@freebsd.org Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: 130.133.86.198 Subject: OpenOffice 2.3 BASE, PostgreSQL 8.3 with JDB/ODBC: NO SSL possible? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 27 Feb 2008 11:09:59 -0000 Hello, 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? Regards, Oliver