change views in grouper to use index prefixes so it fits in default mysql utf configuration

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...

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: grouper-users-request@internet2.edu grouper-users-request@internet2.edu On Behalf Of Wayne Hall
> Sent: Wednesday, May 25, 2016 6:18 PM
> To: grouper-users@internet2.edu
> 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
>
>