OpenProject

Debian packages

commands

Executing rake command where openproject was installed from .deb package

openproject run console
openproject run ruby -v
openproject run env
openproject run rake backup:database:create
 
openproject run rake tmp:cache:clear
 
openproject config       # show current config
openproject reconfigure  # after change config
openproject configure    # after upgrade to newer version
 
openproject logs --tail
 
openproject run rake --tasks
openproject run rake db:migrate:status
openproject run rake assets:precompile

Activate Background Jobs

Start background worker once.

openproject run rake jobs:workoff

Add it to cron

su - openproject -c "bash -l"
[openproject@all] crontab -e
*/1 *  * * * /usr/bin/openproject run rake jobs:workoff
openproject run bin/delayed_job start

Backup

https://www.openproject.org/open-source/upgrade-backup/packaged-installation-backup-guide/

openproject run backup
| op_delete_old_backups.sh
#!/bin/bash -eu
DIR="/var/db/openproject/backup"
find $DIR -mtime +4 -exec rm {} \;

CSS

Edit files: /app/assets/stylesheets/_jstoolbar.sass

   textarea, iframe
     margin: 0
+    font-family: monospace

And regenerate static assests:

openproject run rake assets:clean
openproject run rake assets:clean:all
openproject run rake assets:precompile

Issues

clear memcached

telnet localhost 11211
flush_all
quit

undefined local variable or method `timeline_labels'

 Your query is erroneous and could not be processed.

    An internal error has occured.
  Original error: #<NameError: undefined local variable or method `timeline_labels' for #<Query:0x00007ff7b3bd5a80>
Did you mean?  timeline_visible>

  Stacktrace:

    /opt/openproject/vendor/bundle/ruby/2.4.0/gems/activemodel-5.0.4/lib/active_model/attribute_methods.rb:433:in `method_missing'
    /opt/openproject/app/models/query/timelines.rb:41:in `valid_timeline_labels'
    /opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.4/lib/active_support/callbacks.rb:382:in `block in make_lambda'
    /opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.4/lib/active_support/callbacks.rb:169:in `block (2 levels) in halting'
    /opt/openproject/vendor/bundle/ruby/2.4.0/gems/activesupport-5.0.4/lib/active_support/callbacks.rb:547:in `block (2 levels) in default_terminator'

Some migrations are missing (error during upgrade???):

openproject run rake db:migrate:status
...
   up     20170602073043  Save zoom level in query
   up     20170614131555  Add favicon touch icon to custom style
  down    20170703075208  Add attribute help texts
  down    20170705134348  Remove attribute visibility
  down    20170818063404  Add timeline labels to query

Try to run migrations on current db:

openproject run rake db:migrate
== 20170703075208 AddAttributeHelpTexts: migrating ============================
-- create_table(:attribute_help_texts)
   -> 0.0183s
== 20170703075208 AddAttributeHelpTexts: migrated (0.0185s) ===================

== 20170705134348 RemoveAttributeVisibility: migrating ========================
-- remove_column(:types, :attribute_visibility, :text)
   -> 0.0310s
== 20170705134348 RemoveAttributeVisibility: migrated (0.0312s) ===============

== 20170818063404 AddTimelineLabelsToQuery: migrating =========================
-- add_column(:queries, :timeline_labels, :text)
   -> 0.0372s
== 20170818063404 AddTimelineLabelsToQuery: migrated (0.0374s) ================