r/technitium • u/MrGimper • 4d ago

Idiot guide to using SQL backend for query logging with docker

As above ... I have 2x technitium docker containers with primary zones on 1 and secondary on the other. I can see you can add an app to store queries in a DB for analysis etc. How do you implement this when you're running the servers in docker.

Thanks.

5 Upvotes

86% Upvoted

3 comments sorted by

2

u/joetheshm1 4d ago

Create a MySQL/MariaDB container on each host, or a central one they can both connect to. I went with the former and just kept the creds/DB name the same since after clustering they share the app config. I did this in a podman pod so they just speak to the DB on the loopback address so keep in mind in docker you'll want to have a static IP that is the same on each (or has the same DNS name.)

1

u/MrGimper 1d ago

Thank you ... didn't realise it was that simple. I just created a MySQL container on each host and installed the app after the manual config. I guess the question I should have asked is do the Apps install and work properly when installed on a containerised technitium instance.

Many thanks.

1

u/shreyasonline 4d ago

Thanks for asking. You can read the app's description which explains in brief how to get the db configured. It expects some basic of understanding from user about the db being used though. I would suggest that you attempt to do it following the steps in the app's description and get help from any LLM model with things you may get stuck at. You should be able to get it running in no time.