Set up Sterling Stack

gistfile1.txt

git clone git@github.com:Sterling-DCS/local-setup.git

cd ./local-setup

git clone git@github.com:Sterling-DCS/core.git
git clone git@github.com:Sterling-DCS/integration.git
git clone git@github.com:Sterling-DCS/proxy.git
git clone git@github.com:Sterling-DCS/report.git
git clone git@github.com:Sterling-DCS/image-service.git
git clone git@github.com:Sterling-DCS/takeoff-snapshot.git
git clone git@github.com:Sterling-DCS/resource-integration.git
git clone git@github.com:Sterling-DCS/model-processor.git
git clone git@github.com:Sterling-DCS/infrastructure.git
git clone git@github.com:Sterling-DCS/identity.git
git clone git@github.com:Sterling-DCS/takeoff.git
git clone git@github.com:Sterling-DCS/mailing.git
git clone git@github.com:Sterling-DCS/units.git
git clone git@github.com:Sterling-DCS/frontend-api.git
#npm login --registry https://registry.hoststerling.com/repository/npm/ # if not done so already using cred reece supplied

# In linux i needed to install the relevant file from https://github.com/docker/docker-credential-helpers/releases 
# then 
mv ~/Downloads/docker-credential-pass-v0.8.2.darwin-amd64  /src/bin/docker-credential-pass
 chmod +x docker compose up -d

docker login https://registry.hoststerling.com

#comment out lines
comment out all lines docker-compose.yml
#platform: linux/amd64

# Stop in built web server
sudo systemctl stop apache2
sudo systemctl disable apache2 # perm disable

cp ./.env.local-tmpl ./.env.local

# add this to your /etc/hosts
192.168.1.86 auth.sterling-dcs.io core.sterling-dcs.io reports.sterling-dcs.io

# DB upgrade
Create a `eula.sql` file:
```
USE [aspnet-identity];
GO

BEGIN TRANSACTION;
GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20231020155122_EulaAcceptVersion')
BEGIN
    ALTER TABLE [AspNetUsers] ADD [EulaAcceptVersion] int NULL;
END;
GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20231020155122_EulaAcceptVersion')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20231020155122_EulaAcceptVersion', N'6.0.10');
END;
GO

COMMIT;
GO 
```
`docker cp eula.sql sqlserver:/opt`
`docker exec -it sqlserver /bin/bash`
```
export SQLCMDPASSWORD=P@ssw0rd
export SQLCMDSERVER=127.0.0.1
export SQLCMDUSER=sa
```
`cd /opt/mssql-tools/bin`
`./sqlcmd -i /opt/eula.sql`

### Create a login
???
sudo docker compose build
docker compose up -d