Grouper Users - Open Discussion List

[Wayne Hall <>]

Hello:

Okay, thanks.  I do not have that kind of access to our MariaDB to correct the BINLOG_FORMAT error 
(still curious about the install error).  So, to work around the permissions issue, I created a new 
local grouper vm with its own mysql db and was able to apply the BINLOG_FORMAT fix for that error...

This new instance of grouper also has a working tomcat and ws webpage.  And now the grouper app is 
running, however the grouper ui instance also errors with http error 500.

Here is the grouperUi/grouper_error.log file:

2016-06-01 10:06:28,402: [http-8080-1] ERROR GrouperUiFilter.doFilter(1030) - 
 - UI error
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 1 in the generated java file
The type java.io.ObjectInputStream cannot be resolved. It is indirectly referenced from required 
.class files

Stacktrace:
    at 
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
    at 
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
    at 
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
    at org.apache.jasper.compiler.Compiler.compile(Compiler.java:356)
    at org.apache.jasper.compiler.Compiler.compile(Compiler.java:334)
    at org.apache.jasper.compiler.Compiler.compile(Compiler.java:321)
    at 
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
    at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
    at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:110)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at 
edu.internet2.middleware.grouper.ui.GrouperUiFilter.doFilter(GrouperUiFilter.java:1023)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:745)
2016-06-01 10:06:28,691: [http-8080-1] ERROR GrouperUiFilter.doFilter(1047) -  - Failed to include 
error page:
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 1 in the generated java file
The type java.io.ObjectInputStream cannot be resolved. It is indirectly referenced from required 
.class files

An error occurred at line: 32 in the jsp file: /WEB-INF/jsp/template.jsp
The type java.lang.CharSequence cannot be resolved. It is indirectly referenced from required 
.class files
29: request.setAttribute(“pageUrlMinusQueryString”, pageUrlMinusQuery);
30: char delim = ‘?’;
31: if(request.getQueryString()!=null) {
32:     pageUrl.append(“?” + request.getQueryString());
33:     delim='&’;
34: }
35: request.setAttribute(“pageUrl”,pageUrl.toString());


Stacktrace:
    at 
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
    at 
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
    at 
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
    at org.apache.jasper.compiler.Compiler.compile(Compiler.java:356)
    at org.apache.jasper.compiler.Compiler.compile(Compiler.java:334)
    at org.apache.jasper.compiler.Compiler.compile(Compiler.java:321)
    at 
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
    at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
    at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    at 
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1074)
    at 
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:276)
    at 
org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:252)
    at 
org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:315)
    at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:246)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    at 
edu.internet2.middleware.grouper.ui.GrouperUiFilter.doFilter(GrouperUiFilter.java:1042)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:745)

Still puzzled by this.

Thanks,
Wayne



On 05/25/2016 05:00 PM, Hyzer, Chris wrote:
> I googled your error message, does it help?  :)
>
> https://confluence.atlassian.com/stashkb/stash-2-7-fails-to-start-with-mysql-when-binary-logging-is-enabled-400917077.html
>
> Thanks
> Chris
>
> -----Original Message-----
> From: 
>
>  
> [mailto:]
>  On Behalf Of Wayne Hall
> Sent: Wednesday, May 25, 2016 6:18 PM
> To: 
>
> Subject: [grouper-users] 2.3 install issue
>
> Hi,
>
> I am having problems getting grouper to start on a fresh 2.3 grouper install. 
>  I have tried to
> following install on a Ubuntu 14.04 vm server without success:
>
> Grouper 2.3: Java 7, Java 8, connecting to our existing mysql, and connecting 
> to new mysql database.
>
> However on the same Ubuntu 14.04 vm:
>
> Grouper 2.2.2: Java 7, Java 8, and our existing mysql all work as expected.  
> Ultimately, I prefer
> to use our existing (working) mysql database with  the 2.3 (however the 2.3 
> install pointing to our
> working mysql gives a ddl/java error).
>
> Getting this error during the 2.3 install:
>
> ##################################
>       Tomcat stop with command (note you need CATALINA_HOME and JAVA_HOME 
> set):
>         /opt/grouper/apache-tomcat-6.0.35/bin/shutdown.sh
>
>       May 25, 2016 8:47:01 AM 
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils
> execCommandHelper
>       SEVERE: Process exit status=1: out: , err: Java HotSpot(TM) 64-Bit 
> Server VM warning: ignoring
> option MaxPermSize=150m; support was removed in 8.0
>       May 25, 2016 8:47:01 AM org.apache.catalina.startup.Catalina stopServer
>       SEVERE: Catalina.stop:
>       java.net.ConnectException: Connection refused
>           at java.net.PlainSocketImpl.socketConnect(Native Method)
>           at 
> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>           at 
> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>           at 
> java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>           at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>           at java.net.Socket.connect(Socket.java:589)
>           at java.net.Socket.connect(Socket.java:538)
>           at java.net.Socket.<init>(Socket.java:434)
>           at java.net.Socket.<init>(Socket.java:211)
>           at 
> org.apache.catalina.startup.Catalina.stopServer(Catalina.java:422)
>           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:498)
>           at 
> org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:338)
>           at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:416), 
> on command:
> /usr/lib/jvm/java-8-oracle/bin/java -XX:MaxPermSize=150m -Xmx640m
> -Dcatalina.home=/opt/grouper/apache-tomcat-6.0.35 -jar
> /opt/grouper/apache-tomcat-6.0.35/bin/bootstrap.jar stop , workingDir:
> /opt/grouper/apache-tomcat-6.0.35/bin
>       java.lang.RuntimeException: Process exit status=1: out: , err: Java 
> HotSpot(TM) 64-Bit Server
> VM warning: ignoring option MaxPermSize=150m; support was removed in 8.0
>
>       May 25, 2016 8:47:01 AM org.apache.catalina.startup.Catalina stopServer
>       SEVERE: Catalina.stop:
>       java.net.ConnectException: Connection refused
>           at java.net.PlainSocketImpl.socketConnect(Native Method)
>           at 
> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>           at 
> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>           at 
> java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>           at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>           at java.net.Socket.connect(Socket.java:589)
>           at java.net.Socket.connect(Socket.java:538)
>           at java.net.Socket.<init>(Socket.java:434)
>           at java.net.Socket.<init>(Socket.java:211)
>           at 
> org.apache.catalina.startup.Catalina.stopServer(Catalina.java:422)
>           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:498)
>           at 
> org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:338)
>           at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:416),
>
>       java.lang.RuntimeException: caller stack
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.threadRunWithStatusDots(GrouperInstallerUtils.java:8312)
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10040)
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10003)
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:9979)
>           at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.tomcatBounce(GrouperInstaller.java:738)
>           at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.buildWs(GrouperInstaller.java:8051)
>           at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(GrouperInstaller.java:6287)
>           at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$300(GrouperInstaller.java:79)
>           at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMainFunction$1.logic(GrouperInstaller.java:971)
>           at
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperInstaller.java:1033)
>           at 
> edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstaller.java:304)
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommandHelper(GrouperInstallerUtils.java:10137)
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.access$100(GrouperInstallerUtils.java:128)
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils$2.run(GrouperInstallerUtils.java:10035)
>           at
> edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils$1.run(GrouperInstallerUtils.java:8259)
>           at java.lang.Thread.run(Thread.java:745)
>
> After the install I can web browse to the tomcat page and notice grouper is 
> not started.  When I
> try to start grouper the tomcat web page errors with this message:
> FAIL - Application at context path /grouper could not be started
>
> The grouperUi/grouper_error.log, gives this error:
> 2016-05-25 15:38:21,136: [http-8080-2] ERROR 
> SqlExceptionHelper.logExceptions(129) -  - Cannot
> execute statement: impossible to write to binary log since BINLOG_FORMAT = 
> STATEMENT and at least
> one table uses a storage engine limited to row-based logging. InnoDB is 
> limited to row-logging when
> transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
> 2016-05-25 15:38:21,137: [http-8080-2] ERROR 
> BatchingBatch.performExecution(124) -  - HHH000315:
> Exception executing batch [could not execute batch]
>
> Let me know if additional info is needed.
>
> Thanks for any insights for a resolve,
> Wayne