В 2025 релиз, к 2027-ому — соберут полностью. Будем ждать?

Финская студия по прежнему творит добро — путешествие сквозь ночь продолжается.

Быстрофикс:

export KRB5CCNAME=`mktemp`

или отредактировать /etc/krb5.conf

[libdefaults]
# ...
# default_ccache_name = KEYRING:persistent:%{uid}
  default_ccache_name = /tmp/krb5cc_%{uid}

#!/bin/bash
LIST=(elem1 elem2 elem3)
mkdir "${LIST[@]}"

Биошок в космосе завезли.

ЖТА завезли

По прежнему наивная и забавная история.

docker-compose.yml

version: '3.5'
services:
  kafka:
    image: bitnami/kafka:2.6.0
    ports:
      - "9092:9092"
    environment:
      - KAFKA_BROKER_ID=1
      - KAFKA_LISTENERS=PLAINTEXT://:9092
      - KAFKA_ADVERTISED_LISTENERS=PLAINTEXT://172.23.0.13:9092
      - KAFKA_ZOOKEEPER_CONNECT=zookeeper:2181
      - ALLOW_PLAINTEXT_LISTENER=yes
    depends_on:
      - zookeeper
    networks:
      clickhouse-network:
        ipv4_address: 172.23.0.13
  zookeeper:
    image: zookeeper:3.5.8
    container_name: zookeeper
    hostname: zookeeper
    ports:
      - "2181:2181"
    environment:
      - ALLOW_ANONYMOUS_LOGIN=yes
    networks:
      clickhouse-network:
        ipv4_address: 172.23.0.10
  clickhouse01:
    image: yandex/clickhouse-server:20.8.12.2
    container_name: clickhouse01
    hostname: clickhouse01
    networks:
      clickhouse-network:
        ipv4_address: 172.23.0.11
    ports:
      - "127.0.0.1:8123:8123"
      - "127.0.0.1:9000:9000"
    volumes:
      - ${PWD}/clickhouse01:/etc/clickhouse-server
      - /mnt/volume/clickhouse01/data:/var/lib/clickhouse/
      - /mnt/volume/clickhouse01/logs:/var/log/clickhouse-server/
    depends_on:
      - zookeeper
  clickhouse02:
    image: yandex/clickhouse-server:20.8.12.2
    container_name: clickhouse02
    hostname: clickhouse02
    networks:
      clickhouse-network:
        ipv4_address: 172.23.0.12
    volumes:
      - ${PWD}/clickhouse02:/etc/clickhouse-server
      - /mnt/volume/clickhouse02/data:/var/lib/clickhouse/
      - /mnt/volume/clickhouse02/logs:/var/log/clickhouse-server/
    depends_on:
      - zookeeper

networks:
  clickhouse-network:
    name: clickhouse-network
    ipam:
      config:
        - subnet: 172.23.0.0/24

certutil -hashfile <file> MD5

FROM alpine:3.16

RUN apk update && \
apk add --no-cache git gitlab-runner ansible gawk krb5 dumb-init && \
apk add --upgrade openssh-client-krb5 && \
rm -rf /tmp/* && \
rm -rf /var/cache/apk/*

RUN sed -i -e "s#\(^gitlab-runner:x\):[^:]\+:\(.*\)#\1:1010:\2#" /etc/group
RUN sed -i -e "s#\(^gitlab-runner:x\):[^:]\+:[^:]\+:\(.*\)#\1:1010:1010:\2#" /etc/passwd
RUN chown -R 1010:1010 /var/lib/gitlab-runner

COPY krb5.conf /etc/krb5.conf
COPY .gitconfig /var/lib/gitlab-runner/
COPY entrypoint /

STOPSIGNAL SIGQUIT
ENTRYPOINT ["/usr/bin/dumb-init", "/entrypoint"]
CMD ["run", "--user=gitlab-runner", "--working-directory=/var/lib/gitlab-runner"]

Возникла задача посмотреть историю неудачных входов пользователя за период:

SELECT username, terminal, timestamp,returncode  FROM dba_audit_session WHERE username = 'USERNAME' AND RETURNCODE !=0 AND TIMESTAMP between
    to_date('2023-10-20 00:00:00', 'yyyy-mm-dd HH24:MI:SS') and
    to_date('2023-10-20 16:43:00', 'yyyy-mm-dd HH24:MI:SS')

select * from dba_profiles s where s.profile='PROFILE_NAME' 
and resource_name='PASSWORD_LIFE_TIME';