title: Snow Leopard + Ruby 1.9.1 + MySQL Gem = Huge problems
body: <p>I tried for about 3-4 hours trying to get the mysql gem to install for ruby 1.9.1 on snow leopard.  The mysql gem used to work just fine on 1.9.1 before I upgraded to snow leopard.  I uninstalled MySQL server and gem from my machine.  I then downloaded and installed: mysql-5.1.37-osx10.5-x86_64.dmg.  I have been able to assert that this new version I installed is running as a 64bit application.</p>
  
  <p>I uninstalled the mysql gem.  When I tried to install the gem with this command:</p>
  
  <pre>
  env ARCHFLAGS="-arch x86_64" gem install mysql --verbose -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
  </pre>
  
  <p>I got this error:</p>
  
  <pre>
  GET 304 Not Modified: http://gems.rubyforge.org/latest_specs.4.8.gz
  GET 200 OK: http://gems.github.com/latest_specs.4.8.gz
  Installing gem mysql-2.8.1
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/COPYING
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/COPYING.ja
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/History.txt
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/Manifest.txt
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/README.txt
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/Rakefile
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/ext/mysql_api/extconf.rb
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/ext/mysql_api/mysql.c
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/extra/README.html
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/extra/README_ja.html
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/extra/tommy.css
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/lib/mysql.rb
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/tasks/gem.rake
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/tasks/native.rake
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/tasks/vendor_mysql.rake
  /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/test/test_mysql.rb
  Building native extensions.  This could take a while...
  ERROR:  Error installing mysql:
          ERROR: Failed to build gem native extension.
  
  /Users/sean/.rvm/ruby-1.9.1-p243/bin/ruby extconf.rb --with-mysql-config=/usr/local/mysql/bin/mysql_config
  checking for mysql_ssl_set()... yes
  checking for rb_str_set_len()... no
  checking for rb_thread_start_timer()... no
  checking for mysql.h... yes
  creating Makefile
  
  make
  gcc -I. -I/Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/i386-darwin9.8.0 -I/Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/ruby/backward -I/Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1 -I. -DHAVE_MYSQL_SSL_SET -DHAVE_MYSQL_H  -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE   -I/usr/local/mysql/include  -g -Os -arch x86_64 -fno-common   -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT  -DDONT_DECLARE_CXA_PURE_VIRTUAL -fno-common  -O2 -g -Wall -Wno-parentheses  -fno-common -pipe -fno-common  -o mysql.o -c mysql.c
  In file included from /Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/ruby.h:32,
                   from mysql.c:5:
  /Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/ruby/ruby.h: In function 'INT2NUM':
  /Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/ruby/ruby.h:464: warning: comparison is always true due to limited range of data type
  /Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/ruby/ruby.h:464: warning: comparison is always true due to limited range of data type
  /Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/ruby/ruby.h: In function 'UINT2NUM':
  /Users/sean/.rvm/ruby-1.9.1-p243/include/ruby-1.9.1/ruby/ruby.h:472: warning: comparison is always true due to limited range of data type
  mysql.c: In function 'escape_string':
  mysql.c:290: error: lvalue required as left operand of assignment
  mysql.c:290: error: lvalue required as left operand of assignment
  mysql.c: In function 'real_escape_string':
  mysql.c:434: error: lvalue required as left operand of assignment
  mysql.c:434: error: lvalue required as left operand of assignment
  make: *** [mysql.o] Error 1
  
  
  Gem files will remain installed in /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1 for inspection.
  Results logged to /Users/sean/.gem/ruby/1.9.1/gems/mysql-2.8.1/ext/mysql_api/gem_make.out
  </pre>
  
  <p>I have tried everything I have read from the following links.</p>
  
  <ol>
  <li><a href="http://void-design.net/2009/08/05/ruby-191-mysql-and-a-snow-leopard/" rel="nofollow noreferrer">http://void-design.net/2009/08/05/ruby-191-mysql-and-a-snow-leopard/</a></li>
  <li><a href="http://www.schmidp.com/2009/06/14/rubyrails-and-mysql-on-snow-leopard-10a380/" rel="nofollow noreferrer">http://www.schmidp.com/2009/06/14/rubyrails-and-mysql-on-snow-leopard-10a380/</a></li>
  <li><a href="https://stackoverflow.com/questions/991708/rails-mysql-and-snow-leopard">Rails, MySQL and Snow Leopard</a></li>
  </ol>
  
  <p>Any ideas?</p>