Unable to create default context

[HenningMalzahn]

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:

/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

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:

/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:

/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:

/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

[Martin Heiland]

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

[HenningMalzahn]

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

[HenningMalzahn]

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

[Carsten Hoeger]

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.

[HenningMalzahn]

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:

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.

[Carsten Hoeger]

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/index.php?title=Quick_install_guide_for_the_Server_Edition_Debian4

[Martin Heiland]

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.