[Pdns-users] How to log mysql query details

[frank+pdns at tembo.be]

Hi Cliff, 

The question-marks are not “obfuscation” by PowerDNS, but are what MySQL calls “prepared statements”. 

If you want to know the exact queries that got executed, I recommend you enable query-logging on the MySQL side.

Frank

> On 21 Dec 2018, at 19:51, Cliff Hayes <chayes at afo.net> wrote:
> 
> I have the following in pdns.conf...
> 
> launch=gmysql
> log-dns-details=yes
> logging-facility=0
> loglevel=9
> query-logging=yes
> 
> ...but in the log the queries show question marks instead of values...
> 
> pdns[18975]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?
> 
> How can I configure to show everything in the query?
> 
> Thanks in advance.
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users