gpt4 book ai didi

ruby-on-rails - 在我的 'production' 服务器上运行时, bundle 程序忽略 MySQL2 gem 的安装

转载 作者:行者123 更新时间:2023-12-04 17:26:06 26 4
gpt4 key购买 nike

我正在尝试使用 Capistrano 在我的生产服务器上安装 'mysql2' gem。

我想在开发中使用 SQLite,在生产中使用 MySQL。

我在 Windows 7 机器上开发,生产使用 Ubuntu。

当我跑 bundle install在我的开发机器上,它安装了 MySQL2。

当 Capistrano 在我的生产机器上运行它时,它甚至没有在输出中提及。

当我在我的生产机器上直接在 shell 上运行相同的命令时,它也没有提到 gem。

我还发现 gem 'therubyracer', :platforms => :ruby没有被安装。我在 mysql2 条目之后添加了这个。我希望这两个是相关的。在我添加 therubyracer 之前,mysql2 无法正常工作。

由于上述所有原因,当我尝试查看我的网站时出现以下错误:

Please install the mysql2 adapter: gem install activerecord-mysql2-adapter (mysql2 is not part of the bundle. Add it to Gemfile.)



附加信息

我希望我在下面包含的信息量比痛苦更有用。

gem 文件

我很感激我可以将 mysql2 放在“生产”中,但这不起作用。
source 'http://rubygems.org'

gem 'rails', '3.1.1'
gem 'nokogiri'
gem 'bcrypt-ruby'
gem 'faker'
gem 'will_paginate'
gem 'capistrano'
gem 'capistrano-ext'
gem 'mysql2', "~> 0.3"
gem 'therubyracer', :platforms => :ruby
gem 'sqlite3'

# Gems used only for assets and not required
# in production environments by default.
group :assets do
gem 'sass-rails', '~> 3.1.4'
gem 'coffee-rails', '~> 3.1.1'
gem 'uglifier', '>= 1.0.3'
end

gem 'jquery-rails'

group :test do
# Pretty printed test output
gem 'turn', :require => false
end

Capistrano bundle 安装命令的输出
  * executing "cd /home/gannicott.co.uk/production/listen/www/releases/20120223225131 && bundle install --gemfile /home/gannicott.co.uk/prod
uction/listen/www/releases/20120223225131/Gemfile --path /home/gannicott.co.uk/production/listen/www/shared/bundle --deployment --without de
velopment test"
servers: ["homer.gannicott.co.uk"]
[homer.gannicott.co.uk] executing command
[homer.gannicott.co.uk] sh -c 'cd /home/gannicott.co.uk/production/listen/www/releases/20120223225131 && bundle install --gemfile /home/
gannicott.co.uk/production/listen/www/releases/20120223225131/Gemfile --path /home/gannicott.co.uk/production/listen/www/shared/bundle --dep
loyment --without development test'
** [out :: homer.gannicott.co.uk] Installing rake (0.9.2.2)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing multi_json (1.1.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing activesupport (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing builder (3.0.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing i18n (0.6.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing activemodel (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing erubis (2.7.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing rack (1.3.6)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing rack-cache (1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing rack-mount (0.8.3)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing rack-test (0.6.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing hike (1.2.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing tilt (1.3.3)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing sprockets (2.0.3)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing actionpack (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing mime-types (1.17.2)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing polyglot (0.3.3)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing treetop (1.4.10)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing mail (2.3.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing actionmailer (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing arel (2.2.3)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing tzinfo (0.3.31)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing activerecord (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing activeresource (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing highline (1.6.11)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing net-ssh (2.3.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing net-scp (1.0.4)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing net-sftp (2.0.5)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing net-ssh-gateway (1.1.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing capistrano (2.11.2)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing capistrano-ext (1.2.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing coffee-script-source (1.2.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing execjs (1.3.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing coffee-script (2.2.0)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing rack-ssl (1.3.2)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing json (1.6.5)
** [out :: homer.gannicott.co.uk] with native extensions
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing rdoc (3.12)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing thor (0.14.6)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing railties (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing coffee-rails (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing faker (1.0.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing jquery-rails (1.0.19)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Using bundler (1.0.21)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing rails (3.1.1)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing sass (3.1.15)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing sass-rails (3.1.5)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing uglifier (1.2.3)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Installing will_paginate (3.0.3)
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Updating .gem files in vendor/cache
** [out :: homer.gannicott.co.uk]
** [out :: homer.gannicott.co.uk] Your bundle is complete! It was installed into /home/gannicott.co.uk/production/listen/www/shared/bundle
** [out :: homer.gannicott.co.uk]
command finished in 12924ms

capistrano 的 deploy.rb
require 'bundler/capistrano'
require 'capistrano/ext/multistage'
# Based on: http://guides.beanstalkapp.com/deployments/deploy-with-capistrano.html
set :application, "listen_later"

set :scm, :git
set :repository, "repos location"
set :scm_passphrase, "passphrase"

set :user, "username"

set :stages, ["staging", "production"]
set :default_stage, "staging"

# The following needs to be added to avoid a failure (http://discuss.joyent.com/viewtopic.php?id=27326)
default_run_options[:pty] = true

namespace :deploy do
desc "Tell Passenger to restart the app."
task :restart do
run "touch #{current_path}/tmp/restart.txt"
end
end

# Removed --silent so I can see what's going on
set :bundle_flags, "--deployment"

capistrano 的生产部署文件
server "homer.gannicott.co.uk", :app, :web, :db, :primary => true
set :deploy_to, "/home/gannicott.co.uk/production/listen/www"

数据库配置文件
# SQLite version 3.x
# gem install sqlite3
#
# Ensure the SQLite 3 gem is defined in your Gemfile
# gem 'sqlite3'
development:
adapter: sqlite3
database: db/development.sqlite3
pool: 5
timeout: 5000

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
adapter: sqlite3
database: db/test.sqlite3
pool: 5
timeout: 5000

production:
adapter: mysql2
encoding: utf8
reconnect: false
database: databasename
pool: 5
username: username
password: password
#socket: **/opt/local/var/run/mysql5/mysqld.sock**

# adapter: sqlite3
# database: db/production.sqlite3
# pool: 5
# timeout: 5000

干杯!

最佳答案

都整理好了。虽然它有一个变通办法,但我并不完全满意。

这个调查

更多的谷歌搜索将我带到这个页面:

http://redmine.autotelik.co.uk/blogs (搜索“mysql2”,它会找到相关部分)

这导致我......堆栈溢出(当然!):

Make bundler use different gems for different platforms

这反过来又导致我:

https://github.com/carlhuda/bundler/issues/646

问题

当您在 Windows 上运行 Bundler 时,它包含一个针对 mysql2 的 Windows 版本的条目。但是,这与 Linux 上的要求不同。因此,Gemfile.lock 文件不适合在 Linux 上使用。

解决方案

目标是让 Bundler 生成的 Gemfile.lock 文件在生产服务器上生成。从我读过的内容来看,通常不推荐这样做。也就是说,要实现这一...

我的 git 存储库中不再包含 Gemfile.lock 文件:

echo 'Gemfile.lock' >> .gitignore

我已经从 git 中删除了文件:
git rm Gemfile.lock
git commit -am "Removing Gemfile.lock to cope with Windows and Linux differences"
git push

我已经告诉 Capistrano 不要在部署模式下运行,方法是在我的 config/deploy.rb 中添加以下行:
set :bundle_flags,    ""

您可能希望包含 --quiet引号中的标志,但在这次经历之后,我很想看看在我部署时安装了什么。

现在当我运行时 cap production deploy它将重新生成 Gemfile.lock每次都存档。这意味着现在在我的生产服务器上使用了正确版本的 mysql2。

我想这可以改进,但现在它对我有用。

希望有一天这对某人有所帮助。

关于ruby-on-rails - 在我的 'production' 服务器上运行时, bundle 程序忽略 MySQL2 gem 的安装,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/9423119/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com