Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 8 of 8
  1. #1
    HenningMalzahn Guest

    Default Unable to create default context

    Hello forum,

    I'm having trouble creating the default context. Let me first provide my system information:

    OS: Debian Lenny (5.0)
    OpenXchange version: (apt-cache policy open-xchange-common) --> Installed: 6.8.1-0

    Followed these installation steps: http://www.open-xchange.com/wiki/index.php?title=Quick_install_guide_for_the_Server _Edition_Debian5

    Even with leaving all the default passwords used in the manual above the following error ocours when issuing the following command:

    Code:
    /opt/open-xchange/sbin/createcontext -A oxadminmaster -P admin_master_password -c 1 \
    -u oxadmin -d "Context Admin" -g Admin -s User -p admin_password -L defaultcontext \
    -e oxadmin@example.com -q 1024 --access-combination-name=all
    Code:
    Feb 23, 2009 1:47:49 PM com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage create
    SEVERE: Storage Error
    com.openexchange.admin.rmi.exceptions.StorageException: No such group with ID 1 in context 1
            at com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.create(OXUserMySQLStorage.java:795)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorageCommon.createAdminForContext(OXContextMySQLStorageCommon.java:226)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1213)
            at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:736)
            at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:146)
            at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:204)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
            at sun.rmi.transport.Transport$1.run(Transport.java:153)
            at java.security.AccessController.doPrivileged(Native Method)
            at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
            at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
            at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
            at java.lang.Thread.run(Thread.java:595)
    Feb 23, 2009 1:47:49 PM com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorageCommon handleCreateContextRollback
    SEVERE: SQL Error deleting sequence tables on rollback create context
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'oxdb_9'
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorageCommon.deleteSequenceTables(OXContextMySQLStorageCommon.java:327)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorageCommon.handleCreateContextRollback(OXContextMySQLStorageCommon.java:394)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1255)
            at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:736)
            at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:146)
            at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:204)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
            at sun.rmi.transport.Transport$1.run(Transport.java:153)
            at java.security.AccessController.doPrivileged(Native Method)
            at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
            at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
            at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
            at java.lang.Thread.run(Thread.java:595)
    Feb 23, 2009 1:47:49 PM com.openexchange.database.Database back
    SEVERE: DBP-0002 Category=8 Message=Resolving database for context 1 and server 2 not possible! exceptionID=771177505-3
    DBP-0002 Category=8 Message=Resolving database for context 1 and server 2 not possible! exceptionID=771177505-3
            at com.openexchange.database.AssignmentStorage.loadAssignment(AssignmentStorage.java:161)
            at com.openexchange.database.AssignmentStorage.getAssignment(AssignmentStorage.java:132)
            at com.openexchange.database.Database.resolvePool(Database.java:85)
            at com.openexchange.database.Database.back(Database.java:273)
            at com.openexchange.database.Database.back(Database.java:253)
            at com.openexchange.database.Database.back(Database.java:241)
            at com.openexchange.server.impl.DBPool.pushWrite(DBPool.java:95)
            at com.openexchange.admin.storage.sqlStorage.OXAdminPoolDBPool.pushConnectionForContext(OXAdminPoolDBPool.java:124)
            at com.openexchange.admin.tools.AdminCache.pushConnectionForContext(AdminCache.java:360)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1284)
            at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:736)
            at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:146)
            at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:204)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
            at sun.rmi.transport.Transport$1.run(Transport.java:153)
            at java.security.AccessController.doPrivileged(Native Method)
            at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
            at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
            at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
            at java.lang.Thread.run(Thread.java:595)
    Feb 23, 2009 1:47:49 PM com.openexchange.admin.rmi.impl.OXContextCommonImpl createcommon
    SEVERE: No such group with ID 1 in context 1
    com.openexchange.admin.rmi.exceptions.StorageException: No such group with ID 1 in context 1
            at com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.create(OXUserMySQLStorage.java:795)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorageCommon.createAdminForContext(OXContextMySQLStorageCommon.java:226)
            at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1213)
            at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:736)
            at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:146)
            at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:204)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
            at sun.rmi.transport.Transport$1.run(Transport.java:153)
            at java.security.AccessController.doPrivileged(Native Method)
            at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
            at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
            at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
            at java.lang.Thread.run(Thread.java:595)
    Feb 23, 2009 1:48:50 PM com.openexchange.pooling.ReentrantLockPool run
    SEVERE: Object was not returned. Fetched: 1235396869251, UseTime: 61369, ID: 34, Object: com.mysql.jdbc.ConnectionImpl@6edcb6b4
    com.openexchange.pooling.PoolingException: Object was not returned. Fetched: 1235396869251, UseTime: 61369, ID: 34, Object: com.mysql.jdbc.ConnectionImpl@6edcb6b4
            at com.openexchange.pooling.ReentrantLockPool.run(ReentrantLockPool.java:700)
            at java.lang.Thread.run(Thread.java:595)
    The configdb is created but the database for the context is simply not created. After searching the forum for quite a while a trying different suggestions I made a mistake at one point:
    I erroneously registered a server using the name in the following command:

    Code:
    /opt/open-xchange/sbin/oxinstaller --servername=oxserver --configdb-pass=db_password --master-pass=admin_master_password
    But used a different server name in this command:

    Code:
    /opt/open-xchange/sbin/registerserver -n ox6 -A oxadminmaster -P admin_master_password
    That lead to the situation where the database was created but of course the command:

    Code:
    /opt/open-xchange/sbin/createcontext -A oxadminmaster -P admin_master_password -c 1 \
    -u oxadmin -d "Context Admin" -g Admin -s User -p admin_password -L defaultcontext \
    -e oxadmin@example.com -q 1024 --access-combination-name=all
    failed now telling me that there was no server registered that's called "oxserver". After fixing that problem on the database level by updating the record in table "server" of the configdb I ended up with the same Exception mentioned above that tells me that the database can't be created....

    I'm stuck for now...

    Appreciating any input on that.

    So long,

    Henning

  2. #2
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    Hi Henning,

    that's a known issue of the snapshot packages, the issue has already been fixed so the packages will be updated pretty soon. Please update those packages if available and try again.
    If you rely on stable packages, please use the sources.list entry of the Debian Etch installation guide. Those packages work on lenny, too.

    Gretings

  3. #3
    HenningMalzahn Guest

    Default

    Hi Martin,

    thank you for the fast answer. Wishing I've posted earlier - spent a couple of hours on that yesterday...
    Improvement suggestion: Would be nice if the Wiki articles had a known issues section - could save some time...

    Thank you again,

    Henning

  4. #4
    HenningMalzahn Guest

    Default

    Hi Martin,

    thank you again - up and running!

    Can you provide a link with a good manual on how to set up the mail server connection using Postfix (2.5.5-1) and Dovecot (1.0.15-2.3).

    I'm already using the combination mentioned above with an MySQL server based user management - does that somehow interfere with setting up OpenXchange in addition to that or can I use both ways in parallel?

    So long,

    Henning

  5. #5
    Carsten Hoeger is offline Open-Xchange Professional Services
    Join Date
    Mar 2007
    Posts
    703

    Default

    Quote Originally Posted by HenningMalzahn View Post
    Hi Martin,

    thank you for the fast answer. Wishing I've posted earlier - spent a couple of hours on that yesterday...
    Improvement suggestion: Would be nice if the Wiki articles had a known issues section - could save some time...

    Thank you again,

    Henning
    The snapshot packages are not meant for production/beginner use. They are bleeding edge nightly and untested builds.

    If you need a stable and tested version, you must not use the snapshots.
    OXpedia.org - the answer to almost all questions.

  6. #6
    HenningMalzahn Guest

    Default

    I totally agree with you upon not using snapshot releases
    for production use or as a starting point for learning how to deal with a new product. However wiki the article for Debian Lenny uses the snapshot source as default:

    Code:
    deb http://download.opensuse.org/repositories/server:/OX:/snapshot/DebianLenny/ /
    The wiki article for Debian Etch uses the stable source.
    The leaves the users with the impression that the Lenny installation can only be done using the snapshot sources.

  7. #7
    Carsten Hoeger is offline Open-Xchange Professional Services
    Join Date
    Mar 2007
    Posts
    703

    Default

    Yes, currently Lenny is only supported by the snapshot releases.

    That will change with the next Update of OX6 SP5 packages.

    That doesn't change the fact, that snapshot packages should not be used in production.

    In that case you should think of using another Debian Version, e.g.

    http://www.open-xchange.com/wiki/ind...dition_Debian4
    OXpedia.org - the answer to almost all questions.

  8. #8
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    The cause for this is pretty simple, we've done an OX Release when Etch was the stable platform, so our build infrastructure was not prepared for Lenny yet - since the Etch packages also work for lenny it should not be a problem to use them.

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
  •