Forem: Yaroslav Shelomentsev

RM git submodule

Yaroslav Shelomentsev — Mon, 17 Mar 2025 14:53:25 +0000

// 1. tmp submodule dir
mv submodule submodule_tmp

// 2. deinit submodule
git submodule deinit -f -- submodule    

// 3. rm submodule
rm -rf .git/modules/submodule

// 4. rm git folder
git rm -rf submodule

// 5. return submodule
mv submodule_tmp submodule

// 6. add submodule
git submodule add -- ./submodule submodule

Check gitlab ssh key auth

Yaroslav Shelomentsev — Tue, 17 Dec 2024 11:36:56 +0000

ssh -Tv git@$GIT_SSH_HOST

Базис-мебельщик

Yaroslav Shelomentsev — Wed, 16 Oct 2024 14:00:26 +0000

В папке ./firebird должен находиться файл dbname.fdb (наименование dbname - не важно).

services:
  firebird:
    image: jacobalberty/firebird:2.5.8-sc
    container_name: firebird
    ports:
      - 14357:3050
      - 14358:3050
    volumes:
      - ./firebird:/firebird/data
    env_file:
      - .env.firebird
    restart: always

FIREBIRD_DATABASE=basis.fdb
FIREBIRD_DATABASE_DEFAULT_CHARSET=UTF8

ISC_PASSWORD=masterkey

При подключении в базисе указываем слева IP-адрес сервера, 77.11.22.33 (с доменом будет проблема), а справа - /firebird/data/dbname.fdb (полный путь до файла с базой в докер-контейнере)

Show all docker logs

Yaroslav Shelomentsev — Tue, 19 Dec 2023 10:55:00 +0000

docker ps -q | xargs -L 1 -P `docker ps | wc -l` docker logs --since 30s -f

Nano as default editor

Yaroslav Shelomentsev — Sun, 17 Sep 2023 20:47:57 +0000

echo "set nowrap" >>/etc/nanorc

cat <<EOF >>/etc/profile.d/nano.sh
export VISUAL="nano"
export EDITOR="nano"
EOF

export EDITOR=nano

# check it
crontab -e

Letsencrypt in docker compose mode

Yaroslav Shelomentsev — Sun, 27 Aug 2023 05:01:49 +0000

Example with nginx:

version: '3.8'
services:
  certer:
    image: certbot/certbot:latest
    container_name: certer
    working_dir: /srv
    networks:
      - locality
    volumes:
      - /srv/certer/:/etc/letsencrypt/:rw

  nginx:
    image: nginx:latest
    container_name: nginx
    networks:
      - locality
    volumes:
      # letsencrypt
      - /srv/certer/certs/archive:/etc/letsencrypt/archive
      - /srv/certer/certs/live:/etc/letsencrypt/live
      - /srv/certer/certs/www:/etc/letsencrypt/www

      # config
      - /srv/nginx/pwd:/etc/nginx/pwd
      - /srv/nginx/conf.d:/etc/nginx/conf.d
      - /srv/nginx:/srv/nginx:ro

      # web
      - /srv/web/blank:/srv/web/blank
    ports:
      - 443:443
      - 80:80
    command: bash -c "cp -rf /srv/nginx/nginx.conf /etc/nginx/nginx.conf && nginx -g \"daemon off;\" -c /etc/nginx/nginx.conf"
    restart: always

networks:
  locality:
    external: true

Note: If you have no docker network, create it with docker network create locality or use your own.

Then, delegate your domain/subdomain to your web-server, and run this command in console:

docker compose run --rm certer certonly --webroot --webroot-path /etc/letsencrypt/www -d your_domain.dev && chmod -R 0755 /srv/certer/certs

In some situations, you need to reload Nginx config with docker exec nginx service nginx reload.

Set cron-script to refresh certs:

15 3 * * * docker compose run --rm certer renew --quiet && docker exec nginx service nginx reload

Docker image for puppeteer

Yaroslav Shelomentsev — Sun, 27 Aug 2023 04:46:07 +0000

Dockerfile:

FROM node:20

RUN apt-get update \
    && apt-get install -y wget gnupg \
    && wget -q -O - https://dl-ssl.google.com/linux/linux_signing_key.pub | apt-key add - \
    && sh -c 'echo "deb [arch=amd64] http://dl.google.com/linux/chrome/deb/ stable main" >> /etc/apt/sources.list.d/google.list' \
    && apt-get update \
    && apt-get install -y google-chrome-stable fonts-ipafont-gothic fonts-wqy-zenhei fonts-thai-tlwg fonts-kacst fonts-freefont-ttf libxss1 \
      --no-install-recommends \
    && rm -rf /var/lib/apt/lists/*

Then, you need to create local docker image:

docker build -t node20-ppt .

And, then, use it, for example in docker-compose.yml:

version: '3.8'
services:
  my_api_with_puppeteer:
    image: node20-ppt
    container_name: my_api_with_puppeteer
    working_dir: /srv/web
    volumes:
      - /srv/web:/srv/web
    command: bash -c "yarn install && yarn start"
    restart: always

Docker push local image to remote

Yaroslav Shelomentsev — Sun, 09 Jul 2023 14:56:36 +0000

Create build from Dockerfile:
docker build ./<directory_with_dockerfile>

Create container tag (name):
docker tag <container_id> <image_name>

Push image to remote server:
docker save <image_name> | bzip2 | ssh root@<ip_address> docker load

Install Docker on Centos 9

Yaroslav Shelomentsev — Sat, 15 Apr 2023 05:50:40 +0000

Remove conflict packages with Docker first

dnf -y remove podman runc

install repo

curl https://download.docker.com/linux/centos/docker-ce.repo -o /etc/yum.repos.d/docker-ce.repo
sed -i -e "s/enabled=1/enabled=0/g" /etc/yum.repos.d/docker-ce.repo
dnf --enablerepo=docker-ce-stable -y install docker-ce

Autoload docker

systemctl enable --now docker

Check it

rpm -q docker-ce
docker version

HTML input[type=file] accept types

Yaroslav Shelomentsev — Mon, 26 Dec 2022 13:52:43 +0000

For CSV files (.csv), use:
<input type="file" accept=".csv" />

For Excel Files 97-2003 (.xls), use:
<input type="file" accept="application/vnd.ms-excel" />

For Excel Files 2007+ (.xlsx), use:
<input type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" />

For Text Files (.txt) use:
<input type="file" accept="text/plain" />

For Image Files (.png/.jpg/etc), use:
<input type="file" accept="image/*" />

For HTML Files (.htm,.html), use:
<input type="file" accept="text/html" />

For Video Files (.avi, .mpg, .mpeg, .mp4), use:
<input type="file" accept="video/*" />

For Audio Files (.mp3, .wav, etc), use:
<input type="file" accept="audio/*" />

For PDF Files, use:
<input type="file" accept=".pdf" />