Question & Answer > View Question

Connecting from Joget hosted cloud instance of Joget to external MYSQL database

Confluence User - 31 Aug, 2017

I am trying to connect from a Joget hosted cloud instance of Joget to a MySQL database on AWS using Configure Datasource > Configure Custom Database. When I test it seems to almost connect but I get the error:

Cause:
Cannot create PoolableConnectionFactory (Access denied for user 'mysqlroot'@'ec2-54-193-24-224.us-west-1.compute.amazonaws.com' (using password: YES))

These credentials work just fine from other non-Joget applications.

Why does this not work as expected?

Thanks, Bill

userviews;server;datasource

7

Confluence User •

31 Aug, 2017 •

confluenceUser •

•

confluenceUser •

Hi, I believe this is due to security restrictions as mentioned in Problem connecting external Database in Joget onDemand

Confluence User •

01 Sep, 2017 •

confluenceUser •

•

confluenceUser •

I thought this might be the case so I tried it on an enterprise self-hosted version. Now I get

When I create the Custom Datasource for the Jasper Reports plugin. This looks correct.

However, then why I try to execute the same report from the userview I get

Can this plug not use current TIBCO Jaspersoft Studio jrxml files?

Thanks, Bill

Confluence User •

01 Sep, 2017 •

confluenceUser •

•

confluenceUser •

Hi, in this case the error message says "Access denied for user" which actually indicates that the authentication failed. Perhaps its some incorrect jdbc configuration in the jrxml file.

Confluence User •

03 Sep, 2017 •

confluenceUser •

•

confluenceUser •

Hi Anders,

No, I have now tried to access this same database in a simple datalist. I have verified that the correct credentials have been entered because if I change the password to anything else I get

But it I use the correct password, I get

But when when I click ok in the Custom Datasource screen, i get

The corresponding error in the log is

2017-09-02 15:50:45,674: java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'mysqlroot'@'ec2-54-83-5-152.compute-1.amazonaws.com' (using password: YES))
java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'mysqlroot'@'ec2-54-83-5-152.compute-1.amazonaws.com' (using password: YES))

The SQL Query is simple and correct

SELECT * FROM x2_churches

It appears that when the Query request is made the same/proper credentials are not being used as for the connection test.

How can I get this resolved?

Thank, Bill

Confluence User •

03 Sep, 2017 •

confluenceUser •

•

confluenceUser •

Also in the log, I notice the error “java.lang.IllegalArgumentException:" at the beginning of this section before the first error regarding authentication " java.sql.SQLException:” (see below). Could the first error be causing the issue?

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

2017-09-02 15:50:45,667: java.lang.IllegalArgumentException: Illegal group reference: group index is missing

java.lang.IllegalArgumentException: Illegal group reference: group index is missing

at java.util.regex.Matcher.appendReplacement(Unknown Source)

at java.util.regex.Matcher.replaceAll(Unknown Source)

at java.lang.String.replaceAll(Unknown Source)

at org.joget.commons.util.StringUtil.decryptContent(StringUtil.java:442)

at org.joget.apps.app.service.AppUtil.processHashVariable(AppUtil.java:428)

at org.joget.apps.app.service.AppUtil.processHashVariable(AppUtil.java:410)

at org.joget.apps.app.controller.DatalistBuilderWebController.createDataListBinderFromRequestInternal(DatalistBuilderWebController.java:299)

at org.joget.apps.app.controller.DatalistBuilderWebController.getBuilderDataColumnList(DatalistBuilderWebController.java:211)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:180)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)

at org.joget.commons.spring.web.ParameterizedAnnotationMethodHandlerAdapter.handle(ParameterizedAnnotationMethodHandlerAdapter.java:32)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)