Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 2 of 2

Thread: createcontext

  1. #1

    Default createcontext

    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

  2. #2

    Default

    ok... der aufruf verträgt sich mit der mysql server mode nicht:
    http://dev.mysql.com/doc/refman/5.1/..._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...

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •