Plugins » Foreman Remote Execution

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1314330
Description of problem: I was trying to install/configure remote execution feature. I installed following packages:

tfm-rubygem-foreman_remote_execution-0.3.0.0-1.el7sat.noarch
rubygem-smart_proxy_remote_execution_ssh-0.0.13-1.el7sat.noarch

Packages were installed and feature got enabled on proxy and can see ssh as feature under proxy. I configured the ssh-keys as well. However when I invoke a job for selected host, it got failed with below error:

from production.log

2016-03-03 07:08:14 [app] [I] Started POST "/job_invocations" for 10.65.193.200 at 2016-03-03 07:08:14 -0500
2016-03-03 07:08:14 [app] [I] Processing by JobInvocationsController#create as HTML
2016-03-03 07:08:14 [app] [I]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"PMct6/YHQbLXPT5vwXxojca17Bq20Fbu42zcmxNX6rI=", "job_invocation"=>{"job_category"=>"Commands", "providers"=>{"SSH"=>{"job_template_id"=>"76", "job_templates"=>{"76"=>{"input_values"=>"[FILTERED]", "effective_user"=>""}}}}, "description"=>"Run date", "description_override"=>"Run %{command}", "description_format"=>"Run %{command}", "concurrency_level"=>"", "time_span"=>""}, "targeting"=>{"bookmark_id"=>"", "search_query"=>"name = shost.idmqe.lab.eng.bos.redhat.com", "targeting_type"=>"static_query"}, "triggering"=>{"mode"=>"immediate", "start_at_raw"=>"2016-03-03 07:08", "start_before_raw"=>"", "input_type"=>"daily", "cronline"=>"", "days"=>"", "days_of_week"=>{"1"=>"0", "2"=>"0", "3"=>"0", "4"=>"0", "5"=>"0", "6"=>"0", "7"=>"0"}, "time"=>{"time(1i)"=>"2016", "time(2i)"=>"3", "time(3i)"=>"3", "time(4i)"=>"17", "time(5i)"=>"38"}, "max_iteration"=>"", "end_time_limited"=>"false", "end_time"=>{"end_time(1i)"=>"2016", "end_time(2i)"=>"3", "end_time(3i)"=>"3", "end_time(4i)"=>"17", "end_time(5i)"=>"38"}}, "commit"=>"Submit"}
2016-03-03 07:08:14 [app] [I] Redirected to https://cloud-qe-7.idmqe.lab.eng.bos.redhat.com/job_invocations/7
2016-03-03 07:08:14 [app] [I] Completed 302 Found in 213ms (ActiveRecord: 64.2ms)
2016-03-03 07:08:15 [app] [W] Could not fetch task counts from cloud-qe-7.idmqe.lab.eng.bos.redhat.com, skipped.
| RestClient::InternalServerError: 500 Internal Server Error
| /opt/theforeman/tfm/root/usr/share/gems/gems/rest-client-1.6.7/lib/restclient/abstract_response.rb:48:in `return!'
| /opt/theforeman/tfm/root/usr/share/gems/gems/rest-client-1.6.7/lib/restclient/request.rb:230:in `process_result'
| /opt/theforeman/tfm/root/usr/share/gems/gems/rbovirt-0.0.35/lib/restclient_ext/request.rb:50:in `block in transmit'
| /opt/rh/rh-ruby22/root/usr/share/ruby/net/http.rb:853:in `start'
| /opt/theforeman/tfm/root/usr/share/gems/gems/rbovirt-0.0.35/lib/restclient_ext/request.rb:44:in `transmit'
| /opt/theforeman/tfm/root/usr/share/gems/gems/rest-client-1.6.7/lib/restclient/request.rb:64:in `execute'
| /opt/theforeman/tfm/root/usr/share/gems/gems/rest-client-1.6.7/lib/restclient/request.rb:33:in `execute'
| /opt/theforeman/tfm/root/usr/share/gems/gems/rest-client-1.6.7/lib/restclient/resource.rb:51:in `get'
| /usr/share/foreman/lib/proxy_api/resource.rb:67:in `get'
| /opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.7.14.0/app/lib/proxy_api/foreman_dynflow/dynflow_proxy.rb:35:in `tasks_count'
| /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_remote_execution-0.3.0.0/app/services/proxy_load_balancer.rb:22:in `block in get_counts'

from proxy.log: ===============

E, [2016-03-03T07:06:19.638102 #27820] ERROR -- : SQLite3::CantOpenException: unable to open database file (Sequel::DatabaseConnectionError)
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/adapters/sqlite.rb:107:in `initialize'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/adapters/sqlite.rb:107:in `new'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/adapters/sqlite.rb:107:in `connect'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/connection_pool.rb:101:in `make_new'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:160:in `make_new'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:137:in `available'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:127:in `block in acquire'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:201:in `block in sync'
/usr/share/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:201:in `synchronize'

Version-Release number of selected component (if applicable):
Sat 6.2 snap2

How reproducible:
always

Steps to Reproduce:
1. try to run job on selected content-host from host details page
2.
3.

Actual results:

Expected results:
job should succeed

Additional info: