OX AppSuite 7.8 connection error

[silvio]

Hi,

after my update from 7.6 to 7.8 the only thing i can see on my login page is:

Connection error
The service is not available right now. Retry

The first thing was to update the password with generatempasswd but the problem still exists.
After that i checked listbundles list and found this:

bundlename: com.openexchange.logback.classic.extensions status: RESOLVED
bundlename: com.openexchange.logback.configuration status: RESOLVED
bundlename: com.openexchange.logback.core.extensions status: RESOLVED
bundlename: com.openexchange.system.extension status: RESOLVED

My idea was that something is wrong with the configdb.properties file and i found one unclear point.
Is the password for the configdb database in this file (in cleartext)? If yes the update destroyed the password, i found only the first 2 signs and a dot here.
After that i tested to start with the (checked) password in the file but nothing changed and so i set it back to the original (after update) file.

Has anyone a hint or an idea that i can do to become the systems running?

Thanks

Silvio

[silvio]

Here are some errors from the log:

2015-10-12T22:50:25,350+0200 ERROR [Thread-7] org.apache.jcs.auxiliary.lateral.socket.tcp.discov ery.UDPDiscoveryReceiver.waitForMessage(UDPDiscove ryReceiver.java:173)
Error receving multicast packet
java.net.SocketException: Socket closed
at java.net.PlainDatagramSocketImpl.receive0(Native Method)
at java.net.AbstractPlainDatagramSocketImpl.receive(A bstractPlainDatagramSocketImpl.java:146)
at java.net.DatagramSocket.receive(DatagramSocket.jav a:817)
at org.apache.jcs.auxiliary.lateral.socket.tcp.discov ery.UDPDiscoveryReceiver.waitForMessage(UDPDiscove ryReceiver.java:162)
at org.apache.jcs.auxiliary.lateral.socket.tcp.discov ery.UDPDiscoveryReceiver.run(UDPDiscoveryReceiver. java:185)
at java.lang.Thread.run(Thread.java:745)
2015-10-12T22:50:25,350+0200 WARN [Thread-7] org.apache.jcs.auxiliary.lateral.socket.tcp.discov ery.UDPDiscoveryReceiver.run(UDPDiscoveryReceiver. java:214)
message is null
2015-10-12T22:50:25,351+0200 INFO [Framework stop] com.openexchange.caching.internal.JCSCacheServiceI nit.stop(JCSCacheServiceInit.java:449)
JCS caching system successfully stopped.
2015-10-12T22:50:25,351+0200 INFO [Framework stop] com.openexchange.caching.events.ms.osgi.MsCacheEve ntHandlerActivator.stopBundle(MsCacheEventHandlerA ctivator.java:149)
stopping bundle: com.openexchange.caching.events.ms
2015-10-12T22:50:25,351+0200 INFO [Framework stop] com.openexchange.caching.events.osgi.CacheEventSer viceActivator.stopBundle(CacheEventServiceActivato r.java:105)
stopping bundle: com.openexchange.caching.events
2015-10-12T22:50:25,354+0200 ERROR [Framework stop] com.openexchange.ajp13.osgi.AJPv13Activator.stopBu ndle(AJPv13Activator.java:188)

java.lang.NullPointerException: null
at com.openexchange.ajp13.coyote.AjpProcessor.prepare Response(AjpProcessor.java:2137)
at com.openexchange.ajp13.coyote.AjpProcessor.action( AjpProcessor.java:1072)
at com.openexchange.ajp13.coyote.AjpProcessor.cancel( AjpProcessor.java:625)
at com.openexchange.ajp13.watcher.AJPv13TaskWatcher.s top(AJPv13TaskWatcher.java:139)
at com.openexchange.ajp13.coyote.sockethandler.Coyote SocketHandler.shutDownNow(CoyoteSocketHandler.java :168)
at com.openexchange.ajp13.AJPv13ServerImpl.stopServer (AJPv13ServerImpl.java:151)
at com.openexchange.ajp13.AJPv13Server.stopAJPServer( AJPv13Server.java:147)
at com.openexchange.ajp13.osgi.AJPv13Activator$NAJPSt arter.stop(AJPv13Activator.java:208)
at com.openexchange.ajp13.osgi.AJPv13Activator.stopBu ndle(AJPv13Activator.java:178)
at com.openexchange.osgi.DeferredActivator.doStop(Def erredActivator.java:580)
at com.openexchange.osgi.DeferredActivator.stop(Defer redActivator.java:563)
at org.eclipse.osgi.internal.framework.BundleContextI mpl$4.run(BundleContextImpl.java:827)
at org.eclipse.osgi.internal.framework.BundleContextI mpl$4.run(BundleContextImpl.java:1)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.stop(BundleContextImpl.java:820)
at org.eclipse.osgi.internal.framework.EquinoxBundle. stopWorker0(EquinoxBundle.java:950)
at org.eclipse.osgi.internal.framework.EquinoxBundle$ EquinoxModule.stopWorker(EquinoxBundle.java:324)
at org.eclipse.osgi.container.Module.doStop(Module.ja va:626)
at org.eclipse.osgi.container.Module.stop(Module.java :488)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.decStartLevel(ModuleContainer.java:16 23)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.doContainerStartLevel(ModuleContainer .java:1542)
at org.eclipse.osgi.container.SystemModule.stopWorker (SystemModule.java:248)
at org.eclipse.osgi.internal.framework.EquinoxBundle$ SystemBundle$EquinoxSystemModule.stopWorker(Equino xBundle.java:145)
at org.eclipse.osgi.container.Module.doStop(Module.ja va:626)
at org.eclipse.osgi.container.Module.stop(Module.java :488)
at org.eclipse.osgi.container.SystemModule.stop(Syste mModule.java:186)
at org.eclipse.osgi.internal.framework.EquinoxBundle$ SystemBundle$EquinoxSystemModule$1.run(EquinoxBund le.java:160)
at java.lang.Thread.run(Thread.java:745)
2015-10-12T22:50:25,356+0200 ERROR [Framework stop] com.openexchange.osgi.DeferredActivator.stop(Defer redActivator.java:565)

java.lang.NullPointerException: null
at com.openexchange.ajp13.coyote.AjpProcessor.prepare Response(AjpProcessor.java:2137)
at com.openexchange.ajp13.coyote.AjpProcessor.action( AjpProcessor.java:1072)
at com.openexchange.ajp13.coyote.AjpProcessor.cancel( AjpProcessor.java:625)
at com.openexchange.ajp13.watcher.AJPv13TaskWatcher.s top(AJPv13TaskWatcher.java:139)
at com.openexchange.ajp13.coyote.sockethandler.Coyote SocketHandler.shutDownNow(CoyoteSocketHandler.java :168)
at com.openexchange.ajp13.AJPv13ServerImpl.stopServer (AJPv13ServerImpl.java:151)
at com.openexchange.ajp13.AJPv13Server.stopAJPServer( AJPv13Server.java:147)
at com.openexchange.ajp13.osgi.AJPv13Activator$NAJPSt arter.stop(AJPv13Activator.java:208)
at com.openexchange.ajp13.osgi.AJPv13Activator.stopBu ndle(AJPv13Activator.java:178)
at com.openexchange.osgi.DeferredActivator.doStop(Def erredActivator.java:580)
at com.openexchange.osgi.DeferredActivator.stop(Defer redActivator.java:563)
at org.eclipse.osgi.internal.framework.BundleContextI mpl$4.run(BundleContextImpl.java:827)
at org.eclipse.osgi.internal.framework.BundleContextI mpl$4.run(BundleContextImpl.java:1)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.stop(BundleContextImpl.java:820)
at org.eclipse.osgi.internal.framework.EquinoxBundle. stopWorker0(EquinoxBundle.java:950)
at org.eclipse.osgi.internal.framework.EquinoxBundle$ EquinoxModule.stopWorker(EquinoxBundle.java:324)
at org.eclipse.osgi.container.Module.doStop(Module.ja va:626)
at org.eclipse.osgi.container.Module.stop(Module.java :488)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.decStartLevel(ModuleContainer.java:16 23)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.doContainerStartLevel(ModuleContainer .java:1542)
at org.eclipse.osgi.container.SystemModule.stopWorker (SystemModule.java:248)
at org.eclipse.osgi.internal.framework.EquinoxBundle$ SystemBundle$EquinoxSystemModule.stopWorker(Equino xBundle.java:145)
at org.eclipse.osgi.container.Module.doStop(Module.ja va:626)
at org.eclipse.osgi.container.Module.stop(Module.java :488)
at org.eclipse.osgi.container.SystemModule.stop(Syste mModule.java:186)
at org.eclipse.osgi.internal.framework.EquinoxBundle$ SystemBundle$EquinoxSystemModule$1.run(EquinoxBund le.java:160)
at java.lang.Thread.run(Thread.java:745)


2015-10-12T22:50:32,401+0200 WARN [Start Level: Equinox Container: 1034d1dd-2271-0015-14b7-a8aa2107c549] org.apache.jcs.engine.control.CompositeCache.creat eMemoryCache(Composi
teCache.java:1194)
Failed to init mem cache, using: LRUMemoryCache
java.lang.ClassNotFoundException: org.apache.jcs.engine.memory.lru.LRUMemoryCache
cannot be found by com.openexchange.caching_7.8.0
at org.eclipse.osgi.internal.loader.BundleLoader.find ClassInternal(BundleLoader.java:432)
at org.eclipse.osgi.internal.loader.BundleLoader.find Class(BundleLoader.java:345)
at org.eclipse.osgi.internal.loader.BundleLoader.find Class(BundleLoader.java:337)
at org.eclipse.osgi.internal.loader.ModuleClassLoader .loadClass(ModuleClassLoader.java:160)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 58)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:195)
at org.apache.jcs.engine.control.CompositeCache.creat eMemoryCache(CompositeCache.java:1188)
at org.apache.jcs.engine.control.CompositeCache.<init >(CompositeCache.java:130)
at org.apache.jcs.engine.control.CompositeCacheConfig urator.parseRegion(CompositeCacheConfigurator.java :336)
at org.apache.jcs.engine.control.CompositeCacheConfig urator.parseRegion(CompositeCacheConfigurator.java :294)
at org.apache.jcs.engine.control.CompositeCacheConfig urator.parseRegions(CompositeCacheConfigurator.jav a:271)
at org.apache.jcs.engine.control.CompositeCacheConfig urator.doConfigure(CompositeCacheConfigurator.java :138)
at org.apache.jcs.engine.control.CompositeCacheManage r.configure(CompositeCacheManager.java:314)
at com.openexchange.caching.internal.JCSCacheServiceI nit.configure(JCSCacheServiceInit.java:226)
at com.openexchange.caching.internal.JCSCacheServiceI nit.configure(JCSCacheServiceInit.java:211)
at com.openexchange.caching.internal.JCSCacheServiceI nit.configureByPropertyFile(JCSCacheServiceInit.ja va:413)
at com.openexchange.caching.internal.JCSCacheServiceI nit.start(JCSCacheServiceInit.java:381)
at com.openexchange.caching.osgi.CacheActivator.start Bundle(CacheActivator.java:134)
at com.openexchange.osgi.DeferredActivator.startUp(De ferredActivator.java:542)
at com.openexchange.osgi.DeferredActivator.signalAvai lability(DeferredActivator.java:428)
at com.openexchange.osgi.DeferredActivator$DeferredSe rviceTracker.addingService(DeferredActivator.java: 174)
at org.osgi.util.tracker.ServiceTracker$Tracked.custo mizerAdding(ServiceTracker.java:941)
at org.osgi.util.tracker.ServiceTracker$Tracked.custo mizerAdding(ServiceTracker.java:1)
at org.osgi.util.tracker.AbstractTracked.trackAdding( AbstractTracked.java:256)
at org.osgi.util.tracker.AbstractTracked.track(Abstra ctTracked.java:229)
at org.osgi.util.tracker.ServiceTracker$Tracked.servi ceChanged(ServiceTracker.java:901)
at org.eclipse.osgi.internal.serviceregistry.Filtered ServiceListener.serviceChanged(FilteredServiceList ener.java:109)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.dispatchEvent(BundleContextImpl.java:914)
at org.eclipse.osgi.framework.eventmgr.EventManager.d ispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.ListenerQueue. dispatchEventSynchronous(ListenerQueue.java:148)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistry.publishServiceEventPrivileged(ServiceRegis try.java:862)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistry.publishServiceEvent(ServiceRegistry.java:8 01)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistrationImpl.register(ServiceRegistrationImpl.j ava:127)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistry.registerService(ServiceRegistry.java:225)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.registerService(BundleContextImpl.java:464)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.registerService(BundleContextImpl.java:482)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.registerService(BundleContextImpl.java:998)
at com.openexchange.osgi.HousekeepingActivator.regist erService(HousekeepingActivator.java:275)
at com.openexchange.osgi.HousekeepingActivator.regist erService(HousekeepingActivator.java:285)
at com.openexchange.caching.events.osgi.CacheEventSer viceActivator.startBundle(CacheEventServiceActivat or.java:92)
at com.openexchange.osgi.DeferredActivator.startUp(De ferredActivator.java:542)
at com.openexchange.osgi.DeferredActivator.signalAvai lability(DeferredActivator.java:428)
at com.openexchange.osgi.DeferredActivator$DeferredSe rviceTracker.addingService(DeferredActivator.java: 174)
at org.osgi.util.tracker.ServiceTracker$Tracked.custo mizerAdding(ServiceTracker.java:941)
at org.osgi.util.tracker.ServiceTracker$Tracked.custo mizerAdding(ServiceTracker.java:1)
at org.osgi.util.tracker.AbstractTracked.trackAdding( AbstractTracked.java:256)
at org.osgi.util.tracker.AbstractTracked.track(Abstra ctTracked.java:229)
at org.osgi.util.tracker.ServiceTracker$Tracked.servi ceChanged(ServiceTracker.java:901)
at org.eclipse.osgi.internal.serviceregistry.Filtered ServiceListener.serviceChanged(FilteredServiceList ener.java:109)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.dispatchEvent(BundleContextImpl.java:914)
at org.eclipse.osgi.framework.eventmgr.EventManager.d ispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.ListenerQueue. dispatchEventSynchronous(ListenerQueue.java:148)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistry.publishServiceEventPrivileged(ServiceRegis try.java:862)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistry.publishServiceEvent(ServiceRegistry.java:8 01)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistrationImpl.register(ServiceRegistrationImpl.j ava:127)
at org.eclipse.osgi.internal.serviceregistry.ServiceR egistry.registerService(ServiceRegistry.java:225)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.registerService(BundleContextImpl.java:464)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.registerService(BundleContextImpl.java:482)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.registerService(BundleContextImpl.java:998)
at com.openexchange.osgi.HousekeepingActivator.regist erService(HousekeepingActivator.java:275)
at com.openexchange.osgi.HousekeepingActivator.regist erService(HousekeepingActivator.java:285)
at com.openexchange.threadpool.osgi.ThreadPoolActivat or.startBundle(ThreadPoolActivator.java:120)
at com.openexchange.osgi.DeferredActivator.startUp(De ferredActivator.java:542)
at com.openexchange.osgi.DeferredActivator.signalAvai lability(DeferredActivator.java:428)
at com.openexchange.osgi.DeferredActivator$DeferredSe rviceTracker.addingService(DeferredActivator.java: 174)
at org.osgi.util.tracker.ServiceTracker$Tracked.custo mizerAdding(ServiceTracker.java:941)
at org.osgi.util.tracker.ServiceTracker$Tracked.custo mizerAdding(ServiceTracker.java:1)
at org.osgi.util.tracker.AbstractTracked.trackAdding( AbstractTracked.java:256)
at org.osgi.util.tracker.AbstractTracked.trackInitial (AbstractTracked.java:183)
at org.osgi.util.tracker.ServiceTracker.open(ServiceT racker.java:318)
at org.osgi.util.tracker.ServiceTracker.open(ServiceT racker.java:261)
at com.openexchange.osgi.DeferredActivator.init(Defer redActivator.java:329)
at com.openexchange.osgi.DeferredActivator.start(Defe rredActivator.java:514)
at com.openexchange.osgi.HousekeepingActivator.start( HousekeepingActivator.java:202)
at org.eclipse.osgi.internal.framework.BundleContextI mpl$3.run(BundleContextImpl.java:771)
at org.eclipse.osgi.internal.framework.BundleContextI mpl$3.run(BundleContextImpl.java:1)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.startActivator(BundleContextImpl.java:764)
at org.eclipse.osgi.internal.framework.BundleContextI mpl.start(BundleContextImpl.java:721)
at org.eclipse.osgi.internal.framework.EquinoxBundle. startWorker0(EquinoxBundle.java:936)
at org.eclipse.osgi.internal.framework.EquinoxBundle$ EquinoxModule.startWorker(EquinoxBundle.java:319)
at org.eclipse.osgi.container.Module.doStart(Module.j ava:571)
at org.eclipse.osgi.container.Module.start(Module.jav a:439)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.incStartLevel(ModuleContainer.java:15 82)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.incStartLevel(ModuleContainer.java:15 62)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.doContainerStartLevel(ModuleContainer .java:1533)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.dispatchEvent(ModuleContainer.java:14 76)
at org.eclipse.osgi.container.ModuleContainer$Contain erStartLevel.dispatchEvent(ModuleContainer.java:1)
at org.eclipse.osgi.framework.eventmgr.EventManager.d ispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.EventManager$E ventThread.run(EventManager.java:340)


and a lot from this:


2015-10-12T23:04:22,050+0200 INFO [AJPServer-0001] com.openexchange.monitoring.MonitoringInfo.changeN umberOfConnections(MonitoringInfo.java:256)
MonitoringInfo.changeNumberOfConnections(): Unknown connection type: 0
2015-10-12T23:04:22,051+0200 ERROR [AJP-Processor-0000025] com.openexchange.threadpool.internal.CustomUncaugh tExceptionhandler.uncaughtException(CustomUncaught Exceptionhandler.
java:85)
Thread terminated with exception: AJP-Processor-0000025
java.lang.NoSuchMethodError: com.openexchange.monitoring.MonitoringInfo.addNumb erOfRunningAJPListeners(I)V
at com.openexchange.ajp13.coyote.sockethandler.Coyote Task.changeNumberOfRunningAJPTasks(CoyoteTask.java :144)
at com.openexchange.ajp13.coyote.sockethandler.Coyote Task.beforeExecute(CoyoteTask.java:152)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor.beforeExecute(CustomThreadPoolExecutor .java:1661)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:813)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:842)
at java.lang.Thread.run(Thread.java:745)
2015-10-12T23:04:22,053+0200 ERROR [AJP-Processor-0000025] com.openexchange.threadpool.internal.CustomUncaugh tExceptionhandler.uncaughtException(CustomUncaught Exceptionhandler.
java:99)


Silvio

[silvio]

Hi,

i found the first problem and now the system can load the loginpage. The problem was the open-xchange-ajp package from the 7.6 release. It was the only "7.6" package on the system and some packages has dependencies to this package. If i erase this package the following packages will also be deletet:
open-xchange-meta-singleserver
open-xchange-meta-server
open-xchange-meta-backend-ox6
open-xchange

I installed the open-xchange package again and now it installed open-xchange-grizzly as dependency.
After that a restart brings back the loginpage.

Now the login fails with error DBP-0003.
In the log i found:

Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)

I tested the password with:

mysql -h localhost -u openexchange -p configdb

and it works.

This brings me back to my question in the first post. How do i handle the password for the configdb?

Thanks

Silvio

[silvio]

New tests same problem:
- tested the db connection -works
- tested user/password combination - works
- userlogin - does not work

Errormessage:

com.openexchange.exception.OXException: DBP-0003 Categories=SERVICE_DOWN Message='No connection to database 4' exceptionID=637876521-3
at com.openexchange.database.DBPoolingExceptionCodes. create(DBPoolingExceptionCodes.java:260)
at com.openexchange.database.internal.ReplicationMoni tor.createException(ReplicationMonitor.java:220)
at com.openexchange.database.internal.ReplicationMoni tor.checkActualAndFallback(ReplicationMonitor.java :159)
at com.openexchange.database.internal.ReplicationMoni tor.checkActualAndFallback(ReplicationMonitor.java :142)
at com.openexchange.database.internal.DatabaseService Impl.get(DatabaseServiceImpl.java:94)
at com.openexchange.database.internal.DatabaseService Impl.get(DatabaseServiceImpl.java:90)
at com.openexchange.database.internal.DatabaseService Impl.getReadOnly(DatabaseServiceImpl.java:287)
at com.openexchange.databaseold.Database.get(Database .java:119)
at com.openexchange.server.impl.DBPool.pickup(DBPool. java:68)
at com.openexchange.groupware.contexts.impl.RdbContex tStorage.getAdmin(RdbContextStorage.java:139)
at com.openexchange.groupware.contexts.impl.RdbContex tStorage.loadContext(RdbContextStorage.java:193)
at com.openexchange.groupware.contexts.impl.CachingCo ntextStorage.load(CachingContextStorage.java:226)
at com.openexchange.groupware.contexts.impl.CachingCo ntextStorage.loadContext(CachingContextStorage.jav a:125)
at com.openexchange.groupware.contexts.impl.ContextSt orage.getContext(ContextStorage.java:130)
at com.openexchange.context.internal.ContextServiceIm pl.getContext(ContextServiceImpl.java:85)
at com.openexchange.authentication.basic.DefaultBasic Authentication.handleLoginInfo(DefaultBasicAuthent ication.java:148)
at com.openexchange.authentication.database.impl.Data baseAuthentication.handleLoginInfo(DatabaseAuthent ication.java:80)
at com.openexchange.authentication.service.Authentica tion.login(Authentication.java:91)
at com.openexchange.login.internal.NormalLoginMethod. doAuthentication(NormalLoginMethod.java:77)
at com.openexchange.login.internal.LoginPerformer.doL ogin(LoginPerformer.java:177)
at com.openexchange.login.internal.LoginPerformer.doL ogin(LoginPerformer.java:138)
at com.openexchange.login.internal.LoginPerformer.doL ogin(LoginPerformer.java:134)
at com.openexchange.ajax.login.Login$1.doLogin(Login. java:109)
at com.openexchange.ajax.login.AbstractLoginRequestHa ndler.loginOperation(AbstractLoginRequestHandler.j ava:220)
at com.openexchange.ajax.login.AbstractLoginRequestHa ndler.loginOperation(AbstractLoginRequestHandler.j ava:179)
at com.openexchange.ajax.login.Login.doLogin(Login.ja va:97)
at com.openexchange.ajax.login.Login.handleRequest(Lo gin.java:90)
at com.openexchange.ajax.LoginServlet.doJSONAuth(Logi nServlet.java:731)
at com.openexchange.ajax.LoginServlet.doGet(LoginServ let.java:713)
at com.openexchange.ajax.LoginServlet.doPost(LoginSer vlet.java:795)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.openexchange.ajax.AJAXServlet.service(AJAXServ let.java:532)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at com.openexchange.http.grizzly.service.http.OSGiSer vletHandler$FilterChainImpl.doFilter(OSGiServletHa ndler.java:445)
at com.openexchange.http.grizzly.servletfilter.Reques tReportingFilter.doFilter(RequestReportingFilter.j ava:135)
at com.openexchange.http.grizzly.service.http.OSGiSer vletHandler$FilterChainImpl.doFilter(OSGiServletHa ndler.java:435)
at com.openexchange.http.grizzly.servletfilter.Wrappi ngFilter.doFilter(WrappingFilter.java:195)
at com.openexchange.http.grizzly.service.http.OSGiSer vletHandler$FilterChainImpl.doFilter(OSGiServletHa ndler.java:435)
at com.openexchange.http.grizzly.service.http.OSGiAut hFilter.doFilter(OSGiAuthFilter.java:140)
at com.openexchange.http.grizzly.service.http.OSGiSer vletHandler$FilterChainImpl.doFilter(OSGiServletHa ndler.java:435)
at com.openexchange.http.grizzly.service.http.OSGiSer vletHandler$FilterChainImpl.invokeFilterChain(OSGi ServletHandler.java:413)
at org.glassfish.grizzly.servlet.ServletHandler.doSer vletService(ServletHandler.java:252)
at org.glassfish.grizzly.servlet.ServletHandler.servi ce(ServletHandler.java:194)
at com.openexchange.http.grizzly.service.http.OSGiMai nHandler.service(OSGiMainHandler.java:219)
at org.glassfish.grizzly.http.server.HttpHandler.doHa ndle(HttpHandler.java:164)
at org.glassfish.grizzly.http.server.HttpHandlerChain .service(HttpHandlerChain.java:196)
at org.glassfish.grizzly.http.server.HttpHandler.doHa ndle(HttpHandler.java:164)
at org.glassfish.grizzly.http.server.OXHttpServerFilt er.handleRead(OXHttpServerFilter.java:343)
at org.glassfish.grizzly.filterchain.ExecutorResolver $9.execute(ExecutorResolver.java:119)
at org.glassfish.grizzly.filterchain.DefaultFilterCha in.executeFilter(DefaultFilterChain.java:265)
at org.glassfish.grizzly.filterchain.DefaultFilterCha in.executeChainPart(DefaultFilterChain.java:200)
at org.glassfish.grizzly.filterchain.DefaultFilterCha in.execute(DefaultFilterChain.java:134)
at org.glassfish.grizzly.filterchain.DefaultFilterCha in.process(DefaultFilterChain.java:112)
at org.glassfish.grizzly.ProcessorExecutor.execute(Pr ocessorExecutor.java:78)
at org.glassfish.grizzly.nio.transport.TCPNIOTranspor t.fireIOEvent(TCPNIOTransport.java:770)
at org.glassfish.grizzly.strategies.AbstractIOStrateg y.fireIOEvent(AbstractIOStrategy.java:112)
at org.glassfish.grizzly.strategies.WorkerThreadIOStr ategy.run0(WorkerThreadIOStrategy.java:115)
at org.glassfish.grizzly.strategies.WorkerThreadIOStr ategy.access$100(WorkerThreadIOStrategy.java:55)
at org.glassfish.grizzly.strategies.WorkerThreadIOStr ategy$WorkerThreadRunnable.run(WorkerThreadIOStrat egy.java:135)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$MDCProvidingRunnable.run(CustomThreadP oolExecutor.java:2502)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:815)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:842)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.openexchange.pooling.PoolingException: Cannot create pooled object.
at com.openexchange.pooling.ReentrantLockPool.get(Ree ntrantLockPool.java:321)
at com.openexchange.database.internal.TimeoutFetchAnd Schema.get(TimeoutFetchAndSchema.java:97)
at com.openexchange.database.internal.ReplicationMoni tor.checkActualAndFallback(ReplicationMonitor.java :152)
... 60 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC onnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:973)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:918)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(C onnectionImpl.java:2405)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2326)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:344)
at java.sql.DriverManager.getConnection(DriverManager .java:664)
at java.sql.DriverManager.getConnection(DriverManager .java:208)
at com.openexchange.database.internal.ConnectionLifec ycle.create(ConnectionLifecycle.java:121)
at com.openexchange.database.internal.ConnectionLifec ycle.create(ConnectionLifecycle.java:74)
at com.openexchange.pooling.ReentrantLockPool.get(Ree ntrantLockPool.java:310)
... 62 common frames omitted
Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1084)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4232)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4164)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:926)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 4732)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:13 40)
at com.mysql.jdbc.ConnectionImpl.coreConnect(Connecti onImpl.java:2506)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(C onnectionImpl.java:2344)
... 77 common frames omitted

I don't understand the can not connect to server message, because i can connect localy. Any idea what i can test or change?
The system runs with the last 7.6 update without any problem an now ......

Thanks

Silvio

[silvio]

The problems getting clearer:

checkconsistency checkconfigdb
Connecting to 'service:jmx:rmi:///jndi/rmi://localhost:9999/server'... OK.
ERROR
CSTY-0001 Categories=ERROR Message='Error communicating with mbean in server: javax.management.MBeanException: DBP-0003 Categories=SERVICE_DOWN Message='No connection to database 4' exceptionID=-1002666254-1' exceptionID=181143215-1

listuser -c 1 -A oxadmin -P xxxxxxxxxx
users in context 1 could not be listed:
Server response:
com.openexchange.admin.rmi.exceptions.PoolExceptio n: DBP-0003 Categories=SERVICE_DOWN Message='No connection to database 4' exceptionID=-1002666254-3
at com.openexchange.admin.storage.mysqlStorage.OXTool MySQLStorage.existsUserName(OXToolMySQLStorage.jav a:2335)
at com.openexchange.admin.storage.mysqlStorage.OXTool MySQLStorage.existsUserName(OXToolMySQLStorage.jav a:2356)
at com.openexchange.admin.rmi.impl.BasicAuthenticator .doAuthentication(BasicAuthenticator.java:258)
at com.openexchange.admin.rmi.impl.OXUser.list(OXUser .java:2112)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastSe rverRef.java:323)
at sun.rmi.transport.Transport$1.run(Transport.java:2 00)
at sun.rmi.transport.Transport$1.run(Transport.java:1 97)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport. java:196)
at sun.rmi.transport.tcp.TCPTransport.handleMessages( TCPTransport.java:568)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run0(TCPTransport.java:826)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.lambda$run$93(TCPTransport.java:683)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er$$Lambda$1/405343669.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run(TCPTransport.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at sun.rmi.transport.StreamRemoteCall.exceptionReceiv edFromServer(StreamRemoteCall.java:276)
at sun.rmi.transport.StreamRemoteCall.executeCall(Str eamRemoteCall.java:253)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:1 62)
at java.rmi.server.RemoteObjectInvocationHandler.invo keRemoteMethod(RemoteObjectInvocationHandler.java: 217)
at java.rmi.server.RemoteObjectInvocationHandler.invo ke(RemoteObjectInvocationHandler.java:171)
at com.sun.proxy.$Proxy0.list(Unknown Source)
at com.openexchange.admin.console.user.List.maincall( List.java:87)
at com.openexchange.admin.console.user.ListCore.commo nfunctions(ListCore.java:128)
at com.openexchange.admin.console.user.List.<init>(Li st.java:77)
at com.openexchange.admin.console.user.List.main(List .java:70)


So the problem should not be the connection to the configdb. Any idea how to fix this?

Silvio

[silvio]

Use http://oxpedia.org/wiki/index.php?ti...atabase_access to check the databases and found that the password that i can see here:

SELECT * FROM db_pool;

is not the correct openexchange database user password.
This is that i wrote in my first post, the update destroy the password. We have an $ inside the password and it looks like the update scripts have an problem with this.
Can someone reproduce this?

Silvio

[silvio]

Changed the password in the db_pool table and it works. .....