How do i install Ghost cms in aapanel with docker image.

kloudboy

please help me to install Ghost cms in aapnel. i was tried with docker unfortunately Mysql permision error shows.

aaPanel_Kern

kloudboy
Hello, it is recommended to refer to the official documentation for deployment. The mysql installed on the panel only allows localhost/127.0.0.1 connections by default, pay attention to changing permissions

kloudboy

@"aaPanel_Kern"#p53864 

version: '3.1'

services:

  ghost:
    image: ghost:latest
    restart: always
    ports:
      - 8001:2368
    environment:
      # see https://ghost.org/docs/config/#configuration-options
      database__client: mysql
      database__connection__host: db
      database__connection__user: root
      database__connection__password: strongpasswd
      database__connection__database: ghost
      # this url value is just an example, and is likely wrong for your environment!
      url: https://example.com
      # contrary to the default mentioned in the linked documentation, this image defaults to NODE_ENV=production (so development mode needs to be explicitly specified if desired)
      #NODE_ENV: development

  db:
    image: mysql:oracle
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: strongpasswd
    volumes:
      - ./data:/var/lib/mysql

aaPanel_Kern

kloudboy
Does mysql need to specify to create a ghost database?
Reference: Content:

   - MYSQL_ROOT_PASSWORD=btnextcloud
   - MYSQL_DATABASE=nextcloud
   - MYSQL_USER=nextcloud
   - MYSQL_PASSWORD=nextcloud

https://www.aapanel.com/forum/d/13700-docker-module-docker-compose-to-build-your-own-nextcloud-private-cloud-space

kloudboy

aaPanel_Kern

Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Get "http://%2Fvar%2Frun%2Fdocker.sock/v1.24/containers/730a81a89ac757bcce0bee4f1ad06d7ea357913ee99d6e13232edfc310208d1f/json": dial unix /var/run/docker.sock: connect: permission denied

found this error in docker MySQL terminal.

aaPanel_Kern

kloudboy
Hello, the terminal needs to use root privileges to operate

kloudboy

kloudboy Error Fixed.

After an search weeks this following solution finally worked 😀
sudo chmod 666 /var/run/docker.sock

kloudboy

Here is the docker Template to install Ghost CMS on aapanel. tested and working on Oracle ARM servers in cent os7 aapenel.

version: '3.1'

services:

  ghost:
    image: ghost:latest
    restart: always
    ports:
      - 8001:2368
    environment:
      # see https://ghost.org/docs/config/#configuration-options
      database__client: mysql
      database__connection__host: db
      database__connection__user: ghost
      database__connection__password: addnewpasswd
      database__connection__database: ghost
      # this url value is just an example, and is likely wrong for your environment!
      url: https://yourdomain.com
      # contrary to the default mentioned in the linked documentation, this image defaults to NODE_ENV=production (so development mode needs to be explicitly specified if desired)
      #NODE_ENV: development

  db:
    image: mysql:oracle
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: addnewpasswd
      MYSQL_USER: ghost
      MYSQL_PASSWORD: addnewpasswd
      MYSQL_DATABASE: ghost
    volumes:
      - ./data:/var/lib/mysql