Content
[Solved] 7.3.2 to 7.4 upgrade and re-install failed
Added by Matt Lane about 7 years ago
Hi,
First i want to thank you for this great system and pretty good tutorials and guides you have! Also big thanks for providing support for Debian 9! Unfortunately I’ve run into some problem with the latest version (7.4.0).
I’ve been running 7.3.2 on Debian 9 (VPS) fine for 2 months and decided to upgrade to new version 7.4.0. I followed the simple guide on your site:
sudo apt-get update sudo apt-get install --only-upgrade openproject sudo openproject configure
Unfortunately this run in an error:
... Module cgid already enabled [smtp] ./bin/preinstall [memcached] ./bin/preinstall [openproject] ./bin/preinstall [legacy-installer] ./bin/postinstall [mysql] ./bin/postinstall Generating /etc/openproject/conf.d/database... [apache2] ./bin/postinstall Module rewrite already enabled Module proxy already enabled Considering dependency proxy for proxy_http: Module proxy already enabled Module proxy_http already enabled Module headers already enabled Module expires already enabled Considering dependency filter for deflate: Module filter already enabled Module deflate already enabled Module filter already enabled Site openproject already enabled [repositories] ./bin/postinstall Setting up SVN integration for Apache Setting up Git integration for Apache [smtp] ./bin/postinstall [memcached] ./bin/postinstall [openproject] ./bin/postinstall rake aborted! ArgumentError: Malformed version number string 10.1.26-MariaDB-0+deb9u1 /opt/openproject/lib/open_project/database.rb:89:in `version_matches?' /opt/openproject/lib/open_project/database.rb:71:in `check_version!' /opt/openproject/lib/tasks/database.rake:49:in `block (3 levels) in <top (required)>' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/rake-12.1.0/exe/rake:27:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `load' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `kernel_load' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:27:in `run' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:360:in `exec' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor.rb:369:in `dispatch' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:20:in `dispatch' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/base.rb:444:in `start' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:10:in `start' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:35:in `block in <top (required)>' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/friendly_errors.rb:121:in `with_friendly_errors' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:27:in `<top (required)>' /opt/openproject/bin/bundle:3:in `load' /opt/openproject/bin/bundle:3:in `<main>' Tasks: TOP => db:migrate => openproject:db:ensure_database_compatibility (See full trace by running task with --trace)
After this I tried to upgrade ruby, rbenv, passenger gem apache2 and mariadb-server but things ended even worse (I probably messed something with db). After some time i decided to clean the whole thing and start over.
After removing everything (OP, Apache2, memcached, mariadb, users and files) I run:
root@server:/# apt-get install openproject
`...
Unpacking openproject (7.4.0-1517493473.2462eea9.stretch) ...
Setting up mysql-common (5.8+1.0.2) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up libmariadbclient18:amd64 (10.1.26-0+deb9u1) ...
Setting up libxslt1.1:amd64 (1.1.29-2.1) ...
Setting up libpq5:amd64 (9.6.6-0+deb9u1) ...
Processing triggers for libc-bin (2.24-11+deb9u1) ...
Setting up libevent-core-2.0-5:amd64 (2.0.21-stable-3) ...
Setting up libevent-2.0-5:amd64 (2.0.21-stable-3) ...
Setting up libevent-extra-2.0-5:amd64 (2.0.21-stable-3) ...
Setting up openproject (7.4.0-1517493473.2462eea9.stretch) ...
The openproject package provides an installer. Please run the following command to finish the installation:
sudo openproject configure
Processing triggers for libc-bin (2.24-11+deb9u1) ...`
root@server:/# openproject configure
and that ended in the same error as when upgrading:
... To activate the new configuration, you need to run: systemctl reload apache2 Enabling site openproject. To activate the new configuration, you need to run: systemctl reload apache2 [repositories] ./bin/postinstall Setting up SVN integration for Apache Setting up Git integration for Apache [smtp] ./bin/postinstall [memcached] ./bin/postinstall [openproject] ./bin/postinstall rake aborted! ArgumentError: Malformed version number string 10.1.26-MariaDB-0+deb9u1 /opt/openproject/lib/open_project/database.rb:89:in `version_matches?' /opt/openproject/lib/open_project/database.rb:71:in `check_version!' /opt/openproject/lib/tasks/database.rake:49:in `block (3 levels) in <top (required)>' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/rake-12.1.0/exe/rake:27:in `<top (required)>' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `load' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in `kernel_load' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:27:in `run' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:360:in `exec' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor.rb:369:in `dispatch' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:20:in `dispatch' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/base.rb:444:in `start' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:10:in `start' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:35:in `block in <top (required)>' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/friendly_errors.rb:121:in `with_friendly_errors' /opt/openproject/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:27:in `<top (required)>' /opt/openproject/bin/bundle:3:in `load' /opt/openproject/bin/bundle:3:in `<main>' Tasks: TOP => db:migrate => openproject:db:ensure_database_compatibility (See full trace by running task with --trace)
Here is production.log contents:
rootserver:/var/log/openproject# tail production.log
W, [2018-02-02T21:47:48.279763 #6084] WARN — : [auth_saml] Missing settings from ‘/opt/openproject/config/plugins/auth_saml/settings.yml’, skipping omniauth registration.
W, [2018-02-02T21:47:48.389648 #6084] WARN — : hook registered
W, [2018-02-02T21:55:06.218512 #6324] WARN — : [auth_saml] Missing settings from ‘/opt/openproject/config/plugins/auth_saml/settings.yml’, skipping omniauth registration.
W, [2018-02-02T21:55:06.328736 #6324] WARN — : hook registered
E, [2018-02-02T21:55:09.880802 #6324] ERROR — : Failed to run LDAP group synchronization. ActiveRecord::StatementInvalid: Mysql2::Error: Table ‘openproject.auth_sources’ doesn’t exist: SHOW FULL FIELDS FROM `auth_sources`@
How should i try to solve this problem? I am very newbie with Ruby, so please help if you see what I am missing /doing wrong!
Thank you!
Sincerely,
Matt
Replies (6)
Hello,
Exactly the same behaviour for me. Any idea ?
Thanks
Jérôme
We also try to use the package upgrade from 7.3.2 to 7.4 on Ubuntu 14.04 failed as well. Upgrades from previous versions have worked using the package upgrade, but not this one. I have been trying to figure it out for several hours today, but with no luck.
After the initial upgrade to 7.4, we were able to get into OpenProject, but could not get into any projects or work packages. After doing a reconfigure, we started having issues where we would only get a 503 service unavailable error, or a 403 forbidden error if we comment out the proxy pass info. Normally we access our OpenProject at 192.168.###.###:3000.
Here is our openproject.conf.
@ DocumentRoot /opt/openproject/public
ProxyRequests off
Include /etc/openproject/addons/apache2/includes/vhost/*.conf
# Can’t use Location block since it would overshadow all the other proxypass directives on CentOS
ProxyPass / http://127.0.0.1:6000/ retry=0
ProxyPassReverse / http://127.0.0.1:6000/@
Please help! Let me know if there is any other information you need.
Hi guys,
7.4.0 has a database version check, primarily for PSQL since we now require 9.5+ versions due to UPSERTs being used.
I had implemented a check for MySQL, and with MariaDB in mind, did not enforce the version check. However the MariaDB version string still breaks the check due to it not matching the semver versions.
For a workaround, please apply the patch attached to this post. This will disable the version check that causes the exception:
Download the patch and check whether it applies: From your OpenProject root folder:
git apply --check <patchfile>If nothing is output, it applies cleanly. Then, actually apply the patch:
git apply <patchfile>Sorry for the inconvenience. In any case, please ensure you dump your databases before each minor upgrades.
@Phason Eletronics, this may not apply to your issue, it may be separate from the database check. Please open a new post with your /var/log/openproject/production.log and apache logs attached.
Best,
Oliver
Hello,
I just downloaded and applied the patch then launch openproject configure and it’s now working perfectly.
Thanks a lot Oliver for your quick and efficient support.
Best,
Jérôme
Hi,
I downloaded the patch and installed and then everything started working! Great work Oliver!
Thank you!
Sincerely,
Matt
Great to hear. I’ve just pushed the workaround so a new package of 7.4.0 will be built so in case you’re seeing a new 7.4.0 package, it contains the patch as a workaround.
Best,
Oliver