codeigniter - 添加 database.sql /docker-entrypoint-initdb.d/database.sql
问题描述
我想在 docker 的帮助下安装 opensourcepos。当我运行 docker-compose up 命令时,它会显示以下错误。
第 3/4 步:添加 database.sql /docker-entrypoint-initdb.d/database.sql
错误:服务“sqlscript”构建失败:添加失败:stat /mnt/sda1/var/lib/docker/tmp/docker-builder784255971/database.sql:没有这样的文件或目录
docker-compose.yml 文件
version: '2'
volumes:
uploads:
driver: local
logs:
driver: local
networks:
app_net:
db_net:
services:
sqlscript:
build:
context: database/
dockerfile: Dockerfile
ospos:
build:
context: .
dockerfile: Dockerfile
container_name: ospos
restart: always
depends_on:
- mysql
expose:
- "80"
networks:
- app_net
- db_net
volumes:
- uploads:/app/public/uploads
- logs:/app/application/logs
environment:
- FORCE_HTTPS=true
- PHP_TIMEZONE=UTC
- MYSQL_USERNAME=root
- MYSQL_PASSWORD=
- MYSQL_DB_NAME=ospos
- MYSQL_HOST_NAME=mysql
mysql:
image: mariadb:10.3
container_name: mysql
restart: always
expose:
- "3306"
networks:
- db_net
volumes_from:
- sqlscript
environment:
- MYSQL_ROOT_PASSWORD= password
- MYSQL_DATABASE=ospos
- MYSQL_USER=root
- MYSQL_PASSWORD=
phpmyadmin:
image: phpmyadmin/phpmyadmin
container_name: phpmyadmin
restart: always
depends_on:
- mysql
expose:
- "80"
networks:
- app_net
- db_net
environment:
- MYSQL_USERNAME=root
- MYSQL_ROOT_PASSWORD= password
- PMA_HOST=mysql
nginx:
image: nginx:1.15-alpine
container_name: nginx
restart: always
depends_on:
- ospos
- phpmyadmin
- certbot
volumes:
- ./docker/data/nginx/nginx.tmpl:/etc/nginx/nginx.tmpl:ro
- ./docker/data/nginx/error_log.log:/etc/nginx/error_log.log
- ./docker/data/certbot/conf:/etc/letsencrypt:ro
- ./docker/data/certbot/www:/var/www/certbot:ro
ports:
- "80:80"
- "443:443"
- "8000:8000"
networks:
- app_net
environment:
- WEB_DOMAIN= localhost
- ESC=$$
command: "/bin/sh -c 'envsubst < /etc/nginx/nginx.tmpl > /etc/nginx/nginx.conf & while :; do sleep 6h & wait $${!}; nginx -s reload; done & nginx -g \"daemon off;\"'"
certbot:
image: certbot/certbot
container_name: certbot
restart: always
volumes:
- ./docker/data/certbot/conf:/etc/letsencrypt
- ./docker/data/certbot/www:/var/www/certbot
networks:
- app_net
entrypoint: "/bin/sh -c 'trap exit TERM; while :; do certbot renew; sleep 12h & wait $${!}; done;'"
码头工人文件
FROM php:7.3-apache
MAINTAINER jekkos
RUN apt-get update && DEBIAN_FRONTEND=noninteractive apt-get install -y \
libicu-dev \
libgd-dev \
openssl
RUN a2enmod rewrite
RUN docker-php-ext-install mysqli bcmath intl gd
RUN echo "date.timezone = \"\${PHP_TIMEZONE}\"" > /usr/local/etc/php/conf.d/timezone.ini
RUN echo -e “$(hostname -i)\t$(hostname) $(hostname).localhost” >> /etc/hosts
WORKDIR /app
COPY . /app
RUN ln -s /app/*[^public] /var/www && rm -rf /var/www/html && ln -nsf /app/public /var/www/html
RUN chmod 755 /app/public/uploads && chown -R www-data:www-data /app/public /app/application
RUN [ ! -f test/ospos.js ] || sed -i -e "s/\(localhost\)/web/g" test/ospos.js
这两个文件都在同一个目录中。
解决方案
尝试这个
ADD database.sql /docker-entrypoint-initdb.d/database.sql
并移动database.sql
到数据库文件夹
推荐阅读
- parameters - How to assign an output with combinational logic on a parametric design
- typescript - Express 无法读取 Chunked Post 数据
- c# - Chilkat FTP2 下载 (GetFile) 大文件 (≈12 GB)
- sql - 将 group by 从一个测量值插入另一个测量值
- c# - Sensenet:我可以将 lucene 索引文件存储在 azure 文件存储而不是 App_Data 文件夹中吗?
- php - 前置条件选择表单 - Laravel
- java - ObjectMapper - 线程安全和性能的最佳实践
- typescript - 实例化通用对象时出现类型错误
- php - 我怎样才能防止 EDD 销售捆绑产品而只销售实物产品
- javascript - 如何使用 vanilla javascript 从用户的媒体文件中获取频率?