Content

Support Installation & Updates

crontab

Added by Ronald Wiplinger over 9 years ago

According to the manual installation I should setup a cron:

/1 * * * cd /home/openproject/openproject; /home/openproject/.rvm/gems/ruby-2.1.5/wrappers/rake jobs:workoff

However, the directory /home/openproject/.rvm does not exist.

Replies (11)

RE: crontab - Added by [ jakimfett ] over 9 years ago

Ron,
I’ll need to know a bit more about your environment to help you.

Did you manually install OpenProject? If so, what user did you install it under?
What’s the result of the command “which rake”?
What’s the result of the command “locate rake | grep rvm”?

My openproject user’s crontab has the following line:

*/1 * * * * export RAILS_ENV=production; cd /home/openproject; bundle exec rake jobs:workoff

(I installed OpenProject in the /home/openproject directory, and the openproject user’s .profile adds the rake path to the PATH variable.)

RE: crontab - Added by Ronald Wiplinger over 9 years ago

I installed manually with openproject as user

which rake
/home/openproject/.rbenv/shims/rake

locate rake | grep rvm

locate rake
gives me a lot of lines, interestingly some started as:

/home/openproject/openproject/vendor/bundle/ruby/2.2.0/gems/
…
/opt/openproject-ce/vendor/bundle/ruby/2.1.0/gems/

I failed to install automatically and installed therefore then manual. Should I delete the entire directory /opt/openproject-ce

EDITED:
rake —version
rake, version 10.1.0

RE: crontab - Added by Kevin Woodbrey over 9 years ago

I have the exactly the same issue. Failed automatic package install and then installed manually. Everything works except no .rvm directory and no e-mail processing.

RE: crontab - Added by [ jakimfett ] over 9 years ago

@Ron - In an ideal world, I’d recommend installing OpenProject manually on a fresh system that doesn’t have a partial/failed install on it. That said, it looks like the manual install instructions are…slightly off. I’d recommend trying the following command from your OpenProject root directory (which I think is /home/openproject/openproject for you):

bundle exec rake jobs:workoff

If that runs (and sends emails properly, you should be able to add it to your crontab without too much of an issue.

@Kevin - same advice for you as I gave Ron…try the command manually, if it works, you’re golden.

RE: crontab - Added by Ronald Wiplinger over 9 years ago

~/openproject$ bundle exec rake jobs:workoff
require ‘rails/all’… 0.500s
Bundler.require… 2.080s
Application.initialize!… [deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message.
3.520s
[Worker(host:ronald-desktop pid:27344)] Starting job worker
rake aborted!

ActiveRecord::StatementInvalid: Mysql2::Error: Table ‘openproject_development.delayed_jobs’ doesn’t exist: UPDATE `delayed_jobs` SET locked_by = null, locked_at = null WHERE (locked_by = ‘host:ronald-desktop pid:27344’)

Mysql2::Error: Table ‘openproject_development.delayed_jobs’ doesn’t exist

ActiveRecord::StatementInvalid: Mysql2::Error: Table ‘openproject_development.delayed_jobs’ doesn’t exist: SHOW FULL FIELDS FROM `delayed_jobs`

/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in `execute’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:259:in `execute_and_free’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:426:in `columns’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `yield’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `columns’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:238:in `columns_hash’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/locking/optimistic.rb:131:in `locking_enabled?’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation.rb:170:in `exec_queries’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation.rb:160:in `block in to_a’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/explain.rb:34:in `logging_query_plan’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation.rb:159:in `to_a’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation/finder_methods.rb:159:in `all’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job_active_record-0.3.3/lib/delayed/backend/active_record.rb:58:in `block in find_available’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/benchmarkable.rb:50:in `silence’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job_active_record-0.3.3/lib/delayed/backend/active_record.rb:57:in `find_available’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/backend/base.rb:45:in `reserve’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:258:in `reserve_and_run_one_job’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:187:in `block in work_off’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:186:in `times’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:186:in `work_off’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:151:in `block (4 levels) in start’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:150:in `block (3 levels) in start’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:60:in `call’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:60:in `block in initialize’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:65:in `call’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:65:in `execute’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:38:in `run_callbacks’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:149:in `block (2 levels) in start’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:148:in `loop’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:148:in `block in start’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/plugins/clear_locks.rb:7:in `call’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/plugins/clear_locks.rb:7:in `block (2 levels) in class:ClearLocks’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:78:in `call’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:78:in `block (2 levels) in add’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:60:in `call’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:60:in `block in initialize’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:78:in `call’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:78:in `block in add’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:65:in `call’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:65:in `execute’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/lifecycle.rb:38:in `run_callbacks’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/worker.rb:147:in `start’
/home/openproject/openproject/vendor/bundle/ruby/2.1.0/gems/delayed_job-3.0.5/lib/delayed/tasks.rb:14:in `block (2 levels) in <top (required)>’

Mysql2::Error: Table ‘openproject_development.delayed_jobs’ doesn’t exist

RE: crontab - Added by [ jakimfett ] over 9 years ago

This bit looks relevant to me:

Table 'openproject_development.delayed_jobs' doesn't exist

I’d suggest re-running the database setup commands from your ~/openproject folder:

bundle exec rake db:create:all
bundle exec rake db:migrate
bundle exec rake db:seed
bundle exec rake assets:precompile

This will go through and create any necessary tables and preseed them with necessary data.
Once you run the commands, try running the “bundle exec rake jobs:workoff” command again from your project folder.

RE: crontab - Added by Ronald Wiplinger over 9 years ago

before I try this, does it clears my current data?

RE: crontab - Added by [ jakimfett ] over 9 years ago

Nope, its the commands you run after making changes to the core or install new plugins. Its the same commands from the bottom portion of the manual install instructions.

RE: crontab - Added by Ronald Wiplinger over 9 years ago

I ran the commands and now “bundle exec rake jobs:workoff” runs without an error.

However, this has changed in the window: Special characters like in Overview, Activity … have changed to Chinese characters.

Besides (not sure if it has changed) Chinese characters are not displayed, e.g. this one:
“新北市淡水區大信街”

While no error in crontab either, I do not get any emails when a work page is updated.

RE: crontab - Added by [ jakimfett ] over 9 years ago

I’ve no clue about the issue with special characters changing to Chinese characters.

For the crontab issue, make sure your profile settings are correct (eg, double check your email address, make sure you’ve set the option to receive updates), and then try doing multiple things that would trigger an email update. Run the “bundle exec rake jobs:workoff” command, and if you’re still not getting emails, check your log file for the time period immediately after you run the command.

RE: crontab - Added by Ronald Wiplinger over 9 years ago

I thought it is working, but it isn’t! ;-)

If I issue the command as openproject: “bundle exec rake jobs:workoff” - It runs without an error.

However, there is only send an email to openproject:

From openprojectexample.com Wed Nov 11 22:46:01 2015
Return-Path: <openproject@example.com>
X-Original-To: openproject
Delivered-To: openproject@example.com
Received: by ronald-desktop (Postfix, from userid 124)
id 6D6B01E04F7; Wed, 11 Nov 2015 22:46:01 +0800 (CST)
From: root@example.com (Cron Daemon)
To: openproject@example.com
Subject: Cron <openproject@ronald-desktop> cd /home/openproject/openproject; /home/openproject/.rvm/gems/ruby-2.1.5/wrappers/rake jobs:workoff
Content-Type: text/plain; charset=ANSI_X3.4-1968
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/home/openproject>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=openproject>
Message-Id: <20151111144601.6D6B01E04F7@ronald-desktop>
Date: Wed, 11 Nov 2015 22:46:01 +0800 (CST)

/bin/sh: 1: /home/openproject/.rvm/gems/ruby-2.1.5/wrappers/rake: not found

Indeed the directory /home/openproject/.rvm/ does not exist!!!

The last paragraph in the log file is:

ActionController::RoutingError (No route matches [GET] "/assets/lato/Lato-Italic.ttf"): vendor/bundle/ruby/2.1.0/gems/actionpack-3.2.22/lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' vendor/bundle/ruby/2.1.0/gems/actionpack-3.2.22/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' vendor/bundle/ruby/2.1.0/gems/railties-3.2.22/lib/rails/rack/logger.rb:32:in `call_app' vendor/bundle/ruby/2.1.0/gems/railties-3.2.22/lib/rails/rack/logger.rb:16:in `block in call' vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/tagged_logging.rb:22:in `tagged' vendor/bundle/ruby/2.1.0/gems/railties-3.2.22/lib/rails/rack/logger.rb:16:in `call' vendor/bundle/ruby/2.1.0/gems/request_store-1.1.0/lib/request_store/middleware.rb:8:in `call' vendor/bundle/ruby/2.1.0/gems/actionpack-3.2.22/lib/action_dispatch/middleware/request_id.rb:22:in `call' vendor/bundle/ruby/2.1.0/gems/rack-1.4.6/lib/rack/methodoverride.rb:21:in `call' vendor/bundle/ruby/2.1.0/gems/rack-1.4.6/lib/rack/runtime.rb:17:in `call' vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/cache/strategy/local_cache.rb:72:in `call' vendor/bundle/ruby/2.1.0/gems/rack-1.4.6/lib/rack/lock.rb:15:in `call' vendor/bundle/ruby/2.1.0/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward' vendor/bundle/ruby/2.1.0/gems/rack-cache-1.2/lib/rack/cache/context.rb:245:in `fetch' vendor/bundle/ruby/2.1.0/gems/rack-cache-1.2/lib/rack/cache/context.rb:185:in `lookup' vendor/bundle/ruby/2.1.0/gems/rack-cache-1.2/lib/rack/cache/context.rb:66:in `call!' vendor/bundle/ruby/2.1.0/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call' vendor/bundle/ruby/2.1.0/gems/airbrake-4.1.0/lib/airbrake/user_informer.rb:16:in `_call' vendor/bundle/ruby/2.1.0/gems/airbrake-4.1.0/lib/airbrake/user_informer.rb:12:in `call' vendor/bundle/ruby/2.1.0/gems/railties-3.2.22/lib/rails/engine.rb:484:in `call' vendor/bundle/ruby/2.1.0/gems/railties-3.2.22/lib/rails/application.rb:231:in `call' vendor/bundle/ruby/2.1.0/gems/railties-3.2.22/lib/rails/railtie/configurable.rb:30:in `method_missing' vendor/bundle/ruby/2.1.0/bundler/gems/rack-protection-5a7d1bd2f05c/lib/rack/protection/frame_options.rb:31:in `call' vendor/bundle/ruby/2.1.0/bundler/gems/rack-protection-5a7d1bd2f05c/lib/rack/protection/json_csrf.rb:18:in `call' vendor/bundle/ruby/2.1.0/gems/rack-1.4.6/lib/rack/builder.rb:134:in `call' vendor/bundle/ruby/2.1.0/gems/rack-1.4.6/lib/rack/urlmap.rb:64:in `block in call' vendor/bundle/ruby/2.1.0/gems/rack-1.4.6/lib/rack/urlmap.rb:49:in `each' vendor/bundle/ruby/2.1.0/gems/rack-1.4.6/lib/rack/urlmap.rb:49:in `call' passenger (5.0.21) src/ruby_supportlib/phusion_passenger/rack/thread_handler_extension.rb:97:in `process_request' passenger (5.0.21) src/ruby_supportlib/phusion_passenger/request_handler/thread_handler.rb:152:in `accept_and_process_next_request' passenger (5.0.21) src/ruby_supportlib/phusion_passenger/request_handler/thread_handler.rb:113:in `main_loop' passenger (5.0.21) src/ruby_supportlib/phusion_passenger/request_handler.rb:416:in `block (3 levels) in start_threads' passenger (5.0.21) src/ruby_supportlib/phusion_passenger/utils.rb:113:in `block in create_thread_and_abort_on_exception'

Top Menu

Side Menu

Content

crontab

Replies (11)

RE: crontab - Added by [ jakimfett ] over 9 years ago

RE: crontab - Added by Ronald Wiplinger over 9 years ago

RE: crontab - Added by Kevin Woodbrey over 9 years ago

RE: crontab - Added by [ jakimfett ] over 9 years ago

RE: crontab - Added by Ronald Wiplinger over 9 years ago

RE: crontab - Added by [ jakimfett ] over 9 years ago

RE: crontab - Added by Ronald Wiplinger over 9 years ago

RE: crontab - Added by [ jakimfett ] over 9 years ago

RE: crontab - Added by Ronald Wiplinger over 9 years ago

RE: crontab - Added by [ jakimfett ] over 9 years ago

RE: crontab - Added by Ronald Wiplinger over 9 years ago