Verify logging to database is functioning.

Verify logging to database is functioning.

To see if the report log data is being written, start by making a standard link to /FlushDatabaseCache and assign that to PortalAdminGroup. 
On the loader turn on the debug com.stoneware.service.public.report.insertDataRow , set that to debug and click save. 
Click on View log 

Now run the FlushDatabaseCache link and watch the report viewer for information similar to the following: 
(be sure to shut this off after testing) 

DEBUG [com.stoneware.service.public.Report.insertDataRow]: Cache search string: cn=ReportLogs,ou=stoneware,o=companyroot***encrypted password*** 
DEBUG [com.stoneware.service.public.Report.insertDataRow]: Attempting new connection with class: org.gjt.mm.mysql.Driver connection: jdbc:mysql://192.168.1.13:3306/webnetwork 
DEBUG [com.stoneware.service.public.Report.insertDataRow]: Cached new connection for cn=ReportLogs,ou=stoneware,o=company root***encrypted password*** 
DEBUG [com.stoneware.service.public.Report.insertDataRow]: Removing cached meta data for: cn=ReportLogs,ou=stoneware,o=companyroot***encrypted password*** 
INFO [com.stoneware.service.public.Report.insertDataRow]: ExecuteQuery: INSERT INTO LogTable (ClientHost,UserAgent,Referer,Bytes,Status,Request,RelayDN,Username,LogTime) VALUES (’192.168.1.69’,’Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)’,’http://webnet1.stone-ware.com/secure/swempProfile/FinishLogin.html’,60292,200,’GET /components/displayComponents.jsp HTTP/1.1’,’ou=relay,ou=stoneware,o=companyroot’,’cn=Juser,ou=emp,ou=users,o=companyroot’,’2006-11-13 14:37:29’) 

You should now be able to make a report from the logging table that dumps out all of the data ordered by logtime and see the GET /FlushedDatabaseCache