<> = cset = Cyber Security Evaluation Tool for asset owners with the primary objective of reducing the risk to the nation’s critical infrastructure. * https://github.com/cisagov/cset {{{#!highlight sh cd ~ git clone https://github.com/cisagov/cset.git cd cset find . -name "Dockerfile" ./CSETWebNg/Dockerfile ./CSETWebApi/Dockerfile cp .env.example .env }}} ''' .env ''' {{{#!highlight sh # CSET Web API ConnectionStrings__CSET_DB="data source=mssql,1433;initial catalog=CSET;User Id=sa;Password=********;Encrypt=False;TrustServerCertificate=True;" # Optional: URL to a custom CA certificate (for corporate proxies/VPNs) # CA_CERT_URL=https://your-internal-cert-store/root_ca.crt # Host port overrides for Docker Compose (Optional) WEB_PORT=4200 #WEB_TLS_PORT=443 WEB_TLS_PORT=8443 API_PORT=5000 # MSSQL Server MSSQL_SA_PASSWORD=******** ACCEPT_EULA=Y }}} Run compose {{{#!highlight sh docker compose up docker compose ps NAME IMAGE COMMAND SERVICE CREATED STATUS PORTS cset-api ghcr.io/cisagov/cset/api:latest "dotnet CSETWebCore.…" api 53 seconds ago Up 52 seconds 0.0.0.0:5000->5000/tcp, :::5000->5000/tcp cset-mssql mcr.microsoft.com/mssql/server:2022-CU13-ubuntu-22.04 "/opt/mssql/bin/perm…" sqlserver 53 seconds ago Up 52 seconds 0.0.0.0:1433->1433/tcp, :::1433->1433/tcp cset-web ghcr.io/cisagov/cset/web:latest "/docker-entrypoint.…" web 53 seconds ago Up 52 seconds 0.0.0.0:4200->80/tcp, :::4200->80/tcp, 0.0.0.0:8443->443/tcp, :::8443->443/tcp # http://localhost:4200/ docker compose exec sqlserver bash apt update apt upgrade -y apt install nano vim -y cd /opt/mssql-tools/bin/ ./sqlcmd ./sqlcmd -S localhost -U sa -P ******** select name from sys.databases go master tempdb model msdb exit docker compose exec sqlserver bash cd /var/opt/mssql/backup/ cd bak-files cat CSET.bak.part_a* > /tmp/CSET.bak cp /var/opt/mssql/backup/restoredb.sql /tmp cd /tmp cp restoredb.sql restoredb.sql.ori chmod 666 restoredb.sql chown root restoredb.sql nano restoredb.sql # update to point to /tmp/CSET.bak /opt/mssql-tools/bin/sqlcmd -U 'sa' -P "********" -i /tmp/restoredb.sql }}} == Install dotnet 10 in debian == {{{#!highlight sh # https://dotnet.microsoft.com/en-us/download/dotnet/10.0 # https://learn.microsoft.com/pt-pt/dotnet/core/install/linux-debian?tabs=dotnet10 cd ~ wget https://packages.microsoft.com/config/debian/13/packages-microsoft-prod.deb -O packages-microsoft-prod.deb sudo dpkg -i packages-microsoft-prod.deb rm packages-microsoft-prod.deb sudo apt-get update && sudo apt-get install -y dotnet-sdk-10.0 dotnet --version }}}