Bug 780474 (SOA-2901)

Summary: Teiid user can inadvertently save invalid JDBC username/password in JBDS - and not see an error until he later tries a VDB action
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Len DiMaggio <ldimaggi>
Component: Documentation, EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER9CC: vhalbert
Target Milestone: ---   
Target Release: 5.3.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2901
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-02 20:27:14 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
Teiid-instance.png none

Description Len DiMaggio 2011-02-11 17:07:24 UTC 
project_key: SOA

When a user creates a new Teiid instance in JBDS, the "New Teiid Instance" dialog requires him to define these connection properties:

   * Admin username
   * Admin password
   * JDBC username

The user is not - at this point - required to define a JDBC password.

The user is able to test the Admin connection in this dialog - see attached screenshot.

The user is, however, able to define and save an invalid JBDC username and/or password in this dialog. If the user inadvertently does this, no error results when the Teiid instance is created. An error such as that listed below will result when the user attempts to execute a VDB:

11:55:23,743 WARN  [SECURITY] Processing exception 'The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null.  Exception type org.teiid.client.security.LogonException thrown from org.teiid.transport.LogonImpl.logon(LogonImpl.java:82). Enable more detailed logging to see the entire stacktrace.
11:55:23,871 WARN  [SECURITY] Processing exception 'The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null.  Exception type org.teiid.client.security.LogonException thrown from org.teiid.transport.LogonImpl.logon(LogonImpl.java:82). Enable more detailed logging to see the entire stacktrace.

The workaround to this situation is to have the user edit the Teiid instance prooperties to define a valid JDBC username and password.
Comment 1 Len DiMaggio 2011-02-11 17:10:43 UTC 
Attachment: Added: Teiid-instance.png
Comment 2 Len DiMaggio 2011-02-11 17:11:20 UTC 
Link: Added: This issue is related to SOA-2902
Comment 4 Van Halbert 2011-05-09 21:26:32 UTC 
When the LogonException is received, can the Teiid instance properties dialog be presented and indicate that username and/or password are invalid?
Comment 5 Van Halbert 2011-06-15 18:00:48 UTC 
Link: Added: This issue depends TEIIDDES-870