Issue #14524 has been reported by joy huang. ---------------------------------------- Bug #14524: [can not clean host report in mysql] puppetstoredconfigclean.rb https://projects.puppetlabs.com/issues/14524
Author: joy huang Status: Unreviewed Priority: High Assignee: Category: Target version: Affected Puppet version: Keywords: Branch: Hi I am a puppet lover, using puppet + +passenger+dashboard application , when i use puppetstoredconfigclean.rb tool to clean client report ,it display some error: nee your help [root@centosVM puppet-2.7.9]# ext/puppetstoredconfigclean.rb client2.joy.com autosigntruedbpasswordrootpwdreportsstore, httpdbsocket/var/lib/mysql/mysql.sockstoreconfigstruedbadaptermysqldbserverlocalhostdbnamedashboard_productionssl_client_headerSSL_CLIENT_S_DNreporturlhttp://centosvm.joy.com:3000/reports/uploadssl_client_verify_headerSSL_CLIENT_VERIFY /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:233:in `query': Mysql::Error: Table 'dashboard_production.hosts' doesn't exist: SHOW FULL FIELDS FROM `hosts` (ActiveRecord::StatementInvalid) from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:233:in `execute' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log' from /usr/lib/ruby/gems/1.8/gems/activesupport-3.2.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:233:in `execute' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/mysql_adapter.rb:314:in `execute_and_free' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:414:in `columns' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/schema_cache.rb:12:in `initialize' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/model_schema.rb:228:in `call' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/model_schema.rb:228:in `default' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/model_schema.rb:228:in `[]' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/model_schema.rb:228:in `columns' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/model_schema.rb:248:in `column_names' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/model_schema.rb:261:in `column_methods_hash' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/dynamic_matchers.rb:69:in `all_attributes_exists?' from /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/dynamic_matchers.rb:27:in `method_missing' from ext/puppetstoredconfigclean.rb:86 from ext/puppetstoredconfigclean.rb:85:in `each' from ext/puppetstoredconfigclean.rb:85 [root@centosVM puppet-2.7.9]# cat /etc/puppet/puppet.conf [main] # The Puppet log directory. # The default value is '$vardir/log'. logdir = /var/log/puppet [master] reports = store, http reporturl = http://centosvm.joy.com:3000/reports/upload autosign = true storeconfigs = true dbadapter = mysql dbname = dashboard_production #dbuesr = dashboard #dbpassword = dashboard_pwd dbuesr = root dbpassword = rootpwd dbserver = localhost dbsocket = /var/lib/mysql/mysql.sock ssl_client_header = SSL_CLIENT_S_DN ssl_client_verify_header = SSL_CLIENT_VERIFY [agent] # The file in which puppetd stores a list of the classes # associated with the retrieved configuratiion. Can be loaded in # the separate ``puppet`` executable using the ``--loadclasses`` # option. # The default value is '$confdir/classes.txt'. classfile = $vardir/classes.txt localconfig = $vardir/localconfig server = centosvm.joy.com reportserver = centosvm.joy.com report = true ++++package release: puppet-dashboard-1.2.7 facter 1.6.8 puppet opensource 2.7.9 centoos6.2_X64 -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
