Bug 1014332 - Installer should provide users a way to test/verify DB connectivity (as JON installer does) before performing the install
Summary: Installer should provide users a way to test/verify DB connectivity (as JON i...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Fuse Service Works 6
Classification: JBoss
Component: Installer
Version: 6.0.0 GA
Hardware: Unspecified
OS: Unspecified
unspecified
urgent
Target Milestone: ER7
: 6.0.0
Assignee: Thomas Hauser
QA Contact: Len DiMaggio
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-10-01 18:12 UTC by Len DiMaggio
Modified: 2014-02-06 15:26 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2014-02-06 15:26:04 UTC
Type: Enhancement
Embargoed:


Attachments (Terms of Use)

Description Len DiMaggio 2013-10-01 18:12:38 UTC
Description of problem:

There is no validation of the DB connectivity properties that the user enters into the installer. If there is an error or typo in the DB URL, username, etc. then the user will not be informed until the end of the installation.

Can we add a 'connection test' feature such as is provided by the JON installer?


Version-Release number of selected component (if applicable):
ER4

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Len DiMaggio 2013-10-11 19:15:38 UTC
With out this type of built in test tool, users can mis-type a DB URL and then have to re-run the entire installation when it fails:


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any pack
ets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:
45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
	... 26 more
Caused by: java.net.UnknownHostException: localost: Name or service not known
	at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
	at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:894)
	at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1286)
	at java.net.InetAddress.getAllByName0(InetAddress.java:1239)
	at java.net.InetAddress.getAllByName(InetAddress.java:1155)
	at java.net.InetAddress.getAllByName(InetAddress.java:1091)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:293)
	... 27 more

Comment 2 Thomas Hauser 2013-10-11 19:41:48 UTC
This type of validation has been added to the post-beta installer:

When the user clicks next, their connection will be tested (not optional.) They will be warned about the status of this connection (failure, missing driver, etc) and allowed to continue (perhaps they can correct the problem immediately outside the installer). Let me know if this isn't sufficient.

Comment 3 Jiri Sedlacek 2013-12-12 13:13:14 UTC
verified in ER7


Note You need to log in before you can comment on or make changes to this bug.