search

sap-commerce-tools / ccv2-project-template

Opinionated starter template for any CCv2 project
48 stars 28 forks source link

docker-compose fails with mssqlinit service due to Login failure #10

Closed guiliguili closed 3 years ago

guiliguili commented 3 years ago

Run the following command : 

$ docker-compose up

The following error is shown in the logs :

mssqlinit_1  | wait-for-it.sh: mssql:1433 is available after 9 seconds
2020-12-08 14:55:57.82 spid29s     Server is listening on [ ::1 <ipv6> 1431].
2020-12-08 14:55:57.83 spid29s     Server is listening on [ 127.0.0.1 <ipv4> 1431].
2020-12-08 14:55:57.84 Logon       Error: 18456, Severity: 14, State: 7.
2020-12-08 14:55:57.84 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.19.0.4]
mssqlinit_1  | Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'sa'..

Notice that the same command from docker-compose.yml runs successfully from the host after escaping ! by \! for password :

$ docker-compose exec mssqlinit /tmp/resources/wait-for-it/wait-for-it.sh -t 120 mssql:1433 -- bash -c "/opt/mssql-tools/bin/sqlcmd -S mssql -U sa -P "Hybris\!nimda" -i /tmp/resources/db_init.sql"
wait-for-it.sh: waiting 120 seconds for mssql:1433
wait-for-it.sh: mssql:1433 is available after 0 seconds
Configuration option 'contained database authentication' changed from 0 to 1. Run the RECONFIGURE statement to install.
Changed database context to 'localdev'.

I tried to escape ! by \! in the docker-compose.yml without luck.

mpern commented 3 years ago

Fixed in latest release