I'm using mysql 5.1.44 . I tested the config in the database.yml, by basically using the same credentials and logging in locally. I was able log in fine. Here's a snippet:
production: adapter: mysql database: foreman_prod username: foreman_user password: XXXXXXXXXXX encoding: utf8 I gave the user all access to the database too: GRANT ALL PRIVILEGES ON *.* TO 'foreman_user'@'localhost' WITH GRANT OPTION; I hope I"m not missing something. On Jun 3, 11:19 am, Ohad Levy <ohadl...@gmail.com> wrote: > which db are you using? could it be that you have some error in > config/database.yml file? > > Ohad > > On Thu, Jun 3, 2010 at 11:05 PM, CraftyTech <hmmed...@gmail.com> wrote: > > Hello Ohad, > > > From the instructions you have posted, I tried to setup the > > database via RAILS_ENV=production rake db:migrate, and then I got the > > following error: > > > rake aborted! > > NoMethodError: undefined method `ord' for 0:Fixnum: SET NAMES 'utf8' > > > This is the trace: > > > ** Invoke db:migrate (first_time) > > ** Invoke environment (first_time) > > ** Execute environment > > rake aborted! > > NoMethodError: undefined method `ord' for 0:Fixnum: SET NAMES 'utf8' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract_adapter.rb:219:in `log' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/mysql_adapter.rb:323:in `execute' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/mysql_adapter.rb:599:in `configure_connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/mysql_adapter.rb:594:in `connect' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/mysql_adapter.rb:203:in `initialize' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/mysql_adapter.rb:75:in `new' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/mysql_adapter.rb:75:in `mysql_connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:223:in `send' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:223:in > > `new_connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:245:in > > `checkout_new_connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:188:in `checkout' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:184:in `loop' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:184:in `checkout' > > /usr/lib/ruby/1.8/monitor.rb:238:in `synchronize' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:183:in `checkout' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:98:in `connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:326:in > > `retrieve_connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_specification.rb:123:in > > `retrieve_connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/ > > connection_adapters/abstract/connection_specification.rb:115:in > > `connection' > > /code/foreman/vendor/rails/activerecord/lib/active_record/base.rb: > > 3113:in `quoted_table_name' > > /code/foreman/vendor/plugins/acts_as_audited/lib/acts_as_audited.rb: > > 82:in `acts_as_audited' > > /code/foreman/app/models/host.rb:55 > > /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' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:158:in `require' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:265:in `require_or_load' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:425:in `old_load_missing_constant' > > /code/foreman/config/initializers/ > > fix_already_loading_missing_dependencies.rb:9:in > > `load_missing_constant' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:80:in `const_missing' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:92:in `const_missing' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > inflector.rb:361:in `constantize' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > inflector.rb:360:in `each' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > inflector.rb:360:in `constantize' > > /code/foreman/vendor/rails/activesupport/lib/active_support/core_ext/ > > string/inflections.rb:162:in `constantize' > > /code/foreman/vendor/rails/activerecord/lib/active_record/observer.rb: > > 157:in `observed_class' > > /code/foreman/vendor/rails/activerecord/lib/active_record/observer.rb: > > 183:in `observed_classes' > > /code/foreman/vendor/rails/activerecord/lib/active_record/observer.rb: > > 166:in `initialize' > > /usr/lib/ruby/1.8/singleton.rb:95:in `new' > > /usr/lib/ruby/1.8/singleton.rb:95:in `instance' > > /code/foreman/vendor/rails/activerecord/lib/active_record/observer.rb: > > 38:in `instantiate_observers' > > /code/foreman/vendor/rails/activerecord/lib/active_record/observer.rb: > > 36:in `each' > > /code/foreman/vendor/rails/activerecord/lib/active_record/observer.rb: > > 36:in `instantiate_observers' > > /code/foreman/vendor/rails/actionpack/lib/action_controller/ > > dispatcher.rb:15:in `define_dispatcher_callbacks' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:182:in `call' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:182:in `evaluate_method' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:166:in `call' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:90:in `run' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:90:in `each' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:90:in `send' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:90:in `run' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > callbacks.rb:276:in `run_callbacks' > > /code/foreman/vendor/rails/actionpack/lib/action_controller/ > > dispatcher.rb:51:in `send' > > /code/foreman/vendor/rails/actionpack/lib/action_controller/ > > dispatcher.rb:51:in `run_prepare_callbacks' > > /code/foreman/config/../vendor/rails/railties/lib/initializer.rb: > > 631:in `prepare_dispatcher' > > /code/foreman/config/../vendor/rails/railties/lib/initializer.rb: > > 185:in `process' > > /code/foreman/config/../vendor/rails/railties/lib/initializer.rb: > > 113:in `send' > > /code/foreman/config/../vendor/rails/railties/lib/initializer.rb: > > 113:in `run' > > /code/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' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:156:in `require' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:521:in `new_constants_in' > > /code/foreman/vendor/rails/activesupport/lib/active_support/ > > dependencies.rb:156:in `require' > > /code/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:238: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:238: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 > > > Any Ideas? > > > Thanks, > > > Henry > > > On Jun 2, 11:36 pm, Ohad Levy <ohadl...@gmail.com> wrote: > > > Hi, > > > > Sorry, that tarbar does not include the required libraries, usehttp:// > > theforeman.org/foreman-nightly.tar.bz2instead. > > > > Ohad > > > > On Thu, Jun 3, 2010 at 11:33 AM, Ohad Levy <ohadl...@gmail.com> wrote: > > > > yeah, its still the last stable version, > > > > > You can get the latest development here - > > > >http://github.com/ohadlevy/foreman/tarball/develop > > > > Note that if you plan to rebuild the rpm, you should also use the > > latest > > > > spec files form the extra/spec directory. > > > > > Ohad > > > > > On Thu, Jun 3, 2010 at 12:25 AM, Gustavo Soares < > > gustavosoa...@gmail.com>wrote: > > > > >> I've installed foreman yesterday to play around.. > > > > >> I've have used the tar.gz in the "src.rpm" file to install it... is it > > > >> old? > > > > >> Thanks in advance, > > > >> Gus > > > > >> On Wed, Jun 2, 2010 at 12:28 PM, CraftyTech <hmmed...@gmail.com> > > wrote: > > > > >>> Sounds great. I'm looking forward to > > ... > > read more » -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-us...@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.