Top Menu

Jump to content
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    Home
    • 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

      OpenProject ID Google

Side Menu

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

Content

Expand project menu
Support Installation & Updates
  1. OpenProject Community
  2. OpenProject
  3. Forums
  4. Support Installation & Updates
  5. Reinstallation? Connection to MySQL server failed

Reinstallation? Connection to MySQL server failed

Added by Alasdair McAndrew about 8 years ago

I completely wiped my original openproject installation, and dumped the database into a file using mysqldump. I then restored the database preparatory to reinstalling openproject. But I simply am unable to connect to the MySQL server. I’ve checked all the parameters with `openproject config:get DATABASE_URL`, and I’ve entered these as I go into the wizard opened up by “openproject reconfigure”. But (and I’ve tried this maybe 10, 20 times, with all sorts of configurations), the end result is the same: “Connection to MySQL server failed”.

I have created the “opadmin” user in MySQL and given it all privileges to the openproject database. But no luck.

And help would be gratefully received!

FWIW: System is Ubuntu 14.04, openproject most recent version installed as a package using apt-get.

Thanks very much,
Alasdair

(Initial post below.)

About a year or so ago I installed Openproject on my VPS running Ubuntu 14.04 and Apache. It worked fine, until something I did stopped it working: attempts to log into it on the server just came up with a directory listing.

So I thought I’d clear the lot and start afresh. With regards to that I have a few questions:

  1. How do I recover any files from the original Openproject installation? Do I have to dig them out of a MySQL database, or would they be sitting in a directory somewhere?
  2. How can I completely eliminate the old Openproject from the system: databases and all, before installing a completely new version?

Thank you very much!

cheers,
Alasdair


Replies (3)

RE: Reinstallation? - Added by Oliver Günther about 8 years ago

Hi Alasdair,

OpenProject has two locations where it stores data:

1. Database. If you’re not planning to install on the same server, dump and restore it to the new server. The package wizard allows you to specify an existing database, so the new version will simply migrate your old data during the new installation

2. Attachments. In a packaged installation, these are by default in /var/db/openproject/files. In a manual installation, the default is <OpenProject root>/files. Backup these somewhere.

if you installed OpenProject using the package installer, you will want to simply uninstall the package and remove /opt/openproject/. In a manual installation, you can remove the openproject user home and remove the user with userdel.

To install the current stable version, use the packaged installation guide . In the wizard step, choose existing database and specify the database you created in step 1.
After the installation is complete, copy attachments into /var/db/openproject/files.

Best,
Oliver

RE: Reinstallation? - Added by Alasdair McAndrew about 8 years ago

Many thanks. I’ve done that, but I can’t run the command ‘sudo openproject configure’ - it gives me errors :

    ERROR 2003 (HY000): Can't connect to MySQL server on 'mysite.net' (111)

    cannot initialize curses

    cannot initialize curses
    MySQL configuration canceled.

I’m not sure what’s going on here… maybe I should do a manual installation?

RE: Reinstallation? - Added by Oliver Günther about 8 years ago

1. Is that the only output from openproject configure ?

2. What distribution are you on and which OP package version have you installed?

3. Please verify that the MySQL credentials you entered in the wizard are valid. You can find these values in /etc/openproject/installer.dat.

Best,
Oliver

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