Hi Mohammed,

could you please paste the output of sudo openproject config here? But of course, erase the passwords :)

Best,

Jonas

rootopenproject:/home/mohammed# sudo openproject config
APP_ADDONS=
APP_GROUP=openproject
APP_HOME=/opt/openproject
APP_NAME=openproject
APP_RUNNER_CLI=initctl
APP_RUNNER_TYPE=upstart
APP_SAFE_NAME=openproject
APP_USER=openproject
APP_WIZARDS=legacy-installer,mysql,apache2,svn-dav,smtp,memcached,openproject
GEM_PATH=/opt/openproject/vendor/bundle/ruby/2.1.0:
HOME=/home/openproject
LANG=en_US.UTF-8
MEMORY_AVAILABLE=512
NODE_HOME=/opt/openproject/.heroku/node
OLDPWD=/home/mohammed
ORIGINAL_PWD=/home/mohammed
PATH=/opt/openproject/bin:/opt/openproject/vendor/bundle/bin:/opt/openproject/vendor/bundle/ruby/2.1.0/bin:/opt/openproject/.heroku/node/bin:/opt/openproject/bin:/opt/openproject/node_modules/.bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin:.:/usr/sbin
PORT=6000
PWD=/opt/openproject
RACK_ENV=production
RAILS_ENV=production
ROOT_PATH=/
SHLVL=0
WEB_CONCURRENCY=1
WEB_MEMORY=512
root@openproject:/home/mohammed#@

Thanks for help ^_

also this is outpu ot #service openproject status

rootopenproject:/home/mohammed# service openproject status
● openproject.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)
root@openproject:/home/mohammed# @

Hi Mohammed,

did you install the mysql server during the installation process. Seems to me that mysql is not installed. Is that possible?

Cheers,
Karsten

Hi Karsten,
nops, i already installed MySQL Server and Apache2 also SMTP before even start the operation of installing openproject.

Thanks,
Mohammed

Hi Mohammed,

ok just to get that right: You installed Apache2 and MySQL before you installed OpenProject and that is why you chose not to install MySQL and Apache2 during the installation of OpenProject?

This is important because if that is true the configuration of Apache and MySQL did not took place and therefore your installation is somehow broken.

Cheers,
Karsten

Hi Karsten,
during the installation of openproject he asked me to install apache2 nd i said ok but for MySQL i don’t remember that the installer asked me to install it, maybe he is installing mysql in the background whit out asking but i’m sure that i tolled him to install apache2 during installation to make sure that every thing is ok for OP. However in the end of installation i remember very well that he tolled me something about the password of MySQl is not existe and that broke my installation after that message i executed the command in the above and the rest you know it ^_ this is My story.

Mohammed,

Hi Mohammed,

ok so your Database ist not set. That is something we should be able to fix ;-) …

Please run openproject reconfigure and try to fix the installation. The important part is when the wizard asks about your MySQL connection. I have to admit right now I do no know the exact saying but it should be able to choose something like “use existing database”. It will then ask for your credentials — MySQL user and stuff.

Hopefully this helps. If not I have to spin up a VM myself and have a look about the exact things the wizard is asking.

Cheers,
Karsten

i run openproject reconfigure nd this is what i got :

Enabling site openproject. To activate the new configuration, you need to run: service apache2 reload [svn-dav] ./bin/postinstall cp: cannot create regular file '/usr/lib/perl5/Apache/': No such file or directory rootopenproject:/home/mohammed# cd /usr/lib/perl5/Apache/
bash: cd: /usr/lib/perl5/Apache/: No such file or directory
root@openproject:/home/mohammed# @

Hi Mohammed,

I assume this is not a production system and you have a backup of all your important things right? I suggest running the reconfigure command again and install apache modul so it will make the necessary updates and configurations.

Perl is used for authentication which is obviously not installed by your current installation. So that is a problem.

Cheers,
Karsten

the same thing :

@perl: warning: Falling back to a fallback locale (“en_US.UTF-8”).
Site openproject already enabled

[svn-dav] ./bin/postinstall
cp: cannot create regular file ‘/usr/lib/perl5/Apache/’: No such file or directory@

i think i should go back and restore my vps to first snapshot and re-installing the OP again.

If that is possible go for it. I suggest not to install Apache and MySQL before installing OpenProject.

Cheers,
Karsten

Hi Karsten,
i restored my system, but i need a good tuto t installl OP :/ because all documentations that i have 80% chance up to get errors.

Mohammed,

What about the official documentation at https://www.openproject.org/open-source/packaged-installation/packaged-installation-core/. It should be a good starting point. Unfortunately I do not know any other source which is better suited.

Maybe you can try this one and give feedback on things which are unclear. Even better you can do that be making a Pull Request on github because the documentation is open source and can be changed (https://github.com/opf/openproject/blob/release/4.2/doc/operation_guides/packager/installation-guide.md).

You even might want to install the community edition instead because it has a wider feature set. Have a look here https://github.com/opf/openproject/blob/release/4.2/doc/operation_guides/packager/installation-guide-ce.md.

Cheers,
Karsten

Could someone from OpenProject please add to this/explain how to install OpenProject on a server that already has Apache (and MySQL)?

Will the installation script mess up an existing Apache installation? When it says 'install apache', will it actually configure apache if it already exists and leave existing PHP/MySQL sites unaffected? Or will it just overwrite assuming that it is an empty server?

I can't find a clear answer to this very basic question anywhere. I have been stuck on this point for weeks now. Advice 'not to install Apache and MySQL before installing OpenProject' completely misses the point. I am trying to install OpenProject in a subfolder of an existing site - my company site, a logical place for a project management script. That existing site is a regular PHP/MySQL/Apache site. This will be a common use case and I am obviously not the only one struggling to make this work.

Can anybody help with this?

sudo openproject run check
[ok] MySQL configuration is working
[ko] Web server is NOT running
[ok] openproject server is running
[ok] openproject background job worker is running
/then there is a problem with email, but that's nothing/

So here is the story:

upgraded Ubuntu 18.04 to 20.04,

installed DirectAdmin, and CSF (previously none),

previously existing OP was in mydomain.com/op

but after upgrade and install as above stopped working, ie. this webpage mydomain.com/op returns

'The requested URL was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.'

but DirectAdmin displays mydomain.com

So, what I did was reconfigured OP, changing /op to directly mydomain.com

Still nothing. Results as above. On mydomain.com there is DirectAdmin message displayed.

I am a noob, know little. My guess is there is a conflict between apache2 and DirectAdmin (both are servers kinda of).

sudo openproject config
ADMIN_EMAIL=myemail@domain.com
APP_GROUP=openproject
APP_HOME=/opt/openproject
APP_NAME=openproject
APP_RUNNER_CLI=systemctl
APP_RUNNER_TYPE=systemd
APP_SAFE_NAME=openproject
APP_USER=openproject
APP_WIZARDS=legacy-installer,openproject-edition,postgres,apache2,repositories,smtp,memcached,openproject
ATTACHMENTS_STORAGE_PATH=/var/db/openproject/files
DATABASE_URL=postgres://openproject:xxxxxxxxxxxxxxxxxx@127.0.0.1:45432/openproject
EMAIL_DELIVERY_METHOD=smtp
EXECJS_RUNTIME=Node
GEM_PATH=/opt/openproject/vendor/bundle/ruby/2.7.0:
GIT_REPOSITORIES=
HOME=/home/openproject
HOST=127.0.0.1
LANG=en_US.UTF-8
MALLOC_ARENA_MAX=2
MEMCACHED_SERVERS=tcp://127.0.0.1:11211
MEMORY_AVAILABLE=14336
NODE_ENV=production
NODE_HOME=/opt/openproject/.heroku/node
OLDPWD=/
OPENPROJECT_INSTALLATION__TYPE=packager
OPENPROJECT_RAILS__FORCE__SSL=true
ORIGINAL_PWD=/xxxxxx
PATH=bin:/opt/openproject/vendor/bundle/bin:/opt/openproject/vendor/bundle/ruby/2.7.0/bin:/opt/openproject/.heroku/node/bin:/opt/openproject/.heroku/yarn/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/sbin:/opt/openproject/bin:/opt/openproject/node_modules/.bin
PORT=6000
PWD=/opt/openproject
RACK_ENV=production
RAILS_CACHE_STORE=memcache
RAILS_ENV=production
RAILS_LOG_TO_STDOUT=enabled
RAILS_RELATIVE_URL_ROOT=
RAILS_SERVE_STATIC_FILES=enabled
RECOMPILE_RAILS_ASSETS=
ROOT_PATH=/
SECRET_KEY_BASE=xxxxxxxxxxxxxxxxxxxxxxxxx
SECRET_TOKEN=xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SERVER_GROUP=www-data
SERVER_HOSTNAME=mydomain.com
SERVER_PATH_PREFIX=/
SERVER_PATH_PREFIX_PREVIOUS=/op/
SERVER_PROTOCOL=https
SERVER_USER=www-data
SHLVL=0
SMTP_AUTHENTICATION=login
SMTP_DOMAIN=mydomain.com
SMTP_HOST=domain.com
SMTP_PASSWORD=xxxxx
SMTP_PORT=25
SMTP_URL=smtp://xxxxx
SMTP_USERNAME=xxxxxxx
SVN_REPOSITORIES=
SYS_API_KEY=xxxxxxx
WEB_CONCURRENCY=28
WEB_MEMORY=512
WEB_TIMEOUT=300

What to do, good people, tell me, help me, and I will sing you a song.

Cheers,

Piotr

Hey everyone,

I'm sorry to hear about the issues you're facing with MySQL and your web server. It can be irritating when things do not work as expected, especially when you've got followed a tutorial. Based on the error message you shared, it looks like there are a few problems that want to be addressed.

Firstly, the MySQL connection is not working, which shows that there might be an trouble with the configuration or setup of your MySQL database. You may desire to double-check the credentials and ensure that the MySQL provider is running properly.

Secondly, the net server is not running, which suggests that there would possibly be a problem with the internet server configuration or it might now not be started correctly. You can test the web server logs for any error messages that may want to provide extra insight into the issue.

Regarding the missing ADMIN_EMAIL, you need to set the email settings properly in order to test them. Make sure to provide the necessary information such as the email address to resolve this problem.

It's important to remain calm and systematically troubleshoot the issues step by step. You might find helpful resources in the OpenProject documentation or forums where others have encountered similar problems.