Grouper Users - Open Discussion List

[Wayne Hall <>]

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