Persistent Volumes / Bind Mounts when using docker

[ArcherCentauri]

Hi,

Following the below steps from this page: https://devdocs.krayincrm.com/2.0/introduction/docker.html#introduction I'm able to fire up a running container without issue.

Step 1: Pull Krayin Docker Image
To pull the Krayin Docker image from Docker Hub, use the following command:

docker pull webkul/krayin:2.0.1
[#](https://devdocs.krayincrm.com/2.0/introduction/docker.html#step-2-run-a-new-container)Step 2: Run a New Container
Once the image is pulled, you can run a new Docker container using the command below. This will bind your local port 80 to the container’s port 80, so Krayin can be accessed via the browser.

docker run -it -d -p 80:80 webkul/krayin:2.0.1
Note: If port 80 is already in use, you can try using a different port. For example, you can map port 8082 on your local machine to port 80 in the container by running the following command:

docker run -it -d -p 8082:80 webkul/krayin:2.0.1
After this, you can access the application at http://localhost:8082/ instead of http://localhost:80

[#](https://devdocs.krayincrm.com/2.0/introduction/docker.html#step-3-access-krayin-in-your-browser)

However if I stop or reboot the container all changes are lost and nothing seems persistent. I have tried bind mounting "app" and "dbvolume" as suggested but this doesn't seem to be working. Could someone point me in the right direction of what file path inside the container I would need to mount to the host to retain persistent data.

Many Thanks

[devansh-webkul]

Hello there,

You need to map the volume, in webkul/krayin image everything is packed inside, something like this,

docker run -it -d -p 8082:80 \
  -v /path/on/host:/var/www/html \
  -v /path/on/host/mysql:/var/lib/mysql \
  webkul/krayin:2.0.1

Or you can use our Krayin docker repo also,
https://github.com/krayin/krayin-docker

[ArcherCentauri]

Hi,

I have made the relevant changes as suggested and my docker compose is now the following:

services:
  kraylin:
    container_name: Kraylin
    image: webkul/krayin:2.0.1
    restart: unless-stopped
    volumes:
      - /mnt/docker1/data/kraylin/html:/var/www/html
      - /mnt/docker1/data/kraylin/mysql:/var/lib/mysql
    ports:
      - 8082:80

The container starts but the log seems to be show MYSQL is starting and then stopping a second later.

2024-10-28 21:58:23,573 INFO spawned: 'mysql' with pid 110
2024-10-28 21:58:24,848 INFO success: mysql entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2024-10-28 21:58:24,849 INFO exited: mysql (exit status 1; not expected)
2024-10-28 21:58:25,850 INFO spawned: 'mysql' with pid 112
2024-10-28 21:58:27,137 INFO success: mysql entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2024-10-28 21:58:27,137 INFO exited: mysql (exit status 1; not expected)

Any suggestions would be much appreciated.

[devansh-webkul]

May be this path creating an issue,

• /mnt/docker1/data/kraylin/mysql:/var/lib/mysql

Can you check by removing this path. If working fine then you should check mysql volume map path.

[ArcherCentauri]

Hi,

I've commented out the database volume as you suggested and the container starts however get the following via the web browser

Not Found

The requested URL was not found on this server.

Apache/2.4.41 (Ubuntu) Server at 192.168.0.223 Port 8082

Looking at the log (see below) it looks exactly the same as if I comment out both the HTML and MYSQL bind mounts. The container then starts and I can login but there is no persistence so rebooting the container will lose any changes.

2024-11-03 15:24:59,580 CRIT Supervisor is running as root.  Privileges were not dropped because no user is specified in the config file.  If you intend to run as root, you can set user=root in the config file to avoid this message.
2024-11-03 15:24:59,585 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2024-11-03 15:24:59,585 INFO supervisord started with pid 1
2024-11-03 15:25:00,588 INFO spawned: 'apache2' with pid 8
2024-11-03 15:25:00,590 INFO spawned: 'mysql' with pid 9
2024-11-03 15:25:01,873 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2024-11-03 15:25:01,873 INFO success: mysql entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

Any further assistance on this would be much appreciated.

Many Thanks

[devansh-webkul]

There is no issue in the log. For persistence, you need proper volume mapping. Check the volume map path for MySQL, as the path may be incorrect when mapping MySQL.

[ArcherCentauri]

There is no issue with mapping the bind mounts as the container wouldn't start if they didn't exist. I have also tried chmod 777 on both directory to ensure it isn't a permission issue. Looking at the host via VSCode I can the html folder has the following files once the container starts:

supervisord.log
supervisord.pid

And In the mysql folder I can also see the follow files:

auto.cnf
binlog.index

So it seems the container can write to the directory OK. Any other suggestions would be much appreciated.

[ArcherCentauri]

After some investigation I can see that the www-data user/group inside the container was using id's 33:33 and msql was using 104/105. I tried to Chown on the host but this still didn't seem to work.

I have then tried using docker volume approach with the following compose file which seems to retain the persistent data after a reboot. My preferred option would be to use bind mounts so i can access the raw data on the host.

version: "3.8"
services:
  kraylin:
    container_name: Kraylin
    image: webkul/krayin:2.0.1
    restart: unless-stopped
    volumes:
      - html-data:/var/www/html   # Named volume for the HTML directory
      - mysql-data:/var/lib/mysql  # Named volume for the MySQL directory
    ports:
      - 8082:80

volumes:
  html-data:
    driver: local
  mysql-data:
    driver: local

Happy to try any more suggestions in the mean time.

[devansh-webkul]

After some investigation I can see that the www-data user/group inside the container was using id's 33:33 and msql was using 104/105. I tried to Chown on the host but this still didn't seem to work.

I have then tried using docker volume approach with the following compose file which seems to retain the persistent data after a reboot. My preferred option would be to use bind mounts so i can access the raw data on the host.

version: "3.8"
services:
  kraylin:
    container_name: Kraylin
    image: webkul/krayin:2.0.1
    restart: unless-stopped
    volumes:
      - html-data:/var/www/html   # Named volume for the HTML directory
      - mysql-data:/var/lib/mysql  # Named volume for the MySQL directory
    ports:
      - 8082:80

volumes:
  html-data:
    driver: local
  mysql-data:
    driver: local

Happy to try any more suggestions in the mean time.

If this is working fine, you can try replacing the path with html-data using the host path. This might help.