changeuser funktioniert nicht mehr

Hallo erst einmal,

ich habe schon lange ein Auge auf open-Xchange, nicht zuletzt, weil ich schon mit dem SLOX vertraut war. Eine tolles Produkt und ein dickes Kompliment für die Entscheidung zu open-source.

Ich habe vor Jahren (Mai 2011) eine Installation von ox auf einem Debian-System vorgenommen,
über cli einen User angelegt und nicht weiter damit gearbeitet. Seit dem ist so das eine oder andere Update über das System und die installiert Software gelaufen.

Jetzt wollt ich über folgenden Befehl die aliases dieses einen Users anpassen:

Code:

/opt/open-xchange/sbin/changeuser -c 1 -A <oxadmin> -P <Passwort> -u <username> -e Martin.Mustermann@domain1.de -a Martin.Mustermann@domain1.de,alias2@domain2.de,alias3@domain3.de

Fehlermeldung:

Code:

user <username> in context 1 could not be changed: 
Server response:
 com.openexchange.admin.rmi.exceptions.PoolException: DBP-0001 Categories=SERVICE_DOWN Message='Cannot get connection to config DB.' exceptionID=1987585761-5637
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1803)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.existsContext(OXToolMySQLStorage.java:193)
	at com.openexchange.admin.rmi.impl.BasicAuthenticator.doAuthentication(BasicAuthenticator.java:182)
	at com.openexchange.admin.rmi.impl.OXUser.getModuleAccess(OXUser.java:1047)
	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:597)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
	at sun.rmi.transport.Transport$1.run(Transport.java:159)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
	at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:255)
	at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:233)
	at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:142)
	at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:178)
	at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:132)
	at $Proxy0.getModuleAccess(Unknown Source)
	at com.openexchange.admin.console.user.ChangeCore.commonfunctions(ChangeCore.java:128)
	at com.openexchange.admin.console.user.Change.execute(Change.java:79)
	at com.openexchange.admin.console.user.Change.main(Change.java:70)

/var/log/open-xchange/open-xchange.log.0

Code:

Sep 25, 2013 8:49:39 PM com.openexchange.log.internal.callback.ErrorCallback log
SEVERE: Logged at: com.openexchange.admin.storage.sqlStorage.OXAdminPoolDBPool.getConnectionForConfigDB(OXAdminPoolDBPool.java:93)
 com.openexchange.database.schema=configdb
 
 Error pickup configdb database write connection from pool!
DBP-0001 Categories=SERVICE_DOWN Message='Cannot get connection to config DB.' exceptionID=1987585761-5637
	at com.openexchange.database.DBPoolingExceptionCodes.create(DBPoolingExceptionCodes.java:224)
	at com.openexchange.database.internal.ReplicationMonitor.createException(ReplicationMonitor.java:197)
	at com.openexchange.database.internal.ReplicationMonitor.checkFallback(ReplicationMonitor.java:102)
	at com.openexchange.database.internal.ReplicationMonitor.checkFallback(ReplicationMonitor.java:90)
	at com.openexchange.database.internal.ConfigDatabaseServiceImpl.get(ConfigDatabaseServiceImpl.java:91)
	at com.openexchange.database.internal.ConfigDatabaseServiceImpl.getWritable(ConfigDatabaseServiceImpl.java:120)
	at com.openexchange.database.internal.DatabaseServiceImpl.getWritable(DatabaseServiceImpl.java:148)
	at com.openexchange.admin.storage.sqlStorage.OXAdminPoolDBPool.getConnectionForConfigDB(OXAdminPoolDBPool.java:91)
	at com.openexchange.admin.tools.AdminCache.getConnectionForConfigDB(AdminCache.java:413)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1788)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.existsContext(OXToolMySQLStorage.java:193)
	at com.openexchange.admin.rmi.impl.BasicAuthenticator.doAuthentication(BasicAuthenticator.java:182)
	at com.openexchange.admin.rmi.impl.OXUser.getModuleAccess(OXUser.java:1047)
	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:597)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
	at sun.rmi.transport.Transport$1.run(Transport.java:159)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
Caused by: com.openexchange.pooling.PoolingException: Cannot create pooled object.
	at com.openexchange.pooling.ReentrantLockPool.get(ReentrantLockPool.java:324)
	at com.openexchange.database.internal.TimeoutFetchAndSchema.get(TimeoutFetchAndSchema.java:90)
	at com.openexchange.database.internal.ReplicationMonitor.checkFallback(ReplicationMonitor.java:99)
	... 24 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2385)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2306)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.GeneratedConstructorAccessor25.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:154)
	at com.openexchange.database.internal.ConnectionLifecycle.create(ConnectionLifecycle.java:118)
	at com.openexchange.database.internal.ConnectionLifecycle.create(ConnectionLifecycle.java:71)
	at com.openexchange.pooling.ReentrantLockPool.get(ReentrantLockPool.java:313)
	... 26 more
Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4686)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1304)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2324)
	... 40 more
Sep 25, 2013 8:49:39 PM com.openexchange.log.internal.callback.ErrorCallback log
SEVERE: Logged at: com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1802)
 com.openexchange.database.schema=configdb
 
 Pool Error
com.openexchange.admin.rmi.exceptions.PoolException: DBP-0001 Categories=SERVICE_DOWN Message='Cannot get connection to config DB.' exceptionID=1987585761-5637
	at com.openexchange.admin.storage.sqlStorage.OXAdminPoolDBPool.getConnectionForConfigDB(OXAdminPoolDBPool.java:94)
	at com.openexchange.admin.tools.AdminCache.getConnectionForConfigDB(AdminCache.java:413)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1788)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.existsContext(OXToolMySQLStorage.java:193)
	at com.openexchange.admin.rmi.impl.BasicAuthenticator.doAuthentication(BasicAuthenticator.java:182)
	at com.openexchange.admin.rmi.impl.OXUser.getModuleAccess(OXUser.java:1047)
	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:597)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
	at sun.rmi.transport.Transport$1.run(Transport.java:159)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
Sep 25, 2013 8:49:39 PM com.openexchange.log.internal.callback.ErrorCallback log
SEVERE: Logged at: com.openexchange.database.internal.ConfigDatabaseServiceImpl.back(ConfigDatabaseServiceImpl.java:100)
 com.openexchange.database.schema=configdb
 
 DBP-0005 Categories=ERROR Message='Null is returned to connection pool.' exceptionID=1987585761-5638
DBP-0005 Categories=ERROR Message='Null is returned to connection pool.' exceptionID=1987585761-5638
	at com.openexchange.database.DBPoolingExceptionCodes.create(DBPoolingExceptionCodes.java:224)
	at com.openexchange.database.DBPoolingExceptionCodes.create(DBPoolingExceptionCodes.java:208)
	at com.openexchange.database.DBPoolingExceptionCodes.create(DBPoolingExceptionCodes.java:198)
	at com.openexchange.database.internal.ConfigDatabaseServiceImpl.back(ConfigDatabaseServiceImpl.java:99)
	at com.openexchange.database.internal.ConfigDatabaseServiceImpl.backWritable(ConfigDatabaseServiceImpl.java:130)
	at com.openexchange.database.internal.DatabaseServiceImpl.backWritable(DatabaseServiceImpl.java:158)
	at com.openexchange.admin.storage.sqlStorage.OXAdminPoolDBPool.pushConnectionForConfigDB(OXAdminPoolDBPool.java:133)
	at com.openexchange.admin.tools.AdminCache.pushConnectionForConfigDB(AdminCache.java:417)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1815)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.existsContext(OXToolMySQLStorage.java:193)
	at com.openexchange.admin.rmi.impl.BasicAuthenticator.doAuthentication(BasicAuthenticator.java:182)
	at com.openexchange.admin.rmi.impl.OXUser.getModuleAccess(OXUser.java:1047)
	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:597)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
	at sun.rmi.transport.Transport$1.run(Transport.java:159)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
Sep 25, 2013 8:49:39 PM com.openexchange.log.internal.callback.ErrorCallback log
SEVERE: Logged at: com.openexchange.admin.rmi.impl.OXUser.getModuleAccess(OXUser.java:1060)
 com.openexchange.database.schema=configdb
 
 com.openexchange.admin.rmi.exceptions.PoolException: DBP-0001 Categories=SERVICE_DOWN Message='Cannot get connection to config DB.' exceptionID=1987585761-5637
com.openexchange.admin.rmi.exceptions.StorageException: com.openexchange.admin.rmi.exceptions.PoolException: DBP-0001 Categories=SERVICE_DOWN Message='Cannot get connection to config DB.' exceptionID=1987585761-5637
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1803)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.existsContext(OXToolMySQLStorage.java:193)
	at com.openexchange.admin.rmi.impl.BasicAuthenticator.doAuthentication(BasicAuthenticator.java:182)
	at com.openexchange.admin.rmi.impl.OXUser.getModuleAccess(OXUser.java:1047)
	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:597)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
	at sun.rmi.transport.Transport$1.run(Transport.java:159)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
Caused by: com.openexchange.admin.rmi.exceptions.PoolException: DBP-0001 Categories=SERVICE_DOWN Message='Cannot get connection to config DB.' exceptionID=1987585761-5637
	at com.openexchange.admin.storage.sqlStorage.OXAdminPoolDBPool.getConnectionForConfigDB(OXAdminPoolDBPool.java:94)
	at com.openexchange.admin.tools.AdminCache.getConnectionForConfigDB(AdminCache.java:413)
	at com.openexchange.admin.storage.mysqlStorage.OXToolMySQLStorage.selectwithint(OXToolMySQLStorage.java:1788)
	... 17 more

Dann habe ich die Credentials in /opt/open-xchange/etc/configdb.properties überprüft, alles OK.

Manueller versuch mit der DB Verbindung aufzunehmen:

Code:

mysql -u openexchange -p configdb
Enter password:
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| configdb           |
| funambol           |
| mysql              |
| oxdatabase_5       |
+--------------------+
5 rows in set (0.00 sec)

mysql> show tables;
+------------------------+
| Tables_in_configdb     |
+------------------------+
| configdb_sequence      |
| context                |
| context_server2db_pool |
| db_cluster             |
| db_pool                |
| filestore              |
| login2context          |
| reason_text            |
| server                 |
+------------------------+
9 rows in set (0.00 sec)

Ich habe auch versucht eine andere Fehlermeldung zu erzeugen, in dem ich absichtlich in /opt/open-xchange/etc/configdb.properties ein anderes Passwort eingetragen habe. Die Fehlermeldung bleibt aber gleich.

Jetzt weiß ich nicht mehr weiter..
Hilfe..

Infos zum System:
Server Version: 7.2.2-Rev20

java version "1.6.0_26"
Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
Java HotSpot(TM) Client VM (build 20.1-b02, mixed mode, sharing)

Debian GNU/Linux 6.0 \n \l
Linux OX 2.6.32-5-686 #1 SMP Fri May 10 08:33:48 UTC 2013 i686 GNU/Linux

ZappNduster

Announcement