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. MySQL connection not working

MySQL connection not working

Added by Dan White almost 9 years ago

Hello community,

my Linux knowledge isn’t sufficient to solve this problem, so I wanted to ask you.
I tried to install OP on a Ubuntu 16.04 VM with the package.io method. So far so good, with the ‘sudo’ command to ensure all the necessary rights.
I can’t see any obvious error message while using the installer, though the openproject run check says the MySQL connection isn’t working even though it has been installed. Webserver and OP server get an ok and now I have basically no idea where to configure the connection or even look for errors.
I hope, you might have a clue or advise for me because I’m a novice in setting up something like this.
Thanks!


Replies (2)

RE: MySQL connection not working - Added by Oliver Günther almost 9 years ago

Hey Dan,

did you select the Autoinstall MySQL database in the first steps of the installer?
If that is the case, and you previously had an installation of MySQL on your VM, the wizard will not be able to set up the database simply because it does not have the permissions to do so.

If that VM does not use the database for anything else, you can sudo apt-get purge mysql.server.5.7 (5.7. I believe is the current version in 16.04. LTS, please verify with sudo dpkg -l | grep mysql-server).
Afterwards, restart the wizard using openproject reconfigure.

If you did use the database previously for other services, please set up a user + database manually for OpenProject and choose the Existing MySQL installation in the reconfigure wizard.

Best,
Oliver

RE: MySQL connection not working - Added by Dan White almost 9 years ago

Hey Oliver,

thank you for the quick reply! :)
I did choose the Autoinstall MySQL, it was a fresh VM.
Nevertheless I purged it and restarted the wizard just for a new installation of MySQL.
Service is running, and now I have an actual error message at the end:
“ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)”
Which makes me wonder, why does the standard MySQL login not work?
The wizard does create a user with randomized password, doesn’t it? I guess it’s the openproject:password combination within the DATABASE_URL in the openproject config, if this user is created at all at this moment.

I can’t get access to the MySQL, with root nor openproject user. So the problem is just about the login credentials, isn’t it? Or do I miss anything of importance?
Just for the “fun” of it I’ve started the manual installation and wanted to try if I can set the root password myself. No luck because there wasn’t a request to enter any. service mysql status is active and running, no chance to login via mysql -u root though. :-/
If you could help me once more, I would be very grateful!

Best,
Dan

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