Announcement

Collapse
No announcement yet.

changeuser funktioniert nicht mehr

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    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
    Tags: None
  • #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

    Previous template Next
    Working...
    X