topic Re: Regarding Audit in Alfresco Archive

Regarding Audit

archana_bonkanp — Mon, 18 Feb 2008 13:16:00 GMT

Can anyone explain me how to implement audit ,i have gone through the site http://wiki.alfresco.com/wiki/Audit#Auditing_flow but im not geting an clear ideawhen i apply the template the information which i cant understand is displayedcan any one help in these

Re: Regarding Audit

jbarmash — Sat, 23 Feb 2008 17:33:32 GMT

I am not sure what you mean by "implement audit". Alfresco supports auditing internally. Once you enable it, it starts writing to database audit tables. This happens in many core services, on the code level (through Java annotations).

Then you can write SQL queries to pull out the information you care about.

Did you enable auditing on your system? If so, explore the entries that are being made into the DB and play around with some SQL.

Re: Regarding Audit

archana_bonkanp — Mon, 25 Feb 2008 05:56:24 GMT

"implement audit" is i want to get the information of the user who edited the file,deleted the file and the whatever actions done on a particular file.

i have enabke audit,when applied a template it gives some technical information,but endusers who uses the system needs only the information like edited,deleted the file,he is no way concerned with other technical information

Re: Regarding Audit

andy — Tue, 26 Feb 2008 17:22:51 GMT

Hi

You need your own simplified audit template.
Use the existing one as a base.

Andy

Re: Regarding Audit

archana_bonkanp — Wed, 27 Feb 2008 05:56:35 GMT

but the audit template doesnt give information of deleted contents

Re: Regarding Audit

andy — Thu, 28 Feb 2008 16:58:30 GMT

Hi

You are correct. Some APIs for delete only require the node ref so the parent is not recorded anywhere. The audit service does not have a good API for general queries at the moment. You can get delete information from the DB - but again it will be a bit of a pain to link it up. The wiki was some mysql DB magic to generate paths that may help you.

In the longer term, audit needs to have the option to record path and the user friendly name path.

Andy

Re: Regarding Audit

etzapata — Thu, 01 May 2008 01:43:38 GMT

Hi Andy,

I have turned on auditing but I don't know where in MySQL tables that says who uploads, review/read, and approve a certain document and when. I have searched in the wiki regarding audit but the samples given where limited to:

1. when a user logs in,
2. who among the users have never logged in.

I was required to submit a report regarding the following:

1. Who uploads the document and When?
2. Who edits/reviews the document and When?
3. Who approves the document and When?

Where can I find these information? Please help.
Thank you very much.

EriCtZ

Re: Regarding Audit

etzapata — Mon, 12 May 2008 08:04:44 GMT

Hello everyone,

I also have another question (my problem above has not been answered yet), since turning ON the audit trail will affect the performance of the system, is it possible to just audit the folders that needs to be audited? For example, I have different folders in Company Home: Daily Reports, Images, ISO, Clearing, etc. How do I configure the audit to audit only the things that happen in ISO folder? If everything is audited, it will greatly affect our database as well. I have read the wiki regarding audit but it does not give me a clearer view.

Also, I have queried the following script in MySQL but it says nothing (0 rows fetched).

select * from alf_audit_fact fact
join alf_audit_date date on fact.audit_date_id = date.id
join alf_audit_source source on fact.audit_source_id = source.id
where Service='FileFolderService' and method='move' and fail='0' and return_val like '%isFolder=false%';

I am sure I have turned ON auditing and am sure that many documents have been moved from one folder to another.
How do I make this work?

I was already asked to submit a report as to who approves, who rejects, when and how many (as for our workflow).
If anyone can help me, I'd really be ver grateful.
Thank you very much.

EriCtZ

Re: Regarding Audit

archana_bonkanp — Tue, 13 May 2008 12:48:01 GMT

Hi All,

I have a folder "Corporate Information" folder in CompanyHome, when we direct open the application can we directly root to the Corporate Information folder instead of MyDashboard or CompanyHome.If yes,please let us know.

Atleast we tried directly to route to CompanyHome instead of MyDashboard.
But its not working correctly.'
Please help.

Re: Regarding Audit

etzapata — Thu, 29 May 2008 01:43:20 GMT

Hi all,

Is there anyone knew where I can find the table in Mysql that says who approves the document, who reads, who deletes, etc? I have turned auditing ON but still i cant find the table of the stated audit trail.

Please help…

EriCtZ

Re: Regarding Audit

etzapata — Fri, 06 Jun 2008 07:53:56 GMT

Hi All,

Hasn't anyone activated the auditing function of Alfresco?

Please help.

EriCtZ

Re: Regarding Audit

archana_bonkanp — Fri, 06 Jun 2008 09:07:49 GMT

HI All,

We got an exception in Audit,
We enabled Audit from the information gathered from alfresco wiki in february.
Everything was working fine and yesterday we took some login reports from database.
when we login to the application,we were unable to login.
We examined logs, so we got the following error.

we disabled Audit so the server started working fine.

Please help us in solving the above exception as we also need of audit.

07:27:44,156 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.repo.audit.AuditException: Failed to audit exception
   at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:275)
   at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:191)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy43.createPackage(Unknown Source)
   at org.alfresco.repo.workflow.WorkflowInterpreter.executeCommand(WorkflowInterpreter.java:1275)
   at org.alfresco.repo.workflow.WorkflowInterpreter.access$100(WorkflowInterpreter.java:83)
   at org.alfresco.repo.workflow.WorkflowInterpreter$1$1.doWork(WorkflowInterpreter.java:288)
   at org.alfresco.repo.workflow.WorkflowInterpreter$1$1.doWork(WorkflowInterpreter.java:286)
   at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:189)
   at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:89)
   at org.alfresco.repo.workflow.WorkflowInterpreter$1.doWork(WorkflowInterpreter.java:284)
   at org.alfresco.repo.workflow.WorkflowInterpreter$1.doWork(WorkflowInterpreter.java:282)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:260)
   at org.alfresco.repo.workflow.WorkflowInterpreter.interpretCommand(WorkflowInterpreter.java:280)
   at org.alfresco.repo.workflow.WorkflowInterpreter.onBootstrap(WorkflowInterpreter.java:149)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:448)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [org.alfresco.repo.audit.hibernate.AuditDateImpl]
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
   at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2108)
   at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2588)
   at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
   at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:290)
   at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:180)
   at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:108)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
   at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
   at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
   at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
   at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
   at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
   at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
   at org.alfresco.repo.audit.hibernate.HibernateAuditDAO.getAuditDate(HibernateAuditDAO.java:317)
   at org.alfresco.repo.audit.hibernate.HibernateAuditDAO.audit0(HibernateAuditDAO.java:149)
   at org.alfresco.repo.audit.hibernate.HibernateAuditDAO.audit(HibernateAuditDAO.java:139)
   at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:260)
   … 52 more
Caused by: java.sql.SQLException: Data truncated for column 'date_only' at row 1
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
   at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
   at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
   at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
   … 71 more

Thanks & Regards,
Archana

Re: Regarding Audit

etzapata — Fri, 06 Jun 2008 09:46:28 GMT

Hi Archana,

Since you were into audit, I was wondering if you already discover where in the tables shall I retrieve the details as to:

1. Who approves a document,
2. When the document was approved/rejected,
3. List of documents uploaded by a certain user,
and etc. etc…

Kindly tell us where to get these info. Thank you very much.

EriCtZ

Re: Regarding Audit

andrewriver — Wed, 10 Nov 2010 20:25:09 GMT

Hi!

I want to restart this forum questioning about auditing on Alfresco 3.4.b … Any info, example, tips will be very appreciate.

Regards

Re: Regarding Audit

mcraven — Tue, 23 Nov 2010 19:02:56 GMT

As of version 3.4 auditing has been completely rewritten. Take a look at the Wiki at:
http://wiki.alfresco.com/wiki/Auditing_(from_V3.4)
It would appear that it is only accessible through the API, i.e., the is no user interface available.

Regards,
Mark C.

Re: Regarding Audit

andrewriver — Tue, 23 Nov 2010 19:11:37 GMT

Thanks Mark,

I readed this wiki and made the example of the authentication audit webscripts, but for example, how to get auditing for upload, modify, delete documents? and get this information in alfresco share by dashlets?

Regards,

Andres