Error: 1045-28000, Access denied for user

0
Hello,   I installed Studio Pro (Fresh install, no previous installation), I built a simple query to fetch data from a table in my database (MariaDB 8.0.29) which is hosted on a cloud service, when I run the query I can see my data in the response just fine, but when I try to run my app I get "Error: 1045-28000, Access denied for user":   "An error occurred while initializing the Runtime: (conn=7626270) Access denied for user 'xxxxx'@'xxx.xxx.xxx.xxx' (using password: YES)   (IP Address and user name intentionally redacted:   com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime: (conn=7626270) Access denied for user 'xxxxx'@'xxx.xxx.xxx.xxx' (using password: YES)    at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.scala:158) Caused by: java.sql.SQLInvalidAuthorizationSpecException: (conn=7626270) Access denied for user 'xxxxx'@'xxx.xxx.xxx.xxx' (using password: YES)    at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:293)    at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378)    at org.mariadb.jdbc.client.impl.ConnectionHelper.authenticationHandler(ConnectionHelper.java:279)    at org.mariadb.jdbc.client.impl.StandardClient.<init>(StandardClient.java:195)    at org.mariadb.jdbc.Driver.connect(Driver.java:69)    at org.mariadb.jdbc.MariaDbDataSource.getConnection(MariaDbDataSource.java:80)    at com.mendix.connectionbus.connections.jdbc.implementations.mysql.MySqlDataStoreConfigurator.initialize(MySqlDataStoreConfigurator.scala:37)    at com.mendix.connectionbus.connections.jdbc.ConnectionManager$.apply(ConnectionManager.scala:19)    at com.mendix.connectionbus.ConnectionMinibus.connectionManager$lzycompute(ConnectionMinibus.scala:56)    at com.mendix.connectionbus.ConnectionMinibus.connectionManager(ConnectionMinibus.scala:55)    at com.mendix.connectionbus.ConnectionMinibus.systemProperties$lzycompute(ConnectionMinibus.scala:65)    at com.mendix.connectionbus.ConnectionMinibus.systemProperties(ConnectionMinibus.scala:62)    at com.mendix.connectionbus.ConnectionMinibus.get(ConnectionMinibus.scala:78)    at com.mendix.filedocumentprocessor.OldFileMigration$.isMigrationDone(OldFileMigration.scala:203)    at com.mendix.basis.objectmanagement.meta.metamodel.FileStoreBinaryMember$$anonfun$create$1.applyOrElse(FileStoreBinaryMemberFactory.scala:27)    at com.mendix.basis.objectmanagement.meta.metamodel.FileStoreBinaryMember$$anonfun$create$1.applyOrElse(FileStoreBinaryMemberFactory.scala:24)    at scala.PartialFunction$Lifted.apply(PartialFunction.scala:338)    at scala.PartialFunction$Lifted.apply(PartialFunction.scala:334)    at com.mendix.basis.objectmanagement.meta.metamodel.MetaPrimitiveRegistry$ExtensibleCreator.apply(MetaPrimitiveRegistry.scala:69)    at com.mendix.basis.objectmanagement.meta.metamodel.MetaPrimitiveRegistry$ExtensibleCreator.apply(MetaPrimitiveRegistry.scala:62)    at com.mendix.basis.objectmanagement.meta.metamodel.MetaPrimitiveRegistry.createMendixObjectMember(MetaPrimitiveRegistry.scala:45)    at com.mendix.basis.objectmanagement.MendixObjectFactory.createMendixObjectMember(MendixObjectFactory.scala:116)    at com.mendix.basis.objectmanagement.MendixObjectFactory.createPrimitive(MendixObjectFactory.scala:96)    at com.mendix.basis.objectmanagement.MendixObjectFactory.$anonfun$createMembers$1(MendixObjectFactory.scala:62)    at scala.collection.IterableOnceOps.foreach(IterableOnce.scala:576)    at scala.collection.IterableOnceOps.foreach$(IterableOnce.scala:574)    at scala.collection.AbstractIterable.foreach(Iterable.scala:933)    at com.mendix.basis.objectmanagement.MendixObjectFactory.createMembers(MendixObjectFactory.scala:61)    at com.mendix.basis.objectmanagement.MendixObjectFactory.createInstance(MendixObjectFactory.scala:44)    at com.mendix.basis.objectmanagement.MendixObjectFactory.$anonfun$initializeObjectInstances$1(MendixObjectFactory.scala:35)    at scala.collection.StrictOptimizedIterableOps.map(StrictOptimizedIterableOps.scala:100)    at scala.collection.StrictOptimizedIterableOps.map$(StrictOptimizedIterableOps.scala:87)    at scala.collection.convert.JavaCollectionWrappers$JCollectionWrapper.map(JavaCollectionWrappers.scala:80)    at com.mendix.basis.objectmanagement.MendixObjectFactory.initializeObjectInstances(MendixObjectFactory.scala:35)    at com.mendix.basis.impl.MxRuntimeImpl.$anonfun$initializeCore$1(MxRuntimeImpl.scala:694)    at com.mendix.util.startupmeter.StartUpMeter.measure(StartUpMeter.scala:66)    at com.mendix.basis.impl.MxRuntimeImpl.initializeCore(MxRuntimeImpl.scala:681)    at com.mendix.basis.impl.MxRuntimeImpl.$anonfun$start$1(MxRuntimeImpl.scala:143)    at com.mendix.util.startupmeter.StartUpMeter.measure(StartUpMeter.scala:66)    at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.scala:138)    at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.scala:33)    at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.scala:17)    at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandlerBase.service(HttpAdminHandlerBase.java:128)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:529)    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1384)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1306)    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)    at org.eclipse.jetty.server.Server.handle(Server.java:563)    at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598)    at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753)    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501)    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287)    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)    at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199)    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)    at java.base/java.lang.Thread.run(Thread.java:829)   I'm not sure what's wrong since I have no IP Filter active on my hosted database, to add to that I can see the preview of the data just fine but running the APP itself gives me this error, any thoughts would be much appreciated.   I am using Studio Pro 10.9.0
asked
0 answers