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.

Reply via email to