gitlab on QNAP

gitlab.yaml

gitlab:
  environment:
    DEBUG: 'false'
    GITLAB_PORT: 10080
    GITLAB_SECRETS_DB_KEY_BASE: qcs-gitlab-app
    GITLAB_SSH_PORT: 10022
    GITLAB_SECRETS_SECRET_KEY_BASE: randomrandomrandom
    GITLAB_SECRETS_OTP_KEY_BASE: hogehogehoge12345
  image: sameersbn/gitlab:10.4.4
  links:
  - redis:redisio
  - postgresql:postgresql
  ports:
  - 10080:80
  - '10022:22'
  restart: always
postgresql:
  environment:
    DB_EXTENSION: pg_trgm
    DB_NAME: gitlabhq_production
    DB_PASS: password
    DB_USER: gitlab
  image: sameersbn/postgresql:latest
  restart: always
redis:
  command:
  - --loglevel warning
  image: sameersbn/redis:latest
  restart: always

guacamole.yaml

guacamole:
  image: guacamole/guacamole
  environment:
    DEBUG: 'false'
    GUACD_HOSTNAME: 133.71.3.147
    MYSQL_DATABASE: guacamole
    MYSQL_HOSTNAME: 133.71.3.147
    MYSQL_USER: guacamole
    MYSQL_PASSWORD: Gkyrx8xctcdPiOSM
  ports:
    - 4823:8080
guacd:
  environment:
    DEBUG: 'false'
  image: guacamole/guacd
  ports:
    - 4822:4822

sql

REATE TABLE `guacamole_connection_group` (                                                                                                                                                                                     
                                                                                                                                                                                                                                
  `connection_group_id`   int(11)      NOT NULL AUTO_INCREMENT,                                                                                                                                                                 
  `parent_id`             int(11),                                                                                                                                                                                              
  `connection_group_name` varchar(128) NOT NULL,                                                                                                                                                                                
  `type`                  enum('ORGANIZATIONAL',                                                                                                                                                                                
                               'BALANCING') NOT NULL DEFAULT 'ORGANIZATIONAL',                                                                                                                                                  
                                                                                                                                                                                                                                
  -- Concurrency limits                                                                                                                                                                                                         
  `max_connections`          int(11),                                                                                                                                                                                           
  `max_connections_per_user` int(11),                                                                                                                                                                                           
  `enable_session_affinity`  boolean NOT NULL DEFAULT 0,                                                                                                                                                                        
                                                                                                                                                                                                                                
  PRIMARY KEY (`connection_group_id`),                                                                                                                                                                                          
  UNIQUE KEY `connection_group_name_parent` (`connection_group_name`, `parent_id`),       
                                                                                                                                                                                                                                  
  CONSTRAINT `guacamole_connection_group_ibfk_1`                                                                                                                                                                                
    FOREIGN KEY (`parent_id`)                                                                                                                                                                                                   
    REFERENCES `guacamole_connection_group` (`connection_group_id`) ON DELETE CASCADE                                                                                                                                           
                                                                                                                                                                                                                                
) ENGINE=InnoDB DEFAULT CHARSET=utf8;                                                                                                                                                                                           
                                                                                                                                                                                                                                
--                                                                                                                                                                                                                              
-- Table of connections. Each connection has a name, protocol, and                                                                                                                                                              
-- associated set of parameters.                                                                                                                                                                                                
-- A connection may belong to a connection group.                                                                                                                                                                               
--                                                                                                                                                                                                                              
                                                                                                                                                                                                                                
CREATE TABLE `guacamole_connection` (                                                                                                                                                                                           
                                                                                                                                                                                                                                
  `connection_id`       int(11)      NOT NULL AUTO_INCREMENT,                                                                                                                                                                   
  `connection_name`     varchar(128) NOT NULL,                                                                                                                                                                                  
  `parent_id`           int(11),                                                                                                                                                                                                
  `protocol`            varchar(32)  NOT NULL,                                                                                                                                                                                  
                                                                                                                                                                                                                                
  -- Guacamole proxy (guacd) overrides                                                                                                                                                                                          
  `proxy_port`              integer,                                                                                                                                                                                            
  `proxy_hostname`          varchar(512),                                                                                                                                                                                       
  `proxy_encryption_method` enum('NONE', 'SSL'),                                                                                                                                                                                
                                                                                                                                                                                                                                
  -- Concurrency limits                                                                                                                                                                                                         
  `max_connections`          int(11),                                                                                                                                                                                           
  `max_connections_per_user` int(11),                                                                                                                                                                                           
                                                                                                                                                                                                                                
  -- Load-balancing behavior                                                                                                                                                                                                    
  `connection_weight`        int(11),                                                                                                                                                                                           
  `failover_only`            boolean NOT NULL DEFAULT 0,                                                                                                                                                                        
                                                                                                                                                                                                                                
  PRIMARY KEY (`connection_id`),                                                                                                                                                                                                
  UNIQUE KEY `connection_name_parent` (`connection_name`, `parent_id`),                                                                                                                                                         
                                                                                                                                                                                                                                
  CONSTRAINT `guacamole_connection_ibfk_1`                                                                                                                                                                                      
    FOREIGN KEY (`parent_id`)                                                                 
    REFERENCES `guacamole_connection_group` (`connection_group_id`) ON DELETE CASCADE                                                                                                                                           
                                                                                                                                                                                                                                
) ENGINE=InnoDB DEFAULT CHARSET=utf8;                                                                                                                                                                                           
                                                                                                                                                                                                                                
--                                                                                                                                                                                                                              
-- Table of users. Each user has a unique username and a hashed password                                                                                                                                                        
-- with corresponding salt. Although the authentication system will always set                                                                                                                                                  
-- salted passwords, other systems may set unsalted passwords by simply not                                                                                                                                                     
-- providing the salt.                                                                                                                                                                                                          
--                                                                                                                                                                                                                              
                                                                                                                                                                                                                                
CREATE TABLE `guacamole_user` (                                                                                                                                                                                                 
                                                                                                                                                                                                                                
  `user_id`       int(11)      NOT NULL AUTO_INCREMENT,                                                                                                                                                                         
                                                                                                                                                                                                                                
  -- Username and optionally-salted password                                                                                                                                                                                    
  `username`      varchar(128) NOT NULL,                                                                                                                                                                                        
  `password_hash` binary(32)   NOT NULL,                                                                                                                                                                                        
  `password_salt` binary(32),                                                                                                                                                                                                   
  `password_date` datetime     NOT NULL,                                                                                                                                                                                        
                                                                                                                                                                                                                                
  -- Account disabled/expired status                                                                                                                                                                                            
  `disabled`      boolean      NOT NULL DEFAULT 0,                                                                                                                                                                              
  `expired`       boolean      NOT NULL DEFAULT 0,                                                                                                                                                                              
                                                                                                                                                                                                                                
  -- Time-based access restriction                                                                                                                                                                                              
  `access_window_start`    TIME,                                                                                                                                                                                                
  `access_window_end`      TIME,                                                                                                                                                                                                
                                                                                                                                                                                                                                
  -- Date-based access restriction                                                                                                                                                                                              
  `valid_from`  DATE,                                                                                                                                                                                                           
  `valid_until` DATE,                                                                                                                                                                                                           
                                                                                                                                                                                                                                
  -- Timezone used for all date/time comparisons and interpretation                                                                                                                                                             
  `timezone` VARCHAR(64),                                                                                                                                                                                                       
                                                                                                                                                                                                                                
  -- Profile information                                                                                                                                                                                                        
  `full_name`           VARCHAR(256),                                                              
  `email_address`       VARCHAR(256),                                                                                                                                                                                           
  `organization`        VARCHAR(256),                                                                                                                                                                                           
  `organizational_role` VARCHAR(256),                                                                                                                                                                                           
                                                                                                                                                                                                                                
  PRIMARY KEY (`user_id`),                                                                                                                                                                                                      
  UNIQUE KEY `username` (`username`)                                                                                                                                                                                            
                                                                                                                                                                                                                                
) ENGINE=InnoDB DEFAULT CHARSET=utf8;                                                                                                                                                                                           
                                                                                                                                                                                                                                
--                                                                                                                                                                                                                              
-- Table of sharing profiles. Each sharing profile has a name, associated set                                                                                                                                                   
-- of parameters, and a primary connection. The primary connection is the                                                                                                                                                       
-- connection that the sharing profile shares, and the parameters dictate the                                                                                                                                                   
-- restrictions/features which apply to the user joining the connection via the                                                                                                                                                 
-- sharing profile.                                                                                                                                                                                                             
--                                                                                                                                                                                                                              
                                                                                                                                                                                                                                
CREATE TABLE guacamole_sharing_profile (                                                                                                                                                                                        
                                                                                                                                                                                                                                
  `sharing_profile_id`    int(11)      NOT NULL AUTO_INCREMENT,                                                                                                                                                                 
  `sharing_profile_name`  varchar(128) NOT NULL,                                                                                                                                                                                
  `primary_connection_id` int(11)      NOT NULL,                                                                                                                                                                                
                                                                                                                                                                                                                                
  PRIMARY KEY (`sharing_profile_id`),                                                                                                                                                                                           
  UNIQUE KEY `sharing_profile_name_primary` (sharing_profile_name, primary_connection_id),                                                                                                                                      
                                                                                                                                                                                                                                
  CONSTRAINT `guacamole_sharing_profile_ibfk_1`                                                                                                                                                                                 
    FOREIGN KEY (`primary_connection_id`)                                                                                                                                                                                       
    REFERENCES `guacamole_connection` (`connection_id`)                                                                                                                                                                         
    ON DELETE CASCADE                                                                                                                                                                                                           
                                                                                                                                                                                                                                
) ENGINE=InnoDB DEFAULT CHARSET=utf8;                                                                                                                                                                                           
                                                                                                                                                                                                                                
--                                                                                                                                                                                                                              
-- Table of connection parameters. Each parameter is simply a name/value pair                                                                                                                                                   
-- associated with a connection.                                                                                                                                                                                                
--