MySQL gem woes & staging instance operational
Spent a bit of time trying to fix MySQL 4.1.15 on RHEL 4 today since it was complaining on rake that
Mysql::Error: Lost connection to MySQL server during query: SELECT version FROM schema_info
I found help in this post on the Rails blog which led me to this solution on the Rails wiki. In particular I had to do:
gem install mysql.
cd /usr/lib/ruby/gems/1.8/gems/mysql-2.7
sudo ruby extconf.rb --with-mysql-lib=/usr/lib/mysql
sudo gem install mysql
Once that was fixed the automatic update on commit of the staging instance could be turned on. So now you can see the latest code at the staging instance. The tests are incomplete but we've halted for the night, see you tomorrow.
Oh and I just heard we'll have our superstar developer back from illness tomorrow, woohoo!
Comments
if your mysql is installed in directory other than /usr/lib/mysql you need to use --with-mysql-dir option
i.e.
sudo ruby extconf.rb --with-mysql-dir=/usr/local/mysql
Posted by: Piotr Gabryanczyk | April 17, 2006 11:02 PM