Announcement

Collapse
No announcement yet.

changeuser funktioniert nicht mehr

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

  • 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

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

    Comment

    Working...
    X