AI 助理
备案控制台
开发者社区 问答 正文

怎么样配置druid将sql语句及参数记录到日志文件中去？403.10 禁止访问：配置无效 

@wenshao、@逝水fox  ，怎么样配置druid将sql语句及参数记录到日志文件中去？下面是我的配置，能否帮忙看下什么原因不能记录到日志中去？

log4j.rootLogger=info,stdout,infolog

log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Threshold=debug log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=<%d{yyyy-MM-dd HHss}> <%p> [%c] - %m%n

log4j.appender.infolog=org.apache.log4j.DailyRollingFileAppender log4j.appender.infolog.File=${catalina.home}/logs/info.log log4j.appender.infolog.DatePattern='.'yyyy-MM-dd'.log' log4j.appender.infolog.ImmediateFlush=true log4j.appender.infolog.Append=true log4j.appender.infolog.Threshold=info log4j.appender.infolog.layout=org.apache.log4j.PatternLayout log4j.appender.infolog.layout.ConversionPattern=<%d{yyyy-MM-dd HHss}> <%p> [%c] - %m%n

Druid

log4j.logger.druid.sql=info,stdout,infolog log4j.logger.druid.sql.DataSource=info,stdout,infolog log4j.logger.druid.sql.Connection=info,stdout,infolog log4j.logger.druid.sql.Statement=info,stdout,infolog log4j.logger.druid.sql.ResultSet=info,stdout,infolog

     

@ 逝水fox######log4j.logger.druid.sql=debug,stdout,infolog######

引用来自“wenshao”的答案

log4j.logger.druid.sql=debug,stdout,infolog
@wenshao ，这样配置后是可以正常显示，但怎么每条信息都会显示2次呢？
######怎样的显示两次？######

引用来自“34176470”的答案

引用来自“wenshao”的答案

怎样的显示两次？ 
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. 
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. 
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : []
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. 
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. 
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ...
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ...
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...]
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed
<2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. 
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. 
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle
<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle
 

展开
收起
kun坤 2020-05-28 13:22:58 868 分享 版权

版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

1 条回答
写回答
取消 提交回答
  • kun坤
    @wenshao
    ######你配置了两个log filter了吧######

    引用来自“wenshao”的答案

    你配置了两个log filter了吧 
    <!-- 每隔5分钟将监控日志输出到日志文件中，单位是毫秒。 -->
		<property name="timeBetweenLogStatsMillis" value="300000" />

		<!-- 监控数据库 -->
		<property name="proxyFilters">
			<list>
				<ref bean="stat-filter" />
				<ref bean="wall-filter" />
				<ref bean="log-filter" />
			</list> 
		</property>



<bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">
		<property name="slowSqlMillis" value="3000" />
		<property name="logSlowSql" value="true" />
		<property name="mergeSql" value="true" />
	</bean>
	
	<bean id="log-filter" class="com.alibaba.druid.filter.logging.Log4jFilter">
		<!-- <property name="resultSetLogEnabled" value="false" /> -->
		<!-- <property name="statementExecutableSqlLogEnable" value="true" /> -->
	</bean>
	
	<bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter">
		<property name="dbType" value="oracle" />
		<property name="config" ref="wall-filter-config" />
	</bean>
	
	<bean id="wall-filter-config" class="com.alibaba.druid.wall.WallConfig" init-method="init">
		<property name="dir" value="META-INF/druid/wall/oracle" />
	</bean>
    ###### @wenshao ，有配置两个 log filter吗？######感觉是配置了两个log filter，你在LogFilter中调试看看，是不是两个LogFilter了。###### 可能是这里： log4j.logger.druid.sql=info,stdout,infolog 导致输出了两次
    2020-05-28 16:11:15
    赞同 展开评论
问答分类：
SQL druid 日志服务
问答标签：
SQL日志 配置日志服务 SQL配置 druid日志服务 日志服务文件
问答地址：
开发者社区 > 数据库 > 问答
相关问答
日志服务分析Trace数据能看到sql的参数吗
99
1
0
数据库自治服务SQL审计日志如何过滤DQL语句
77
1
0
ARMS使用sls日志服务的Node.js SDK能通过sql的形式查询logstore-rum吗？
174
1
0
Flink的SQL脚本接kafka 当一条消息来了可不可以在日志中打印出来？
104
1
0
在实时数仓Hologres中hologres 有query_log之类的吗用户的查询sql如何导出？
109
1
0
云数据仓库ADB Spark SQL访问MaxCompute数据源-支持的库表操作
118
1
0
大数据计算MaxCompute sql查询平台，数据地图，数据调度等均无法访问，为什么？
83
0
0
云数据仓库ADB Spark SQL访问OSS外表-（可选）步骤五：删除外表
105
1
0
怎么可以通过云函数计算来访问DMS的SQL数据库呢？
145
1
0
RDS for SQL Server收缩事务日志
90
1
0