Activity Log Problem

[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

[jllort]

you are talking about OKM_ACTIVITY table or about $TOMCAT/logs/ files ?

[anubarak65]

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.

[jllort]

First count the number of lines you have in OKM_ACTIVITY table AT Administration>Database Query:

Code: Select all

select 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 all

LOGIN
LOGOUT
CREATE_.*
DELETE_.*
PURGE_.*
MOVE_.*
COPY_.*
DOWNLOAD_.*
CHECKOUT_DOCUMENT
CHECKIN_DOCUMENT
GET_DOCUMENT_CONTENT.*

[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?

[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.

[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 all

2016-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)

[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 ?

[anubarak65]

I restarted OpenKM, and yes i can make a ping.

[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.