do_mysql error,and how to track

<br />[lake@yhd2 ad_server]$ sudo gem install do_mysql<br />#在裝do_mysql gem時 又爆掉啦<br />Building native extensions. This could take a while...<br />ERROR: Error installing do_mysql:<br /> ERROR: Failed to build gem native extension.<br /><br /># 它是用 extconf.rb 這個file 去產生makfile<br />/usr/local//bin/ruby extconf.rb install do_mysql<br />checking for mysql.h... yes<br />checking for main() in -lmysqlclient... no #找不到<br />checking for mysql_query()... no #又找不到<br />checking for mysql_ssl_set()... no #通通找不到<br />creating Makefile #東西通通找不到, build makefile 當然就爆啦<br /><br />make<br />gcc -I. -I. -I/usr/local//lib/ruby/1.8/i686-linux -I. -DHAVE_MYSQL_H -I/usr/include/mysql -g -pipe -m32 -march<br />=i386 -mtune=pentium4 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fPIC -g -O<br />2 -fPIC -Wall -c do_mysql_ext.c<br />gcc -shared -rdynamic -Wl,-export-dynamic -L'/usr/local//lib' -Wl,-R'/usr/local//lib' -o do_mysql_ext.so do_m<br />ysql_ext.o -Wl,-R -Wl,/usr/local//lib -L/usr/local//lib -L. -lruby -L/usr/lib/mysql -lmysqlclient -lz -lcrypt <br />-lnsl -lm -L/usr/lib -lssl -lcrypto -lpthread -ldl -lcrypt -lm -lc<br />/usr/bin/ld: cannot find -lmysqlclient<br />collect2: ld returned 1 exit status<br />make: *** [do_mysql_ext.so] Error 1<br /><br /># gem file 還是有留在這, 從上面知道makefile 有問題, 所以要去找要生它的人, 從上面知道是extconf.rb 這個檔案, 從下面應該知道它應該在/usr/local/lib/ruby/gems/1.8/gems/do_mysql-0.9.9 下, 所以去他下面找<br />Gem files will remain installed in /usr/local/lib/ruby/gems/1.8/gems/do_mysql-0.9.9 for inspection.<br />Results logged to /usr/local/lib/ruby/gems/1.8/gems/do_mysql-0.9.9/ext/gem_make.out<br /><br /># 在 extconf.rb file 裡 , 發現了這句話<br /><br /># Allow overriding path to mysql_config on command line using:<br /># ruby extconf.rb --with-mysql-config=/path/to/mysql_config<br /><br />#很明顯告訴我們, 如果path 不同要自己下參數啦<br /><br /># 那現在就是要找mysql_config, 有幾種方法<br /># 1. which mysql_config , 但這很容易只是找到path, 而不是真正安裝的地方<br /># 2. pa aux | grep mysqld, 查一下在那邊跑就知道啦<br /># 3. sudo find / -name 'mysql_config', 最後不行就只好find 下去啦, 不過可以 /usr/bin 和 /usr/local/bin 這兩個下面先找, 十之八久都是裝在這邊<br /><br />#找到之後, 參數填好 就給他跑下去啦<br />sudo gem install do_mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config<br /><br />#打完 收工<br />Building native extensions. This could take a while...<br />Successfully installed do_mysql-0.9.9<br />1 gem installed<br /><br />