Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. install issues

install issues

Added by phil ball over 2 years ago

any idea what i am doing wrong? centos system, standard pkg install of openproject. i did create an empty db in postgres12, user has creatdb and createrole rights. the openproject installer seems to be happy to connect to it...as far i can tell.

./bin/postinstall 
Server prefix is set. Need to recompile rails assets. Setting RECOMPILE_RAILS_ASSETS=true 
/opt/openproject/config/constants/settings/definition.rb:295:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_ATTACHMENTS_STORAGE_PATH
instead of ATTACHMENTS_STORAGE_PATH (StructuredWarnings::StandardWarning) 
/opt/openproject/config/constants/settings/definition.rb:295:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_RAILS_CACHE_STORE instea
d of RAILS_CACHE_STORE (StructuredWarnings::StandardWarning) 
/opt/openproject/config/constants/settings/definition.rb:295:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_RAILS_RELATIVE_URL_ROOT 
instead of RAILS_RELATIVE_URL_ROOT (StructuredWarnings::StandardWarning) 
/opt/openproject/config/constants/settings/definition.rb:295:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_ATTACHMENTS_STORAGE_PATH
instead of ATTACHMENTS_STORAGE_PATH (StructuredWarnings::StandardWarning) 
/opt/openproject/config/constants/settings/definition.rb:295:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_RAILS_CACHE_STORE instea
d of RAILS_CACHE_STORE (StructuredWarnings::StandardWarning) 
/opt/openproject/config/constants/settings/definition.rb:295:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_RAILS_RELATIVE_URL_ROOT 
instead of RAILS_RELATIVE_URL_ROOT (StructuredWarnings::StandardWarning) 
/opt/openproject/vendor/bundle/ruby/3.1.0/bin/rake db:migrate db:seed packager:postinstall: symbol lookup error: /opt/openproject/vendor/bundle/ruby/3.1.0/gems/pg-1.4.1/lib/pg_ext.so: undefi
ned symbol: PQconninfo


Replies (8)

RE: install issues - Added by Adam Szabo over 2 years ago

Hi, please use the DOCUMENTED WAY to install OpenProject on CentOS, the PSQL will be created automatically, and does not need to be created by the person installing manually.

Please share also which CentOS version you are using exactly

https://www.openproject.org/docs/installation-and-operations/installation/packaged/#centos-8--rhel-8

please do not forget to issue "sudo openproject configure" after the installation.

With these steps there should be not any issue if it is a default CentOS 7 or CentOS 8

RE: install issues - Added by phil ball over 2 years ago

hello, i went by the documentation except postgres because i already have 12 running for another service. i am using nethserver 7.9 which is based on centos7.

RE: install issues - Added by Adam Szabo over 2 years ago

OpenProject since Version 12 does require postgres 13.8

Maybe that could be the issue?

RE: install issues - Added by phil ball over 2 years ago

hmm...ok. is that postgres version info in the installer still accurate - ie. postgres v10? dunno how much overhead it is to have two postgres version running side by side. might just try it...

RE: install issues - Added by Adam Szabo over 2 years ago

Hi Phil

i see you want to use the manual installation method, please be aware that this documentation is totally outdated

please use the normal installation method, and you will have no trouble.

Also you could start reading in the beginning of the manual installation documentation.

IMPORTANT: We strongly recommend to use one of the officially supported installation methods. This guide is simply provided as a reference, and is most likely NOT up to date with relation to the latest OpenProject releases.

RE: install issues - Added by phil ball over 2 years ago

hey adam,

thats what i did. installed the rpms and used the openproject config. - the manual part was an empty db inside postgres12. inside the installer i chose 'use existing db'

su - postgres -c 'scl enable rh-postgresql12 -- psql -p 55434'

create database openproject with template = template0 encoding 'utf8';

create user openproject with encrypted password 'PASS';

grant all privileges on database openproject to openproject;

\c openproject

ALTER USER openproject CREATEDB;

ALTER USER openproject CREATEROLE;

\q

RE: install issues - Added by Adam Szabo over 2 years ago

nowhere in the docs i can refer to postgres12, please send me a link where you found that in the docs.

the manual docs ARE only good if you install OpenProject 9.5

RE: install issues - Added by cipriano vera over 2 years ago

Hi Phil

 I was running into the same issue. I was able to resolve all the errors expect the one relayed to the db 

/opt/openproject/vendor/bundle/ruby/3.1.0/bin/rake db:migrate db:seed packager:postinstall: symbol lookup error: /opt/openproject/vendor/bundle/ruby/3.1.0/gems/pg-1.4.1/lib/pg_ext.so: undefined symbol: PQconninfo

What I did for the other errors was change the current environment to the one it is asking. If you go to the following location on your server /etc/openproject/conf.d/ and read the other file you will see all the environment there. What I did was 

openproject config:get VAR

openproject config:unset VAR

openproject config:set VAR=

openproject configure

After rerun the configuration all I was left was the one related to PQconninfo. Which I will be looking into.

Thanks

Chip

  • (1 - 8/8)
Loading...