From owner-freebsd-ports@FreeBSD.ORG  Thu Dec  6 21:26:25 2007
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@FreeBSD.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 238B116A473
	for <freebsd-ports@FreeBSD.org>; Thu,  6 Dec 2007 21:26:25 +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 DB60B13C46B
	for <freebsd-ports@FreeBSD.org>; Thu,  6 Dec 2007 21:26:23 +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.67) with esmtp
	(envelope-from <ohartman@zedat.fu-berlin.de>)
	id <1J0Nxl-0000Nv-7K>; Thu, 06 Dec 2007 22:08:53 +0100
Received: from telesto.geoinf.fu-berlin.de ([130.133.86.198])
	by inpost2.zedat.fu-berlin.de (Exim 4.67) with esmtpsa
	(envelope-from <ohartman@zedat.fu-berlin.de>)
	id <1J0Nxl-0007Ku-6M>; Thu, 06 Dec 2007 22:08:53 +0100
Message-ID: <47586505.6030604@zedat.fu-berlin.de>
Date: Thu, 06 Dec 2007 21:09:25 +0000
From: "O. Hartmann" <ohartman@zedat.fu-berlin.de>
Organization: Freie =?ISO-8859-15?Q?Universit=E4t_Berlin?=
User-Agent: Thunderbird 2.0.0.9 (X11/20071121)
MIME-Version: 1.0
To: freebsd-questions@freebsd.org, freebsd-ports@FreeBSD.org
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Originating-IP: 130.133.86.198
Cc: 
Subject: ports/database/ruby-dbi and ports/database/ruby-dbd_pg faulty.
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 06 Dec 2007 21:26:25 -0000

Hello.

I try to use DBI:Pg and DBI:MySQL within a ruby-skript for accessing 
either MySQL or PostgreSQL database.

Box is FreeBSD 7.0-BETA4
Mysql is mysql50-server
Postgresql is posgresql82-server and postgresql82-client
with unixODBC and ruby-dbi and ruby-dbd_pg and ruby-dbd_mysql installed.

When running an access using Pg as backend (Postgres) and run this
connect:

dsn   = "DBI:Pg:dbname=#{@db};host=#{@db_host};port=#{@db_port}"


dbh     = DBI.connect(dsn,@db_user,@db_passwd)

I get this error:

/usr/local/lib/ruby/site_ruby/1.8/dbi.rb:344:in `load_driver': Could not 
load driver (no such file to load -- postgres) (DBI::InterfaceError)
         from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:227:in 
`_get_full_driver'
         from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:213:in `connect'


It seems that a class library 'postgres.rb' is missing, which is 
included by Pg.rb located in /usr/local/lib/ruby/site_ruby/1.8/DBD/Pg/.

I did a find on my whole filesystem looking for 'postgres.rb' or 
'postgres*' and did not find suitable. It seems this file is missing and 
not been installed by the installation process via ports.

Is this a 'feature', or should I fill out a PR?


Oliver