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

Migrating from MySQL to Postgres: Unexpected EOF

Added by Tero Ollikainen over 5 years ago

Hi,

I'm following the guide for migrating from MySQL to Postgres database and I'm at the step where I have to set the database to point to the new Postgres, so I'm using these command from the guide:

openproject config:set MYSQL_DATABASE_URL="$(openproject config:get DATABASE_URL)"
openproject config:get MYSQL_DATABASE_URL

My console then outputs:
etc/openproject/conf.d/other: line 19: unexpected EOF while looking for matching "' etc/openproject/conf.d/other: line 19: unexpected EOF while looking for matching "'

Any idea what could be causing this? I have followed the guide to the letter. Should I just go poking around the file to overcome this?
I'm running the commands as root, and I'm using Ubuntu 18.04. I just upgraded Openproject from 8.3 to the latest before beginning the migration.

Thank you for your help,
_tero


Replies (3)

RE: Migrating from MySQL to Postgres: Unexpected EOF - Added by Oliver Günther over 5 years ago

Hi Tero,

What is line 19 of the /etc/openproject/conf.d/other file? It could be that your DATABASE_URL was not set which leaves your file with something like this export MYSQL_DATABASE_URL= which will result in an error. This file is bascially an env file that gets parsed by bash and now contains a syntax error.

Could you attach the other file here while redacting all passwords from it?

Best,

Oliver

RE: Migrating from MySQL to Postgres: Unexpected EOF - Added by Tero Ollikainen over 5 years ago

Hello Oliver,

Well thank you for the tip to look into the file. You know, I have no idea how this got there ( I must have done something silly in the console), but on line 18 there was:
Either log in as 'openproject', root, use sudo, or add sudo privileges for running openproject with your current user."
which I figured had no place in there. So I deleted it, and I have now completed the steps for the migration, and everything looks to be working great.

Thanks for your help!

Best regards,
Tero

RE: Migrating from MySQL to Postgres: Unexpected EOF - Added by mauro santini almost 5 years ago

Ciao Oliver,

I use the same thread as it is similar issue but with SMTP file which u can find copied below and the error is:

/etc/openproject/conf.d/smtp: line 9: unexpected EOF while looking for matching `"'

SMTP file.

export EMAIL_DELIVERY_METHOD="smtp"
export ADMIN_EMAIL="m.sanXXXXX@YYYYY.it"
export SMTP_AUTHENTICATION="login"
export SMTP_HOST="smtp.gmail.com"
export SMTP_PORT="587"
export SMTP_USERNAME="m.sanXXXXXX@gmail.com"
export SMTP_PASSWORD="XXXXXXXXX"
export SMTP_DOMAIN=""
export SMTP_URL="smtp://m.sanXXXXX%40gmail.com:XXXXXXX@smtp.gmail.com:587/"

Cheers

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