Plugins » Katello

After installing a new development instance with katello-deploy:

[michaelm@katello01 foreman]$ rake test
[...]
# Running tests:

EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

Finished tests in 6.492263s, 150.4868 tests/s, 0.0000 assertions/s.

  1) Error:
ApacheTest#test_authenticate!:
ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR:  permission denied: "RI_ConstraintTrigger_31669" is a system trigger
: ALTER TABLE "auth_sources" ENABLE TRIGGER ALL;ALTER TABLE "audits" ENABLE TRIGGER ALL;ALTER TABLE "bookmarks" ENABLE TRIGGER ALL;ALTER TABLE "cached_user_roles" ENABLE TRIGGER ALL;ALTER TABLE "cached_usergroup_members" ENABLE TRIGGER ALL;ALTER TABLE "config_group_classes" ENABLE TRIGGER ALL;ALTER TABLE "config_groups" ENABLE TRIGGER ALL;ALTER TABLE "config_templates" ENABLE TRIGGER ALL;ALTER TABLE "compute_resources" ENABLE TRIGGER ALL;ALTER TABLE "delayed_jobs" ENABLE TRIGGER ALL;ALTER TABLE "features" ENABLE TRIGGER ALL;ALTER TABLE "features_smart_proxies" ENABLE TRIGGER ALL;ALTER TABLE "external_usergroups" ENABLE TRIGGER ALL;ALTER TABLE "fact_names" ENABLE TRIGGER ALL;ALTER TABLE "filterings" ENABLE TRIGGER ALL;ALTER TABLE "foreman_tasks_locks" ENABLE TRIGGER ALL;ALTER TABLE "foreman_tasks_tasks" ENABLE TRIGGER ALL;ALTER TABLE "host_config_groups" ENABLE TRIGGER ALL;ALTER TABLE "hostgroups" ENABLE TRIGGER ALL;ALTER TABLE "host_classes" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_components" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_filters" ENABLE TRIGGER ALL;ALTER TABLE "katello_capsule_lifecycle_environments" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_environments" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_package_group_filter_rules" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_puppet_environments" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_puppet_modules" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_repositories" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_histories" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_package_filter_rules" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_filters_repositories" ENABLE TRIGGER ALL;ALTER TABLE "katello_custom_info" ENABLE TRIGGER ALL;ALTER TABLE "katello_distributors" ENABLE TRIGGER ALL;ALTER TABLE "katello_help_tips" ENABLE TRIGGER ALL;ALTER TABLE "katello_gpg_keys" ENABLE TRIGGER ALL;ALTER TABLE "katello_environment_priors" ENABLE TRIGGER ALL;ALTER TABLE "katello_host_collections" ENABLE TRIGGER ALL;ALTER TABLE "katello_permissions" ENABLE TRIGGER ALL;ALTER TABLE "katello_notices" ENABLE TRIGGER ALL;ALTER TABLE "katello_ldap_group_roles" ENABLE TRIGGER ALL;ALTER TABLE "katello_key_host_collections" ENABLE TRIGGER ALL;ALTER TABLE "katello_marketing_engineering_products" ENABLE TRIGGER ALL;ALTER TABLE "katello_pools" ENABLE TRIGGER ALL;ALTER TABLE "katello_providers" ENABLE TRIGGER ALL;ALTER TABLE "katello_resource_types" ENABLE TRIGGER ALL;ALTER TABLE "katello_roles_users" ENABLE TRIGGER ALL;ALTER TABLE "katello_systems" ENABLE TRIGGER ALL;ALTER TABLE "katello_search_histories" ENABLE TRIGGER ALL;ALTER TABLE "katello_search_favorites" ENABLE TRIGGER ALL;ALTER TABLE "katello_user_notices" ENABLE TRIGGER ALL;ALTER TABLE "locations_organizations" ENABLE TRIGGER ALL;ALTER TABLE "logs" ENABLE TRIGGER ALL;ALTER TABLE "lookup_values" ENABLE TRIGGER ALL;ALTER TABLE "media" ENABLE TRIGGER ALL;ALTER TABLE "messages" ENABLE TRIGGER ALL;ALTER TABLE "katello_verbs" ENABLE TRIGGER ALL;ALTER TABLE "models" ENABLE TRIGGER ALL;ALTER TABLE "key_pairs" ENABLE TRIGGER ALL;ALTER TABLE "os_default_templates" ENABLE TRIGGER ALL;ALTER TABLE "parameters" ENABLE TRIGGER ALL;ALTER TABLE "notices" ENABLE TRIGGER ALL;ALTER TABLE "puppetclasses" ENABLE TRIGGER ALL;ALTER TABLE "nics" ENABLE TRIGGER ALL;ALTER TABLE "permissions" ENABLE TRIGGER ALL;ALTER TABLE "ptables" ENABLE TRIGGER ALL;ALTER TABLE "roles" ENABLE TRIGGER ALL;ALTER TABLE "sessions" ENABLE TRIGGER ALL;ALTER TABLE "settings" ENABLE TRIGGER ALL;ALTER TABLE "realms" ENABLE TRIGGER ALL;ALTER TABLE "sources" ENABLE TRIGGER ALL;ALTER TABLE "reports" ENABLE TRIGGER ALL;ALTER TABLE "subnet_domains" ENABLE TRIGGER ALL;ALTER TABLE "taxonomies" ENABLE TRIGGER ALL;ALTER TABLE "template_combinations" ENABLE TRIGGER ALL;ALTER TABLE "tokens" ENABLE TRIGGER ALL;ALTER TABLE "trends" ENABLE TRIGGER ALL;ALTER TABLE "user_compute_resources" ENABLE TRIGGER ALL;ALTER TABLE "user_domains" ENABLE TRIGGER ALL;ALTER TABLE "user_facts" ENABLE TRIGGER ALL;ALTER TABLE "user_hostgroups" ENABLE TRIGGER ALL;ALTER TABLE "filters" ENABLE TRIGGER ALL;ALTER TABLE "architectures_operatingsystems" ENABLE TRIGGER ALL;ALTER TABLE "images" ENABLE TRIGGER ALL;ALTER TABLE "environment_classes" ENABLE TRIGGER ALL;ALTER TABLE "compute_attributes" ENABLE TRIGGER ALL;ALTER TABLE "environments" ENABLE TRIGGER ALL;ALTER TABLE "operatingsystems" ENABLE TRIGGER ALL;ALTER TABLE "config_templates_operatingsystems" ENABLE TRIGGER ALL;ALTER TABLE "architectures" ENABLE TRIGGER ALL;ALTER TABLE "user_roles" ENABLE TRIGGER ALL;ALTER TABLE "fact_values" ENABLE TRIGGER ALL;ALTER TABLE "hosts" ENABLE TRIGGER ALL;ALTER TABLE "hostgroup_classes" ENABLE TRIGGER ALL;ALTER TABLE "katello_jobs" ENABLE TRIGGER ALL;ALTER TABLE "usergroups" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_views" ENABLE TRIGGER ALL;ALTER TABLE "compute_profiles" ENABLE TRIGGER ALL;ALTER TABLE "smart_proxies" ENABLE TRIGGER ALL;ALTER TABLE "katello_activation_keys" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_erratum_filter_rules" ENABLE TRIGGER ALL;ALTER TABLE "katello_roles" ENABLE TRIGGER ALL;ALTER TABLE "katello_permission_tags" ENABLE TRIGGER ALL;ALTER TABLE "domains" ENABLE TRIGGER ALL;ALTER TABLE "template_kinds" ENABLE TRIGGER ALL;ALTER TABLE "katello_environments" ENABLE TRIGGER ALL;ALTER TABLE "katello_job_tasks" ENABLE TRIGGER ALL;ALTER TABLE "katello_content_view_versions" ENABLE TRIGGER ALL;ALTER TABLE "lookup_keys" ENABLE TRIGGER ALL;ALTER TABLE "subnets" ENABLE TRIGGER ALL;ALTER TABLE "user_notices" ENABLE TRIGGER ALL;ALTER TABLE "usergroup_members" ENABLE TRIGGER ALL;ALTER TABLE "katello_permissions_verbs" ENABLE TRIGGER ALL;ALTER TABLE "katello_products" ENABLE TRIGGER ALL;ALTER TABLE "katello_repositories" ENABLE TRIGGER ALL;ALTER TABLE "katello_sync_plans" ENABLE TRIGGER ALL;ALTER TABLE "katello_system_activation_keys" ENABLE TRIGGER ALL;ALTER TABLE "katello_system_host_collections" ENABLE TRIGGER ALL;ALTER TABLE "katello_task_statuses" ENABLE TRIGGER ALL;ALTER TABLE "media_operatingsystems" ENABLE TRIGGER ALL;ALTER TABLE "operatingsystems_ptables" ENABLE TRIGGER ALL;ALTER TABLE "operatingsystems_puppetclasses" ENABLE TRIGGER ALL;ALTER TABLE "taxable_taxonomies" ENABLE TRIGGER ALL;ALTER TABLE "trend_counters" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/connection_adapters/postgresql_adapter.rb:650:in `async_exec'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/connection_adapters/postgresql_adapter.rb:650:in `block in execute'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.18/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/connection_adapters/postgresql_adapter.rb:649:in `execute'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/connection_adapters/postgresql_adapter.rb:526:in `ensure in disable_referential_integrity'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/connection_adapters/postgresql_adapter.rb:526:in `disable_referential_integrity'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/fixtures.rb:476:in `create_fixtures'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/fixtures.rb:895:in `load_fixtures'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activerecord-3.2.18/lib/active_record/fixtures.rb:849:in `setup_fixtures'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.18/lib/active_support/callbacks.rb:407:in `_run__3947419965270393234__setup__376977062704921304__callbacks'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.18/lib/active_support/callbacks.rb:405:in `__run_callback'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.18/lib/active_support/callbacks.rb:385:in `_run_setup_callbacks'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.18/lib/active_support/callbacks.rb:81:in `run_callbacks'
    /home/michaelm/.rvm/gems/ruby-1.9.3-p448/gems/activesupport-3.2.18/lib/active_support/testing/setup_and_teardown.rb:35:in `run'
[...]

After giving the katello DB user superuser priviledges, tests work. This should be set by the installer, or worked around in some other way.