いつもお世話になります。docker-compose.ymlにsqlserverの記述をし、docker-compose up -dで起動しようしたのですが、うまく動作しません。
エラー内容
ERROR: The Compose file './docker-compose.yml' is invalid because:
Unsupported config option for services.volumes: 'ms-sqlserver-data'
と出ます。以下が設定ファイルです。ご教授をお願いします。
// docker-compose
version: '3' services: php: build: context: ./php7.2 dockerfile: dockerfile volumes: - ./php7.2/php.ini:/usr/local/etc/php/php.ini - ./html:/var/www/html ports: - 8000:80 links: - mysql:mysql db: build: ./mssql environment: SA_PASSWORD: "Strong#Password1" ACCEPT_EULA: "Y" MSSQL_PID: "Developer" ports: - "1433:1433" container_name: "mssql" volumes: - ./mssql/ms-sqlserver-data:/var/opt/mssql - ./mssql/backup:/var/opt/mssql/data/backup volumes: ms-sqlserver-data: driver: local
// Dockerfile
FROM microsoft/mssql-server-linux:latest COPY ./entrypoint.sh /usr/src/ COPY ./restore-backup.sh /usr/src/ WORKDIR /usr/src/ RUN chmod +x /usr/src/restore-backup.sh CMD /bin/bash ./entrypoint.sh
// entrypoin.sh
/opt/mssql/bin/sqlservr & /usr/src/restore-backup.sh & /opt/mssql/bin/sqlservr
// restore-backup.sh
sleep 10s /opt/mssql-tools/bin/sqlcmd -H localhost -U SA -P Strong#Password1 -Q "RESTORE DATABASE Northwind FROM DISK = '/var/opt/mssql/data/backup/Northwind.bak' WITH MOVE 'Northwind' TO '/var/opt/mssql/data/Northwind.mdf', MOVE 'Northwind_Log' TO '/var/opt/mssql/data/Northwind_Log.ldf'" /opt/mssql-tools/bin/sqlcmd -H localhost -U SA -P Strong#Password1 -Q "RESTORE DATABASE AdventureWorks2014 FROM DISK = '/var/opt/mssql/data/backup/AdventureWorks2014.bak' WITH MOVE 'AdventureWorks2014_data' TO '/var/opt/mssql/data/AdventureWorks2014.mdf', MOVE 'AdventureWorks2014_Log' TO '/var/opt/mssql/data/AdventureWorks2014.ldf'" /opt/mssql-tools/bin/sqlcmd -H localhost -U SA -P Strong#Password1 -Q 'RESTORE DATABASE WideWorldImporters FROM DISK = "/var/opt/mssql/data/backup/WideWorldImporters-Full.bak" WITH MOVE "WWI_Primary" TO "/var/opt/mssql/data/WideWorldImporters.mdf", MOVE "WWI_UserData" TO "/var/opt/mssql/data/WideWorldImporters_userdata.ndf", MOVE "WWI_Log" TO "/var/opt/mssql/data/WideWorldImporters.ldf", MOVE "WWI_InMemory_Data_1" TO "/var/opt/mssql/data/WideWorldImporters_InMemory_Data_1"'
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。