Рубрика: Администрирование

Gitlab configure reply by email Edit config file gitlab.rb gitlablab_rails[‘gitlablab_email_display_name’] = ‘gitlabLab Administrator’ gitlablab_rails[‘gitlablab_email_reply_to’] = ‘gitlab@mail.linux2be.com’ gitlablab_rails[‘gitlablab_email_from’] = ‘gitlab@mail.linux2be.com’ gitlablab_rails[‘smtp_enable’] = true gitlablab_rails[‘smtp_address’] = “mail.linux2be.com” gitlablab_rails[‘smtp_port’] = 587 gitlablab_rails[‘smtp_user_name’] = “gitlab@mail.linux2be.com” gitlablab_rails[‘smtp_password’] = “gitlabLAB_USER_PASSWORD” gitlablab_rails[‘smtp_authentication’] = “login” gitlablab_rails[‘smtp_enable_starttls_auto’] = true gitlablab_rails[‘smtp_tls’] = false gitlablab_rails[‘smtp_openssl_verify_mode’] = ‘none’ gitlablab_rails[‘smtp_force_ssl’] = false gitlablab_rails[‘incoming_email_enabled’] = true gitlablab_rails[‘incoming_email_address’] = “gitlab@mail.linux2be.com” […]

Читать дальше… from Gitlab self hosted – configure reply by email and smtp

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