pentaho DBベースauditログを追加

1、biserver-ce/pentaho-solutions/system/pentahoObjectsを修正する.spring.xml

 <!--bean id="IAuditEntry" class="org.pentaho.platform.engine.services.audit.AuditFileEntry" scope="singleton" / ， SQLEntry-->
  <bean id="IAuditEntry" class="org.pentaho.platform.engine.services.audit.AuditSQLEntry" scope="singleton" />
 

 
2、建表pro_audit
    create table PRO_AUDIT

(
  JOB_ID             VARCHAR2(160),
  INST_ID            VARCHAR2(60),
  OBJ_ID             VARCHAR2(160),
  OBJ_TYPE           VARCHAR2(60),
  ACTOR              VARCHAR2(60),
  MESSAGE_TYPE       VARCHAR2(60),
  MESSAGE_NAME       VARCHAR2(60),
  MESSAGE_TEXT_VALUE VARCHAR2(60),
  MESSAGE_NUM_VALUE  VARCHAR2(60),
  DURATION           VARCHAR2(60),
  AUDIT_TIME         VARCHAR2(60),
  AUDIT_ID           NUMBER
)

 
3、audit_の修正sql

      cp biserver-ce/pentaho-solutions/system/dialects/postgresql/audit_sql.xml pentaho/biserver-ce/pentaho-solutions/system/audit_sql.xml

   
4、pentahoを再起動する