Tja, was soll ich sagen.. Wunderheilung!
Über das Wochenende habe ich meine Installation auf das Update von Open-Xchange 7.4.0 Rev11 angehoben (neuen Kernel und einige Update für das OS gab's auch).
Noch einmal die Parameter in der Datei /opt/open-xchange/etc/configdb.properties kontrolliert, und weil das PW so lang und kompliziert ist einfach noch einmal d'rüberkopiert.
Jetzt geht wieder alles.
Gruß
ZappNduster
Announcement
Collapse
No announcement yet.
changeuser funktioniert nicht mehr
Collapse
X
-
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
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
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)
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
ZappNdusterTags: None
Leave a comment: