blocky icon indicating copy to clipboard operation
blocky copied to clipboard

blocky not writing to mariadb docker container

Open panks21 opened this issue 7 months ago • 0 comments

MariaDB 11.4.2-MariaDB-ubu2404 block - 0.24

docker-compose contents

version: "2.1"

services:
  blocky:
    image: spx01/blocky
    container_name: blocky
    restart: unless-stopped
    ports:
      - "53:53/tcp"
      - "53:53/udp"
      - "5000:5000"
    environment:
      - TZ=Asia/Kolkata
    volumes:
      - ./blocky-config/config.yml:/app/config.yml
##version: '3'
##volumes:
##  data:
##services:
  mariadb:
    image: mariadb
    container_name: mariadb
    environment:
      MYSQL_ROOT_PASSWORD: blocky
      MYSQL_DATABASE: blocky
      MYSQL_USER: blocky
      MYSQL_PASSWORD: blocky
    volumes:
      - ./data:/var/lib/mysql
    ports:
      - "3306:3306"

querylog config in config.yml

queryLog:
  type: mysql
  target: blocky:blocky@tcp(mariadb:3306)/blocky?charset=utf8mb4&parseTime=True&loc=Local
  logRetentionDays: 5
  creationAttempts: 20
  creationCooldown: 2s
  fields:
    - clientIP
    - duration
  flushInterval: 30s

post adding mysql as the source in the grafana.. the dashboard is empty. I am not a database expert. please pardon my mistake in config..

panks21 avatar Jul 11 '24 13:07 panks21