Page 1 of 1
Activity Log Problem
PostPosted:Fri Jan 15, 2016 1:50 am
by anubarak65
I download your source code and made some changes ti it (nothing major) and had it run on an internal server (CentOS). I had a power failure which resulted in my backup to change IP address so I assigned a fixed IP afterwards but what i forgot to do it to mount my backup into the IP again. so as a result the backup started piling up in root file and caused my OS to crash. so i had to free up some space to be able to boot the system again. after deleting some log and temp files the OS came up again and i was manage to mount the back up into the right IP again. the system works fine now but the activity log only generates reports up to the day before the crash and not after. Any idea why this has happened and how can i fix it? thank you
Re: Activity Log Problem
PostPosted:Fri Jan 15, 2016 7:21 pm
by jllort
you are talking about OKM_ACTIVITY table or about $TOMCAT/logs/ files ?
Re: Activity Log Problem
PostPosted:Mon Jan 18, 2016 3:26 am
by anubarak65
jllort wrote:you are talking about OKM_ACTIVITY table or about $TOMCAT/logs/ files ?
Im talking about the OKM_ACTIVITY table.
Just to be sure i have put an img in the attachments.
Re: Activity Log Problem
PostPosted:Wed Jan 20, 2016 7:22 pm
by jllort
First count the number of lines you have in OKM_ACTIVITY table AT Administration>Database Query:
Code: Select allselect count(*) from OKM_ACTIVITY;
Next take a look at configuration parameter at Administration > Configuration parameters, named activity.log.actions, which is the value ?
Should be something like:
Code: Select allLOGIN
LOGOUT
CREATE_.*
DELETE_.*
PURGE_.*
MOVE_.*
COPY_.*
DOWNLOAD_.*
CHECKOUT_DOCUMENT
CHECKIN_DOCUMENT
GET_DOCUMENT_CONTENT.*
Re: Activity Log Problem
PostPosted:Fri Jan 22, 2016 1:24 am
by anubarak65
There are no results when I execute the query. Just an empty page.
And I dont have the configuration parameter you mentioned. But why would it show all the records before September and not after?
Re: Activity Log Problem
PostPosted:Sat Jan 23, 2016 9:19 am
by jllort
Did you changed the source code ?
Which OpenKM version are you using ? 6.3.1 ?
Take a look at catalina.log if there's some error there about inserting data in OKM_ACTIVITY table.
Re: Activity Log Problem
PostPosted:Tue Jan 26, 2016 1:36 am
by anubarak65
Yes i have changed to source code. but just to disable and add different function for administrator and normal users (E.g rolls and sharing). But my log use to work fine.
V. 6.3.1.
and this is in my
catalina.log.
Code: Select all2016-01-26 00:00:02,296 [ main] ERROR org.apache.catalina.startup.Catalina - Catalina.stop:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:208)
at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:490)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:371)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:452)
Re: Activity Log Problem
PostPosted:Thu Jan 28, 2016 3:08 pm
by jllort
Seems OpenKM is not starting ? could you stop openkm, remove catalina.log file, start again and upload entire log to see it.
Are you able to make a ping to your hostname ?
Re: Activity Log Problem
PostPosted:Fri Jan 29, 2016 1:30 am
by anubarak65
I restarted OpenKM, and yes i can make a ping.
Re: Activity Log Problem
PostPosted:Sat Jan 30, 2016 8:56 am
by jllort
Stop OpenKM, delete catalina.log file, start OpenKM and then share with us the catalina.log file.
Does your server binding to 0.0.0.0 check server.xml file into conf folder and looking for port 8080 -> should see in that xml tag binding to 0.0.0.0 rather localhost.