Hooking up Ruby/Rails/MySQL troubleshooting notes
I documented my experience with hooking up Ruby/Rails/MySQL - I found many broken links, update issues, and just funny bugs... I hope this helps you in your quest for RRM hookup.
STATUS: RUBY 1.8.6 GEM 1.3.5 RAILS: 2.3.5 MYSQL 14.14 dis: 5.1.41 Readline: 5.1
=====================================================
Downloaded TextMate http://download-b.macromates.com/TextMate_1.5.9.dmg
Downloaded XTools 3.1.4 for 10.5.8 http://connect.apple.com/cgi-bin/WebObjects/MemberSite.woa/wa/getSoftwar...
Downloaded MacPorts 1.8.1 http://www.macports.org/ for simple 'sudo port install ruby'
=====================================================
MAC PORTS DID EVERYTHING! @_@ --- NOTE: Careful Macports will install into /opt/local not /src/local
=====================================================
RUBY 1.8.7 curl -O ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.7-p72.tar.gz
RUBY 1.8.6 curl -O ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.6.tar.gz
RUBY 1.9.1 curl -O ftp://ftp.ruby-lang.org/pub/ruby/1.9/ruby-1.9.1-p376.tar.gz
tar xzvf ruby-1.9.1-p376.tar.gz
cd /...
./configure --enable-shared --enable-pthread CFLAGS=-D_XOPEN_SOURCE=1
make
sudo make install
cd ..
PREVIOUS ERROR GONE: sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql "DOES NOT LIKE 1.8.7 or 1.9.1 --- USE 1.8.6"
========================================================
RAN: ./configure --prefix=/usr/local --enable-pthread --with-readline-dir=/usr/local
ERROR: ./mkconfig.rb:159: [BUG] Segmentation fault + ruby 1.8.4 (2005-12-24) [i686-darwin9.8.0] + make: *** [.rbconfig.time] Abort trap
SOLUTION: 'svn up' + 'make realclean'
REPLACE RAN WITH: ./configure && make -j 4
NOTE: and it built fine on (intel) leopard... I would recommend against configure options and let it figure out what is best.
CHECK WITH: ./ruby -v
========================================================
RAN: curl -O http://rubyforge-files.ruby-forum.com/rubygems/rubygems-0.9.0.tgz
ERROR: curl: (6) Couldn't resolve host 'rubyforge-files.ruby-forum.com'
SOLUTION: curl -O http://rubyforge.iasi.roedu.net/files/rubygems/rubygems-1.3.1.tgz
NOTE: Make sure you check version: http://hivelogic.com/articles/ruby-rails-leopard NOT!!!: http://hivelogic.com/articles/ruby_rails_lighttpd_mysql_tiger
========================================================
RAN: sudo gem install rails --include-dependencies
ERROR: could not find rails locally or in a repository" when installing rails? with ""
SOLUTION1: check 'gem -v' 'gem sources' + 'sudo gem update --system'
SOLUTION2: sudo gem install rails
========================================================
GRAB MYSQL: http://dev.mysql.com/downloads/mysql/5.1.html#macosx-dmg
NOTE: Running Intel Core 2 Duo + 10.5.8 = CHOOSE: x86 - 64bit
========================================================
NOTE: MySQL requires >=1.8.6 so download 1.9.1 @ http://www.ruby-lang.org/en/downloads/
ERROR: ruby -v won't update at all...
FIXED WITH:
autoconf
./configure --program-suffix=19 --enable-shared --with-readline-dir=/usr/local
make && sudo make install
NEW ERROR: ruby -v = 1.9.1 yet ERROR: Error installing mysql:
mysql requires Ruby version >= 1.8.6
NEW ATTEMPT: curl -O ftp://mirror.anl.gov/pub/mysql/Downloads/MySQL-5.1/mysql-5.1.41-osx10.5-...
tar xzvf mysql-5.1.41-osx10.5-x86_64.tar.gz
cd mysql-5.1.41-osx10.5-x86_64
========================================================
RAN: rake db:migrate
ERROR: !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql. rake aborted!
SOLUTION: sudo gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
========================================================
ERROR: dyld: lazy symbol binding failed: Symbol not found: _mysql_init
SOLUTION: probably its version of mysql not this correct one - uninstall mysql following these steps:
1. Open Terminal
2. sudo nano /etc/hostconfig
3. Delete the following line: "MYSQLCOM=-YES-"
4. CTRL+x
5. y
6. CTRL+m
7. Make sure MySQL is not running
8. Open Terminal
9. sudo rm /usr/local/mysql
10. sudo rm -rf /usr/local/mysql * (BE VERY CAREFUL WITH THIS!!!! IT WILL ERASE FILES)
11. sudo rm -rf /Library/StartupItems/MySQLCOM
12. sudo rm -rf /Library/PreferencePanes/My*
13. sudo rm -rf /Library/Receipts/mysql*
14. sudo rm -rf /Library/Receipts/MySQL*
installs the correct version, probably x386 or 32bits: http://dev.mysql.com/downloads/mysql/5.1.html#downloads
Open Terminal
sudo env ARCHFLAGS="-arch i386" gem install mysql --
--wuth-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
========================================================
