# Gem install mysql returns list of No definition for XYZ

**URL:** <https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819>\
**Category:** Ruby\
**Created:** [September 2, 2009, 6:36pm UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819 "2009-09-02T18:36:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 2, 2009, 6:36pm UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/1 "2009-09-02T18:36:52Z")

</div>

Hello,  
[http://www.schmidp.com/2009/06/14/rubyrails-and-mysql-on-snow-leopard-10a380/comment-page-1/#comment-3751](http://www.schmidp.com/2009/06/14/rubyrails-and-mysql-on-snow-leopard-10a380/comment-page-1/#comment-3751)

I am searching for fix to problem, Russell F., Mike and Andrew. All  
have the same problem.

root@br:/# gem install mysql  
Building native extensions. This could take a while…  
Successfully installed mysql-2.8.1  
1 gem installed  
Installing ri documentation for mysql-2.8.1…

No definition for next\_result  
No definition for field\_name  
No definition for field\_table  
No definition for field\_def  
No definition for field\_type  
No definition for field\_length  
No definition for field\_max\_length  
No definition for field\_flags  
No definition for field\_decimals  
No definition for time\_inspect  
No definition for time\_to\_s  
No definition for time\_get\_year  
No definition for time\_get\_month  
No definition for time\_get\_day  
No definition for time\_get\_hour  
No definition for time\_get\_minute  
No definition for time\_get\_second  
No definition for time\_get\_neg  
No definition for time\_get\_second\_part  
No definition for time\_set\_year  
No definition for time\_set\_month  
No definition for time\_set\_day  
No definition for time\_set\_hour  
No definition for time\_set\_minute  
No definition for time\_set\_second  
No definition for time\_set\_neg  
No definition for time\_set\_second\_part  
No definition for time\_equal  
No definition for error\_errno  
No definition for error\_sqlstate

Installing RDoc documentation for mysql-2.8.1…

No definition for next\_result  
No definition for field\_name  
No definition for field\_table  
No definition for field\_def  
No definition for field\_type  
No definition for field\_length  
No definition for field\_max\_length  
No definition for field\_flags  
No definition for field\_decimals  
No definition for time\_inspect  
No definition for time\_to\_s  
No definition for time\_get\_year  
No definition for time\_get\_month  
No definition for time\_get\_day  
No definition for time\_get\_hour  
No definition for time\_get\_minute  
No definition for time\_get\_second  
No definition for time\_get\_neg  
No definition for time\_get\_second\_part  
No definition for time\_set\_year  
No definition for time\_set\_month  
No definition for time\_set\_day  
No definition for time\_set\_hour  
No definition for time\_set\_minute  
No definition for time\_set\_second  
No definition for time\_set\_neg  
No definition for time\_set\_second\_part  
No definition for time\_equal  
No definition for error\_errno  
No definition for error\_sqlstate

My email address is removed\_email\_address@domain.invalid please let me know fix.

I also problem but no fix at the following URL  
[http://forums.mysql.com/read.php?116,279110,279110](http://forums.mysql.com/read.php?116,279110,279110)

---

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 2, 2009, 10:22pm UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/2 "2009-09-02T22:22:20Z")

</div>

On Sep 2, 6:46 pm, Joao S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> Then i must edit the require line of my program  
> require “./mysql”  
> becomes  
> require “./mysql\_api”
> 
> Thank you all.

First: do not top post.

Second: there is no error in the installation, but the generation of  
documentation.

Third: cannot reproduce:

luis@seyori ~$ sudo gem install mysql --ri --rdoc  
Building native extensions. This could take a while…  
Successfully installed mysql-2.8.1  
1 gem installed  
Installing ri documentation for mysql-2.8.1…  
Updating ri class cache with 2771 classes…  
Installing RDoc documentation for mysql-2.8.1…

Forth: You’re trying to use a gem, and for that you need to require  
‘rubygems’ prior using it:

require ‘rubygems’  
require ‘mysql’

That works.

Manual copy of the file could introduce other issues in your  
environment. Try avoid that.

---

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 2, 2009, 6:46pm UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/3 "2009-09-02T18:46:54Z")

</div>

I fix the problem.

gem install mysql  
it says, “Successfully installed mysql-2.8.1”  
so I do, updatedb  
then i do, locate mysql-2.8.1  
which gives me  
/var/lib/gems/1.8/gems/mysql-2.8.1/ext/mysql\_api/mysql\_api.so  
so I copy to my ruby program dir, cp  
/var/lib/gems/1.8/gems/mysql-2.8.1/ext/mysql\_api/mysql\_api.so ./  
Then i must edit the require line of my program  
require “./mysql”  
becomes  
require “./mysql\_api”

Thank you all.

Joao S. wrote:

> Hello,  
> [http://www.schmidp.com/2009/06/14/rubyrails-and-mysql-on-snow-leopard-10a380/comment-page-1/#comment-3751](http://www.schmidp.com/2009/06/14/rubyrails-and-mysql-on-snow-leopard-10a380/comment-page-1/#comment-3751)
> 
> I am searching for fix to problem, Russell F., Mike and Andrew. All  
> have the same problem.
> 
> root@br:/# gem install mysql  
> Building native extensions. This could take a while…  
> Successfully installed mysql-2.8.1  
> 1 gem installed  
> Installing ri documentation for mysql-2.8.1…
> 
> No definition for next\_result  
> No definition for field\_name  
> No definition for field\_table  
> No definition for field\_def  
> No definition for field\_type  
> No definition for field\_length  
> No definition for field\_max\_length  
> No definition for field\_flags  
> No definition for field\_decimals  
> No definition for time\_inspect  
> No definition for time\_to\_s  
> No definition for time\_get\_year  
> No definition for time\_get\_month  
> No definition for time\_get\_day  
> No definition for time\_get\_hour  
> No definition for time\_get\_minute  
> No definition for time\_get\_second  
> No definition for time\_get\_neg  
> No definition for time\_get\_second\_part  
> No definition for time\_set\_year  
> No definition for time\_set\_month  
> No definition for time\_set\_day  
> No definition for time\_set\_hour  
> No definition for time\_set\_minute  
> No definition for time\_set\_second  
> No definition for time\_set\_neg  
> No definition for time\_set\_second\_part  
> No definition for time\_equal  
> No definition for error\_errno  
> No definition for error\_sqlstate
> 
> Installing RDoc documentation for mysql-2.8.1…
> 
> No definition for next\_result  
> No definition for field\_name  
> No definition for field\_table  
> No definition for field\_def  
> No definition for field\_type  
> No definition for field\_length  
> No definition for field\_max\_length  
> No definition for field\_flags  
> No definition for field\_decimals  
> No definition for time\_inspect  
> No definition for time\_to\_s  
> No definition for time\_get\_year  
> No definition for time\_get\_month  
> No definition for time\_get\_day  
> No definition for time\_get\_hour  
> No definition for time\_get\_minute  
> No definition for time\_get\_second  
> No definition for time\_get\_neg  
> No definition for time\_get\_second\_part  
> No definition for time\_set\_year  
> No definition for time\_set\_month  
> No definition for time\_set\_day  
> No definition for time\_set\_hour  
> No definition for time\_set\_minute  
> No definition for time\_set\_second  
> No definition for time\_set\_neg  
> No definition for time\_set\_second\_part  
> No definition for time\_equal  
> No definition for error\_errno  
> No definition for error\_sqlstate
> 
> My email address is [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) please let me know fix.
> 
> I also problem but no fix at the following URL  
> [http://forums.mysql.com/read.php?116,279110,279110](http://forums.mysql.com/read.php?116,279110,279110)

---

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 3, 2009, 7:50pm UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/4 "2009-09-03T19:50:58Z")

</div>

On Sep 3, 8:51 am, Peter M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> irb(main):002:0\> require ‘mysql’  
> petermarks [23:33] ~ which mysql  
> /usr/local/mysql/bin/mysql
> 
> petermarks [23:33] ~ file  
> /usr/local/lib/ruby/site\_ruby/1.8/i686-darwin8.10.1/mysql.bundle  
> /usr/local/lib/ruby/site\_ruby/1.8/i686-darwin8.10.1/mysql.bundle: Mach-O  
> 64-bit bundle x86\_64

The problem is that you installed mysql extension using ruby  
“setup.rb” instead of the gem.

Please remove the site\_ruby mysql.bundle file and try installing the  
gem

if you do “gem which mysql” you will see that the entry point (the  
library) is mysql.rb, not mysql.bundle in mysql gem version 2.8.1

---

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 3, 2009, 8:26pm UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/5 "2009-09-03T20:26:41Z")

</div>

FWIW I am getting these messages in doc generation since I switched to  
1.8.7 with the upgrade to SL. Don’t know if that explains it though,  
just feedback.

---

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 3, 2009, 8:51am UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/6 "2009-09-03T08:51:25Z")

</div>

I got the same error as Joao installing the mysql gem with the following  
command:

sudo gem install mysql â€”  
â€“with-mysql-config=/usr/local/mysql/bin/mysql\_config

I get an error loading the gem though:

irb(main):001:0\> require ‘rubygems’  
=\> true  
irb(main):002:0\> require ‘mysql’  
LoadError: Failed to load  
/usr/local/lib/ruby/site\_ruby/1.8/i686-darwin8.10.1/mysql.bundle  
from /usr/local/lib/ruby/site\_ruby/1.8/i686-darwin8.10.1/mysql.bundle  
from  
/usr/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`require’  
from (irb):2

Mysql is running fine and seems to be installed correctly:

petermarks [23:33] ~ which mysql  
/usr/local/mysql/bin/mysql

petermarks [23:33] ~ file  
/usr/local/lib/ruby/site\_ruby/1.8/i686-darwin8.10.1/mysql.bundle  
/usr/local/lib/ruby/site\_ruby/1.8/i686-darwin8.10.1/mysql.bundle: Mach-O  
64-bit bundle x86\_64

---

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 13, 2009, 12:36am UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/7 "2009-09-13T00:36:49Z")

</div>

Luis L. wrote:

> The problem is that you installed mysql extension using ruby  
> “setup.rb” instead of the gem.
> 
> Please remove the site\_ruby mysql.bundle file and try installing the  
> gem

Thanks, this got me further along. I no longer get an error loading  
‘mysql’ in irb after removing the site\_ruby mysql.bundle file. However,  
I get an error trying to load ‘mysql\_api’:

irb(main):004:0\> require ‘mysql\_api’  
LoadError: Failed to load  
/Users/petermarks/.gem/ruby/1.8/gems/mysql-2.8.1/lib/mysql\_api.bundle  
from  
/Users/petermarks/.gem/ruby/1.8/gems/mysql-2.8.1/lib/mysql\_api.bundle  
from  
/usr/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:36:in  
`require’  
from (irb):4

Although I appear to have the correct version of the api bundle  
installed:

petermarks [15:28] ~ file  
/Users/petermarks/.gem/ruby/1.8/gems/mysql-2.8.1/lib/mysql\_api.bundle  
/Users/petermarks/.gem/ruby/1.8/gems/mysql-2.8.1/lib/mysql\_api.bundle:  
Mach-O 64-bit bundle x86\_64

Has anyone had this?

---

<div class="post-metadata">

**Author:** ![yankees26](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/eb9ed0/32.png) [@yankees26](https://www.ruby-forum.com/u/yankees26)\
**Post date:** [September 20, 2009, 8:02pm UTC](https://www.ruby-forum.com/t/gem-install-mysql-returns-list-of-no-definition-for-xyz/174819/8 "2009-09-20T20:02:33Z")

</div>

I finally resolved this. It helps to have 64-bit ruby 🙂

I was under the impression that snow leopard and/or xcode was supposed  
to install 1.8.7, but I was somehow left with a 32-bit 1.8.6 install in  
usr/local/bin. Strange.
