How to install Mysql/Ruby on Solaris SPARC 64

I found only partial documentation on how to install the Ruby driver for MySql. There are two version of drivers, one is MySql/Ruby and is written in C, the second is Ruby/MySql and is written in Ruby. Ruby/MySql is included in Rails but has slower performance, plus it was not working with MySql 5.0, it does not work with MySql 4.something too!

So I decieded to compile the C driver. Below you can find the commands:


curl http://tmtm.org/downloads/mysql/ruby/mysql-ruby-2.7.tar.gz -o mysql-gzip -d gzip -d mysql-ruby-2.7.tar.gz
tar xfv mysql-ruby-2.7.tar
cd mysql-ruby-2.7
ruby extconf.rb --with-mysql-include=/usr/local/mysql/include/mysql --with-mysql-lib=/usr/local/mysql/lib/mysql
make
sudo make install


Make sure that 'make install' will be executed as root. Now you can test the connection with:


ruby test.rb [hostname] [username] [dbpassword]


Of course you have to put the host, username and password. Another nice script to test your MySql connection is:


require 'mysql'

mysql = Mysql.init()
mysql.connect('localhost', 'username', 'password')
results = mysql.query("SELECT now();")
results.each{|row|; puts row;}
mysql.close()