Announcement

Collapse
No announcement yet.

Unable to create default context

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Comment


    • #3
      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

      Comment


      • #4
        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

        Comment


        • #5
          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.

          Comment


          • #6
            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.

            Comment


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

              Comment


              • #8
                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.

                Comment

                Working...
                X