Customize Xibo Docker Using Remote MySQL

Get Help
1

Hi,

I’m relatively new to Xibo, already tried everything to make it run but nothing works,
Here’s my server :

  • Ubuntu 18.04
  • PHP 7.2
  • MySQL 5.7.22
  • Apache

What i want to achieve is make Xibo using docker to run with external DB using MySQL in my server above.

Here’s what i have done so far

  1. I created database in MySQL server named Xibo , also with user and grant all privileges
  2. I copied the configuration remote template , named it as conf.env , and i put the detail of my database setting above :
  • MYSQL_HOST=localhost
  • MYSQL_PORT=3306
  • MYSQL_DATABASE=xibo
  • MYSQL_USER=xibouser
  • MYSQL_PASSWORD=xibopassword
  1. For the cms_remote-mysql.yml , i change the web server port to 8080

Then i run : docker-compose -f cms_remote-mysql.yml up -d

But still no luck, it’s not working.

** Here’s the result for docker-compose logs | more

cms-db:
        environment:
          CMS_PHP_MAX_EXECUTION_TIME: '600'
          CMS_PHP_POST_MAX_SIZE: 4G
          CMS_PHP_UPLOAD_MAX_FILESIZE: 4G
          CMS_SERVER_NAME: xxx
          CMS_SMTP_FROM_LINE_OVERRIDE: "YES"
          CMS_SMTP_HOSTNAME: xxx
          CMS_SMTP_PASSWORD: xxxyyy
          CMS_SMTP_REWRITE_DOMAIN: xxx
          CMS_SMTP_SERVER: smtp.gmail.com:587
          CMS_SMTP_USERNAME: xxxyyy
          CMS_SMTP_USE_STARTTLS: "YES"
          CMS_SMTP_USE_TLS: "YES"
          MYSQL_DATABASE: cms
          MYSQL_HOST: localhost
          MYSQL_PASSWORD: xibopassword
          MYSQL_PORT: '3306'
          MYSQL_RANDOM_ROOT_PASSWORD: "yes"
          MYSQL_USER: cms
        image: mysql:5.6
        mem_limit: 1g
        restart: always
        volumes:
        - /opt/xibo/shared/db:/var/lib/mysql:rw
      cms-web:
        environment:
          CMS_PHP_MAX_EXECUTION_TIME: '600'
          CMS_PHP_POST_MAX_SIZE: 4G
          CMS_PHP_UPLOAD_MAX_FILESIZE: 4G
          CMS_SERVER_NAME: xxx
          CMS_SMTP_FROM_LINE_OVERRIDE: "YES"
          CMS_SMTP_HOSTNAME: xxx
          CMS_SMTP_PASSWORD: xxxyyy
          CMS_SMTP_REWRITE_DOMAIN: xxx
          CMS_SMTP_SERVER: smtp.gmail.com:587
          CMS_SMTP_USERNAME: xxxyyy
          CMS_SMTP_USE_STARTTLS: "YES"
          CMS_SMTP_USE_TLS: "YES"
          MYSQL_DATABASE: xibo
          MYSQL_HOST: localhost
          MYSQL_PASSWORD: xibopassword
          MYSQL_PORT: '3306'
          MYSQL_USER: xibouser
          XMR_HOST: cms-xmr
        image: xibosignage/xibo-cms:release-1.8.9
        links:
        - cms-db:mysql
        - cms-xmr:50001
        mem_limit: 1g
        ports:
        - 80:80/tcp
        restart: always
        volumes:
        - /opt/xibo/shared/cms/custom:/var/www/cms/custom:rw
        - /opt/xibo/shared/backup:/var/www/backup:rw
        - /opt/xibo/shared/cms/web/theme/custom:/var/www/cms/web/theme/custom:rw
        - /opt/xibo/shared/cms/library:/var/www/cms/library:rw
        - /opt/xibo/shared/cms/web/userscripts:/var/www/cms/web/userscripts:rw
      cms-xmr:
        environment:
          CMS_PHP_MAX_EXECUTION_TIME: '600'
          CMS_PHP_POST_MAX_SIZE: 4G
          CMS_PHP_UPLOAD_MAX_FILESIZE: 4G
          CMS_SERVER_NAME: xxx
          CMS_SMTP_FROM_LINE_OVERRIDE: "YES"
          CMS_SMTP_HOSTNAME: xxx
          CMS_SMTP_PASSWORD: xxxyyy
          CMS_SMTP_REWRITE_DOMAIN: xxx
          CMS_SMTP_SERVER: smtp.gmail.com:587
          CMS_SMTP_USERNAME: xxxyyy
          CMS_SMTP_USE_STARTTLS: "YES"
          CMS_SMTP_USE_TLS: "YES"
          MYSQL_DATABASE: xibo
          MYSQL_HOST: localhost
          MYSQL_PASSWORD: xibopassword
          MYSQL_PORT: '3306'
          MYSQL_USER: xibouser
        image: xibosignage/xibo-xmr:release-0.7
        mem_limit: 256m
        ports:
        - 9505:9505/tcp
        restart: always
    version: '2.1'

Weird things is that in the DB section , it won’t take the configuration from config.env.
It automatically put different DB names , and user

Can someone help me how to solve this problem?

Thanks