Project

General

Profile

Actions

Support #1912

closed

production database is not configured

Added by Andrew Gooding over 11 years ago. Updated over 11 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Triaged:
Fixed in Releases:
Found in Releases:

Description

Hello,

I am new installing and configuring Foreman. My installation includes puppetmaster, passenger, RabbitMQ & MCollective un der Centos 6.3
All the dependencies and packages have been installed and configured as per instructions. But when I run "RAILS_ENV=production rake db:migrate --trace" it aborts. Below are the versions and trace:

Distributor ID: CentOS
Description: CentOS release 6.3 (Final)
Release: 6.3
Codename: Final

foreman-0.1.6-2.noarch
rabbitmq-server-2.5.1-1.noarch
mcollective-common-2.2.1-1.el6.noarch
mcollective-2.2.1-1.el6.noarch
mcollective-client-2.2.1-1.el6.noarch
puppet-server-2.7.19-1.el6.noarch
puppet-2.7.19-1.el6.noarch

activemodel (3.0.10)
activerecord (3.0.10)
activesupport (3.0.10)
arel (2.0.10)
builder (2.1.2)
daemon_controller (1.0.0)
fastthread (1.0.7)
i18n (0.5.0)
mysql2 (0.3.11)
passenger (3.0.17)
rack (1.4.1)
rake (0.8.7)
sqlite3-ruby (1.2.4)
stomp (1.2.2)
tzinfo (0.3.33)

The trace:

RAILS_ENV=production rake db:migrate --trace
(in /usr/share/foreman)
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    production database is not configured
    /usr/share/foreman/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:62:in `establish_connection'
    /usr/share/foreman/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:55:in `establish_connection'
    /usr/share/foreman/config/../vendor/rails/railties/lib/initializer.rb:438:in `initialize_database'
    /usr/share/foreman/config/../vendor/rails/railties/lib/initializer.rb:141:in `process'
    /usr/share/foreman/config/../vendor/rails/railties/lib/initializer.rb:113:in `send'
    /usr/share/foreman/config/../vendor/rails/railties/lib/initializer.rb:113:in `run'
    /usr/share/foreman/config/environment.rb:9
    /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    /usr/share/foreman/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
    /usr/share/foreman/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
    /usr/share/foreman/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
    /usr/share/foreman/vendor/rails/railties/lib/tasks/misc.rake:4
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:635:in `call'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:635:in `execute'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:630:in `each'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:630:in `execute'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:596:in `invoke_with_call_chain'
    /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:589:in `invoke_with_call_chain'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:606:in `invoke_prerequisites'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:603:in `each'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:603:in `invoke_prerequisites'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:595:in `invoke_with_call_chain'
    /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:589:in `invoke_with_call_chain'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:582:in `invoke'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2050:in `invoke_task'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2028:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2028:in `each'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2028:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2067:in `standard_exception_handling'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2022:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in `run'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2067:in `standard_exception_handling'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1997:in `run'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
    /usr/bin/rake:19:in `load'
    /usr/bin/rake:19
    ---------------------------------------------------------------------------------------

Please let me know if you need more information
I have this files in /usr/share/foreman/config
drwxr-xr-x 5 root root 4.0K Oct 22 11:49 .
drwxr-xr-x 9 root root 4.0K Oct 22 11:28 ..
rw-r--r- 1 root root 2.8K Nov 12 2010 boot.rb
rw-r--r- 1 root root 159 Oct 22 11:28 database.yml
lrwxrwxrwx 1 root root 23 Oct 22 11:28 email.yaml > /etc/foreman/email.yaml
-rw-r--r-
1 foreman foreman 2.1K Nov 12 2010 environment.rb
drwxr-xr-x 2 root root 4.0K Oct 22 11:49 environments
drwxr-xr-x 2 root root 4.0K Oct 22 11:28 initializers
drwxr-xr-x 2 root root 4.0K Oct 22 11:28 locales
rw-r--r- 1 root root 2.5K Nov 12 2010 routes.rb
rw-r--r- 1 root root 237 Oct 22 11:28 settings.yaml

  1. cat database.yml
    production:
    adapter: mysql
    database: puppet
    username: puppet
    password: xxxxxxxxxxxxxxxxxxxxxxx
    socket: "/var/lib/mysql/mysql.sock"
    host: localhost
    encoding: utf8

mysql> show databases;
------------------ | Database |
------------------ | information_schema | | mysql | | puppet | | test |
------------------
4 rows in set (0.00 sec)

mysql> show tables;
Empty set (0.00 sec)

ls al /usr/share/foreman/config/environments
-rw-r--r-
1 root root 820 Nov 12 2010 development.rb
rw-r--r- 1 root root 1011 Nov 12 2010 production.rb
rw-r--r- 1 root root 1.4K Nov 12 2010 test.rb

cat production.rb
  1. Settings specified here will take precedence over those in config/environment.rb
  1. The production environment is meant for finished, "live" apps.
  2. Code is not reloaded between requests
    config.cache_classes = true
  1. Full error reports are disabled and caching is turned on
    config.action_controller.consider_all_requests_local = false
    config.action_controller.perform_caching = true
    config.action_view.cache_template_loading = true
  1. See everything in the log (default is :info)
  2. config.log_level = :debug
  1. Use a different logger for distributed setups
  2. config.logger = SyslogLogger.new
  1. Use a different cache store in production
  2. config.cache_store = :mem_cache_store
  1. Enable serving of images, stylesheets, and javascripts from an asset server
  2. config.action_controller.asset_host = "http://assets.example.com"
  1. Disable delivery errors, bad email addresses will be ignored
  2. config.action_mailer.raise_delivery_errors = false
  1. Enable threaded mode
  2. config.threadsafe!puppet.xxxx.com:/usr/share/foreman/config/environments (Mon Oct 22 -- 12:38:35)

Please let me know if you need additional information.
Thanks in advance,

Andrew

Actions #1

Updated by Greg Sutcliffe over 11 years ago

If that database.yml is literal, then your whitespace is wrong - in YAML whitespace does matter. Try a 2 space indent (yes that's 2 spaces, the Redmine formatting is interesting :P):

production:
adapter: mysql
database: puppet
username: puppet
password: xxxxxxxxxxxxxxxxxxxxxxx
socket: "/var/lib/mysql/mysql.sock"
host: localhost
encoding: utf8
Actions #2

Updated by Andrew Gooding over 11 years ago

Thanks a lot! Greg... I didn't have idea of that... it works now...

Actions #3

Updated by Ohad Levy over 11 years ago

  • Status changed from New to Resolved

I did saw foreman-0.1.6-2.noarch in your logs, that version is about 2 years old now :), have a look at yum.theforeman.org

Actions

Also available in: Atom PDF