gem install mysql fails

I've found other online references to this error:

ERROR: While executing gem ... (Gem::Installer::ExtensionBuildError)
    ERROR: Failed to build gem native extension.

ruby extconf.rb install mysql
checking for mysql_query() in -lmysqlclient... no
... blah blah

The most apparently relevant is old, though, from November 2005
  <http://www.rubyforums.com/showthread.php?p=462>
blaming gcc4.

Is this still the case? Does anyone know of an alternative workaround?
Unfortunately I only have gcc4.0.2 on this system (SuSE 10.0 64bit).

TIA,

No, I already have all the dev header stuff; what version(s) of gcc are
on your system? Or more to the point, which did you use to compile?

'gem install mysql' uses gcc -- what do you get from `which gcc`?

Here's what I do on my Centos 4/5 boxes. After installing mysql and
mysql-devel (using yum), I do this:

gem install mysql (let it fail)
cd /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7
ruby extconf.rb --with-mysql-config=/usr/bin/mysql_config
make && make install from gem directory

Hope this helps,

Dave
http://www.stevensonsoftware.com - affordable VPS Hosting
http://www.gotossh.com - web based SSH

! Thanks, that /seemed/ to work, in the sense that no error messages
were generated :slight_smile:

However, when I do a `gem query --local` there's no 'mysql' in the
list -- is that normal?

Having gotten this far I'd like to see the documentation and run the
unit tests...