aaaargh!

Why, oh why can't I get this mysql gem to install?

What am I missing out?

I've tried permutations of all of these commands with flags on and off, and I'm now totally out of ideas:

Mysql is here

	Chris-Adamss-MacBook:~ chrisadams$ ls -l /usr/local/
	total 8
	drwxr-xr-x   9 root  wheel  306 29 Jul 18:18 git
	lrwxr-xr-x   1 root  wheel   27 30 Jul 11:56 mysql -> mysql-5.1.36-osx10.5-x86_64
	drwxr-xr-x  17 root  wheel  578 16 Jun 17:40 mysql-5.1.36-osx10.5-x86_64

	sudo gem install mysql

	sudo env ARCHFLAGS="-arch i386" ruby extconf.rb --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib --with-mysql-include=/usr/local/mysql/includesudo env 

	ARCHFLAGS="-arch i386" gem install mysql ——with-mysql-dir=/usr/local/mysql -—with-mysql-lib=/usr/local/mysql/lib --with-mysql-include=/usr/local/mysql/include -—with-mysql-config=/usr/local/mysql/bin/mysql_config


http://wonko.com/post/how-to-install-the-mysqlruby-gem-on-mac-os-x-leopard
http://dev.mysql.com/downloads/mysql/5.1.html

I've also tried running through these guides.

http://hivelogic.com/articles/installing-mysql-on-mac-os-x
http://hivelogic.com/articles/ruby-rails-mongrel-mysql-osx

gem_make.out

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb
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 ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers.  Check the mkmf.log file for more
details.  You may need configuration options.

Provided configuration options:
	--with-opt-dir
	--without-opt-dir
	--with-opt-include
	--without-opt-include=${opt-dir}/include
	--with-opt-lib
	--without-opt-lib=${opt-dir}/lib
	--with-make-prog
	--without-make-prog
	--srcdir=.
	--curdir
	--ruby=/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby
	--with-mysql-config
	--without-mysql-config
	--with-mysql-dir
	--without-mysql-dir
	--with-mysql-include
	--without-mysql-include=${mysql-dir}/include
	--with-mysql-lib
	--without-mysql-lib=${mysql-dir}/lib
	--with-mysqlclientlib
	--without-mysqlclientlib
	--with-mlib
	--without-mlib
	--with-mysqlclientlib
	--without-mysqlclientlib
	--with-zlib
	--without-zlib
	--with-mysqlclientlib
	--without-mysqlclientlib
	--with-socketlib
	--without-socketlib
	--with-mysqlclientlib
	--without-mysqlclientlib
	--with-nsllib
	--without-nsllib
	--with-mysqlclientlib
	--without-mysqlclientlib

gistfile3.txt

*** LOCAL GEMS ***

actionmailer (2.3.2, 1.3.6, 1.3.3)
actionpack (2.3.2, 1.13.6, 1.13.3)
actionwebservice (1.2.6, 1.2.3)
activerecord (2.3.2, 1.15.6, 1.15.3)
activeresource (2.3.2)
activesupport (2.3.2, 1.4.4, 1.4.2)
acts_as_ferret (0.4.1)
authlogic (2.1.1)
bgetting-hominid (1.1.5)
bmabey-email_spec (0.2.1)
capistrano (2.0.0)
cgi_multipart_eof_fix (2.5.0, 2.2)
chronic (0.2.3)
daemons (1.0.9, 1.0.7)
derfred-workling (0.4.9.6)
dnssd (0.6.0)
eventmachine (0.12.8)
fastercsv (1.5.0)
fastthread (1.0.1, 1.0)
fcgi (0.8.7)
ferret (0.11.4)
gem_plugin (0.2.3, 0.2.2)
highline (1.2.9)
hoe (2.3.2)
hpricot (0.6)
javan-whenever (0.3.6)
json (1.1.7)
libxml-ruby (0.9.5, 0.3.8.4)
mislav-will_paginate (2.3.11)
mongrel (1.1.4, 1.0.1)
needle (1.3.0)
net-sftp (1.1.0)
net-ssh (1.1.2)
newrelic_rpm (2.9.4)
rack (1.0.0)
rails (2.3.2, 1.2.6, 1.2.3)
rake (0.8.7, 0.7.3)
RedCloth (3.0.4)
right_aws (1.10.0)
right_http_connection (1.2.4)
rspec (1.2.8)
rspec-rails (1.2.7.1)
ruby-openid (1.1.4)
ruby-yadis (0.3.4)
rubyforge (1.0.4)
rubygems-update (1.3.5)
rubynode (0.1.3)
sources (0.0.1)
sqlite3-ruby (1.2.1)
term-ansicolor (1.0.4)

mkmf.log

find_library: checking for mysql_query() in -lmysqlclient... -------------------- no

"gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0 -I. -I/usr/local/include   -arch ppc -arch i386 -Os -pipe -fno-common conftest.c  -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L. -arch ppc -arch i386     -lruby -lmysqlclient  -lpthread -ldl -lm  "
conftest.c: In function ‘t’:
conftest.c:3: error: ‘mysql_query’ undeclared (first use in this function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
conftest.c: In function ‘t’:
conftest.c:3: error: ‘mysql_query’ undeclared (first use in this function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
lipo: can't figure out the architecture type of: /var/tmp//ccORGOOH.out
checked program was:
/* begin */
1: /*top*/
2: int main() { return 0; }
3: int t() { void ((*volatile p)()); p = (void ((*)()))mysql_query; return 0; }
/* end */

"gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0 -I. -I/usr/local/include   -arch ppc -arch i386 -Os -pipe -fno-common conftest.c  -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L. -arch ppc -arch i386     -lruby -lmysqlclient  -lpthread -ldl -lm  "
ld: library not found for -lmysqlclient
collect2: ld returned 1 exit status
ld: library not found for -lmysqlclient
collect2: ld returned 1 exit status
lipo: can't open input file: /var/tmp//ccQDW6XK.out (No such file or directory)
checked program was:
/* begin */
1: /*top*/
2: int main() { return 0; }
3: int t() { mysql_query(); return 0; }
/* end */

"gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0 -I. -I/usr/local/include   -arch ppc -arch i386 -Os -pipe -fno-common conftest.c  -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L. -arch ppc -arch i386     -lruby -lmysqlclient  -lpthread -ldl -lm  "
conftest.c: In function ‘t’:
conftest.c:3: error: ‘mysql_query’ undeclared (first use in this function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
conftest.c: In function ‘t’:
conftest.c:3: error: ‘mysql_query’ undeclared (first use in this function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
lipo: can't figure out the architecture type of: /var/tmp//ccLvRRft.out
checked program was:
/* begin */
1: /*top*/
2: int main() { return 0; }
3: int t() { void ((*volatile p)()); p = (void ((*)()))mysql_query; return 0; }
/* end */

"gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0 -I. -I/usr/local/include   -arch ppc -arch i386 -Os -pipe -fno-common conftest.c  -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L. -arch ppc -arch i386     -lruby -lmysqlclient  -lpthread -ldl -lm  "
ld: library not found for -lmysqlclient
collect2: ld returned 1 exit status
ld: library not found for -lmysqlclient
collect2: ld returned 1 exit status
lipo: can't open input file: /var/tmp//ccoIIN6v.out (No such file or directory)
checked program was:
/* begin */
1: /*top*/
2: int main() { return 0; }
3: int t() { mysql_query(); return 0; }
/* end */

"gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0 -I. -I/usr/local/include   -arch ppc -arch i386 -Os -pipe -fno-common conftest.c  -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L/usr/local/lib/mysql -L. -arch ppc -arch i386     -lruby -lmysqlclient  -lpthread -ldl -lm  "
conftest.c: In function ‘t’:
conftest.c:3: error: ‘mysql_query’ undeclared (first use in this function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
conftest.c: In function ‘t’:
conftest.c:3: error: ‘mysql_query’ undeclared (first use in this function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
lipo: can't figure out the architecture type of: /var/tmp//ccdYdFmS.out
checked program was:
/* begin */
1: /*top*/
2: int main() { return 0; }
3: int t() { void ((*volatile p)()); p = (void ((*)()))mysql_query; return 0; }
/* end */

"gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0 -I. -I/usr/local/include   -arch ppc -arch i386 -Os -pipe -fno-common conftest.c  -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L/usr/local/lib/mysql -L. -arch ppc -arch i386     -lruby -lmysqlclient  -lpthread -ldl -lm  "
ld:ld