Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

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