Experience Portal : Voice Portal : Customer cannot login to VPMS webadmin

Doc ID    SOLN258243
Version:    4.0
Status:    Published
Published date:    11 Aug 2017
Created Date:    21 Oct 2014
Author:   
Mukti Sharma
 

Details

VP 5.1

VP 5.0 Sp2

Problem Clarification

Customer was not able to login to VP webadmin page

Cause

After applying the security patch customer did not rebooted the VPMS .(which is mandatory)

 

I could see in catalina logs that database connection times out which might cause the VPMS login issue, this error started coming from 26th September and after the VPMS reboot I cannot see this timeout.


Oct 14, 2014 2:04:51 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 2:06:01 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 2:09:21 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 2:16:00 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 2:19:19 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 2:26:55 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 2:33:40 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 2:39:04 AM com.avaya.vp.users.VoicePortalRealm$VPRealmExceptionLog log
SEVERE: getConnection: problem connecting to the database: jdbc:postgresql://127.0.0.1:5432/VoicePortal
org.postgresql.util.PSQLException: Connection attempt timed out.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
      at org.postgresql.Driver.connect(Driver.java:264)
      at com.avaya.vp.users.VoicePortalRealm.getConnection(VoicePortalRealm.java:727)
      at com.avaya.vp.users.VoicePortalRealm.getTimeStampFromDB(VoicePortalRealm.java:825)
      at com.avaya.vp.users.VoicePortalRealm.access$100(VoicePortalRealm.java:49)
      at com.avaya.vp.users.VoicePortalRealm$VPCacheUpdateThread.run(VoicePortalRealm.java:148)
Oct 14, 2014 9:10:06 AM com.sun.faces.lifecycle.Phase doPhase


I can see patch bash-3.2-33.el5_11.4 was intalled on the system on 26th september and as per process after appplying any patch on system a clean reboot should be performed .

[sroot@MYAUSLV00100817 logs]# rpm -qa --last
bash-3.2-33.el5_11.4                          Fri 26 Sep 2014 05:23:12 PM EST
a

 

Solution

Rebooted the VPMS server fiexed the issue


Avaya -- Proprietary. Use pursuant to the terms of your signed agreement or Avaya policy