Ruby gem not found after upgrade from 8.0.3 to 10.2.1

panaxx 2019-12-16 16:33:32 UTC #1

Which version of the application are you using?:
bitnami-openproject-10.2.1-0-linux-x64-installer
Please choose how you got the application: Installer (Windows, Linux, macOS), cloud image (AWS, GCE, Azure, ...) or VM (VMDK, VBOX):
Installer
Have you installed any plugin or modified any configuration file?:
No
Describe here your question/suggestion/issue (expected and actual results):
I started out earlier this year with a Bitnami vmdk for OpenProject (8.0.3 iirc).
Since it was showing my version as vulnerable in the dashboard and I reconed that I could use the newer version, I decided to dump the headless vm and upgrade to a vm running ubuntu 18.04 lts and used the installer for openproject 10.2.1.
I backed up the data of the old vm and it looks like the transition from mysql to postgresql worked.
I've updated the password and can connect to the database, etc.
I followed these instructions:
https://docs.bitnami.com/installer/apps/openproject/administration/upgrade/

But after running
ruby bin/rake db:migrate RAILS_ENV=production

I got into troubles with the ruby installation.
At first nothing seemed to work and bit by bit I assembled a ruby installation that had the correct versions of bundler and everything.
Now I've been at it for more than a week and I am stuck withthe following error message from Passenger:

Could not find bcrypt-3.1.6 in any of the sources (Bundler::GemNotFound)

I checked that my gem is of the correct version and the files are definitely located at
/opt/bitnami/apps/openproject/apps/openproject/htdocs/vendor/bundle/ruby/2.6.0/gems

I even did a chmod -R 777 to make sure it's not an access right issue.
To no avail.

I downloaded the bnsupport-tool and here is my token:
f8090a28-944a-c434-d4ba-3441378f0bcb

Thank you very much in advance for your help!
You are doing a great job

michiel 2019-12-17 09:52:04 UTC #2

Hi @panaxx,

Can you tell me the output of the following command:

sudo /opt/bitnami/use_openproject 
cd /opt/bitnami/apps/openproject/htdocs
sudo gem install bcrypt -v 3.1.6

Regards,
Michiel

panaxx 2020-01-03 11:33:02 UTC #3

Hello @michiel,

thanks for your reply and sorry for the late answer - I had fallen ill.

The gemfile seems to install without any issue

Fetching bcrypt-3.1.6.gem
Building native extensions. This could take a while...
Successfully installed bcrypt-3.1.6
Parsing documentation for bcrypt-3.1.6
Installing ri documentation for bcrypt-3.1.6
Done installing documentation for bcrypt after 1 seconds
1 gem installed

After this I ran
bundle update
bundle install

But when I try to start openproject, I end up with the same error as before:
sudo /opt/bitnami/apps/openproject/ctlscript.sh start
/opt/bitnami/apps/openproject/postgresql/scripts/ctl.sh : postgresql (pid 1807) already running
/opt/bitnami/apps/openproject/memcached/scripts/ctl.sh : memcached (pid 1843) already running
openproject_delayed_job could not be started
WARNING: PassengerPreStart cannot occur within section
WARNING: PassengerPreStart cannot occur within section
Syntax OK
/opt/bitnami/apps/openproject/apache2/scripts/ctl.sh : httpd (pid 2178) already running

Thanks for your help,
Panaxx

michiel 2020-01-07 09:56:55 UTC #4

Hi @panaxx,

Could you try to run the command below and post the output?

sudo su daemon -s /bin/sh -c "export RAILS_ENV=production && cd /opt/bitnami/apps/openproject/htdocs && /opt/bitnami/ruby/bin/ruby script/delayed_job start"

Regards,
Michiel

panaxx 2020-01-07 12:39:50 UTC #5

Hi @michiel
I had to adapt the command to my paths:

sudo su daemon -s /bin/sh -c "export RAILS_ENV=production && cd /opt/bitnami/apps/openproject/apps/openproject/htdocs && /opt/bitnami/apps/openproject/ruby/bin/ruby script/delayed_job start"

resulting in:

Traceback (most recent call last):
/opt/bitnami/apps/openproject/ruby/bin/.ruby.bin: No such file or directory -- script/delayed_job (LoadError)

Do you think that my installation path could be an issue?
For some reason /apps/openproject appears twice.

Thanks,
panaxx

michiel 2020-01-08 10:19:33 UTC #6

Hi @panaxx,

A colleague from another team will update this this thread with further information.

Regards,
Michiel

marcos 2020-01-09 11:24:35 UTC #7

Hi @panaxx,

First of all, could you describe how you converted the MySQL database to be PostgreSQL compatible? So we can try and upgrade those versions from our side.

Next, you mention you get an error starting Passenger:

WARNING: PassengerPreStart cannot occur within section
WARNING: PassengerPreStart cannot occur within section

That is a warning and should not affect the application.

The error "Could not find bcrypt-3.1.6 in any of the sources (Bundler::GemNotFound)" is different and should be fixable by running "bundle install --deployment".

If that doesn't work, try with "sudo bundle install --no-deployment" instead.

panaxx 2020-01-10 14:45:46 UTC #8

Hello @marcos

unfortunately neither "bundle install --deployment" nor "bundle install --no-deployment" worked.
I still get the error message openproject_delayed_job could not be started.

For DB migration I used this guide with pgloader:
https://www.openproject.org/operations/migration-guides/migrating-manual-openproject-database-postgresql/

Then, I made a dump using pg_dump and moved to a new virtual machine.
I was using a bitnami VM first, but then decided to switch to a self-installed Ubuntu 18.04 LTS with the bitnami stack.
I Installed the bitnami stack on the Ubuntu and imported the dump from the Postgresql, following this guide:
https://docs.bitnami.com/oci/apps/openproject/administration/upgrade/

I hope this helps.

Thanks a lot for your support,
panaxx

marcos 2020-01-10 15:53:40 UTC #9

Hi @panaxx,

unfortunately neither "bundle install --deployment" nor "bundle install --no-deployment" worked.
I still get the error message openproject_delayed_job could not be started.

When you mention "bundle install" didn't work, could you clarify if the actual "bundle install" command completed successfully? Since the "openproject_delayed_job could not be started" comes from starting services via /opt/bitnami/ctlscript.sh.

Then, I made a dump using pg_dump and moved to a new virtual machine.
I was using a bitnami VM first, but then decided to switch to a self-installed Ubuntu 18.04 LTS with the bitnami stack.
I Installed the bitnami stack on the Ubuntu and imported the dump from the Postgresql, following this guide:
https://docs.bitnami.com/oci/apps/openproject/administration/upgrade/

Checking the Delayed Jobs log at /opt/bitnami/apps/openproject/htdocs/log/delayed_jobs.log, it is complaining about the reason you mentioned Passenger was showing:

/opt/bitnami/apps/openproject/ruby/lib/ruby/gems/2.6.0/gems/bundler-2.0.2/lib/bundler/spec_set.rb:87:in `block in materialize': Could not find bcrypt-3.1.6 in any of the sources (Bundler::GemNotFound)
    from /opt/bitnami/apps/openproject/ruby/lib/ruby/gems/2.6.0/gems/bundler-2.0.2/lib/bundler/spec_set.rb:81:in `map!'
    from /opt/bitnami/apps/openproject/ruby/lib/ruby/gems/2.6.0/gems/bundler-2.0.2/lib/bundler/spec_set.rb:81:in `materialize'
    ...

Which seems to indicate that there is an error installing the packages via "bundle install". Could you share the logs running the commands we mentioned in our previous post?

panaxx 2020-01-13 09:54:36 UTC #10

Hello @marcos,

the bundle install command is completed successfully. Sorry about the confusion. What I meant was, that it does not remedy the error I get regarding the bcrypt gem.

Could you please clarify which logs you would like to see and where to find them?

Thanks,
panaxx

panaxx 2020-01-15 09:02:09 UTC #11

Hi,

I ended up installing OpenProject as a docker container and routing the database URL to my local Postgresql db.
This is working for me now.

Thanks for your support!
panaxx

rafaelrios 2020-01-20 12:29:51 UTC #12

Hi @panaxx,
We are happy you were able to solve the issue.
Thanks

system 2020-02-03 12:29:57 UTC #13

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!