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. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.