Steve Neuharth
2010-Sep-06 14:14 UTC
[Puppet Users] error in foreman, seem to be missing a column in DB
I''ve been trying to get foreman to work and I''m getting the
following
error:
Processing DashboardController#index (for 10.10.32.10 at 2010-09-06
08:50:06) [GET]
Parameters: {"action"=>"index",
"controller"=>"dashboard"}
ActiveRecord::StatementInvalid (Mysql::Error: Unknown column
''enabled''
in ''where clause'': SELECT count(*) AS count_all FROM `hosts`
WHERE
(last_report < ''2010-09-06 13:15:06'' and enabled = 1) ):
app/controllers/dashboard_controller.rb:57:in `prefetch_data''
/usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in `service''
/usr/lib64/ruby/1.8/webrick/httpserver.rb:65:in `run''
/usr/lib64/ruby/1.8/webrick/server.rb:173:in `start_thread''
/usr/lib64/ruby/1.8/webrick/server.rb:162:in `start''
/usr/lib64/ruby/1.8/webrick/server.rb:162:in `start_thread''
/usr/lib64/ruby/1.8/webrick/server.rb:95:in `start''
/usr/lib64/ruby/1.8/webrick/server.rb:92:in `each''
/usr/lib64/ruby/1.8/webrick/server.rb:92:in `start''
/usr/lib64/ruby/1.8/webrick/server.rb:23:in `start''
/usr/lib64/ruby/1.8/webrick/server.rb:82:in `start''
Rendering /var/lib/foreman/public/500.html (500 Internal Server Error)
I checked mysql and the ''enabled'' column is definitely absent.
Is my
database messed up or did I miss something in my puppet or foreman
installation?
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
Ohad Levy
2010-Sep-06 14:18 UTC
Re: [Puppet Users] error in foreman, seem to be missing a column in DB
You probably updated from source (git?) and forgot to migrate your database: see http://theforeman.org/projects/foreman/wiki/Upgrade_instructions#Step-4-Update-the-database <http://theforeman.org/projects/foreman/wiki/Upgrade_instructions#Step-4-Update-the-database> Ohad On Mon, Sep 6, 2010 at 5:14 PM, Steve Neuharth <steve.neuharth@gmail.com>wrote:> I''ve been trying to get foreman to work and I''m getting the following > error: > Processing DashboardController#index (for 10.10.32.10 at 2010-09-06 > 08:50:06) [GET] > Parameters: {"action"=>"index", "controller"=>"dashboard"} > > ActiveRecord::StatementInvalid (Mysql::Error: Unknown column ''enabled'' > in ''where clause'': SELECT count(*) AS count_all FROM `hosts` WHERE > (last_report < ''2010-09-06 13:15:06'' and enabled = 1) ): > app/controllers/dashboard_controller.rb:57:in `prefetch_data'' > /usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in `service'' > /usr/lib64/ruby/1.8/webrick/httpserver.rb:65:in `run'' > /usr/lib64/ruby/1.8/webrick/server.rb:173:in `start_thread'' > /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start'' > /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start_thread'' > /usr/lib64/ruby/1.8/webrick/server.rb:95:in `start'' > /usr/lib64/ruby/1.8/webrick/server.rb:92:in `each'' > /usr/lib64/ruby/1.8/webrick/server.rb:92:in `start'' > /usr/lib64/ruby/1.8/webrick/server.rb:23:in `start'' > /usr/lib64/ruby/1.8/webrick/server.rb:82:in `start'' > > Rendering /var/lib/foreman/public/500.html (500 Internal Server Error) > > I checked mysql and the ''enabled'' column is definitely absent. Is my > database messed up or did I miss something in my puppet or foreman > installation? > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@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-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Steve Neuharth
2010-Sep-06 14:22 UTC
[Puppet Users] Re: error in foreman, seem to be missing a column in DB
ah, yes, that did the trick. I got too excited once I got foreman running in passenger and just started clicking on stuff when I should have completed the installation instructions ;) thanks ohad, -s On Sep 6, 9:18 am, Ohad Levy <ohadl...@gmail.com> wrote:> You probably updated from source (git?) and forgot to migrate your database: > > seehttp://theforeman.org/projects/foreman/wiki/Upgrade_instructions#Step... > > <http://theforeman.org/projects/foreman/wiki/Upgrade_instructions#Step...> > Ohad > > On Mon, Sep 6, 2010 at 5:14 PM, Steve Neuharth <steve.neuha...@gmail.com>wrote: > > > I''ve been trying to get foreman to work and I''m getting the following > > error: > > Processing DashboardController#index (for 10.10.32.10 at 2010-09-06 > > 08:50:06) [GET] > > Parameters: {"action"=>"index", "controller"=>"dashboard"} > > > ActiveRecord::StatementInvalid (Mysql::Error: Unknown column ''enabled'' > > in ''where clause'': SELECT count(*) AS count_all FROM `hosts` WHERE > > (last_report < ''2010-09-06 13:15:06'' and enabled = 1) ): > > app/controllers/dashboard_controller.rb:57:in `prefetch_data'' > > /usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in `service'' > > /usr/lib64/ruby/1.8/webrick/httpserver.rb:65:in `run'' > > /usr/lib64/ruby/1.8/webrick/server.rb:173:in `start_thread'' > > /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start'' > > /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start_thread'' > > /usr/lib64/ruby/1.8/webrick/server.rb:95:in `start'' > > /usr/lib64/ruby/1.8/webrick/server.rb:92:in `each'' > > /usr/lib64/ruby/1.8/webrick/server.rb:92:in `start'' > > /usr/lib64/ruby/1.8/webrick/server.rb:23:in `start'' > > /usr/lib64/ruby/1.8/webrick/server.rb:82:in `start'' > > > Rendering /var/lib/foreman/public/500.html (500 Internal Server Error) > > > I checked mysql and the ''enabled'' column is definitely absent. Is my > > database messed up or did I miss something in my puppet or foreman > > installation? > > > -- > > You received this message because you are subscribed to the Google Groups > > "Puppet Users" group. > > To post to this group, send email to puppet-users@googlegroups.com. > > To unsubscribe from this group, send email to > > puppet-users+unsubscribe@googlegroups.com<puppet-users%2Bunsubscribe@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-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.