MySql table fields question

[audricd]

Hello,

I have set up MySql for logs, v3.0.1
I am a bit surprised that the protocol column always shows 0? unless i am missing something, i dont see the use of it.

Also, response type is an int between 0 and 4 (or more?), same for rcode. but where can i see what the codes correspond to?

also: is it on the roadmap to have more than dns queries logs? id be interested in seeing the cluster activity for example, on top of the queries going on.

thanks!

[ShreyasZare]

Thanks for asking. The database columns use integer values for the enumerations used in the source code. You will need to check the app's code to find out the values for them. Protocol "0" is UDP which is why you see it for most entries.

The app is designed only for DNS query logs. The clustering feature uses HTTP API for all tasks so its not possible to add any logs in there.

[audricd]

thank you!
could, maybe, the codes be part of the plugin documentation? its asking a lot, for non developers, to look through the codes to see what those numbers do.

[ShreyasZare]

You're welcome. Will get the docs updated once the docs PR is reviewed and merged.

[ShreyasZare]

Technitium DNS Server v15.0 is now available which includes read me file for all apps and include database field info as discussed. Do upgrade and let me know your feedback.

[audricd]

hello! thank you for the update and your interest.

I upgraded, but im not sure i see the difference?

im on 15.0.1

mysql log table:

its a cluster and both as updated, as per release instructions

i dont see the new field or the readme.

[Hemsby]

The readme is in the apps folder of each app in /etc/dns/apps

[ShreyasZare]

Please check the readme file for details. The database values are not changed and they will remain as integers.

[audricd]

oh okay i see them! that looks nice! and very helpful. thank you very much!

[ShreyasZare]

You're welcome!