Appfog + Rails 3+ Postgresql + IronWorker =>无法连接到服务器:连接超时(PG：：错误)

Question

我在Appfog上部署了一个带有postgresql数据库的Rails 3应用程序。我想用IronWorker运行后台作业，但我无法连接到我的数据库。

这是我的铁工文件(.worker + my_worker.rb)

.worker

runtime "ruby"
gemfile '../Gemfile'
dir "../app/models" # merge all models
full_remote_build true
exec "my_worker.rb"

my_worker.rb

require 'rubygems'
require 'active_record'
require 'pg'
require 'models/my_model.rb'


def setup_database
  puts "Database connection details:#{params['database'].inspect}"
  return unless params['database']
  # estabilsh database connection
  ActiveRecord::Base.establish_connection(params['database'])
end


setup_database
@my_models = My_model.all

然后，我创建了一个任务，将数据库连接传递给ironworker：

client = IronWorkerNG::Client.new
client.tasks.create("my_worker", database:Rails.configuration.database_configuration[Rails.env])

下面是我在IronWorker中遇到的错误

/task/__gems__/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1213:in `initialize': could not connect to server: Connection timed out (PG::Error)
Is the server running on host "10.0.48.220" and accepting TCP/IP connections on port 5432?

有人能帮我从IronWorker连接我的Appfog DB吗？

提前谢谢你

--马修

Answer 1

据我所知，AppFog阻止外部连接到他们的数据库https://groups.google.com/forum/?fromgroups=#!topic/appfog-users/I31ni0pff9I

可能的解决方案：

• Poke AppFog
• Switch to other database hoster
• 创建某种隧道。例如，SSH允许您在worker执行期间与任何非特权代码进行交互，因此您可以尝试建立到“好”计算机的IronWorker隧道。