<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">I can confirm the issue with the fixed password. Doing some more tests I come to the conclusion that the whole idea of testing the connection during the "Create Datasource" wizard is a bad idea. There are more issues related to this [1]. </div><div class=""><br class=""></div><div class="">[1] <a href="http://wildfly-development.1055759.n5.nabble.com/Test-connection-issues-in-management-console-td5716696.html" class="">http://wildfly-development.1055759.n5.nabble.com/Test-connection-issues-in-management-console-td5716696.html</a></div><br class=""><div><blockquote type="cite" class=""><div class="">Am 30.01.2016 um 22:46 schrieb Renann Prado <<a href="mailto:darkness.renann@gmail.com" class="">darkness.renann@gmail.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">I've just downloaded Wildfly 10.0.0.Final and it's still not working 100%.<div class=""><br class=""></div><div class="">1 - Fill all the fields, but put some wrong information like password, ip, whatever</div><div class="">2 - Get to the last screen where you can test the connection</div><div class="">3 - Test the connection (and fails)</div><div class="">4 - Go back, fix the connection info with right information</div><div class="">5 - Test connection and still fails (it's using old credentials)</div><div class=""><br class=""></div><div class="">Btw I was also able to see org.jboss.msc.service.DuplicateServiceException when I was testing, though I don't have clear steps how to reproduce.</div><div class="">I don't believe the problem is in the web UI.</div><div class=""><br class=""></div><div class="">Another minor issue is that when it fails to test, most of the times (if not always), regardless of the type of error I get in the server, in web UI I always get same generic error message:</div><div class=""><br class=""></div><div class=""><p class=""><span class="">19:41:01,345 ERROR [org.jboss.as.controller.management-operation] (management task-5) WFLYCTL0013: Operation ("test-connection-in-pool") failed - address: ([</span></p><p class=""><span class=""> ("subsystem" => "datasources"),</span></p><p class=""><span class=""> ("data-source" => "MySqlDS")</span></p><p class=""><span class="">]) - failure description: "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid"</span></p><p class=""><span class=""><br class=""></span></p><p class="">And when I went to look in the server log:<br class=""><br class=""></p><p class=""><span class="">Caused by: java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'admin'@'192.168.0.107' (using password: YES)</span></p><p class=""><span class=""><span class=""> </span>at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:121)</span></p><p class=""><span class=""><span class=""> </span>at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)</span></p><p class=""><span class=""><span class=""> </span>at org.mariadb.jdbc.Driver.connect(Driver.java:110)</span></p><p class=""><span class=""><span class=""> </span>at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:319)</span></p><div class="">
<br class="webkit-block-placeholder"></div><p class=""><span class=""><span class=""> </span>... 31 more</span></p></div><div class=""><br class=""></div><div class="">It would be nice to propagete the correct error to the web UI.</div><div class=""><br class=""></div><div class="">Thanks</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div>
<div class="gmail_extra"><br clear="all" class=""><div class=""><div class="gmail_signature">Renann Prado</div></div>
<br class=""><div class="gmail_quote">On Fri, Jan 29, 2016 at 7:22 AM, Darran Lofthouse <span dir="ltr" class=""><<a href="mailto:darran.lofthouse@jboss.com" target="_blank" class="">darran.lofthouse@jboss.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class=""><br class="">
<br class="">
On 29/01/16 02:07, Renann Prado wrote:<br class="">
> I'm pretty sure I reported same issue as yours.<br class="">
><br class="">
> See:<br class="">
> <a href="https://issues.jboss.org/browse/WFLY-6015" rel="noreferrer" target="_blank" class="">https://issues.jboss.org/browse/WFLY-6015</a><br class="">
><br class="">
> Seems to be fixed, but it's not clear to me whether it will be part of<br class="">
> Wildfly 10 Final or not.<br class="">
<br class="">
</span>Apart from the occasional mistake in Jira if the status is 'Resolved'<br class="">
the 'Fix Version/s' field shows the release the fix is or will be<br class="">
included in.<br class="">
<span class=""><br class="">
> However you can easily work around: just add the datasource with with<br class="">
> your driver && config and DO NOT CLICK IN TEST CONNECTION, then while<br class="">
> EDITING the datasource you can test the connection as many times as you<br class="">
> want. I did that in Wildfly 10.0.0.CR5 and it worked just fine.<br class="">
><br class="">
> I wouldn't call that a blocker as there are couple of ways to create a<br class="">
> datasource.<br class="">
><br class="">
> Hope it helps.<br class="">
><br class="">
> Renann Prado<br class="">
><br class="">
> On Thu, Jan 28, 2016 at 11:58 PM, Danilo Cominotti Marques<br class="">
</span><span class="">> <<a href="mailto:dcominottim@gmail.com" target="_blank" class="">dcominottim@gmail.com</a> <mailto:<a href="mailto:dcominottim@gmail.com" target="_blank" class="">dcominottim@gmail.com</a>>> wrote:<br class="">
><br class="">
> Hello there,<br class="">
><br class="">
> I have seen the e-mail that listed the following issues as blockers<br class="">
> for WildFly 10 Final,<br class="">
><br class="">
> 1. <a href="https://issues.jboss.org/browse/WFLY-5480" rel="noreferrer" target="_blank" class="">https://issues.jboss.org/browse/WFLY-5480</a><br class="">
> 2. <a href="https://issues.jboss.org/browse/WFCORE-1277" rel="noreferrer" target="_blank" class="">https://issues.jboss.org/browse/WFCORE-1277</a><br class="">
><br class="">
> but I would clearly add the following one to that list,<br class="">
><br class="">
> 3. <a href="https://issues.jboss.org/browse/HAL-1030" rel="noreferrer" target="_blank" class="">https://issues.jboss.org/browse/HAL-1030</a><br class="">
><br class="">
> because my company certainly wouldn't deploy WildFly 10 Final before<br class="">
> this issue is solved.<br class="">
><br class="">
> Any chances of having somebody look into it before the final release?<br class="">
><br class="">
> Thanks.<br class="">
><br class="">
> Danilo Cominotti Marques<br class="">
><br class="">
><br class="">
> _______________________________________________<br class="">
> wildfly-dev mailing list<br class="">
</span>> <a href="mailto:wildfly-dev@lists.jboss.org" target="_blank" class="">wildfly-dev@lists.jboss.org</a> <mailto:<a href="mailto:wildfly-dev@lists.jboss.org" target="_blank" class="">wildfly-dev@lists.jboss.org</a>><br class="">
> <a href="https://lists.jboss.org/mailman/listinfo/wildfly-dev" rel="noreferrer" target="_blank" class="">https://lists.jboss.org/mailman/listinfo/wildfly-dev</a><br class="">
<div class=""><div class="">><br class="">
><br class="">
><br class="">
><br class="">
> _______________________________________________<br class="">
> wildfly-dev mailing list<br class="">
> <a href="mailto:wildfly-dev@lists.jboss.org" target="_blank" class="">wildfly-dev@lists.jboss.org</a><br class="">
> <a href="https://lists.jboss.org/mailman/listinfo/wildfly-dev" rel="noreferrer" target="_blank" class="">https://lists.jboss.org/mailman/listinfo/wildfly-dev</a><br class="">
><br class="">
_______________________________________________<br class="">
wildfly-dev mailing list<br class="">
<a href="mailto:wildfly-dev@lists.jboss.org" target="_blank" class="">wildfly-dev@lists.jboss.org</a><br class="">
<a href="https://lists.jboss.org/mailman/listinfo/wildfly-dev" rel="noreferrer" target="_blank" class="">https://lists.jboss.org/mailman/listinfo/wildfly-dev</a><br class="">
</div></div></blockquote></div><br class=""></div></div>
_______________________________________________<br class="">wildfly-dev mailing list<br class=""><a href="mailto:wildfly-dev@lists.jboss.org" class="">wildfly-dev@lists.jboss.org</a><br class="">https://lists.jboss.org/mailman/listinfo/wildfly-dev</div></blockquote></div><br class=""><div class="">
---<br class="">Harald Pehl<br class="">JBoss by Red Hat<br class=""><a href="http://hpehl.info" class="">http://hpehl.info</a><br class="">
</div>
<br class=""></body></html>