Rails 3与mysql问题 [英] Rails 3 with mysql problem

问题描述

我已将雪豹的滑轨更新为3.以前，我使用sqlite进行开发. 当我耙db:create时，它工作正常.

I have updated to rails 3 on my Snow leopard. Previously i use sqlite for development. It's working fine when i rake db:create.

现在我正在尝试在Mac上安装mysql.

Now I'm trying to install mysql on my mac.

1. 我下载了mysql-5.1.50-osx10.6-x86.dmg
2. 安装了所有三个文件.(mysql- {version} -osx10.5-x86.pkg，MySQL.prefPane，MySQLStartupItem.pkg)
3. 执行此操作以安装gem.

sudo env ARCHFLAGS="-arch i386" gem install mysql -- \
  --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib \
  --with-mysql-include=/usr/local/mysql/include

一切都很好.创建的宝石没有错误.

Everything is good. gem created with no error.

我用

rails new p1 -d mysql

创建一个新项目 继续

rake db:create

它显示

Could not find gem 'mysql2 (>= 0, runtime)' in any of the gem sources.
Try running `bundle install`.

然后我安装新的gem. sudo gem安装mysql2.

Then I install new gem. sudo gem install mysql2.

同样的问题.我有

dyld: lazy symbol binding failed: Symbol not found: _mysql_init
  Referenced from: /Library/Ruby/Gems/1.8/gems/mysql2-0.2.3/lib/mysql2/mysql2.bundle
  Expected in: flat namespace

dyld: Symbol not found: _mysql_init
  Referenced from: /Library/Ruby/Gems/1.8/gems/mysql2-0.2.3/lib/mysql2/mysql2.bundle
  Expected in: flat namespace

Trace/BPT trap

我删除了重复的mysql2.bundle.结果是一样的.错误.

I deleted the duplicate mysql2.bundle. The result is same. error.

我几乎阅读了网上的所有文章.但是可以解决这个问题.

i have read almost all articles on the net. But could solve this problem.

是因为我在雪豹上安装了32位mysql吗?还是我的红宝石问题? 为什么Rails 3突然要求mysql2 gem，因为我使用的是-d mysql.

Is it because i installed 32 bit mysql on snow leopard? or my rubygems problem? Why rails 3 suddenly asking for mysql2 gem since i use '-d mysql'.

Rails 3 + MySql在Mac上

Rails 3 + MySql on mac

谢谢.祝你有美好的一天.

Thank you. Have a nice day.

推荐答案

我多次尝试并出错

mysql-5.1.50-osx10.6-x86 mysql-5.1.50-osx10.6-x86_64

mysql-5.1.50-osx10.6-x86 mysql-5.1.50-osx10.6-x86_64

我收到了mysql.prefpane和dyld:懒惰的符号绑定失败:未找到符号:_mysql_init问题.

I received mysql.prefpane and dyld: lazy symbol binding failed: Symbol not found: _mysql_init problem.

然后我在 http://weblog.rubyonrails.org/上找到了一条帖子. 它说我需要安装

Then I found a post at http://weblog.rubyonrails.org/. It says i need to install

mysql-5.1.50-osx10.5-x86_64

mysql-5.1.50-osx10.5-x86_64

效果更好.解决了两个问题.但仍然出现错误:2.我无法创建数据库.

works better. solved both problem. but still got errno: 2. Which i can't create database.

通过重新启动解决了errno:2.

Solved errno:2 by REBOOT the system.

这篇关于Rails 3与mysql问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！