Highlighted
CIURI86 Absent Member.
Absent Member.
446 views

Sentinel 7.3.2.0-2101 Reports errors after upgrade


Hello ,

today I updated my test environment server from 7.3.1 to 7.3.2.0-2101
but for now some old reports don't work anymore . I got this strange
error after upgrade in server0.0.log:




Code:
--------------------


Thu Dec 03 22:25:46 EET 2015|WARNING|qtp1831715352-850|org.eclipse.jetty.server.handler.ContextHandler$Context.log
Exception while dispatching incoming RPC call
Caused by: Error DBConnectException(General): FATAL: password authentication failed for user "rptuser" - SQLState : 28P01 - ErrorCode : 0; Root cause: FATAL: password authentication failed for user "rptuser" (org.postgresql.util.PSQLException)
java.lang.RuntimeException: com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract com.novell.sentinel.scout.client.report.RunReportParams com.novell.sentinel.scout.client.report.SentinelReportService.getRunReportParams(java.lang.String,java.lang.String) throws com.novell.sentinel.scout.client.exception.RemoteExceptionForGwt,com.novell.sentinel.scout.client.exception.InvalidArgumentException' threw an unexpected exception: java.lang.RuntimeException: Could not fetch parameters for the given report
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.handleExporterProcessingException(GWTRPCServiceExporter.java:456)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.processCall(GWTRPCServiceExporter.java:425)
at com.novell.sentinel.scout.server.SafeRPCServiceExporter.processCall(SafeRPCServiceExporter.java:30)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:305)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.handleRequest(GWTRPCServiceExporter.java:478)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:788)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:717)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
at com.novell.sentinel.scout.server.filters.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:32)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at com.novell.sentinel.scout.server.filters.ValidUserFilter.doFilter(ValidUserFilter.java:35)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1476)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:370)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
at org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:196)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract com.novell.sentinel.scout.client.report.RunReportParams com.novell.sentinel.scout.client.report.SentinelReportService.getRunReportParams(java.lang.String,java.lang.String) throws com.novell.sentinel.scout.client.exception.RemoteExceptionForGwt,com.novell.sentinel.scout.client.exception.InvalidArgumentException' threw an unexpected exception: java.lang.RuntimeException: Could not fetch parameters for the given report
at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:389)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.encodeResponseForFailure(GWTRPCServiceExporter.java:302)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.handleInvocationTargetException(GWTRPCServiceExporter.java:327)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.processCall(GWTRPCServiceExporter.java:416)
... 45 more
Caused by: java.lang.RuntimeException: Could not fetch parameters for the given report
at esecurity.ccs.comp.reporting.EReportingService.getParameters(EReportingService.java:1494)
at esecurity.db.object.ReportingServiceAuditShim.getParameters(ReportingServiceAuditShim.java:1318)
at com.novell.sentinel.scout.server.SentinelReportServiceImpl.getReportDefinitionParametersInternal(SentinelReportServiceImpl.java:135)
at com.novell.sentinel.scout.server.SentinelReportServiceImpl.getReportDefinitionParameters(SentinelReportServiceImpl.java:187)
at com.novell.sentinel.scout.server.SentinelReportServiceImpl.getRunReportParams(SentinelReportServiceImpl.java:998)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.invokeMethodOnService(GWTRPCServiceExporter.java:245)
at org.gwtwidgets.server.spring.GWTRPCServiceExporter.processCall(GWTRPCServiceExporter.java:410)
... 45 more
Caused by: java.lang.RuntimeException: Unable to get option query parameters:
at esecurity.ccs.comp.reporting.EReportingService.populateOptionQueryParameter(EReportingService.java:2080)
at esecurity.ccs.comp.reporting.EReportingService.processParameters(EReportingService.java:2475)
at esecurity.ccs.comp.reporting.EReportingService.getParameters(EReportingService.java:1483)
... 55 more
Caused by: esecurity.base.exceptions.DBConnectException: FATAL: password authentication failed for user "rptuser" - SQLState : 28P01 - ErrorCode : 0



--------------------


--
CIURI86
------------------------------------------------------------------------
CIURI86's Profile: https://forums.netiq.com/member.php?userid=5735
View this thread: https://forums.netiq.com/showthread.php?t=54787

0 Likes
1 Reply
CIURI86 Absent Member.
Absent Member.

Re: Sentinel 7.3.2.0-2101 Reports errors after upgrade


Code:
--------------------

at esecurity.base.db.connection.DBConnectionPool.getNewConnection(DBConnectionPool.java:406)
at esecurity.base.db.connection.DBConnectionPool.getConnection(DBConnectionPool.java:141)
at esecurity.ccs.comp.reporting.jasper.JasperReportingComponent$ReportUserDBConnectionManager.getConnection(JasperReportingComponent.java:163)
at esecurity.ccs.comp.reporting.EReportingService.doExecuteOptionSelectStatement(EReportingService.java:1276)
at esecurity.ccs.comp.reporting.EReportingService.executeOptionSelectStatement(EReportingService.java:1267)
at esecurity.ccs.comp.reporting.EReportingService.populateOptionQueryParameter(EReportingService.java:2044)
... 57 more
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "rptuser"

at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at esecurity.base.db.platform.DefaultPlatform.getNewConnection(DefaultPlatform.java:382)
at esecurity.base.db.platform.PostgreSQLPlatform.getNewConnection(PostgreSQLPlatform.java:357)
at esecurity.base.db.connection.DBConnectionPool.getNewConnection(DBConnectionPool.java:391)
... 62 more

--------------------


And when I rerun the setup to change passwords :


Code:
--------------------



A list of questions will now be presented.
Your answers to these questions will be used to configure Sentinel for this server.

1. Standard configuration
2. Custom configuration

Select the configuration method [1] => 2

1. Use a default evaluation license key
2. Enter a purchased license key for Sentinel
3. Keep the currently installed license

Select a license method [3] => 3
============================================================================================================================================================================================================================================



The "admin" user is the identity used for initial and subsequent administration tasks through the Sentinel user interface, including the creation of other user accounts.

User "admin" has an existing password.

1. Keep the existing password
2. Enter a new password

Select what you want to do [1] => 2

Enter the password for admin... =>
Confirm the password for admin: =>
============================================================================================================================================================================================================================================

The "dbauser" user is the identity used by Sentinel configuration commands to interact with the database. The password you enter here can be used to perform database maintenance tasks, including resetting the "admin" password if the
"admin" password is forgotten or lost.

User "dbauser" has an existing password.

1. Keep the existing password
2. Enter a new password

Select what you want to do [1] => 2

Enter the password for dbauser... =>
Confirm the password for dbauser: =>
============================================================================================================================================================================================================================================

The "appuser" user is an internal identity used by Sentinel Java process to establish connection and interact with the database. The password you enter here can be used by Sentinel Java process to perform database tasks.

User "appuser" has an existing password.

1. Keep the existing password
2. Enter a new password

Select what you want to do [1] => 2

Enter the password for appuser... =>
Confirm the password for appuser: =>
Error: Could not find or load main class esecurity.base.ccs.util.EncryptPassword
Password not changed in Security Intelligence database
Error setting the password for the "" user. Check /var/opt/novell/sentinel/log/si_db.log
Error: Could not find or load main class esecurity.base.ccs.util.EncryptPassword
Error: Could not find or load main class esecurity.base.ccs.util.EncryptPassword
Password not changed in Security Intelligence database
Error: Could not find or load main class esecurity.base.ccs.util.EncryptPassword
Password not changed in Security Intelligence database
Error setting the password for the "" user. Check /var/opt/novell/sentinel/log/si_db.log


--------------------


And the si_db.log doesn't exist.


--
CIURI86
------------------------------------------------------------------------
CIURI86's Profile: https://forums.netiq.com/member.php?userid=5735
View this thread: https://forums.netiq.com/showthread.php?t=54787

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.