From: Ben <coppin@...>
Date: 2009-01-13T02:34:19+09:00
Subject: Segmentation fault trying to query MySQL

Hi all,

I'm trying to use DBI to connect to MySQL from ruby. Unfortunately, as
soon as I use execute to try to send a query, it seg-faults. Here's a
sample of code which does this:

require 'rubygems'
gem 'mysql'
gem 'dbi'
require 'dbi'
require 'mysql'

dsn = "DBI:Mysql:DATABASE:www.HOSTNAME.net"
dbh = DBI.connect(dsn, "USERNAME", "PASSWORD")

sth = dbh.execute("select  * from pm limit 10;")

I've checked the value of dbh, and it's not nil, and looks fine. No
exceptions are thrown, as I've checked for that too. I'm running this
on Windows - not sure if that makes a difference?

Does anyone know what I'm doing wrong?

Thanks,

Ben