Run mssql server Enterprise edition on docker with linux

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» #задает максимальный объем памяти (в […]

Читать далее…

Postgresql jsonb querys

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 […]

Читать далее…

Run Samba on Docker-compose

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: […]

Читать далее…

Nginx monster docker with logging headers

Instruction about build docker nginx with many modules and enable headers logging Dockerfile FROM alpine:3.9.4 LABEL maintainer «a.v.galushko86@gmail.com» ENV COMPILE_DIR /build ENV LIBRESSL_DIR /libressl ENV NB_PROC 4 ARG NGINX_VERSION ENV VERSION_PCRE pcre-8.42 ENV VERSION_LIBRESSL libressl-2.8.2 ENV VERSION_NGINX nginx-$NGINX_VERSION ENV SOURCE_LIBRESSL http://ftp.openbsd.org/pub/OpenBSD/LibreSSL/ ENV SOURCE_PCRE https://ftp.pcre.org/pub/pcre/ ENV SOURCE_NGINX http://nginx.org/download/ ENV STATICLIBSSL $LIBRESSL_DIR/$VERSION_LIBRESSL ENV VERSION_NGINX_DEVEL_KIT 0.3.1 ENV VERSION_LUA_NGINX_MODULE […]

Читать далее…