Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DF1BA475CA6 for ; Sat, 14 Sep 2002 10:30:01 -0400 (EDT) Received: from mailhub2.sghms.ac.uk (firewall.sghms.ac.uk [194.82.50.2]) by postgresql.org (Postfix) with ESMTP id DECFC475C9E for ; Sat, 14 Sep 2002 10:30:00 -0400 (EDT) Received: from [194.82.51.24] (helo=imail) by mailhub2.sghms.ac.uk with esmtp (Exim 4.05) id 17qDtf-0005E5-00 for pgsql-interfaces@postgresql.org; Sat, 14 Sep 2002 15:27:43 +0100 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.1 HotFix 0.7 (built May 7 2002)) with ESMTPA id <0H2F001LBMXJWV@imail.sghms.ac.uk> for pgsql-interfaces@postgresql.org; Sat, 14 Sep 2002 15:29:43 +0100 (BST) Date: Sat, 14 Sep 2002 15:29:47 +0100 From: Adam Witney To: pgsql-interfaces Message-id: MIME-version: 1.0 User-Agent: Microsoft-Entourage/10.1.0.2006 Subject: Connecting R to PostgreSQL Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT X-Spam-Status: No, hits=-99.5 required=6.0 tests=TO_LOCALPART_EQ_REAL,USER_IN_WHITELIST version=2.31 X-Spam-Level: X-MailScanner: Found to be clean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/54 X-Sequence-Number: 3115 Hi, I am not sure if the problem here relates to PostgreSQL or elsewhere, but I am trying to connect the R statistical package to my PostgreSQL database using the Rdbi.PgSQL driver. The driver installs ok, however when I try to load it in R I get the following error > library(Rdbi.PgSQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/Users/adam/Projects/R stuff/rlibs/Rdbi.PgSQL/libs/Rdbi.PgSQL.so": dlcompat: dyld: /sw/lib/R/bin/R.bin Undefined symbols: _ERR_get_error _ERR_reason_error_string _SSL_CTX_new _SSL_connect _SSL_free _SSL_library_init _SSL_load_error_strings _SSL_new _SSL_read _SSL_set_fd _SSL_write _SSLv23_method Error in library(Rdbi.PgSQL) : .First.lib failed Looking through the source code the driver includes which subsequently includes openssl/ssl.h I don't know if this is where the problem lies? My system is Mac OSX 10.2 Any ideas or pointers to further information would be greatly appreciated. Thanks Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.