Автор: human

Let’s encrypt wildcard cert generate via docker.  Step 1 . Prepare folders Create if not exist dir for let’s encrypt files Example mdkir -p /docker-compose/SWARM/certbot/etc/letsencrypt Step 2 . Create default credfile for cloudflare usage. Get in cloudflare panel. Example file cat /docker-compose/SWARM/certbot/etc/letsencrypt/cred_default.ini Output # Cloudflare API credentials used by Certbot dns_cloudflare_email = a.v.galushkotest@gmail.com dns_cloudflare_api_key = […]

Читать дальше… from Let’s encrypt wildcard cert generate via docker for with cloudflare dns server.

For run mssql server in docker i use docker and docker-compose. Content docker-compose.yml version: ‘2’ services: mssql-server-server: image: mcr.microsoft.com/mssql/server:2017-latest container_name: mssql-server-server hostname: mssql-server-server ports: – “1433:1433” – “5022:5022” volumes: – “/docker-compose/SWARM/mssql-server/dataEnterprise:/var/opt/mssql” – “/backups:/backups” environment: – “ACCEPT_EULA=Y” – “SA_PASSWORD=SuperPAssword” – “MSSQL_PID=Enterprise” #- “MSSQL_PID=Express” #- “MSSQL_LCID=1049” # русский #- “MSSQL_COLLATION=1049” – “MSSQL_MEMORY_LIMIT_MB=3500” #задает максимальный объем памяти (в […]

Читать дальше… from Run mssql server Enterprise edition on docker with linux

Create table with pgjson CREATE TABLE asu_clients_activity_jsonb ( id serial primary key, pg_timestamp timestamp default NULL, data jsonb ); Select from records distink by last timestamp SELECT DISTINCT ON (client_id) pg_timestamp AS “@timestamp”, data->>’client_id’ AS client_id, data->’client.env’->>’asu_hosts_ssl’ AS asu_hosts_ssl, data->>’asu_version’ AS asu_version, data->’asu_clients_activity’->>’companies’ AS companies, data->’asu_clients_activity’->>’users_count’ AS users_count, data->’asu_clients_activity’->>’area_of_​​houses_thousand(sqm)’ AS area_of_houses_thousand, data->>’global_auth_token’ AS global_auth_token FROM […]

Читать дальше… from Postgresql jsonb querys

How run samba with docker and docker-compose? Docker-compose file for samba mkdir -p /docker-compose/services/samba cd /docker-compose/services/samba vim docker-compose.yml Add data to file version: ‘3.4’ services: samba: image: devsadds/samba:1.0.0 container_name: samba restart: unless-stopped stdin_open: true tty: true environment: # timszone, ex: ‘Asia/Yekaterinburg’ TZ: “Asia/Yekaterinburg” # advertise shares, default: true, or false (open ports 137, 138) NMBD: […]

Читать дальше… from Run Samba on Docker-compose