pinpoint-apm / pinpoint

APM, (Application Performance Management) tool for large-scale distributed systems.
https://pinpoint-apm.gitbook.io/
Apache License 2.0
13.36k stars 3.75k forks source link

How to Hide SQL Bind Values and Restrict Monitoring to Specific Applications in 2.5.4 #11287

Open benti-dh opened 1 month ago

benti-dh commented 1 month ago

Hello, I am using Pinpoint and it's been very helpful.

I'm using Pinpoint Docker version 2.5.4, and I would like to know if there is a way to configure it so that the bind values in SQL queries within the server map data are not identifiable. Additionally, is there a way to restrict monitoring to specific applications for each user?

emeroad commented 1 month ago
###########################################################
# JDBC                                                    #
###########################################################
# Size of cache. Fixed maximum.
profiler.jdbc.sqlcachesize=1024
# trace bindvalues for PreparedStatements
profiler.jdbc.tracesqlbindvalue=true <--- 
# Maximum bindvalue size. 
profiler.jdbc.maxsqlbindvaluesize=1024
# Bytes formatter of PreparedStatement.setBytes(int, byte[])
# format : hex or raw
profiler.jdbc.preparedstatement.bytes.format=hex
profiler.jdbc.format.maxwidth=64

profiler.jdbc.tracesqlbindvalue=false

Try changing the bindvalue option to false in agent configuration