MySQL Bindings for Ruby under Mac OS X Tiger

Thanks for this. I actu­ally googled for part the error I was receiv­ing. The full error was:

dyld: NSLinkMod­ule() error dyld: Sym­bol not found: _sprintf$LDBLStub Ref­er­enced from: /usr/lib/ruby/site_ruby/1.8/powerpc-darwin8.0/mysql.bundle Expected in: flat namespace

Get­ting the beta mysql bind­ing and com­pil­ing with gcc 4 instead of 3 solved the prob­lem as you outlined.

Posted by Noah on August 12, 2005 at 12:52

Same prob­lem as above, didn't got lucky with google but con­tacted the author. Very clear fix, congrats.

Posted by Stephane on August 16, 2005 at 05:23

This (or any other solu­tion that I can find) doesn't seem to work for tiger server (10.4.2) — does any­one have any ideas for get­ting the mysql bind­ings work­ing on server?

Posted by Mal­colm on August 16, 2005 at 19:44

Hi Mal­colm, Tiger Server comes with a copy of MySQL installed by default, so I think it's prob­a­bly a case of fig­ur­ing out where it's installed, and adding it's bin direc­tory to your PATH before you try con­fig­ur­ing and installing the gem. Happy to walk you through it if you want to send me an e-​mail (see the side bar).

Posted by Tony on August 17, 2005 at 02:34

Thanks for the tips, you saved me a lot of time.

Posted by Dan on August 18, 2005 at 06:29

I get a fail­ure when run­ning make. mysql.c:71: error: parse error before “MYSQL_​STMT”. This is fol­lowed by many more mes­sages, prob­a­bly caused by this first error.
Rails was setup as described in your other blog post. I have MySql 4.1 run­ning.
Any ideas?

Posted by Erik on August 18, 2005 at 20:58

which sql edi­tors are you guys using?

I'm using cocoamysql, but am expe­ri­enc­ing a few prob­lems with it.

Posted by ramin on August 19, 2005 at 01:48

I use the offi­cial MySQL Query Browser. it's pretty smooth :)

Posted by Tony on August 19, 2005 at 04:54

i might check that out. the only prob­lems I'm hav­ing with cocoamysql is when try­ing to insert a field that has a time­stamp type, it doesn't seem to want to take, keeps giv­ing me a mysql error regard­ing the default value (which i haven't set).

Posted by ramin on August 19, 2005 at 05:10

I'm get­ting the same error as Eric (#6):

mysql.c:71: error: parse error before “MYSQL_​STMT”

fol­lowed by a whole host of error messages.

Any­one got any ideas? Eric, did you man­age to sort it out?

Many thanks.

Posted by James on August 25, 2005 at 22:22

Still get­ting

check­ing for mysql_​ssl_​set()… no
check­ing for mysql.h… no
check­ing for mysql/mysql.h… no

on 10.4.2 with 4.1.12 and gc set to 4

Posted by utter on August 25, 2005 at 23:13

Just a quick com­ment to say that all of these instruc­tions worked just fine on my lap­top under 10.4.2.

Thanks Tony for the clear instruc­tions and excel­lent pointers!

Ken

Posted by Ken Ander­son on August 31, 2005 at 19:08

I have a clean install of Tiger, from which I migrated my old sys­tem over using Apple's migra­tion tool. MySQL is installed at /​Library/​MySQL/​bin/​mysql and already work­ing and acces­si­ble for other apps.

The errors I get are (in part):

gcc –fno-​common –g –Os –pipe –fno-​common –I. –I/usr/lib/ruby/1.8/powerpc-darwin8.0 –I/usr/lib/ruby/1.8/powerpc-darwin8.0 –I. –DHAVE_​MYSQL_​SSL_​SET –DHAVE_​MYSQL_​H –I”/Library/MySQL/include/mysql” –c mysql.c
mysql.c:71: error: parse error before “MYSQL_​STMT“
mysql.c:71: warn­ing: no semi­colon at end of struct or union

Posted by Nick on September 3, 2005 at 04:11

Notably, 2.7 is out of beta. I tried using that ver­sion per the above instruc­tions, but still received errors.

<http://​www​.tmtm​.org/​e​n​/​m​y​s​q​l​/​ruby/>

Posted by Nick on September 3, 2005 at 04:23

For what it&apos;s worth, here&apos;s what I learned:

1) My clean install of Tiger, fol­lowed by the migra­tion, brought serverlogistics.com&apos;s 4.0.15 ver­sion of MySQL over. I needed to upgrade this, and chose 4.1.11.

2) it&apos;s pos­si­ble to gem install mysql by spec­i­fy­ing the cor­rect direc­tory of mySQL (which changed for me to /​usr/​local/​mysql for 4.1.11 from /​Library/​MySQL/​for the server­l­ogis­tics version.

3) There&apos;s a gem, fixr­b­con­fig, which assist in com­pil­ing the above.

Hope this helps some­one else migrat­ing to Tiger.

Posted by Nick on September 4, 2005 at 02:14

Thank You! After bang­ing my head try­ing to get the mysql pack­age to com­pile the 2.7 beta finally worked. My Rails app will now con­nect to MySQL.

Thanks for the link.

Posted by Gerry Shaw on September 4, 2005 at 13:25

i have the same prob­lem as erik above

error: parse error before "MYSQL_STMT" and then a lot of other errors

Posted by Laura Her­ald on September 15, 2005 at 17:00

Thanks for this writeup. I wish your writeup was at the top of the list insted of the bottom.

Posted by Doug on October 3, 2005 at 01:14

Tony, thankyou. I come from a design back­ground and I find your clear expla­na­tion extremely help­ful. I was about to throw my “Agile Web dev in rails” book right out the win­dow until I stum­bled onto your post clearly explain­ing how to install mysql-ruby-2.7.tar.gz

I&apos;m such a new­bie I didnt know I how to cd to the direc­tory until recently…

THANKS!,
Mike Moscow dot com

Posted by Mike Moscow on October 13, 2005 at 09:21

Tony, thank you very much! I strug­gled with MySQL quite a bit on my Power­Book. Now, I am ready for some seri­ous Ruby munch­ing away at my data­base… Your instal­la­tion descrip­tion was really great, thanks again.

Posted by norb on October 27, 2005 at 02:52

Hi!

I try install mysql-ruby-2.7 on my Mac G5 (MySQL mysql-standard-5.0.15-osx10.4-powerpc-64bit Mac OS X 10.4.2, Ruby 1.8.2) and got error

====

KrynkaCard:~/src/Ruby/mysql-ruby-2.7 big­mac$ ruby extconf.rb –with-​mysql-​config

check­ing for mysql_​ssl_​set()… no

check­ing for mysql.h… yes

cre­at­ing Makefile

KrynkaCard:~/src/Ruby/mysql-ruby-2.7 big­mac$ make

/​usr/​bin/​ld: trun­cated or mal­formed archive: /usr/local/mysql/lib/libmysqlclient.a (ran­lib struc­tures in table of con­tents extends past the end of the table of con­tents, can&apos;t load from it)

collect2: ld returned 1 exit status

make: ***| [mysql.bundle] Error 1

—| — |–

What&apos;s wrong?

Sorry, my eng­lish very poor

Thanks

Posted by Iwan on November 3, 2005 at 21:09

Hi Iwan — it looks like your copy of MySQL isn&apos;t right (one of the libraries is bro­ken). First try this:

ranlib /usr/local/mysql/lib/libmysqlclient.a Then try com­pil­ing again. If that doesn&apos;t work, you&apos;ll need to re-​download MySQL from MySQL​.com and install again.

Posted by Tony on November 4, 2005 at 01:37

This is the most help­ful Rails tuto­r­ial on the inter­net. Good work!

Posted by Devon on November 4, 2005 at 06:59

Tony, you are a saint. thanks so much

Posted by Gregg Seib­ert on November 4, 2005 at 08:26

To hope­fully save some­one some headache(s):

the MySQL 64bit ver­sion for Tiger (oth­ers?) will con­sis­tently fail with:

(ran­lib struc­tures in table of con­tents extends past the end of the table of con­tents, can&apos;t load from it)

Using the non-​64bit ver­sion works successfully.

Posted by josh­paul on November 5, 2005 at 12:59

Hi!

Thanks Tony and joshpaul!

I exper­i­mented with MySQL — 4, 5 and 5-​64bit and only 5 work fine. Another ver­sion got error:

check­ing for mysqlsslset()… no

Posted by Iwan on November 7, 2005 at 18:43

Ok. I&apos;m on Tiger Server, 10.4.3, run­ning MySQL 5.0.1164bit. I&apos;ve tried nearly every­thing thus far on this thread, but I&apos;m con­fused as to how to fix a few of the prob­lems, namely:

1.) The newly relo­cated “ruby.h” file in Xcode 2.2

2.) Issues in the make process after copy­ing ruby.h to the expected directory

Some instruc­tions for get­ting this up and run­ning on OS X Server would be very help­ful, I think. We&apos;re want­ing to use Rails for an upcom­ing project but may have to scratch that idea if we can&apos;t fig­ure this out. Thanks, in advance, for your help.

Posted by Brooks on November 23, 2005 at 03:48

I have been try­ing to do this for awhile, but when­ever I try to extconf.rb I get the error “can&apos;t find header files for ruby.”. Every­one always says to install the Xcode devel­oper tools (includ­ing BSD sub­sys­tems) and I already had Xcode installed fully. I down­loaded a new ~800 meg dmg from Apple, rein­stalled Devel­oper TOols com­pletely, and .. got the same error message.

Any thoughts?

locate finds ruby.h in :

/usr/lib/ruby/1.8/universal-darwin8.0/ruby.h

Posted by Gary Burke on November 25, 2005 at 11:24

extconf.rb runs fine, but then I get this when I try to make:

In file included from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:74:3: #error ---->> ruby requires sizeof(void*) == sizeof(long) to be compiled. <<----
In file included from /usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:670,
                 from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/missing.h:19: error: redefinition of `struct timeval';
In file included from /usr/lib/ruby/1.8/powerpc-darwin8.0/missing.h:133,
                 from /usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:670,
                 from mysql.c:5:
/usr/include/gcc/darwin/3.3/varargs.h:10:2: #error "GCC no longer implements <varargs.h>."
/usr/include/gcc/darwin/3.3/varargs.h:11:2: #error "Revise your code to use <stdarg.h>."
In file included from /usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:670,
                 from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/missing.h:135: warning: conflicting types for built-in function `snprintf';
In file included from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:682: error: parse error before "rb_nativethread_t"
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:682: warning: data definition has no type or storage class
make: *** [mysql.o] Error 1

Some expla­na­tion: the dif­fer­ence lies in /usr/lib/ruby/1.8 on my machine (g4 power­book, 10.4.3) in which one direc­tory is universal-darwin8.0 and the direc­tory it&apos;s look­ing for the head­ers in is powerpc-darwin8.0. So I put in sym­links from the wrong direc­tory to the right one, but now I get these errors. So obvi­ously sym­links are a bad idea. what should I do instead?

–Gary

Posted by Gary Burke on November 25, 2005 at 11:51

Hi,

besides installing mysql locally, how do i use a remote mysql server for devel­op­ing?
i can con­nect to my db server for view­ing data (in radrails), but when test­ing the app locally with webrick, it tries to con­nect to local­host and gives an error.

Hen­drik

Posted by Hen­drik on November 28, 2005 at 23:46

I was strug­gling to get RoR work­ing prop­erly with mySQL 5 — your installer and these mqsql bind­ings instruc­tions did the trick and got every­thing work­ing. Thanks.

Posted by Grant on January 3, 2006 at 13:31

I get the fol­low­ing behaviour:

$ make
gcc -fno-common  -arch ppc -g -Os -pipe -fno-common  -arch ppc -pipe -pipe -fno-common  -I. -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I. -DHAVE_MYSQL_H  -I/usr/local/mysql/include -Os -arch ppc64 -fno-common -c mysql.c
cc -dynamic -bundle -undefined suppress -flat_namespace  -L"/usr/lib" -o mysql.bundle mysql.o  -L/usr/local/mysql/lib -lmysqlclient -lz -lm  -lpthread -ldl -lobjc
/usr/bin/ld: truncated or malformed archive: /usr/local/mysql/lib/libmysqlclient.a (ranlib structures in table of contents extends past the end of the table of contents, can';t load from it)
collect2: ld returned 1 exit status
make: *** [mysql.bundle] Error 1

Where do i go from here — any help would be appreciated

Posted by Bren­dan Park on January 24, 2006 at 19:36

I first had trou­ble run­ning the export com­mand, but did some Googling and found that using bash would prob­a­bly help. After typ­ing “bash” into the con­sole, I retried the com­mand with bet­ter suc­cess. Not sure why bash wasn&apos;t being used before, but just a help­ful tip if any­one else has prob­lems like this.

Posted by Matt James on February 8, 2006 at 07:05

Thanks a lot!

Posted by Ken­neth Love on February 17, 2006 at 21:50

Tony — Thank you for post­ing these MySQL bind­ings instruc­tions. Very clear, very use­ful. They worked for me.

Posted by Chris Joakim on February 28, 2006 at 16:19

For those of you who may be won­der­ing how to do this using Fink, doing so is not too difficult.

The path to the Ruby libraries as setup by the mkmf is invalid. It expects your header files to be in /sw/lib/ruby/1.8/powerpc-darwin instead of /sw/lib/ruby/1.8/*-darwin/, where they should actu­ally be.

How­ever, /sw/lib/ruby/1.8/powerpc-darwin is a valid path with impor­tant files in it, so your best bet with­out alter­ing code in mkmf.rb is to sim­ply cre­ate sim­links from the .h files in ../​–dar­win to ../​powerpc-​darwin.

After that, it should work fine, although maybe this is a sign I should give dar­win ports another shot…

Posted by Eon­flare on March 7, 2006 at 11:39

If your error is as follows:

I get the following behaviour:

$ make
gcc -fno-common  -arch ppc -g -Os -pipe -fno-common  -arch ppc -pipe -pipe -fno-common  -I. -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I. -DHAVE_MYSQL_H  -I/usr/local/mysql/include -Os -arch ppc64 -fno-common -c mysql.c
cc -dynamic -bundle -undefined suppress -flat_namespace  -L"/usr/lib" -o mysql.bundle mysql.o  -L/usr/local/mysql/lib -lmysqlclient -lz -lm  -lpthread -ldl -lobjc
/usr/bin/ld: truncated or malformed archive: /usr/local/mysql/lib/libmysqlclient.a (ranlib structures in table of contents extends past the end of the table of contents, can't load from it)
collect2: ld returned 1 exit status
make: *** [mysql.bundle] Error 1

Can you try the fol­low­ing command:

sudo env ARCHFLAGS=’-arch i386’ gem install mysql –v=2.7 – –with-mysql-config=/usr/local/mysql/bin/mysql_config

Posted by San­thosh on November 16, 2009 at 20:23