buildmaster linux docker install: sa login failures

MaxCascone

I'm following the instructions to install BuildMaster on a CentOS VM: https://docs.inedo.com/docs/installation-linux-docker-guide

I've got the two containers going, but the BuildMaster container keeps failing at around 20 seconds up. docker logs buildmaster shows a login error for the SA:

 $> d logs buildmaster
Attempting to use shared configuration for BuildMaster.
Shared configuration file not found at /etc/inedo/BuildMaster.config.
No encryption key is configured. Credentials will be stored in plain text.
BuildMaster version is 7.0.14.5.
Current DB schema version is unknown.
Unhandled exception. Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "BuildMaster" requested by the login. The login failed.
Login failed for user 'sa'.

The docker commands I'm running are verbatim from the docs except the password:

docker run --name inedo-sql \
  -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=redacted' \
  -e 'MSSQL_PID=Express' --net=inedo --restart=unless-stopped \
  -d mcr.microsoft.com/mssql/server:2019-latest

docker exec -it inedo-sql /opt/mssql-tools/bin/sqlcmd \
  -S localhost -U SA -P 'redacted' \
  -Q 'CREATE DATABASE [ProGet] COLLATE SQL_Latin1_General_CP1_CI_AS'

docker run -d --name=buildmaster --restart=unless-stopped \
  -v buildmaster-artifacts:/var/buildmaster/artifacts \
  -p 80:80 --net=inedo \
  -e BUILDMASTER_SQL_CONNECTION_STRING='Data Source=inedo-sql; Initial Catalog=BuildMaster; User ID=sa; Password=redacted' \
  proget.inedo.com/productimages/inedo/buildmaster:latest

Any help is appreciated! Thanks!

UPDATE after all this staring at it, I noticed an issue right after posting this: The database created is [ProGet], i'm assuming it should be [BuildMaster]. Will follow up after trying.

UPDATE 2: Yep, that's it. It's up and running now after changing the second command to be

docker exec -it inedo-sql /opt/mssql-tools/bin/sqlcmd \
  -S localhost -U SA -P 'redacted' \
  -Q 'CREATE DATABASE [BuildMaster] COLLATE SQL_Latin1_General_CP1_CI_AS'

rhessinger

@mcascone said in buildmaster linux docker install: sa login failures:

docker exec -it inedo-sql /opt/mssql-tools/bin/sqlcmd
-S localhost -U SA -P 'redacted'
-Q 'CREATE DATABASE [ProGet] COLLATE SQL_Latin1_General_CP1_CI_AS'

Hi @mcascone,

This line has the issue. You created a database named [ProGet] instead of a database name [BuildMaster] as you stated in the connection string on the third command.

Thanks,
Rich

olenevivienne9025_2473

@rhessinger said in buildmaster linux docker install: sa login failures:

@mcascone slope game said in buildmaster linux docker install: sa login failures:

docker exec -it inedo-sql /opt/mssql-tools/bin/sqlcmd
-S localhost -U SA -P 'redacted'
-Q 'CREATE DATABASE [ProGet] COLLATE SQL_Latin1_General_CP1_CI_AS'

Hi @mcascone,

This line has the issue. You created a database named [ProGet] instead of a database name [BuildMaster] as you stated in the connection string on the third command.

Thanks,
Rich

Thank you very much for the explanation. It works now.