Installing 5.0.6 on Synology with Portainer - No connection to external MySQL DB about docker-redmine HOT 6 CLOSED

The following command is used to check if mysql is reachable, can you try that as well.
mysqladmin -h ${DB_HOST} -P ${DB_PORT} -u ${DB_USER} ${DB_PASS:+-p$DB_PASS} status

from docker-redmine.

Note it might help to read through this issue as well
#399

As far as I can tell all of this works okay when the host is ubuntu so not sure what Synology is doing things differently.

from docker-redmine.

Hi jcormier,

I tryed you command in the SSH shell and get the following:

root@CCNAS01:~# docker exec -it CC_Redmine_Prod bash
root@cc_redmine_prod:/home/redmine/redmine# mysqladmin -h Synology_NAS_IP -P 3306 -u REDMINEDBUSER -pREDMINEDBPW status
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Uptime: 100519  Threads: 14  Questions: 30904  Slow queries: 0  Opens: 14477  Open tables: 10  Queries per second avg: 0.307
root@cc_redmine_prod:/home/redmine/redmine#

from docker-redmine.

Solved:

WRONG

      DB_USERNAME: REDMINEDBUSER
      DB_PASSWORD: REDMINEDBPW

CORRECT

      DB_USER: REDMINEDBUSER
      DB_PASS: REDMINEDBPW

And a big AND change the following:

    ports:
      #- 8059:3000
      - 8059:80
      - 8060:443

Now I'm in the loginpage and could change the PW for admin.

Hope this helps some one other who uses portainer on hin Synology NAS and would install Redmine with the MySQL from external.

from docker-redmine.

And for completeness, here are the yml for Redmine, deploying it via portainer.io on a Synology NAS in docker with an external MariaDB/MySQL Server:

version: '3.9'
services:
  redmine:
    image: sameersbn/redmine:latest
    container_name: Redmine_Prod
    hostname: redmine_prod
    environment:
      DB_ADAPTER: mysql2
      DB_HOST: <YOUR_SQLSRV_IP>
      DB_PORT: 3306
      DB_NAME: redmine
      DB_USER: redmine
      DB_PASS: redmine
    volumes:
      - /volume1/docker/redmine/files:/usr/src/redmine/files:rw
      - /volume1/docker/redmine/data:/home/redmine/data:rw
      - /volume1/docker/redmine/log:/var/log/redmine:rw
    ports:
      - 8059:80
      - 8060:443
    restart: always

Please keep in mind, if you are using an external SQL server, you first have to create the user and the database, otherwise it will not be working and don't forget to create the folders for the volumes ;)

Hope this save others hours of finding errors... I spend over 9h to get it functional, but it depends on my low experrience with docker.

Cheers,
Firehead

from docker-redmine.

Glad to hear it

from docker-redmine.