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
    • 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
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

Unable to 'Use existing Database' at install

Added by Joel Small over 9 years ago

I’ve been able to set up OP on Amazon AWS using both the bitnami loader and by using the package-ce installer.

Both work correctly after first install, however I can’t seem to get them to an existing database not on localhost. Instead of connecting to my mysql server on a different machine, The application attempts to connect to localhost via my network address.

I’m using the automated installer, and have also set the environment variable for DATABASE_URL. Neither have helped.

Has anyone attempted this before and come up with a solution?

EG, my database url is:

DATABASE_URL=mysql2://user:password@mysql1.region.rds.amazonaws.com:3306/openproject_ce

and the error i get is:
Mysql2::Error: Access denied for user ‘user’@‘172.xxx.xxx.xxx’ (using password: YES)

How do i force the connection to use the database as I have specified?


Replies (5)

RE: Unable to 'Use existing RDS Database' at install - Added by Ron Meske about 8 years ago

Hello,

I am running into the same issue with the latest build. Is there any guidence on how to setup OpenProject on AWS using an RDS server as the database server?

Regards,
Ron

RE: Unable to 'Use existing Database' at install - Added by Joel Small about 8 years ago

I admit I haven’t tried again since. Instead i used a local mysql install. Not ideal, but I wasn’t getting any more info from the forums here :(.

How are you running up your app? I was doing it on a ubuntu image.

RE: Unable to 'Use existing Database' at install - Added by Ron Meske about 8 years ago

Success!

There was a bug for setting up SMTP email where the password was not being encoded and some characters did not work at all. I did a reconfigure and tried encoding the password. This solved my problem.

I am also using an Ubuntu image, version 14.04.

RE: Unable to 'Use existing Database' at install - Added by Cyril Rohr about 8 years ago

In case it helps, you can also see the full list of environment variables currently used by doing a openproject config, and you can also get a specific env variable by running e.g. openproject config:get DATABASE_URL. This way you can check whether your config is correct. Also, remember to service openproject restart if you manually update the configuration.

RE: RE: Unable to 'Use existing Database' at install - Added by Moutonjr NotApplicable about 5 years ago

Hi @Cyril Rohr:

IS there any documentation where we can get the whole set of env vars we can use?

It would be awesome to perform full install based upon all options at once, explained (here it's a bit messy).

Regards,

-- moutonjr

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