# Leopard + mysql

**URL:** <https://www.ruby-forum.com/t/leopard-mysql/118616>\
**Category:** Ruby\
**Created:** [October 29, 2007, 2:34pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616 "2007-10-29T14:34:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![x43](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/3ec8ea/32.png) [@x43](https://www.ruby-forum.com/u/x43)\
**Post date:** [October 29, 2007, 2:34pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616/1 "2007-10-29T14:34:28Z")

</div>

Hello:

I am trying to connect to a remote mysql server via ruby with require  
mysql tag.

I am seeing the following error :

dbconnect.rb:4:in `require’: no such file to load – mysql (LoadError)  
from dbconnect.rb:4

Any thoughts ?

thanks

---

<div class="post-metadata">

**Author:** ![x43](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/3ec8ea/32.png) [@x43](https://www.ruby-forum.com/u/x43)\
**Post date:** [October 29, 2007, 5:44pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616/2 "2007-10-29T17:44:26Z")

</div>

did you install the mysql adapter gem?

---

<div class="post-metadata">

**Author:** ![x43](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/3ec8ea/32.png) [@x43](https://www.ruby-forum.com/u/x43)\
**Post date:** [October 29, 2007, 7:48pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616/3 "2007-10-29T19:48:01Z")

</div>

Michael S. wrote:

> did you install the mysql adapter gem?

That’s where the problem is coming. I tried doing that in both manner:

gem install mysql

and as shown here :  
[http://www.notsostupid.com/blog/2007/10/25/ruby-leopard-and-gems/](http://www.notsostupid.com/blog/2007/10/25/ruby-leopard-and-gems/)

Both result in :

Building native extensions. This could take a while…  
ERROR: While executing gem … (Gem::Installer::ExtensionBuildError)  
ERROR: Failed to build gem native extension.

ruby extconf.rb install mysql  
checking for mysql\_query() in -lmysqlclient… no  
checking for main() in -lm… yes  
checking for mysql\_query() in -lmysqlclient… no  
checking for main() in -lz… yes  
checking for mysql\_query() in -lmysqlclient… no  
checking for main() in -lsocket… no  
checking for mysql\_query() in -lmysqlclient… no  
checking for main() in -lnsl… no  
checking for mysql\_query() in -lmysqlclient… no  
\*\*\* extconf.rb failed \*\*\*

Appreciate your response. Thanks in advance.  
Aashish

---

<div class="post-metadata">

**Author:** ![x43](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/3ec8ea/32.png) [@x43](https://www.ruby-forum.com/u/x43)\
**Post date:** [October 29, 2007, 8:31pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616/4 "2007-10-29T20:31:19Z")

</div>

Did you install MySQL? Binary or Source? Even if you are connecting to  
a remote database, you are still going to have to have mysql header  
files and libs installed.

---

<div class="post-metadata">

**Author:** ![x43](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/3ec8ea/32.png) [@x43](https://www.ruby-forum.com/u/x43)\
**Post date:** [October 29, 2007, 8:34pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616/5 "2007-10-29T20:34:08Z")

</div>

Michael S. wrote:

> Did you install MySQL? Binary or Source? Even if you are connecting to  
> a remote database, you are still going to have to have mysql header  
> files and libs installed.

NO I haven’t installed MYSQL ( Binary/libraries/header files). Do you  
mean a _full_ mysql install ? Or are there drivers available ??

---

<div class="post-metadata">

**Author:** ![x43](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/3ec8ea/32.png) [@x43](https://www.ruby-forum.com/u/x43)\
**Post date:** [October 29, 2007, 10:10pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616/6 "2007-10-29T22:10:44Z")

</div>

On Oct 29, 2007 8:34 PM, X43 X43 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Michael S. wrote:
> 
> > Did you install MySQL? Binary or Source? Even if you are connecting to  
> > a remote database, you are still going to have to have mysql header  
> > files and libs installed.
> 
> NO I haven’t installed MYSQL ( Binary/libraries/header files). Do you  
> mean a _full_ mysql install ? Or are there drivers available ??

So, you need to install MySQL first. You can grab a binary installer  
from [mysql.com](http://mysql.com) for your architecture.

Then, in order to install the Ruby bindings, follow the steps here:

[http://trac.macosforge.org/projects/ruby/wiki/Troubleshooting#IcannotbuildrubymysqlonLeopardwithmysql.combinaries](http://trac.macosforge.org/projects/ruby/wiki/Troubleshooting#IcannotbuildrubymysqlonLeopardwithmysql.combinaries)

Please tell us if this doesn’t work for you.

Laurent

---

<div class="post-metadata">

**Author:** ![x43](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/3ec8ea/32.png) [@x43](https://www.ruby-forum.com/u/x43)\
**Post date:** [October 29, 2007, 11:41pm UTC](https://www.ruby-forum.com/t/leopard-mysql/118616/7 "2007-10-29T23:41:45Z")

</div>

Laurent S. wrote:

> [http://trac.macosforge.org/projects/ruby/wiki/Troubleshooting#IcannotbuildrubymysqlonLeopardwithmysql.combinaries](http://trac.macosforge.org/projects/ruby/wiki/Troubleshooting#IcannotbuildrubymysqlonLeopardwithmysql.combinaries)
> 
> Please tell us if this doesn’t work for you.
> 
> Laurent

This works!!! Thanks Laurent.

Aashish