Content
Added by Martin Kedaj about 8 years ago
Hi ,
I have a problem to get OpenProject up and running with the advice I found on the web.
The prologue to my problem:
I am looking for a tool to help managing the tasks and projects of my team.
I want to suggest my company a tool which I have tested and feel comfortable with and I can recommend without any doubt.
I want to just use it and not having to struggle much with it’s configuration.
That’s the way it would be used by the team. For implementation and first training the company should buy support and also for special requirements.
But the basic “operate and analyze” should be possible without becoming a Ruby on Rails developer.
I am an IT Pro in Service Management (Windows environment). I am not a programmer but more a scripter ( Bash, Perl, Powershell, … )
I can help myself on searching the web and applying the found solutions. But special customizations on Rails or Apache take me to my limits.
My test environment:
I have a virtualized server just accessible by the IP or standard hostname given by the provider.
The virtual box is running a debian 8 (jessie).
There is already a MySql installed and used by a mail server.
My experiences with OpenProject installs:
My first shot was the deb package. I selected during it’s setup to use the existing MySql instance. The setup never asked for the MySql root password and failed to create the database.
I downloaded a jessie-vm from osboxes.org and installed the deb package there letting it install MySql. The setup did not ask much and finished successful.
It would have been nice if it had asked me to define the password of MySql-root during istallation of MySql or if it had told me where to find the self and silent generated root password. But it seemed to work
I continued my trials with the box on the web:
First I found the script where it reads the value from the db-file and creates the database. I have put a read statement in it and let me ask if the root password was empty. Later on I’ve found the db-file at /etc/openproject and added the entry with the password.
Installation succeeded now, but I could not get it work - I thought it was an issue with my ssl configuration in apache (I got an error message when accessing the site ).
So I disabled all other sites and ran the openproject site as plain unsecured http site.
It seemes to work but … next day from work I wanted to access the site: Error 502: The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET.
In the evening I tried to fix it. At last after a “openproject configure” the site was accessible again. But next day at work … same error.
Yesterday I decided to try a last attempt and follow this time the steps of https://www.openproject.org/open-source/download/manual-installation-guide/
This time I was stopped at the part “Finish the Installation of OpenProject”:
~/openproject-ce$ RAILS_ENV="production" ./bin/rake db:create Your bundle is locked to activesupport (4.2.7.1), but that version could not be found in any of the sources listed in your Gemfile. If you haven't changed sources, that means the author of activesupport (4.2.7.1) has removed it. You'll need to update your bundle to a different version of activesupport (4.2.7.1) that hasn't been removed in order to install. Run `bundle install` to install missing gems.
I do not know what this wants me to do. `bundle install` will do nothing
I havent tried to set it up with a docker container and I do not want to do this.
Is there any step by step guide that works for a simple setup without the need of deep knowledge of the underlying technology?
Any help is appreciated.
Regards
Martin
Replies (9)
Hi Martin,
using the packaged installer should work without a hassle.
Though I’d recommend you to install mysql before you start installing OpenProject.
That way you have full control of your mySQL installation
Next, setup the database according to the manual installation.
Now you have a database “openproject” and a user/password combination that you can pass to the installer.
OpenProject doesn’t necessarily have to be ssl encrypted, if you use apache as a proxy. Just let the installer finish its work and add SSL certificates in apache later on.
That should do the trick. ;)
Oliver Jakobi wrote:
Hi Oliver,
What is the problem with the installer routine? What kind of “control” do you mean?
Best Niels
Hi Niels,
there is nothing wrong with the installer routine. It works perfectly fine.
I’m just a fan of having MySQL setup on my own.
That way I can set my own passwords, secure the installation/connections etc and do not have to get the password from the installer.dat file/ run the secure-scripts with a fully setup database.
I also guess Martin misunderstood the “use existing MySQL Database” part as an installer itself. That would at least explain, why he sees not being asked for a root password as an issue that is none.
Other than that I was not able to recreate the issues stated, hence have no tips to share..
OpenProjects log files should give some hints as to why the Upstream encountered a problem though.
Best
Oliver
Thank you Oliver, for your response.
I also prefer to setup MySQL separately. But I would like the setup create the database. For this I need to provide the password to the package setup. And I did not find any hint how to do this.
I will install one more time with the deb package and preinstalled database and have look on the OP logs.
Regards
Martin
Hi Martin,
the intsaller routine hat two options:
1st: Install mysql and create a database.
In this case you will not have to do anything yourself (very convenient, but does not work, if you already run some databases with MySQL)
You will find your root password in
/etc/openproject/installer.dat2nd: Use existing MySQL instance and fill existing database.
I believe that this is, where some people missunderstand.
You will have to create a database, database user and password for openproject. (This procedure is very well documented in the manual installation script)
No admin should experience any problems with this.
In my opinion, this is the best way provide both options in the installer.
No root password needed, so no possibilities to have a buggy installer screw up your whole MySQL installation whatsoever. Safest bet for both, openproject and you.
Best
Oliver
Hi Oliver,
thank you for the advice. Today I reinstalled OP the second way.
At first I have chosen to use a directory and SSL (e.g. !https://example.org/openproject). It installed, but didn’t work.
Then I reconfigured to use the servers root and no SSL and got a working installation.
Next step was to add a second vhost for port 443 and add the SSL configuration.
Now both vhosts did it.
At last I replaced the config for port 80 with a redirect to port 443 and this also worked. What a surprise! Prior attempts of redirection ended most times with a redirect to the IP and the certificate wasn’t valid for https://08.15.47.11 .
During the day all went well. I only had to do a
openproject configureafter I made anapt-get upgradeand this brought an update for openproject. After reenabling my custom openproject.conf on apache everything went on again.I am confident I can access the site tomorrow from work and create some projects I have to manage and collect experience how to do it with OpenProject.
By the way: I noticed that syntax highlighting is done with CodeRay. Looking for supported languages or continued development on http://coderay.rubychan.de/ gave me an impression of stagnancy.
Are there any plans to replace it in future versions? For example adapt the Redmine plugin HighlightJS? The demo page (https://highlightjs.org/static/demo/) seems promising to me.
Thanks again for the support.
Martin
Here my final reply to this thread,
I worked during the day with my OP instance without any problem.
I just noticed a slow response while processing some changes. In the evening I checked whats going on on my server while working with OP. My finding was that somtimes swapping and disk IO slows down. Might be that my 512 MB RAM are not enough for good performance, CPU is most times less than 10% and .
I will keep on testing and invited my boss to have a look at OpenProject.
Regards
Martin
Hi Martin,
Yup. All future releases should simply be that (other than changing the package source for major version upgrades).
Yes, the system is mainly I/O and memory bound. We suggest at least 1024MB of RAM, rather double that.
If you’re stuck with 512MB, you can try to optimize the number of workers with WEB_CONCURRENCY. Also you can try to test different partitions of RAM given to unicorn + database.
Best,
Oliver
Thank you for the sizing hints, Oliver.
Unfortunately I am stuck at the webserver with 512 MB. It is just my private mailserver and for my private experiments. It’s only 11 € / month.
The next higher step would increase my budget from 130 € to 215 € a year. This would double the RAM to 1024 MB and also the CPU count (2) and HD (100GB). But my common usage does not require this. So I will accept the delay at my OpenProject playground :-)
Nevertheless: In the last two hours I have set up a fresh debian 8.6 vm with 2 cores and 2 GB RAM and installed OpenProject.
My environment:
5 years old Dell Laptop (i7-2630QM, 16 GB RAM)
VMware Workstation 12.5 on Win 8.1 Pro
And yea, it works like a charm - fast and responsive.
In my company it would run within our XEN-farm with more than enough resources. So I will recommend the tool with total conviction.
All the best
Martin