From owner-freebsd-ruby@FreeBSD.ORG  Mon Nov 16 15:09:10 2009
Return-Path: <owner-freebsd-ruby@FreeBSD.ORG>
Delivered-To: freebsd-ruby@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 6CC221065694
	for <freebsd-ruby@freebsd.org>; Mon, 16 Nov 2009 15:09:10 +0000 (UTC)
	(envelope-from penty@dgc.se)
Received: from smtp05.dgcsystems.net (smtp05.dgcsystems.net [83.241.254.75])
	by mx1.freebsd.org (Postfix) with ESMTP id 2D9288FC12
	for <freebsd-ruby@freebsd.org>; Mon, 16 Nov 2009 15:09:09 +0000 (UTC)
Received: from picard.dgc.se (220.248.181.62.in-addr.dgcsystems.net
	[62.181.248.220])
	by smtp05.dgcsystems.net (Postfix) with ESMTP id 163F06A12F6;
	Mon, 16 Nov 2009 16:09:08 +0100 (CET)
Received: by picard.dgc.se (Postfix, from userid 1000)
	id 0055AB833; Mon, 16 Nov 2009 16:09:07 +0100 (CET)
Date: Mon, 16 Nov 2009 16:09:07 +0100
From: Penty Wenngren <penty.wenngren@dgc.se>
To: Dirk Meyer <dirk.meyer@dinoex.sub.org>
Message-ID: <20091116150907.GY74360@picard.dgc.se>
References: <20091111160649.GL74360@picard.dgc.se>
	<iLQ6Bi/njm@dmeyer.dinoex.sub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <iLQ6Bi/njm@dmeyer.dinoex.sub.org>
User-Agent: Mutt/1.4.2.3i
Organization: DGC Solutions AB
Cc: "freebsd-ruby@freebsd.org" <freebsd-ruby@freebsd.org>
Subject: Re: Ruby, dbi and PostgreSQL
X-BeenThere: freebsd-ruby@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: penty.wenngren@dgc.se
List-Id: FreeBSD-specific Ruby discussions <freebsd-ruby.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ruby>,
	<mailto:freebsd-ruby-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ruby>
List-Post: <mailto:freebsd-ruby@freebsd.org>
List-Help: <mailto:freebsd-ruby-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ruby>,
	<mailto:freebsd-ruby-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 16 Nov 2009 15:09:10 -0000

On Sun, Nov 15, 2009 at 10:56:06AM +0100, Dirk Meyer wrote:
> 
> > After having upgraded our installed ports this morning we have a few
> > machines that no longer want to play with ruby, dbi and postgres. This
> > is the output I get when trying to do this in irb:
> > 
> > irb(main):001:0> require 'dbi'
> > => true
> > irb(main):002:0> dbh = DBI.connect("DBI:Pg:test","test","test")
> > DBI::InterfaceError: Could not load driver (Could not find driver Pg or pg (error:
> > no such file to load -- pg))
> >     from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:318:in `load_driver'
> >     from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:160:in `_get_full_driver'
> >     from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:145:in `connect'
> >     from (irb):2
>  
> The update to ruby18-dbd_pg-0.3.8 is wrong.
> seems that my patches where not commited.
> I will merge my patches and commit the necessary fixes.
> 
> > ruby18-dbd_pg-0.3.8
> 


Thanks Dirk, it seems your patches solved that problem. However, now I get
another error message instead:

$ irb
irb(main):001:0> require 'rubygems'
=> true
irb(main):002:0> require 'dbi'
=> true
irb(main):003:0> dbh = DBI.connect("DBI:Pg:mydb","user","secret")
DBI::OperationalError: can't format
        from /usr/local/lib/ruby/site_ruby/1.8/dbd/pg/database.rb:82:in
`initialize'
        from /usr/local/lib/ruby/site_ruby/1.8/dbd/Pg.rb:157:in `new'
        from /usr/local/lib/ruby/site_ruby/1.8/dbd/Pg.rb:157:in `connect'
        from /usr/local/lib/ruby/site_ruby/1.8/dbi/handles/driver.rb:33:in
`connect'
        from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:148:in `connect'
        from (irb):3


// Penty

-- 

Penty Wenngren
DGC Solutions AB