Openproject 8.3.2-0 stack not working after fresh install

Andarion 2019-05-10 14:57:48 UTC #1

Hello.

I downloaded and installed the Openproject 8.3.2.-0 bitnami stack on a virtual Ubuntu 16.04.6 LTS machine. So far everything seemed fine, installation was running smooth. So did the application that started automatically after the installation.

But when I tried to access Openproject through the browser afterwards I only get an error about the Phusion Passenger application server. It takes it quite a while so I guess this is timeout related.

It also tells me that something has been logged and an id which is created anew each time. I found something in the apache error_log:

Cannot checkout session because a spawning error occurred. The identifier of the error is c7eb3c88. Please see earlier logs for details about the error.

So I did go back a little and found this:

core online, PID 7261
[Fri May 10 16:08:18.703524 2019] [mpm_prefork:notice] [pid 7239] AH00163: Apache/2.4.39 (Unix) OpenSSL/1.0.2r SVN/1.11.1 PHP/7.2.17 Phusion_Passenger/6.0.1 configured -- resuming normal operations
[Fri May 10 16:08:18.703671 2019] [core:notice] [pid 7239] AH00094: Command line: '/opt/openproject-8.3.2-0/apache2/bin/httpd.bin -f /opt/openproject-8.3.2-0/apache2/conf/httpd.conf'
[ E 2019-05-10 16:08:20.7629 7261/T5 age/Cor/SecurityUpdateChecker.h:507 ]: Security update check failed: Problem with the SSL CA cert (path? access rights?) while connecting to https://securitycheck.phusionp assenger.com/v1/check.json ; this might happen if the nss backend is installed for libcurl instead of GnuTLS or OpenSSL. If the problem persists, you can also try upgrading or reinstalling Phusion Passenger ( next check in 24 hours)
[ E 2019-05-10 16:09:51.5476 7261/Tf age/Cor/App/Implementation.cpp:221 ]: Could not spawn process for application /opt/openproject-8.3.2-0/apps/openproject/htdocs/: A timeout occurred while starting a preloa der process.
Error ID: c7eb3c88
Error details saved to: /tmp/passenger-error-xA31ZJ.html

This seems to be the root of the problem because all futuere errors look just the same as you can read in teh first quote. Thing is I never had this error with earlier versions of the bitnami stack. All worked fine. I also thought that the stack uses it's own enviroment so I can't figure out where this went wrong. It looks to me tha it has huge problems with the SSLcerts, yes? But how can that be after a fresh installation that completed without errors?

jota 2019-05-13 05:47:47 UTC #2

Hi @Andarion,

This error message shows that the installation may not have the required amount of memory to work. Please note that OpenProject requires 3GB of RAM to work and we suggest you have a more memory at installation time, does the VM you have meet this requirement?

You may know that we provide ready-to-use VMs in bitnami.com. They include the application you want to use and they have been properly tested in our systems before publishing them.

Could you please let us know if you continue receiving the same error message when increasing the VM's memory or using one of the VMs we provide?

Happy to help!

Was my answer helpful? Click on

Andarion 2019-05-13 14:48:07 UTC #3

The VM has 8 GB of RAM and 2 cores.

I know that there are ready to use VMs but I would have to jump through several hoops to adapt the VM to our network all the time. This one is running fine and I used it for bitnami Openproject stacks for some time now. latest Version which was running fine was 8.1.0. I made a mysql dump and a backup, stopped it with the ctlscript and installed the 8.3.2-0 stack in a different folder to afterwards drop the database and reimpart the old data according to the manual I found. That way I have a fallback option if something goes wrong. The stack is not started automatically.

Only that time after installing 8.3.2 I could not access Openproject with the errors mentioned earlier.

michiel 2019-05-14 08:59:58 UTC #4

We have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please download and execute it on the machine where the stack is running by following the steps described in the guide below?

How to Run the Bitnami Support Tool

Please note that you need to paste the code outputted by the tool in your reply.

Andarion 2019-05-17 13:43:42 UTC #5

Hello.

I will run the tool as soon as possible. Hopefully on monday I can plan a short downtime for the machine.

Andarion 2019-05-21 15:45:36 UTC #6

I ran the support tool and it gave me the following code:

99e0b304-4ae9-9346-e382-8cfb9ecf3e0a

michiel 2019-05-22 10:52:13 UTC #7

Hi @Andarion,

I'm forwarding the issue to another team, they will update the topic or request additional information.

tomasp 2019-05-23 13:56:12 UTC #8

@Andarion Thanks for using the bnsupport tool. I have seen the following error in the production.log:

F, [2019-05-10T16:08:46.527488 #5525] FATAL -- : MySQL client is not connected

And this other in the delayed_jobs.log:

/opt/openproject-8.3.2-0/apps/openproject/htdocs/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query': MySQL server has gone away (Mysql2::Error::ConnectionError)

So it seems the problem is in the mysql server. Can you check if it is running?

sudo /opt/openproject-8.3.2-0/ctlscript.sh status

Andarion 2019-05-23 14:09:07 UTC #9

Subversion, mysql, apache and memcached are shown as "already running".

delayed job is shown as not running.

Andarion 2019-05-24 15:42:00 UTC #10

I am on a vacation until June, 11th. Bad timing, I know. Sorry.

If you could stop the ticket from closing, that would be nice.

tomasp 2019-05-27 13:44:20 UTC #11

Ok! I just marked this case to not be closed automatically.

When you have the time, can you run the bnsupport tool again so we can check the MySQL logs?

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