ruby-on-rails - 尝试在 Vagrant 中将 sql server 与 RoR 应用程序连接时出错
问题描述
我正在尝试将 RoR 应用程序与 SQL Server 连接。我创建了一个database.yml
文件,如下所示:
development:
<<: *default
adapter: sqlserver
host: 'pcname\domain'
encoding: 'unicode'
database: 'db_name'
username: 'user'
password: 'pass'
pool: 5
port: 1434
我在 SQL 配置管理器中启用了 TPC/IP 并将端口更改为 1434。
当我尝试使用rake db:migrate
控制台运行迁移时,抛出:
TinyTds::Error: 在配置文件中找不到服务器名称
我以前安装过 FreeTDS。我试过有dataserver: 'pcname\domain:1434'
和dataserver: 'pcname\domain'
没有端口
完整跟踪
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/tiny_tds-2.0.0/lib/tiny_tds/client.rb:54:in connect'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/tiny_tds-2.0.0/lib/tiny_tds/client.rb:54:ininitialize' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-sqlserver-adapter-5.2.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:375:in new'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-sqlserver-adapter-5.2.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:375:indblib_connect' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-sqlserver-adapter-5.2.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:361:in connect'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-sqlserver-adapter-5.2.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:59:ininitialize' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-sqlserver-adapter-5.2.0/lib/active_record/sqlserver_base.rb:13:in new'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-sqlserver-adapter-5.2.0/lib/active_record/sqlserver_base.rb:13:insqlserver_connection' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:811:in new_connection'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:855:incheckout_new_connection' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:834:in try_to_checkout_new_connection'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:795:inacquire_connection' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:523:in checkout'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:inconnection' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:1014:in retrieve_connection'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_handling.rb:118:inretrieve_connection' /home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/connection_handling.rb:90:in connection'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:inmigrate'/home/vagrant/.rvm/gems/ruby-2.3.3/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in block (2 levels) in <main>'
/home/vagrant/.rvm/gems/ruby-2.3.3/gems/rake-12.3.2/exe/rake:27:in' /home/vagrant/.rvm/gems/ruby-2.3.3/bin/ruby_executable_hooks:15:in eval'
/home/vagrant/.rvm/gems/ruby-2.3.3/bin/ruby_executable_hooks:15:in' Tasks: TOP => db:migrate
流浪文件
# -*- mode: ruby -*-
# vi: set ft=ruby :
# All Vagrant configuration is done below. The "2" in Vagrant.configure
# configures the configuration version (we support older styles for
# backwards compatibility). Please don't change it unless you know what
# you're doing.
Vagrant.configure("2") do |config|
# The most common configuration options are documented and commented below.
# For a complete reference, please see the online documentation at
# https://docs.vagrantup.com.
# Every Vagrant development environment requires a box. You can search for
# boxes at https://vagrantcloud.com/search.
config.vm.box = "jaxmetalmax/debian8-rubydev"
# Disable automatic box update checking. If you disable this, then
# boxes will only be checked for updates when the user runs
# `vagrant box outdated`. This is not recommended.
# config.vm.box_check_update = false
# Create a forwarded port mapping which allows access to a specific port
# within the machine from a port on the host machine. In the example below,
# accessing "localhost:8080" will access port 80 on the guest machine.
# NOTE: This will enable public access to the opened port
# config.vm.network "forwarded_port", guest: 80, host: 8080
# Create a forwarded port mapping which allows access to a specific port
# within the machine from a port on the host machine and only allow access
# via 127.0.0.1 to disable public access
# config.vm.network "forwarded_port", guest: 80, host: 8080, host_ip: "127.0.0.1"
# Create a private network, which allows host-only access to the machine
# using a specific IP.
# config.vm.network "private_network", ip: "192.168.33.10"
# Create a public network, which generally matched to bridged network.
# Bridged networks make the machine appear as another physical device on
# your network.
# config.vm.network "public_network"
# Share an additional folder to the guest VM. The first argument is
# the path on the host to the actual folder. The second argument is
# the path on the guest to mount the folder. And the optional third
# argument is a set of non-required options.
# config.vm.synced_folder "../data", "/vagrant_data"
config.vm.synced_folder "C:/EGodoy/Sites", "/home/vagrant/sites"
config.vm.network "private_network", ip: "192.168.33.10"
# Provider-specific configuration so you can fine-tune various
# backing providers for Vagrant. These expose provider-specific options.
# Example for VirtualBox:
#
# config.vm.provider "virtualbox" do |vb|
# # Display the VirtualBox GUI when booting the machine
# vb.gui = true
#
# # Customize the amount of memory on the VM:
# vb.memory = "1024"
# end
#
# View the documentation for the provider you are using for more
# information on available options.
# Enable provisioning with a shell script. Additional provisioners such as
# Puppet, Chef, Ansible, Salt, and Docker are also available. Please see the
# documentation for more information about their specific syntax and use.
# config.vm.provision "shell", inline: <<-SHELL
# apt-get update
# apt-get install -y apache2
# SHELL
end
解决方案
据我所知,您没有在 vagrant VM 和主机之间转发任何端口,您需要为在 VM 上运行的 RoR 执行此操作才能连接到正在运行的 SQL Server 的端口主机。在 vagrant 文件中添加这一行:
config.vm.network "forwarded_port", guest: 1434, host: 1434
您可能还需要取消注释此行,以便您可以访问您的 RoR 站点:
config.vm.network "forwarded_port", guest: 80, host: 8080
或将上面的端口更改为您正在运行 RoR 的任何端口(我相信 3000 是默认值,所以3000
不是80
)
推荐阅读
- python - 如何使用正则表达式对该字符串进行排序
- swift - Xcode 无法构建新项目 (12.4) - 无法构建 Objective-C 模块“SwiftUI”
- android - android studio - 我在下载时不小心点击了“背景”按钮,现在我找不到下载进度
- mysql - jmerise export 在 mariadb 中导入时出现语法错误,但我在脚本中找不到语法错误
- sql - 递归查询查找满足条件的循环
- python - 有没有办法找到每个预测的特征重要性?
- homebrew - 任何 brew 安装导致'curl:(35)错误:1400410B:SSL 例程:CONNECT_CR_SRVR_HELLO:错误的版本号'
- javascript - 如何在循环中获取动态属性
- python - while 循环,如何设置相等并中断 while 循环?
- c# - 从数据库中检索数据时如何跳过不正确的 DateAndTime 格式