createcontext fails with 'configdb.filestore.max_context' isn't in GROUP BY

[swalter]

Hi,

I'm following installation of OX7 under CentOS7 with MariaDB 10.2 (https://oxpedia.org/wiki/index.php?t..._configuration).

Everything goes fine (except I had to disable SELinux), but I'm currently failing in creating the default context.

The createcontext command gives the following output.

context 1 could not be created: 
Server response:
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 'configdb.filestore.max_context' isn't in GROUP BY
	at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorage.findFilestoreForEntity(OXUtilMySQLStorage.java:1925)
	at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorage.findFilestoreForContext(OXUtilMySQLStorage.java:1784)
	at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1558)
	at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:1236)
	at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:179)
	at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:453)
	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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357)
	at sun.rmi.transport.Transport$1.run(Transport.java:200)
	at sun.rmi.transport.Transport$1.run(Transport.java:197)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
	at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:283)
	at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:260)
	at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:161)
	at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
	at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
	at com.sun.proxy.$Proxy0.create(Unknown Source)
	at com.openexchange.admin.console.context.Create.maincall(Create.java:143)
	at com.openexchange.admin.console.context.CreateCore.commonfunctions(CreateCore.java:147)
	at com.openexchange.admin.console.context.Create.<init>(Create.java:80)
	at com.openexchange.admin.console.context.Create.main(Create.java:84)

[swalter]

SOLVED

After reading the installation manual again, I found the problem. I did not adapt the proper entry for "sql_mode" in tunings.cnf. I left a "ONLY_FULL_GROUP_BY" value in there...
Now I can create the context!