interesting, this seems related to your version of ruby (is it 1.8.6?) what do you get when you run the following in a shell?
ruby -v -e "puts 'abc'[1].ord" Ohad On Thu, Jun 3, 2010 at 11:58 PM, CraftyTech <hmmed...@gmail.com> wrote: > Ok, we got a little further now : ) This is the new error: > > rake aborted! > NoMethodError: undefined method `ord' for 0:Fixnum: SET > SQL_AUTO_IS_NULL=0 > > Here's the trace: > > (in /code/foreman) > ** Invoke db:migrate (first_time) > ** Invoke environment (first_time) > ** Execute environment > rake aborted! > NoMethodError: undefined method `ord' for 0:Fixnum: SET > SQL_AUTO_IS_NULL=0 > /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:603: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 > > Is there an optimal config that's required for the /etc/my.cnf ? > > Thanks, > > > On Jun 3, 11:34 am, Ohad Levy <ohadl...@gmail.com> wrote: > > try without the encoding line > > seehttp:// > theforeman.org/projects/foreman/wiki/FAQ#I-want-to-use-MySQLfor > > a working example. > > > > cheers, > > Ohad > > > > On Thu, Jun 3, 2010 at 11:31 PM, CraftyTech <hmmed...@gmail.com> wrote: > > > 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' > > > > ... > > > > 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<puppet-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > > -- 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.
