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

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. MySQL and Web server not working

MySQL and Web server not working

Added by BAHADDOU Mohammed over 9 years ago

Hello, i installed openproject on my server ubuntu 15.04 , i followed this totu. https://www.youtube.com/watch?v=twhJclA2xRY . ut for sorry when i tried to check my work with thise command : “sudo openproject run check” i got this :
@
root@openproject:/etc/openproject# sudo openproject run check
[ko] MySQL connection is NOT working
[ko] Web server is NOT running
[ok] openproject server is running
[ok] openproject background job worker is running
[ko] no ADMIN_EMAIL set. Can’t test email settings.@

Please help me my boss notifying me every hour :(

Mr Mohammed BAHADDOU
IT-Systems Administrator & WebMaster


Replies (17)

RE: MySQL and Web server not working - Added by Jonas Heinrich (Finn) over 9 years ago

Hi Mohammed,

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

Best,

Jonas

RE: MySQL and Web server not working - Added by BAHADDOU Mohammed over 9 years ago

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 _

RE: MySQL and Web server not working - Added by BAHADDOU Mohammed over 9 years ago

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# @

RE: MySQL and Web server not working - Added by Karsten Gallinowski over 9 years ago

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

RE: MySQL and Web server not working - Added by BAHADDOU Mohammed over 9 years ago

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

Thanks,
Mohammed

RE: MySQL and Web server not working - Added by Karsten Gallinowski over 9 years ago

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

RE: MySQL and Web server not working - Added by BAHADDOU Mohammed over 9 years ago

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,

RE: MySQL and Web server not working - Added by Karsten Gallinowski over 9 years ago

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

RE: MySQL and Web server not working - Added by BAHADDOU Mohammed over 9 years ago

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# @

RE: MySQL and Web server not working - Added by Karsten Gallinowski over 9 years ago

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

RE: MySQL and Web server not working - Added by BAHADDOU Mohammed over 9 years ago

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.

RE: MySQL and Web server not working - Added by Karsten Gallinowski over 9 years ago

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

Cheers,
Karsten

RE: MySQL and Web server not working - Added by BAHADDOU Mohammed over 9 years ago

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,

RE: MySQL and Web server not working - Added by Karsten Gallinowski over 9 years ago

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

RE: MySQL and Web server not working - Added by Peter Verkooijen about 5 years ago

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.

RE: MySQL and Web server not working - Added by Piotr F about 4 years ago

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

RE: MySQL and Web server not working - Added by Stef Heisel almost 2 years ago

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.

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