# Wowza log to Database is not work with event Play

**URL:** https://community.wowza.com/t/wowza-log-to-database-is-not-work-with-event-play/50419
**Category:** Wowza Streaming Engine
**Tags:** wowza-streaming-server-java-api
**Created:** [December 21, 2017, 6:05pm UTC](https://community.wowza.com/t/wowza-log-to-database-is-not-work-with-event-play/50419 "2017-12-21T18:05:42Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Diego\_Fonseca](https://avatars.discourse-cdn.com/v4/letter/d/e99b99/32.png) [@Diego\_Fonseca](https://community.wowza.com/u/Diego_Fonseca)
#### Post date: [December 21, 2017, 6:05pm UTC](https://community.wowza.com/t/wowza-log-to-database-is-not-work-with-event-play/50419/1 "2017-12-21T18:05:42Z")

</div>

Hello,  
Im working with wowza log to database, but the play event don’t see in the table access log, I just can see comment event.  
in my configuration file i’ve a following:

"  
log4j.appender.SQ=org.apache.log4j.jdbc.JDBCAppender  
log4j.appender.SQ.Driver=com.mysql.jdbc.Driver  
log4j.appender.SQ.URL=jdbc:mysql://dev2:3306/estreaming  
log4j.appender.SQ.user=admin  
log4j.appender.SQ.password=Saj236  
log4j.appender.SQ.layout=com.wowza.wms.logging.ECLFPatternLayout  
log4j.appender.SQ.layout.OutputHeader=false  
log4j.appender.SQ.sql=INSERT INTO accesslog (date, time, tz, xevent, xcategory, xseverity,xstatus,xctx,xcomment,xvhost,xapp,xappinst,xduration,sip,sport,suri,cip,cproto,creferrer,cuseragent,cclientid,csbytes,scbytes,xstreamid, xspos,csstreambytes,scstreambytes,xsname,xsnamequery,xfilename,xfileext,xfilesize,xfilelength,xsuri,xsuristem,xsuriquery,csuristem,csuriquery) VALUES (’%X{date}’, ‘%X{time}’, ‘%X{tz}’, ‘%X{x-event}’, ‘%X{x-category}’, ‘%X{x-severity}’, ‘%X{x-status}’, ‘%X{x-ctx}’, ‘%X{x-comment}’, ‘%X{x-vhost}’, ‘%X{x-app}’, ‘%X{x-appinst}’, ‘%X{x-duration}’, ‘%X{s-ip}’, ‘%X{sport}’, ‘%X{s-uri}’, ‘%X{c-ip}’, ‘%X{c-proto}’, ‘%X{c-referrer}’, ‘%X{c-user-agent}’, ‘%X{c-client-id}’, ‘%X{cs-bytes}’, ‘%X{scbytes}’, ‘%X{x-stream-id}’, ‘%X{x-spos}’,’%X{cs-stream-bytes}’, ‘%X{sc-stream-bytes}’, ‘%X{x-sname}’, ‘%X{x-sname-query}’, ‘%X{x-file-name}’, ‘%X{x-file-ext}’, ‘%X{x-file-size}’, ‘%X{x-file-length}’,’%X{x-suri}’,’%X{x-suri-stem}’, ‘%X{x-suri-query}’, ‘%X{c-suri-stem}’, ‘%X{c-suri-query}’);  
"

I appreciate your help