createcontext

[tsdauche]

Hallo habe folgendes problem:
createcontext -A oxadminmaster -P admin_master_password -c 1 -u ctxadmin -d "Context Admin" -g Admin -s User -p admin_password -e oxadmin@nagler-company.com -q 1024 -L defaultcontext --access-combination-name=all
context 1 could not be created:
Server response:
Error unmarshaling return; nested exception is:
java.lang.ClassNotFoundException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception (no security manager: RMI class loader disabled)


im admin log steht folgendes:
Nov 8, 2010 8:40:08 AM com.openexchange.admin.rmi.impl.OXContextCommonImp l createcommon
SEVERE: non-grouping field 'count' is used in HAVING clause
com.openexchange.admin.rmi.exceptions.StorageExcep tion: non-grouping field 'count' is used in HAVING clause
at com.openexchange.admin.storage.mysqlStorage.OXCont extMySQLStorage.getNextUnfilledSchemaFromDB(OXCont extMySQLStorage.java:1308)
at com.openexchange.admin.storage.mysqlStorage.OXCont extMySQLStorage.findOrCreateSchema(OXContextMySQLS torage.java:1207)
at com.openexchange.admin.storage.mysqlStorage.OXCont extMySQLStorage.create(OXContextMySQLStorage.java: 984)
at com.openexchange.admin.rmi.impl.OXContext.createma incall(OXContext.java:822)
at com.openexchange.admin.rmi.impl.OXContextCommonImp l.createcommon(OXContextCommonImpl.java:159)
at com.openexchange.admin.rmi.impl.OXContext.create(O XContext.java:215)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:613)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastSe rverRef.java:322)
at sun.rmi.transport.Transport$1.run(Transport.java:1 77)
at sun.rmi.transport.Transport$1.run(Transport.java:1 74)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport. java:173)
at sun.rmi.transport.tcp.TCPTransport.handleMessages( TCPTransport.java:553)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run0(TCPTransport.java:808)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run(TCPTransport.java:667)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:717)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: non-grouping field 'count' is used in HAVING clause
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:531)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 36)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1885)
at com.openexchange.admin.storage.mysqlStorage.OXCont extMySQLStorage.getNextUnfilledSchemaFromDB(OXCont extMySQLStorage.java:1296)
... 20 more

[tsdauche]

ok... der aufruf verträgt sich mit der mysql server mode nicht:

http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html#sqlmode_only_full_group_by

SELECT db_schema,COUNT(db_schema) AS count FROM context_server2db_pool WHERE write_db_pool_id=4 GROUP BY db_schema HAVING count<1000 ORDER BY count

führt dann zu einem fehler...
also einfach die server-mode leider doch abschalten...