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

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Lenovo Unified Workspace End-of-Life Questions and Answers

        Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...

      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...

      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...

      • LanSchool Documentation Guides

        LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...

      • Lenovo Unified Workspace 7.0.1.41 Released

        Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...

      • Related Articles

      • Move database logging to SQL server.

        Changing / migrating the Logging Database from HSQL to MySQL , MSSQL. By default, the Stoneware Relay logs all transactions to a Java database called HyperSonic SQL. This database is installed as part of the portal installation and automatically ...

      • Database Pooling

        Issue The way UW connects to a Database to run queries, it uses a single connection for each DB object created.  Thus if you have multiple queries that are run against that connection, they are processed in order, one at a time.  A very long query ...

      • Verify Active Directory SSL

        How can I check if my Microsoft Active Directory Domain controller / LDAP Server has SSL ?   The following URL has a nice write up about the Microsoft Tool called LDP.exe http://www.computerperformance.co.uk/w2k3/utilities/ldp.htm You can download ...

      • What does webNetwork send to the SQL server to purge logging data each night?

        Each night at midnight the loader sends a SQL command to the SQL server to purge old log information.  That command is as follows : DELETE FROM LogTable WHERE LogTime < 'some date'; 'some date' is formatted like this: yyyy-MM-dd HH:mm:ss If your ...

      • Unable to Verify / Extend Schema

        On the console the customer sees : FATAL (05/09) 12:10:51 [com.stoneware.service.DirectoryManager]: Unable to verify/extend schema. javax.naming.CommunicationException: simple bind failed: 10.1.1.17:636 [Root exception is ...