{
    "ConnectionStrings": {
        "PostgreSqlConnection": "User ID=postgres;Password=postgres;Host=localhost;Port=5432;Database=pix_bi_config;Pooling=true;",
        "PostgreSqlDataProtectionKeysConnection": "User ID=postgres;Password=postgres;Host=localhost;Port=5432;Database=pix_bi_keys;Pooling=true;"
    },
    "DataWarehouseConnectionStrings": {
        //"PostgreSqlConnection": "User ID=postgres;Password=postgres;Host=localhost;Port=5432;Database=pix_bi_dwh;Pooling=true;"
        "ClickhouseConnection": "Compression=True;CheckCompressedHash=False;Compressor=lz4;Host=localhost;Port=8123;Protocol=http;Username=guest;Password=guest;UseSession=true;set_cancel_http_readonly_queries_on_client_close=1"
    },
    "DataWarehouseReadOnlyUser": {
        "login": "chreadonly",
        "password": "chreadonly"
    },
    "Logging": {
        "LogLevel": {
            "Default": "Information",
            "Microsoft": "Warning",
            "Microsoft.Hosting.Lifetime": "Information"
        }
    },
    "AllowedHosts": "*",
    
    "UseSwagger": "false",
    "TokenKey": "cagw374h-126b-7h67-12c3-6dvegw3241", // заменить на рандомный GUID
    
    "UseMemoryCache": "true",
    "CacheAbsoluteExpirationInMinutes": "5",
    
    "ConnectionStringsEncrypted": "false",
    
    "KeyTabPath": ""
}

  "DataWarehouseConnectionStrings": {
      "ClickhouseConnection":
            "Host=localhost; Port=9000; User=default; Password=default"
  },

sudo apt-get update
sudo apt-get install apt-transport-https
sudo apt-get update

wget https://packages.microsoft.com/config/debian/10/packages-microsoft-prod.deb -O packages-microsoft-prod.deb
sudo dpkg -i packages-microsoft-prod.deb
sudo apt-get update
sudo apt-get install -y dotnet-sdk-7.0

sudo apt-get install apache2

cd /etc/apache2
mkdir ssl
cd ssl
sudo openssl req -new -x509 -days 1461 -nodes -out cert.pem -keyout cert.key -subj "/C=RU/ST=Msk/L=Msk/O=YourCompany/OU=IT Department/CN=localhost/CN=pixbi"

sudo a2enmod proxy_http proxy_html proxy_wstunnel ssl
sudo a2enmod rewrite
sudo systemctl restart apache2

sudo nano /etc/apache2/conf-enabled/pixbi.conf

<VirtualHost *:443>
ServerName www.CurrentDomain.com
DocumentRoot /var/www/pixbi
SSLEngine on
SSLCertificateFile ssl/cert.pem
SSLCertificateKeyFile ssl/cert.key
#SSLCertificateChainFile ssl/cert.ca-bundle
ProxyPreserveHost On
ProxyPass / http://127.0.0.1:5000/
ProxyPassReverse / http://127.0.0.1:5000/
RewriteEngine on
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]
RewriteCond %{HTTP:UPGRADE} ^WebSocket$ [NC]
RewriteCond %{HTTP:CONNECTION} Upgrade$ [NC]
RewriteRule /(.*) ws://127.0.0.1:5000/$1 [P]
ErrorLog /var/log/apache2/pixbi-error.log
CustomLog /var/log/apache2/pixbi-access.log common
</VirtualHost>

sudo apachectl configtest

sudo apachectl configtest

sudo service apache2 restart

sudo service apache2 status

wget http://localhost/ 

mkdir /var/www/pixbi 
cd /var/www/pixbi
wget https://pix.ru/download/bi_linux

sudo apt-get install unzip

unzip pix_bi_ХХXXХХ.main.nix64.zip

cd /var/www/pixbi
mkdir .local-chromium
chmod 777 .local-chromium
mkdir PixBILog
chmod 777 PixBILog
mkdir BIuploadedImages
chmod 777 BIuploadedImages
mkdir BITempFolder
chmod 777 BITempFolder

{
  "ConnectionStrings": {
    "PostgreSqlConnection": "User ID=postgres;Password=postgres;Host=localhost;Port=5432;Database=pix_bi_test;Pooling=true;",
    "PostgreSqlDataProtectionKeysConnection": "User ID=postgres;Password=postgres;Host=localhost;Port=5432;Database=pix_bi_keys;Pooling=true;"
  },
  "DataWarehouseConnectionStrings": {
    "PostgreSqlConnection": "User ID=postgres;Password=postgres;Host=localhost;Port=5432;Pooling=true;"
    //"ClickhouseConnection": "Host=localhost;Port=9000;User=guest;Password=guest"
  },
  "DataWarehouseReadOnlyUser": {
    "login": "postgres",
    "password": "postgres"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "PasswordValidationOptions": {
    "RequiredLength": "8",
    "RequireNonAlphanumeric": "true",
    "RequireLowercase": "true",
    "RequireUppercase": "true",
    "RequireDigit": "true"
  },
  "UseSwagger": "false",
  "TokenKey": "cagw374h-126b-7h67-12c3-6dvegw3241", // заменить на рандомный GUID

  "LdapProvider": {
    "Enabled": "false",
    "LdapController": "127.0.0.24", //or use domain name "dc.domain.com"
    "LdapPort": "389", //Default non-secure port "389"
    "BindingID": "user", //bind login
    "BindingSecret": "password", //bind secure password
    "Domain": "dom.ain" // e.g. domain.com
  }
}

  "DataWarehouseConnectionStrings": {
      "ClickhouseConnection":
            "Host=localhost; Port=9000; User=default; Password=default"
  },

sudo nano /etc/systemd/system/pixbi.service

[Unit]
Description=ASP .NET Web Application
[Service]
#Указываем путь к директории с установленным PIX BI
WorkingDirectory=/var/www/pixbi
ExecStart=/usr/bin/dotnet /var/www/pixbi/pix-bi.dll
Restart=always
RestartSec=10
SyslogIdentifier=pixbi
User=www-data
Environment=ASPNETCORE_ENVIRONMENT=Production
[Install]
WantedBy=multi-user.target

sudo systemctl enable pixbi.service
sudo systemctl start pixbi.service

sudo ufw allow 443
sudo ufw allow 5000

sudo systemctl start pixbi.service 
sudo service apache2 status

cd /var/www/pixbi
dotnet pix-bi.dll
# затем:
sudo systemctl stop pixbi.service
sudo systemctl start pixbi.service
sudo service apache2 restart