The Puppet Labs Issue Tracker has Moved: https://tickets.puppetlabs.com

Bug #14524

[can not clean host report in mysql] puppetstoredconfigclean.rb

Added by joy huang over 2 years ago. Updated about 2 years ago.

Status:AcceptedStart date:05/15/2012
Priority:HighDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Keywords: Affected URL:
Branch: Affected Dashboard version:

Description

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 FROMhosts` (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

History

#1 Updated by Kelsey Hightower about 2 years ago

  • Project changed from Puppet to Puppet Dashboard
  • Status changed from Unreviewed to Accepted

Also available in: Atom PDF