Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. [solved]Can't see my workpackages any more /no drop down box(after update?)

[solved]Can't see my workpackages any more /no drop down box(after update?)

Added by Bernd Müller over 9 years ago

Today I tried to bundle let’s encrypt ssl certificates and OP.
It worked. So I had a working + valid https.
But during that process I accidentally “configure”d OP instead of “reconfigur(e)”ing it.
So I guess that I updated OP to the latest version (though I still can see that 5.0.7 is displayed…maybe I have 5.10, maybe not)
Anyways! The main problem is now, that I cannot not see my work packages any more
When I click on work packages I can see that URLs are generated in that form:

<host>/projects/<name_of_project>/work_packages?query_props={%22f%22%3A[{%22v%22%3A2%2C%22n%22%3A%22type_id%22%2C%22o%22%3A%22%3D%22}]%2C%22t%22%3A%22updated_at%3Adesc%22}

The logs do not give me a clue:

, [2016-01-26T15:10:41.564677 #10762]  WARN -- : hook registered
W, [2016-01-26T15:53:44.935472 #14797]  WARN -- : hook registered
W, [2016-01-26T16:42:47.193565 #20397]  WARN -- : hook registered
W, [2016-01-26T17:11:14.226456 #22977]  WARN -- : hook registered
W, [2016-01-26T17:21:35.329868 #24253]  WARN -- : hook registered

But in my browser I just see a while sheet.

Now what can I do? Any hint is appreciated


Replies (8)

RE: Can't see my workpackages any more (after update?) - Added by Oliver Günther over 9 years ago

Hey Bernd,

running openproject(-ce) configure should not update the application nor break it per se. It simply re-runs the installer using the configuration items persisted in /etc/openproject-ce/installer.dat and should be idempotent and thus not break your app. An update is installed through your package manager, and running configure would only run new installer steps.

Could you provide me with the following:

1. The content of installer.dat above (passwords redacted)

2. The output of the apache2 error log (/var/log/apache2/error.log)

BTW: You can check the OpenProject version by running sudo openproject run bundle exec rake version.

Best,
Oliver

RE: Can't see my workpackages any more (after update?) - Added by Bernd Müller over 9 years ago

Hi!

Thanks for your feedack. Would be great if we´d figure out what´s happening there:

installer.dat looks something like this:

smtp/authentication login
smtp/host blabla
smtp/port 465
smtp/username blabla
smtp/password blabla
smtp/domain moserver
smtp/admin_email blabla
server/ssl_cert /etc/letsencrypt/live/blabla/cert.pem
server/ssl_key /etc/letsencrypt/live/blabla/privkey.pem
server/ssl_ca
server/variant apache2
server/hostname blabla
server/server_path_prefix
server/ssl no
repositories/api-key L9T5d6EbGjh6V5UY4Onlm62gek5PZc4A
repositories/svn-install skip
repositories/git-install skip
mysql/retry retry
mysql/autoinstall reuse
mysql/db_host 192.168.0.100
mysql/db_port 3306
mysql/db_username root
mysql/db_password blabla
mysql/db_name openproject2
mysql/db_source_host moserver
mysql/ssl no
server/autoinstall skip
smtp/autoinstall skip
memcached/autoinstall skip

the error.log contains this here….maybe this gives a hint:

  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/helper-scripts/rack-preloader.rb:28:in `<main>'


[ 2016-01-26 17:09:32.0229 15400/7fe6b397f700 age/Cor/Req/CheckoutSession.cpp:252 ]: [Client 2-30] Cannot checkout session because a spawning error occurred. The identifier of the error is 9846fbbe. Please see earlier logs for details about the error.
App 21475 stdout:
App 21475 stdout:
[ 2016-01-26 17:09:40.2919 15400/7fe6b1a26700 App/Implementation.cpp:303 ]: Could not spawn process for application /opt/openproject: An error occured while starting up the preloader.
  Error ID: a6915aa8
  Error details saved to: /tmp/passenger-error-Ve9Aph.html
  Message from application: Your Ruby version is 2.1.5, but your Gemfile specified 2.1.6 (Bundler::RubyVersionMismatch)
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/bundler-1.11.2/lib/bundler/definition.rb:402:in `validate_ruby!'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/bundler-1.11.2/lib/bundler.rb:88:in `setup'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/bundler-1.11.2/lib/bundler/setup.rb:18:in `<top (required)>'
  /home/openproject/.rvm/rubies/ruby-2.1.5/lib/ruby/site_ruby/2.1.0/rubygems/core_ext/kernel_require.rb:54:in `require'
  /home/openproject/.rvm/rubies/ruby-2.1.5/lib/ruby/site_ruby/2.1.0/rubygems/core_ext/kernel_require.rb:54:in `require'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/lib/phusion_passenger/loader_shared_helpers.rb:395:in `activate_gem'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/lib/phusion_passenger/loader_shared_helpers.rb:277:in `block in run_load_path_setup_code'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/lib/phusion_passenger/loader_shared_helpers.rb:400:in `running_bundler'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/lib/phusion_passenger/loader_shared_helpers.rb:276:in `run_load_path_setup_code'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/helper-scripts/rack-preloader.rb:99:in `preload_app'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/helper-scripts/rack-preloader.rb:153:in `<module:App>'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/helper-scripts/rack-preloader.rb:29:in `<module:PhusionPassenger>'
  /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/helper-scripts/rack-preloader.rb:28:in `<main>'


Hmm….what makes me wonder, why is the openproject looking into /home/openproject? This location is the place where my “old” manual insallation was running. I change to the packaged installer as the manual setup cause some issue. I guess that I should setup the ENV to /opt/openproject. Not 100% sure show to…maybe you got a clue. But unfortunately I am not sure if this is really related to my issue, could be tough…

I have restarted the apache, this is shown after a restart, semms ok in my eyes:

[ 2016-01-27 10:39:28.9609 13242/7f3515764740 age/Wat/Main.cpp:1349 ]: Starting Passenger watchdog...
[ 2016-01-27 10:39:28.9759 13245/7fef017fd740 age/Cor/Main.cpp:957 ]: Starting Passenger core...
[ 2016-01-27 10:39:28.9762 13245/7fef017fd740 age/Cor/Main.cpp:234 ]: Passenger core running in multi-application mode.
[ 2016-01-27 10:39:28.9803 13245/7fef017fd740 age/Cor/Main.cpp:707 ]: Passenger core online, PID 13245
[ 2016-01-27 10:39:28.9926 13250/7f0b39b60740 age/Ust/Main.cpp:430 ]: Starting Passenger UstRouter...
[ 2016-01-27 10:39:28.9940 13250/7f0b39b60740 age/Ust/Main.cpp:311 ]: Passenger UstRouter online, PID 13250

[ 2016-01-27 10:39:28.9978 13250/7f0b35191700 age/Ust/Main.cpp:337 ]: Signal received. Gracefully shutting down... (send signal 2 more time(s) to force shutdown)
[ 2016-01-27 10:39:28.9979 13250/7f0b39b60740 age/Ust/Main.cpp:399 ]: Received command to shutdown gracefully. Waiting until all clients have disconnected...
[ 2016-01-27 10:39:28.9979 13250/7f0b35191700 Ser/Server.h:752 ]: [LoggerApiServer] Freed 0 spare client objects
[ 2016-01-27 10:39:28.9980 13250/7f0b35191700 Ser/Server.h:443 ]: [LoggerApiServer] Shutdown finished
[ 2016-01-27 10:39:28.9983 13250/7f0b39b60740 age/Ust/Main.cpp:424 ]: Passenger UstRouter shutdown finished

[ 2016-01-27 10:39:28.9989 13245/7feefce60700 age/Cor/Main.cpp:507 ]: Signal received. Gracefully shutting down... (send signal 2 more time(s) to force shutdown)
[ 2016-01-27 10:39:28.9989 13245/7fef017fd740 age/Cor/Main.cpp:876 ]: Received command to shutdown gracefully. Waiting until all clients have disconnected...
[ 2016-01-27 10:39:28.9992 13245/7feefc65f700 Ser/Server.h:752 ]: [ServerThr.2] Freed 128 spare client objects
[ 2016-01-27 10:39:28.9992 13245/7feefc65f700 Ser/Server.h:443 ]: [ServerThr.2] Shutdown finished
[ 2016-01-27 10:39:28.9994 13245/7feefce60700 Ser/Server.h:752 ]: [ServerThr.1] Freed 128 spare client objects
[ 2016-01-27 10:39:28.9994 13245/7feefce60700 Ser/Server.h:443 ]: [ServerThr.1] Shutdown finished
[ 2016-01-27 10:39:28.9996 13245/7feefbddd700 Ser/Server.h:752 ]: [ApiServer] Freed 0 spare client objects
[ 2016-01-27 10:39:28.9996 13245/7feefbddd700 Ser/Server.h:443 ]: [ApiServer] Shutdown finished
[ 2016-01-27 10:39:29.0011 13245/7fef017fd740 age/Cor/Main.cpp:942 ]: Passenger core shutdown finished
[ 2016-01-27 10:39:29.1431 13291/7fdc40c1a740 age/Wat/Main.cpp:1349 ]: Starting Passenger watchdog...
[ 2016-01-27 10:39:29.1590 13294/7f309662a740 age/Cor/Main.cpp:957 ]: Starting Passenger core...
[ 2016-01-27 10:39:29.1594 13294/7f309662a740 age/Cor/Main.cpp:234 ]: Passenger core running in multi-application mode.
[ 2016-01-27 10:39:29.1634 13294/7f309662a740 age/Cor/Main.cpp:707 ]: Passenger core online, PID 13294
[ 2016-01-27 10:39:29.1751 13299/7f3d875d9740 age/Ust/Main.cpp:430 ]: Starting Passenger UstRouter...
[ 2016-01-27 10:39:29.1765 13299/7f3d875d9740 age/Ust/Main.cpp:311 ]: Passenger UstRouter online, PID 13299
[Wed Jan 27 10:39:29 2016] [notice] Apache/2.2.22 (Debian) DAV/2 SVN/1.6.17 PHP/5.4.45-0+deb7u2 mod_ssl/2.2.22 OpenSSL/1.0.1e Phusion_Passenger/5.0.11 mod_perl/2.0.7 Perl/v5.14.2 configured -- resuming normal operations

The log within openproject says following

W, [2016-01-26T20:20:53.352306 #2150]  WARN -- : hook registered
W, [2016-01-26T20:21:05.251319 #2150]  WARN -- : WARNING on line 70 of /tmp/d20160126-18-blvvbt/opt/openproject/app/assets/stylesheets/layout/_toolbar.sass:
This selector doesn't have any properties and will not be rendered.

W, [2016-01-26T20:21:05.424601 #2150]  WARN -- : WARNING on line 30 of /tmp/d20160126-18-blvvbt/opt/openproject/app/assets/stylesheets/content/_context_menu.sass:
This selector doesn't have any properties and will not be rendered.

W, [2016-01-26T20:21:05.447942 #2150]  WARN -- : WARNING on line 181 of /tmp/d20160126-18-blvvbt/opt/openproject/app/assets/stylesheets/content/_forms.sass:
This selector doesn't have any properties and will not be rendered.

W, [2016-01-26T20:21:05.471013 #2150]  WARN -- : WARNING on line 435 of /tmp/d20160126-18-blvvbt/opt/openproject/app/assets/stylesheets/content/_forms.sass:
This selector doesn't have any properties and will not be rendered.

W, [2016-01-26T20:21:25.627533 #2150]  WARN -- : WARNING on line 182 of /tmp/d20160126-18-blvvbt/opt/openproject/app/assets/stylesheets/timelines.css.sass:
This selector doesn't have any properties and will not be rendered.

W, [2016-01-26T20:21:52.942746 #2304]  WARN -- : hook registered
W, [2016-01-27T10:07:59.566035 #12095]  WARN -- : hook registered

Does this make any sense to you?
Cheers!

RE: Can't see my workpackages any more (after update?) - Added by Bernd Müller over 9 years ago

Ah!

I guess that I got a little step further -> I guess my problem could be related to my old apache.conf that I created while using the manual installation, here is see

   LoadModule passenger_module /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11/$
   <IfModule mod_passenger.c>
     PassengerRoot /home/openproject/.rvm/gems/ruby-2.1.5/gems/passenger-5.0.11
     PassengerDefaultRuby /home/openproject/.rvm/gems/ruby-2.1.5/wrappers/ruby
   </IfModule>

When I do a “ruby -v” I get

 ruby -v
ruby 1.9.3p194 (2012-04-20 revision 35410) [x86_64-linux]

I should see 2.16, right?

RE: Can't see my workpackages any more /no drop down box(after update?) - Added by Bernd Müller over 9 years ago

Also i forgot to mention that my drop down boxes refuse to drop down. sigh

RE: Can't see my workpackages any more /no drop down box(after update?) - Added by Oliver Günther over 9 years ago

The packaged installation does not use packager, but uses unicorn. There should only be one openproject.conf site in apache2 that includes most of its configuration from /etc/openproject/addons/apache2/includes/{vhost,server}/*.

So I assume that you’re request is actually going to the old installation (or some weird state in between) which would explain why the log remains empty in the packaged installation.

The packaged installation always lives at /opt/openproject and does not require configuration regarding that path.

Best,
Oliver

RE: Can't see my workpackages any more /no drop down box(after update?) - Added by Bernd Müller over 9 years ago

Hi!

Thx bro, for your support!!

You were very right, in apache.conf I had still old stuff that I forgot to disable.
Now I see following issue in apache´s error.log:

[Wed Jan 27 16:17:46 2016] [error] [client 92.227.147.251] File does not exist: /opt/openproject/public/assets/application-dcd010a399b3372241a63a26aff12655.js, referer: http://blabla.com/projects/blabla/work_packages?query_props=%7B%22f%22%3A%5B%7B%22v%22%3A10%2C%22n%22%3A%22type_id%22%2C%22o%22%3A%22%3D%22%7D%5D%2C%22t%22%3A%22updated_at%3Adesc%22%7D
[Wed Jan 27 16:17:47 2016] [error] [client 92.227.147.251] File does not exist: /opt/openproject/public/assets/application-dcd010a399b3372241a63a26aff12655.js, referer: http://blabla/projects/blabla/work_packages?query_props=%7B%22f%22%3A%5B%7B%22v%22%3A10%2C%22n%22%3A%22type_id%22%2C%22o%22%3A%22%3D%22%7D%5D%2C%22t%22%3A%22updated_at%3Adesc%22%7D

and in deed these .js were not generated in the /opt/openproject/public/assets/. Now how should create these.js?

Does that ring a bell, maybe?

Cheers!

RE: Can't see my workpackages any more /no drop down box(after update?) - Added by Oliver Günther over 9 years ago

That’s weird, since the package should contain all required assets.

You can still force a recompilation of assets with
sudo openproject run bundle exec rake assets:precompile

RE: [solved]Can't see my workpackages any more /no drop down box(after update?) - Added by Bernd Müller over 9 years ago

OP lives again. I simply rebooted the server and tata all back to normal. Lord! :-/

  • (1 - 8/8)
Loading...