====== OpenProject ======

<code bash>
systemctl stop openproject
</code>

====== Debian packages ======

[[https://packager.io/gh/opf/openproject-ce/refs/stable/8|stable 8 branch]]

Debian installation guide: [[https://www.openproject.org/open-source/download/packaged-installation-guide/]]

====== commands ======

Executing rake command where openproject was installed from .deb package

<code bash>
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

</code>

====== Activate Background Jobs ======
Start background worker once.
<code bash>
openproject run rake jobs:workoff
</code>

Add it to cron

<code bash>
su - openproject -c "bash -l"
[openproject@all] crontab -e
</code>

<code>
*/1 *  * * * /usr/bin/openproject run rake jobs:workoff
</code>


<code bash>
openproject run bin/delayed_job start
</code>

====== Backup ======
[[https://www.openproject.org/open-source/upgrade-backup/packaged-installation-backup-guide/]]
<code bash>
openproject run backup
</code>

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

====== CSS ======
Edit files: ''/app/assets/stylesheets/_jstoolbar.sass''
<code css>
   textarea, iframe
     margin: 0
+    font-family: monospace

</code>

And regenerate static assests:
<code bash>
openproject run rake assets:clean
openproject run rake assets:clean:all
openproject run rake assets:precompile
</code>

====== Issues ======

===== clear memcached ====

<code bash>
telnet localhost 11211
flush_all
quit
</code>

===== undefined local variable or method `timeline_labels' =====

<code>
 Your query is erroneous and could not be processed.

    An internal error has occured.
</code>
<code>
  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'
</code>

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

<code bash>
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
</code>

Try to run migrations on current db:
<code bash>
openproject run rake db:migrate
</code>
<code>
== 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) ================
</code>