Dashing / shopify仪表板Rubygem错误

我正在尝试使用Dashing构build一个小型仪表板。 这个仪表板应该从SQL数据库中获取数据。 这是我的代码

require 'rubygems' require 'mysql2' SCHEDULER.every '15m', :first_in => 0 do |job| db = Mysql2::Client.new(:host => "localhost",:username => "root", :password => "password", :port => 3306, :database => "cbbreporter" ) sql1="select count(*) from cbbjobs" sql2="select count(*) from cbbjobs WHERE JobResult=\"Failed\"" sql3="select count(*) from cbbjobs WHERE JobResult=\"Success\"" totaljobsrun = db.query(sql1) failedjobs = db.query(sql2) successjobs=db.query(sql3) totaljobsrun.each do | line | puts line["count(*)"] end failedjobs.each do | line | puts line["count(*)"] end successjobs.each do | line | puts line["count(*)"] end db.close end 

它适用于Ruby。 但是,当我试图开始冲刺,它不能加载gem

  /var/lib/gems/1.9.1/gems/backports-3.6.7/lib/backports/std_lib.rb:9:in ` require': cannot load such file -- mysql2 (LoadError) from /var/lib/gems/1.9.1/gems/backports-3.6.7/lib/backports/std_lib.rb:9:in `require_with_backports' from /root/backupreporter/jobs/cbbreporter.rb:2:in `<top (required)>' from /var/lib/gems/1.9.1/gems/backports-3.6.7/lib/backports/std_lib.rb:9:in `require' from /var/lib/gems/1.9.1/gems/backports-3.6.7/lib/backports/std_lib.rb:9:in `require_with_backports' from /var/lib/gems/1.9.1/gems/dashing-1.3.4/lib/dashing/app.rb:157:in `block in require_glob' from /var/lib/gems/1.9.1/gems/dashing-1.3.4/lib/dashing/app.rb:156:in `each' from /var/lib/gems/1.9.1/gems/dashing-1.3.4/lib/dashing/app.rb:156:in `require_glob' from /var/lib/gems/1.9.1/gems/dashing-1.3.4/lib/dashing/app.rb:167:in `<top (required)>' from /var/lib/gems/1.9.1/gems/dashing-1.3.4/lib/dashing.rb:3:in `require' from /var/lib/gems/1.9.1/gems/dashing-1.3.4/lib/dashing.rb:3:in `<top (required)>' 

我是初学者,请帮助我。

问候,

对不起,我解决了这个问题,我没有足够的search或足够的阅读。

我不得不更新gem文件并运行软件包更新。