# Segmentation fault trying to query MySQL

**URL:** <https://www.ruby-forum.com/t/segmentation-fault-trying-to-query-mysql/157529>\
**Category:** Ruby\
**Created:** [January 12, 2009, 6:35pm UTC](https://www.ruby-forum.com/t/segmentation-fault-trying-to-query-mysql/157529 "2009-01-12T18:35:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ben](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/df788c/32.png) [@ben](https://www.ruby-forum.com/u/ben)\
**Post date:** [January 12, 2009, 6:35pm UTC](https://www.ruby-forum.com/t/segmentation-fault-trying-to-query-mysql/157529/1 "2009-01-12T18:35:49Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ben](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/df788c/32.png) [@ben](https://www.ruby-forum.com/u/ben)\
**Post date:** [January 12, 2009, 11:20pm UTC](https://www.ruby-forum.com/t/segmentation-fault-trying-to-query-mysql/157529/2 "2009-01-12T23:20:46Z")

</div>

On Jan 12, 3:31 pm, Ben [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> require ‘mysql’  
> Does anyone know what I’m doing wrong?  
> What is your ruby version?

Can you provide more information about the MySQL version (more  
importantly the libmysql.dll that is in the path, which version it is?