Content
Installation Guide for installing Openproject-CE on AWS AMI / CentOS 6.x with common bugfixes
I have been using an old version of OpenProject very happily for our small-office. I even managed manually install OpenProject-CE v4. However I wanted to go to the packaged-installation (albeit fresh install). It works.
Note: But I’ll really appreciate if anyone can help me configure apache virtual host.
For anyone else struggling, here are the directions.
Installing OpenProject-ce on AWS AMI
sudo yum -y install httpd24 sudo yum -y install mysql-server sudo chkconfig httpd on sudo chkconfig mysqld on sudo service mysqld start sudo mysql_secure_installation sudo yum -y install memcached sudo service memcached start sudo chkconfig memcached on
Manually create openproject database, openproject mysql user/pass that you will use with the install
Install OpenProject4 CE
sudo rpm --import https://rpm.packager.io/key echo "[pkgr-openproject-community] name=Repository for finnlabs/pkgr-openproject-community application. baseurl=https://rpm.packager.io/gh/finnlabs/pkgr-openproject-community/centos6/stable enabled=1" | sudo tee /etc/yum.repos.d/pkgr-openproject-community.repo sudo yum -y install openproject-ce
You get the following error:
/var/tmp/rpm-tmp.lGDQuZ: line 18: addgroup: command not found error: %pre(openproject-ce-4.0.9-1427122816.6200c65.centos6.x86_64) scriptlet failed, exit status 127 Error in PREIN scriptlet in rpm package openproject-ce-4.0.9-1427122816.6200c65.centos6.x86_64
I couldn’t find a way to get the addgroup command working so I created a user and group manually. May be there’s a better way to do this (create a system user?)
sudo groupadd openproject sudo adduser openproject -g openproject sudo openproject-ce configure
Then you get the following error
@ LoadError: Please install the mysql2 adapter: `gem install activerecord-mysql2-adapter` (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory - /opt/openproject-ce/vendor/bundle/ruby/2.1.0/extensions/x86_64-linux/2.1.0-static/mysql2-0.3.17/mysql2/mysql2.so)
@
Run the following to install the libraries:
sudo yum -y install mysql51-devel
There still is a long way before you can try and get it working in your browser. For now let’s verify if things actually work on teh server.
sudo yum -Y install lynx lynx http://localhost:6000
and voila it works, at least in lynx
Now try creating a virtual host in apache:
<VirtualHost *:80> ServerName mydomain.in # !!! Be sure to point DocumentRoot to 'public'! DocumentRoot /opt/openproject-ce/public <Directory /opt/openproject-ce/public> # This relaxes Apache security settings. AllowOverride all # MultiViews must be turned off. Options -MultiViews # Uncomment this if you're on Apache >= 2.4: Require all granted </Directory> </VirtualHost>
Finally you try http://mydomain.in
Forbidden You don't have permission to access / on this server.
That’s as far as I have reached. Any help will be appreciated.
Finally to get the thing to work on port 80 and having no way to get passenger to get working here’s the workaround:
<VirtualHost *:80>
ServerName myserver.com
# !!! Be sure to point DocumentRoot to ‘public’!
DocumentRoot /opt/openproject-ce/public
ProxyRequests off
ProxyPass / http://127.0.0.1:6000/ retry=0
ProxyPassReverse / http://127.0.0.1:6000/
<Directory /opt/openproject-ce/public>
# This relaxes Apache security settings.
AllowOverride all
# MultiViews must be turned off.
Options -MultiViews
# Uncomment this if you’re on Apache >= 2.4:
Require all granted
If you are not able to send the test mail after openproject-ce configure edit the following file
/etc/openproject-ce/conf.d/smtp
and insert the following at the very end:
export SMTP_ENABLE_STARTTLS_AUTO=“true”