AstraSerg

# cat command
load database  
    from '/var/spool/grafana_data/grafana.db'
    into postgresql://grafana:password@localhost/grafana

with include drop, create tables, create indexes, reset sequences  

set work_mem to '16MB', maintenance_work_mem to '512 MB';
==============
# cat convert.sh

AstraSerg

docker update

usermod -aG docker astraserg

apt-get remove docker docker-engine docker.io containerd runc

apt-get install \
    apt-transport-https \
    ca-certificates \
    curl \

AstraSerg

#!/usr/bin/env python3
# coding: utf-8

import consul as cons

'''
Cs = {
    'redmine_db_ip': '',
    'mongo_conn_string': '', 
    'mongo_un': 'root',

AstraSerg

import gettext
gettext.install("locales")





apt install  gettext

AstraSerg

#!/bin/bash

# checks if certs was updated by lego
# and put it to spot

key_file='/home/certs/certificates/hs1.srv.key'
crt_file='/home/certs/certificates/hs1.srv.crt'
mix_file='/opt//config/server.pem'

# take 1 line from the middle of new (?) cert

AstraSerg

version: "3"
services:
  prometheus:
    image: prom/prometheus
    volumes:
      - /opt/docker-persist/prometheus/data:/prometheus-data
    ports:
      - 9090:9090
    restart: always
    command: --config.file=/prometheus-data/prometheus.yml

AstraSerg

mongoexport \
    --db db \
    --collection coll \
    --type=csv \
    -h host:27017 \
    --fields rm_issue_id,status,period,partner_id,summ_info,summ_clear \
    -u user \
    -p password \
    --out file.dump.csv