From owner-freebsd-questions@FreeBSD.ORG Sun Dec 9 11:58:55 2007 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 4ED3316A41B for ; Sun, 9 Dec 2007 11:58:55 +0000 (UTC) (envelope-from ohartman@mail.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 104EB13C457 for ; Sun, 9 Dec 2007 11:58:54 +0000 (UTC) (envelope-from ohartman@mail.zedat.fu-berlin.de) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost1.zedat.fu-berlin.de (Exim 4.67) with esmtp (envelope-from ) id <1J1Ko9-0004FI-J5>; Sun, 09 Dec 2007 12:58:53 +0100 Received: from e178034045.adsl.alicedsl.de ([85.178.34.45] helo=thor.walstatt.dyndns.org) by inpost2.zedat.fu-berlin.de (Exim 4.67) with esmtpsa (envelope-from ) id <1J1Ko9-0006Dx-Gk>; Sun, 09 Dec 2007 12:58:53 +0100 Message-ID: <475BD8AF.4060904@mail.zedat.fu-berlin.de> Date: Sun, 09 Dec 2007 12:59:43 +0100 From: "O. Hartmann" User-Agent: Thunderbird 2.0.0.9 (X11/20071118) MIME-Version: 1.0 To: freebsd-openoffice@freebsd.org, freebsd-questions@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: 85.178.34.45 Cc: Subject: OO 2.3.1 connecting a PostgreSQL 8.2 server via SSL and postgresql-odbc? 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: Sun, 09 Dec 2007 11:58:55 -0000 I need to connect to a remote PostgreSQL-Server accepting SSL connections via OO 2.3.1. I installed ports/database/postgresql-odbc utilizing unixODBC for that purpose but I do not have any success connecting the Postgresql server due to the lack of SSL-capability in the postgresql-odbc-driver. Tried a MySQL test setup using mysql-connector-odbc and this worked over SSL for me (ldd shows libssl being compiled in in myodbc, but not compiled in using postgresql-odbc). Does anyone out here solved this problem? Thanks in advance, Oliver