anduin / Multitenant MoongladePure

# Runs on each web machine. #!/bin/bash sudo apt install jq dotnet7 -y echo "Cleaning up..." rm -rf /home/anduin/build mkdir -p /home/anduin/build echo "Downloading source code..." wget https://gitlab.aiursoft.cn/aiursoft/moongladepure/-/archive/master/moongladepure-master.tar.gz -O /home/anduin/build/moongladepure-master.tar.gz echo "Extracting source code..." tar -zxf /home/anduin/build/moongladepure-master.tar.gz -C /home/anduin/build echo "Building source code..." dotnet publish -c Release -o /home/anduin/build/bin -r linux-x64 --no-self-contained /home/anduin/build/moongladepure-master/src/Moonglade.Web/MoongladePure.Web.csproj echo 'Installing fonts...' sudo mkdir /usr/share/fonts sudo wget https://gitlab.aiursoft.cn/aiursoft/moongladepure/-/raw/master/assets/OpenSans-Regular.ttf -O /usr/share/fonts/OpenSans-Regular.ttf sudo chown www-data:www-data /usr/share/fonts/OpenSans-Regular.ttf curl https://gitlab.aiursoft.cn/aiursoft/moongladepure/-/raw/master/assets/tenants --output /tmp/tenants.txt while read -r tenant port do echo "Building tenant $tenant..." echo "His port is $port..." echo 'Stopping service...' sudo systemctl stop $tenant echo 'Creating tenant folder...' sudo mkdir -p /opt/apps/$tenant > /dev/null echo 'Copying files...' sudo cp /home/anduin/build/bin/* /opt/apps/$tenant/ -r echo 'Setting permissions...' sudo chown -R www-data:www-data /opt/apps/$tenant echo 'Creating appsettings.json...' sudo -u www-data cp /opt/apps/$tenant/appsettings.json /opt/apps/$tenant/appsettings.Production.json echo 'Setting appsettings.json...' sudo -u www-data jq --arg tenant "$tenant" '.ConnectionStrings.MoongladeDatabase = "Server=moongladedb;Port=3306;Database=" + $tenant + ";uid=moongladepure;Password=DATABASE_PASSWORD@1234;"' /opt/apps/$tenant/appsettings.Production.json | sudo -u www-data tee /tmp/tmp.json > /dev/null sudo -u www-data mv /tmp/tmp.json /opt/apps/$tenant/appsettings.Production.json sudo -u www-data jq '.ImageStorage.FileSystemPath = "/mnt/Store/'$tenant'"' /opt/apps/$tenant/appsettings.Production.json | sudo -u www-data tee /tmp/tmp.json > /dev/null sudo -u www-data mv /tmp/tmp.json /opt/apps/$tenant/appsettings.Production.json sudo -u www-data jq '.OpenAI.Token = "OPENAI-KEY"' /opt/apps/$tenant/appsettings.Production.json | sudo -u www-data tee /tmp/tmp.json > /dev/null sudo -u www-data mv /tmp/tmp.json /opt/apps/$tenant/appsettings.Production.json echo 'Creating service...' echo "[Unit] Description=$tenant Service After=network.target Wants=network.target [Service] Type=simple User=www-data ExecStart=/usr/bin/dotnet /opt/apps/$tenant/MoongladePure.Web.dll --urls=http://0.0.0.0:$port/ WorkingDirectory=/opt/apps/$tenant Restart=always RestartSec=10 SyslogIdentifier=$tenant KillSignal=SIGINT Environment=\"ASPNETCORE_ENVIRONMENT=Production\" Environment=\"DOTNET_PRINT_TELEMETRY_MESSAGE=false\" Environment=\"DOTNET_CLI_TELEMETRY_OPTOUT=1\" Environment=\"ASPNETCORE_FORWARDEDHEADERS_ENABLED=true\" [Install] WantedBy=multi-user.target" | sudo tee /etc/systemd/system/$tenant.service > /dev/null sudo systemctl daemon-reload sudo systemctl enable $tenant sudo systemctl start $tenant done < /tmp/tenants.txt # Runs on each DB machine: curl https://gitlab.aiursoft.cn/aiursoft/moongladepure/-/raw/master/assets/tenants --output /tmp/tenants.txt while read -r tenant port do echo "Creating database $tenant" sudo mysql -u root --password=mynewpassword -e "CREATE DATABASE $tenant;" > /dev/null 2>&1 echo "Granting permissions on $tenant to user moongladepure" sudo mysql -u root --password=mynewpassword -e "GRANT ALL PRIVILEGES ON $tenant.* TO 'moongladepure'@'%';" sudo mkdir /mnt/Store/$tenant sudo chmod 666 /mnt/Store/$tenant sudo chown -R nobody:nogroup /mnt/Store/$tenant done < /tmp/tenants.txt