Little help with multisite configuration


(Michael Solomon) #1

Hey,
I think I very close to solution.
From this guide I understand that if I want to separate the web and the data containers for each site!
So if I want 2 websites my container folder should look like:

  1. openu_web.yml
  2. openu_data.yml
  3. second_site_web.yml
  4. second_site_data.yml

First I’m trying to create the first website with multi-site configuration:
This is my first site web_only file:

# IMPORTANT: SET A SECRET PASSWORD in Postgres for the Discourse User
# TODO: change SOME_SECRET in this template

templates:
  - "templates/web.template.yml"
  - "templates/web.ratelimited.template.yml"

expose:
  - "80:80"
  - "2222:22"

# Use 'links' key to link containers together, aka use Docker --link flag.
links:
  - link:
      name: openu_data
      alias: openu_data

# any extra arguments for Docker?
# docker_args:

params:
  ## Which Git revision should this container use? (default: tests-passed)
  #version: tests-passed

env:
  LANG: en_US.UTF-8
  ## TODO: How many concurrent web requests are supported?
  ## With 2GB we recommend 3-4 workers, with 1GB only 2
  ## If you have lots of memory, use one or two workers per logical CPU core
  UNICORN_WORKERS: 3

  ## TODO: configure connectivity to the databases
  DISCOURSE_DB_SOCKET: ''
  #DISCOURSE_DB_USERNAME: discourse
  DISCOURSE_DB_PASSWORD: myDiscourseUserPassword
  DISCOURSE_DB_HOST: openu_data
  DISCOURSE_REDIS_HOST: openu_data
  ##
  ## TODO: List of comma delimited emails that will be made admin and developer
  ## on initial signup example 'user1@example.com,user2@example.com'
  DISCOURSE_DEVELOPER_EMAILS: 'micheal540@gmail.com'
  ##
  ## TODO: The domain name this Discourse instance will respond to
  DISCOURSE_HOSTNAME: 'domain.com'
  ##
  ## Uncomment if you want the container to be started with the same
  ## hostname (-h option) as specified above (default "$hostname-$config")
  #DOCKER_USE_HOSTNAME: true
  ##
  ## TODO: The mailserver this Discourse instance will use
  DISCOURSE_SMTP_ADDRESS: smtp.mailgun.org         # (mandatory)
  DISCOURSE_SMTP_PORT: 587                        # (optional)
  DISCOURSE_SMTP_USER_NAME: postmaster@domain.com      # (optional)
  DISCOURSE_SMTP_PASSWORD: myMailgunPassword               # (optional)
  ##
  ## The CDN address for this Discourse instance (configured to pull)
  #DISCOURSE_CDN_URL: //discourse-cdn.example.com

volumes:
  - volume:
      host: /var/discourse/shared/openu_web
      guest: /shared
  - volume:
      host: /var/discourse/shared/openu_web/log/var-log
      guest: /var/log

## The docker manager plugin allows you to one-click upgrade Discouse
## http://discourse.example.com/admin/docker
hooks:
  after_code:
    - exec:
        cd: $home/plugins
        cmd:
          - mkdir -p plugins
          - git clone https://github.com/discourse/docker_manager.git
  before_bundle_exec:
    - file:
        path: $home/config/multisite.yml
        contents: |
         openu:
           adapter: postgresql
           database: openu
           pool: 25
           timeout: 5000
           db_id: 2
           host_names:
             - openu.domain.com

  after_bundle_exec:
    - exec: cd /var/www/discourse && sudo -E -u discourse bundle exec rake multisite:migrate

## Remember, this is YAML syntax - you can only have one block with a name
run:
  - exec: echo "Beginning of custom commands"

  ## If you want to configure password login for root, uncomment and change:
  ## Use only one of the following lines:
  #- exec: /usr/sbin/usermod -p 'PASSWORD_HASH' root
  #- exec: /usr/sbin/usermod -p "$(mkpasswd -m sha-256 'RAW_PASSWORD')" root

  ## If you want to authorized additional users, uncomment and change:
  #- exec: ssh-import-id username
  #- exec: ssh-import-id anotherusername

  - exec: echo "End of custom commands"
  - exec: awk -F\# '{print $1;}' ~/.ssh/authorized_keys | awk 'BEGIN { print "Authorized SSH keys for this container:"; } NF>=2 {print $NF;}'

And my openu_data.yml look like:

# A container for all things Data, be sure to set a secret password for
# discourse account, SOME_SECRET is just an example
#

templates:
  - "templates/postgres.template.yml"
  - "templates/redis.template.yml"

# any extra arguments for Docker?
# docker_args:

params:
  db_default_text_search_config: "pg_catalog.english"

  ## Set db_shared_buffers to a max of 25% of the total memory.
  ##
  ## On 1GB installs set to 128MB (to leave room for other processes)
  ## on a 4GB instance you may raise to 1GB
  #db_shared_buffers: "256MB"
  #
  ## Set higher on large instances it defaults to 10MB, for a 3GB install 40MB is a good default
  ## this improves sorting performance, but adds memory usage per-connection
  #db_work_mem: "40MB"
  #

env:
  # ensure locale exists in container, you may need to install it
  LANG: en_US.UTF-8

volumes:
  - volume:
        host: /var/discourse/shared/openu_data
        guest: /shared
  - volume:
        host: /var/discourse/shared/openu_data/log/var-log
        guest: /var/log

# TODO: SOME_SECRET to a password for the discourse user
hooks:
  after_postgres:

     - exec: sudo -u postgres createdb openu || exit 0
     - exec:
          stdin: |
            grant all privileges on database openu to discourse;
          cmd: sudo -u postgres psql openu
          raise_on_fail: false
     - exec:
        stdin: |
          alter user discourse with password 'myDiscourseUserPassword';
        cmd: su - postgres -c 'psql openu'
        raise_on_fail: false

     - exec: /bin/bash -c 'sudo -u postgres psql openu <<< "alter schema public owner to discourse;"'
     - exec: /bin/bash -c 'sudo -u postgres psql openu <<< "create extension if not exists hstore;"'
     - exec: /bin/bash -c 'sudo -u postgres psql openu <<< "create extension if not exists pg_trgm;"'

when I run ./launcher rebuild openu_data
all things goes fine, I can enter the container and postgres.

when I run ./launcher rebuild openu_web
I get this errors in middle of the rebuild:

course -c 'bundle exec rake assets:precompile'
URGENT: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 Failed to initialize site openu
dicourse -c 'bundle exec rake db:migrate'
URGENT: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 Failed to initialize site openu

and this one in the end:

FAILED
--------------------
Pups::ExecError: cd /var/www/discourse && su discourse -c 'bundle exec rake assets:precompile' failed with return #<Process::Status: pid 248 exit 1>
Location of failure: /pups/lib/pups/exec_command.rb:108:in `spawn'
exec failed with the params {"cd"=>"$home", "hook"=>"bundle_exec", "cmd"=>["su discourse -c 'bundle install --deployment --verbose --without test --without development'", "su discourse -c 'bundle exec rake db:migrate'", "su discourse -c 'bundle exec rake assets:precompile'"]}
5bd6228c816b0c4e31890510d007090ac91dbc94a97d932cf3a5c7b713d04358
** FAILED TO BOOTSTRAP ** please scroll up and look for earlier error messages, there may be more than one

Please help me!
Thanks,
Michael