Upgrading Redmine from old 2.6 version to newer - MySQL to MSSQL - Redmine

Upgrading Redmine from old 2.6 version to newer - MySQL to MSSQL

Hello everybody,

I'm starting to dig into the upgrade of an old 2.6 Bitnami Redmine version.
The only plugin I really need to keep is (well, the feature more than the plugin): Redmine LDAP Sync

I'd like to move to docker as we have a docker instance.
Database from Mysql to MSSQL ==> Already copied schema and data using SSMA tool from microsoft

If I did my homeworks well, I need to go through all those versions to upgrade the database :

2.6.x to 3.0.x
3.0.x to 3.4.x
3.4.x to 4.0.x
4.0.x to 4.1.x
4.1.x to 4.2.x
4.2.x to 5.0.x (latest)

Here is the docker compose I'm using:

 redmine:
    image: redmine:3.0.4
    container_name: redmine
    restart: always
    environment:
      REDMINE_DB_MYSQL: "false" 
      REDMINE_DB_ADAPTER: "sqlserver" 
      REDMINE_DB_DATABASE: "Test" 
      REDMINE_DB_HOST: "MyServer" 
      REDMINE_DB_PORT: "1433" 
      REDMINE_DB_USERNAME: "db_user" 
      REDMINE_DB_PASSWORD: "db_password" 
      REDMINE_DB_SCHEMA: "bitnami_redmine" 
      VIRTUAL_HOST: "redmine.mydomain.com" 
    ports:
      - "3000:3000" 
    volumes:
      - REDMINE_DATA:/usr/src/redmine/files
    networks:
      - common_network

The thing is it won't connect to DB.
Error in the log is :
warning: missing MYSQL_PORT_3306_TCP or POSTGRES_PORT_5432_TCP environment variables

is it missing something to connect to MSSQL ?

Replies (1)

RE: Upgrading Redmine from old 2.6 version to newer - MySQL to MSSQL - Added by Holger Just 5 months ago

Likely, the Docker image for Redmine 3.0 did not yet support MSSQL Server (support for which was quite new in Redmine at that time).

In any case though, you don't need to upgrade in steps. Redmine supports single-step updates from any previous version to its latest version. As such, you should be able to update directly from your ancient Redmine 2.6 to a current Redmine 5.1.3.

(Also please note that the Redmine project does not maintain any Docker images. The so called Official Docker image is maintained entirely by external maintainers. Thus, any issues with the Docker images are more likely to be resolved at their issue tracker.

(1-1/1)

Project

General

Profile

Redmine