dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Hi JP,

Kindly check the number of connections to the DB server.You must be running
out of connections since all instances share the same DB server. Bob can
assist.


Alex

On Saturday, July 16, 2016, J. Paul Mutali <mutali@xxxxxxxxx> wrote:

> Hi there,
>
> we are having issues on our instances where users can login to instances,
>
> when you restart the server , everything works for few hours and then no
> user cant enter again and the instance does not give any  error message.
>
> here is the log form one instance:
>
>  INFO  2016-07-16 02:00:02,302 'system-process' create
> org.hisp.dhis.datastatistics.DataStatistics, uid: xry0yKYJwrm
> (AuditLogUtil.java [taskScheduler-7])
> * INFO  2016-07-16 02:00:02,926 Saved data statistics snapshot
> (DataStatisticsTask.java [taskScheduler-7])
> * WARN  2016-07-16 10:22:31,761 Authentication event
> AuthenticationSuccessEvent:randy; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@166c8:
> RemoteIpAddress: 10.0.3.2; SessionId: 0B0B9001C894367D42DDDD97E8EEC87D
> (LoggerListener.java [tomcat-http-2])
> * WARN  2016-07-16 10:22:31,888 Authentication event
> SessionFixationProtectionEvent: randy; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@166c8:
> RemoteIpAddress: 10.0.3.2; SessionId: 0B0B9001C894367D42DDDD97E8EEC87D
> (LoggerListener.java [tomcat-http-2])
> * WARN  2016-07-16 10:22:31,888 Authentication event
> InteractiveAuthenticationSuccessEvent: randy; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@166c8:
> RemoteIpAddress: 10.0.3.2; SessionId: 0B0B9001C894367D42DDDD97E8EEC87D
> (LoggerListener.java [tomcat-http-2])
> * INFO  2016-07-16 10:22:32,199 'randy' update
> org.hisp.dhis.user.UserCredentials, name: Randy Wilson, uid: Wqd844HmPt5
> (AuditLogUtil.java [tomcat-http-2])
> * WARN  2016-07-16 10:22:37,404 Authentication event
> AuthenticationSuccessEvent:randy; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@ffff4c9c:
> RemoteIpAddress: 10.0.3.2; SessionId: F1CF7C76C0C4359EBB9759A9295D3AC3
> (LoggerListener.java [tomcat-http-1])
> * WARN  2016-07-16 10:22:37,405 Authentication event
> SessionFixationProtectionEvent: randy; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@ffff4c9c:
> RemoteIpAddress: 10.0.3.2; SessionId: F1CF7C76C0C4359EBB9759A9295D3AC3
> (LoggerListener.java [tomcat-http-1])
> * WARN  2016-07-16 10:22:37,405 Authentication event
> InteractiveAuthenticationSuccessEvent: randy; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@ffff4c9c:
> RemoteIpAddress: 10.0.3.2; SessionId: F1CF7C76C0C4359EBB9759A9295D3AC3
> (LoggerListener.java [tomcat-http-1])
> * INFO  2016-07-16 10:22:37,413 'randy' update
> org.hisp.dhis.user.UserCredentials, name: Randy Wilson, uid: Wqd844HmPt5
> (AuditLogUtil.java [tomcat-http-1])
>
>
> any hint?
>
> 10.0.3.2 is our proxy server (nginx)
>
>
> Thanks
>
>

-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET  | HISP Uganda
Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant


"I don't want to be anything other than what I have been - one tree hill "