[JBoss JIRA] Commented: (TEIID-1488) EDS adminshell fails to connect to server with IBM JDK
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1488?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-1488:
-------------------------------------
Do you think it is feasible for us to follow the suggestion they make in the site above and provide the TrustManager for IBM JVM?
> EDS adminshell fails to connect to server with IBM JDK
> ------------------------------------------------------
>
> Key: TEIID-1488
> URL: https://issues.jboss.org/browse/TEIID-1488
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER7 build
> java -version
> java version "1.6.0"
> Java(TM) SE Runtime Environment (build pxi3260sr8-20100409_01(SR8))
> IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr8-20100401_55940 (JIT enabled, AOT enabled)
> J9VM - 20100401_055940
> JIT - r9_20100401_15339
> GC - 20100308_AA)
> JCL - 20100408_01
> uname -a
> Linux soa3.qa.atl2.redhat.com 2.6.18-128.4.1.el5 #1 SMP Thu Jul 23 19:59:17 EDT 2009 i686 athlon i386 GNU/Linux
> Reporter: Len DiMaggio
> Labels: ibm-jvm, ssl
> Fix For: 7.4
>
>
> export JAVA_HOME=/opt/ibm-java-i386-60/jre
> export PATH=/opt/ibm-java-i386-60/jre/bin/:$PATH
> sh ./adminshell.sh
> ======================================================================
> Teiid AdminShell Bootstrap Environment
> TEIID_HOME = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell
> CLASSPATH = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/patches/*:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/teiid-adminshell-7.1.1.jar:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/*
> JAVA = /opt/ibm-java-i386-60/jre/bin/java
> ======================================================================
> ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;]
> Groovy Shell (1.7.2, JVM: 1.6.0)
> Type 'help' or '\h' for help.
> ------------------------------------------------------------------------------------------------------------------------------------------
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "testing")
> ERROR java.lang.AssertionError:
> Assertion failed.
> at org.teiid.core.util.Assertion.failed (Assertion.java:73)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:68)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:60)
> at org.teiid.net.socket.SocketUtil.addCipherSuite (SocketUtil.java:135)
> at org.teiid.net.socket.SocketUtil$SSLSocketFactory.getSocket (SocketUtil.java:85)
> at org.teiid.net.socket.OioOjbectChannelFactory.createObjectChannel (OioOjbectChannelFactory.java:165)
> at org.teiid.net.socket.SocketServerInstanceImpl.connect (SocketServerInstanceImpl.java:91)
> at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance (SocketServerConnectionFactory.java:276)
> at org.teiid.net.socket.SocketServerConnection.connect (SocketServerConnection.java:172)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance (SocketServerConnection.java:124)
> at org.teiid.net.socket.SocketServerConnection.<init> (SocketServerConnection.java:94)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:312)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:71)
> at org.teiid.adminapi.AdminFactory$AdminProxy.<init> (AdminFactory.java:53)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:159)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:149)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:120)
> at org.teiid.adminshell.AdminShell.connectAsAdmin (AdminShell.java:71)
> at org.teiid.adminshell.AdminShell$connectAsAdmin.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
> ...
> groovy:000>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months
[JBoss JIRA] Resolved: (TEIID-217) LDAP Connector should provide a way to retrieve all values of an attribute that appears multiple times within a search result
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-217?page=com.atlassian.jira.plugin.... ]
Steven Hawkins resolved TEIID-217.
----------------------------------
Resolution: Done
updated the doc and the code to allow the default value to control multi-valued behavior.
> LDAP Connector should provide a way to retrieve all values of an attribute that appears multiple times within a search result
> -----------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-217
> URL: https://issues.jboss.org/browse/TEIID-217
> Project: Teiid
> Issue Type: Feature Request
> Components: LDAP Connector
> Affects Versions: 6.0.0
> Reporter: Michael Walker
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 7.4
>
> Attachments: ldap.patch.txt, LDAPSyncQueryExecution.java
>
>
> If an attribute appears more than once, we should have some way to return all values. Currently, we only return one value, with no rhyme, reason, or determinism as to which one gets returned. Implementing this is difficult when multiple attributes appear more than once, of course. But a simple example of where this problem rears it's head is in modeling LDAP groups. Groups typically have repeating attributes to represent each member, and it would be nice to query all members of a given group, but impossible to do so with the current logic.
> A sophisticated solution would create a normalized view of a DN, breaking out multi-valued attributes into a separate table that could be joined by a primary key. A simple solution might allow attributes to be flagged as "multi-valued", in which case, they could be maintained in a single denormalized table that represents all values in the DN.
> If we build an importer for LDAP, we should consider how to best handle this issue in the importer design.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months
[JBoss JIRA] Resolved: (TEIID-1488) EDS adminshell fails to connect to server with IBM JDK
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1488?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1488.
-----------------------------------
Labels: ibm-jvm ssl (was: )
Fix Version/s: 7.4
Resolution: Done
changed the assertion to a warning, which simplifies the workarounds for IBM or other jvms that don't support the anon cipher suite:
1) Have the adminshell not use ssl. The Teiid server would need to be changed to non-ssl for admin connections.
2) User has to configure the TrustManager to support anonymous ciphers on the client/server
3) Have the server use full ssl. Some kind of cert, self-signed or otherwise, would need to be generated.
For differences between Sun JDK and IBM JDK, see: http://www.ibm.com/developerworks/java/jdk/security/50/secguides/jsse2Doc...
> EDS adminshell fails to connect to server with IBM JDK
> ------------------------------------------------------
>
> Key: TEIID-1488
> URL: https://issues.jboss.org/browse/TEIID-1488
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER7 build
> java -version
> java version "1.6.0"
> Java(TM) SE Runtime Environment (build pxi3260sr8-20100409_01(SR8))
> IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr8-20100401_55940 (JIT enabled, AOT enabled)
> J9VM - 20100401_055940
> JIT - r9_20100401_15339
> GC - 20100308_AA)
> JCL - 20100408_01
> uname -a
> Linux soa3.qa.atl2.redhat.com 2.6.18-128.4.1.el5 #1 SMP Thu Jul 23 19:59:17 EDT 2009 i686 athlon i386 GNU/Linux
> Reporter: Len DiMaggio
> Labels: ssl, ibm-jvm
> Fix For: 7.4
>
>
> export JAVA_HOME=/opt/ibm-java-i386-60/jre
> export PATH=/opt/ibm-java-i386-60/jre/bin/:$PATH
> sh ./adminshell.sh
> ======================================================================
> Teiid AdminShell Bootstrap Environment
> TEIID_HOME = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell
> CLASSPATH = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/patches/*:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/teiid-adminshell-7.1.1.jar:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/*
> JAVA = /opt/ibm-java-i386-60/jre/bin/java
> ======================================================================
> ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;]
> Groovy Shell (1.7.2, JVM: 1.6.0)
> Type 'help' or '\h' for help.
> ------------------------------------------------------------------------------------------------------------------------------------------
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "testing")
> ERROR java.lang.AssertionError:
> Assertion failed.
> at org.teiid.core.util.Assertion.failed (Assertion.java:73)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:68)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:60)
> at org.teiid.net.socket.SocketUtil.addCipherSuite (SocketUtil.java:135)
> at org.teiid.net.socket.SocketUtil$SSLSocketFactory.getSocket (SocketUtil.java:85)
> at org.teiid.net.socket.OioOjbectChannelFactory.createObjectChannel (OioOjbectChannelFactory.java:165)
> at org.teiid.net.socket.SocketServerInstanceImpl.connect (SocketServerInstanceImpl.java:91)
> at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance (SocketServerConnectionFactory.java:276)
> at org.teiid.net.socket.SocketServerConnection.connect (SocketServerConnection.java:172)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance (SocketServerConnection.java:124)
> at org.teiid.net.socket.SocketServerConnection.<init> (SocketServerConnection.java:94)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:312)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:71)
> at org.teiid.adminapi.AdminFactory$AdminProxy.<init> (AdminFactory.java:53)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:159)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:149)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:120)
> at org.teiid.adminshell.AdminShell.connectAsAdmin (AdminShell.java:71)
> at org.teiid.adminshell.AdminShell$connectAsAdmin.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
> ...
> groovy:000>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months
[JBoss JIRA] Moved: (TEIID-1488) EDS adminshell fails to connect to server with IBM JDK
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1488?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-2952 to TEIID-1488:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1488 (was: SOA-2952)
Affects Version/s: 7.1.1
(was: 5.1.0.ER7)
Release Notes Docs Status: (was: Documented as Known Issue)
Release Notes Text: (was: Teiid expects the vm to support the TLS_DH_anon_WITH_AES_128_CBC_SHA for anon ssl, which is the default for admin communication. However, with the IBM JDK, it does not support anonymous ciphers.
There are options:
1) Have the adminshell not use ssl. This would require the changing of the admin connection properties file and turning off ssl. This file will need to be added to the front of the classpath. Also, the Teiid server would need to be changed to non-ssl for admin connections.
2) User has to configure the TrustManager to support annonymous ciphers
3) same as 1 on the client side (unless we put in a change that downgrades the assertionerror to a warning) and have the server use full ssl. Some kind of cert, self-signed or otherwise, would need to be generated.
For differences between Sun JDK and IBM JDK, see: http://www.ibm.com/developerworks/java/jdk/security/50/secguides/jsse2Doc...
)
Component/s: Server
(was: EDS)
Security: (was: Public)
Fix Version/s: (was: FUTURE)
> EDS adminshell fails to connect to server with IBM JDK
> ------------------------------------------------------
>
> Key: TEIID-1488
> URL: https://issues.jboss.org/browse/TEIID-1488
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER7 build
> java -version
> java version "1.6.0"
> Java(TM) SE Runtime Environment (build pxi3260sr8-20100409_01(SR8))
> IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr8-20100401_55940 (JIT enabled, AOT enabled)
> J9VM - 20100401_055940
> JIT - r9_20100401_15339
> GC - 20100308_AA)
> JCL - 20100408_01
> uname -a
> Linux soa3.qa.atl2.redhat.com 2.6.18-128.4.1.el5 #1 SMP Thu Jul 23 19:59:17 EDT 2009 i686 athlon i386 GNU/Linux
> Reporter: Len DiMaggio
>
> export JAVA_HOME=/opt/ibm-java-i386-60/jre
> export PATH=/opt/ibm-java-i386-60/jre/bin/:$PATH
> sh ./adminshell.sh
> ======================================================================
> Teiid AdminShell Bootstrap Environment
> TEIID_HOME = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell
> CLASSPATH = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/patches/*:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/teiid-adminshell-7.1.1.jar:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/*
> JAVA = /opt/ibm-java-i386-60/jre/bin/java
> ======================================================================
> ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;]
> Groovy Shell (1.7.2, JVM: 1.6.0)
> Type 'help' or '\h' for help.
> ------------------------------------------------------------------------------------------------------------------------------------------
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "testing")
> ERROR java.lang.AssertionError:
> Assertion failed.
> at org.teiid.core.util.Assertion.failed (Assertion.java:73)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:68)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:60)
> at org.teiid.net.socket.SocketUtil.addCipherSuite (SocketUtil.java:135)
> at org.teiid.net.socket.SocketUtil$SSLSocketFactory.getSocket (SocketUtil.java:85)
> at org.teiid.net.socket.OioOjbectChannelFactory.createObjectChannel (OioOjbectChannelFactory.java:165)
> at org.teiid.net.socket.SocketServerInstanceImpl.connect (SocketServerInstanceImpl.java:91)
> at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance (SocketServerConnectionFactory.java:276)
> at org.teiid.net.socket.SocketServerConnection.connect (SocketServerConnection.java:172)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance (SocketServerConnection.java:124)
> at org.teiid.net.socket.SocketServerConnection.<init> (SocketServerConnection.java:94)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:312)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:71)
> at org.teiid.adminapi.AdminFactory$AdminProxy.<init> (AdminFactory.java:53)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:159)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:149)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:120)
> at org.teiid.adminshell.AdminShell.connectAsAdmin (AdminShell.java:71)
> at org.teiid.adminshell.AdminShell$connectAsAdmin.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
> ...
> groovy:000>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months
[JBoss JIRA] Moved: (TEIID-1486) Add implicit conversion of NULL to correct datatype in transformation validator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1486?page=com.atlassian.jira.plugin... ]
Steven Hawkins moved TEIIDDES-210 to TEIID-1486:
------------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-1486 (was: TEIIDDES-210)
Affects Version/s: 6.0.0
(was: 6.0.0)
(was: 6.1.0)
Component/s: Query Engine
(was: Transformations)
(was: Validation)
Fix Version/s: (was: Future)
> Add implicit conversion of NULL to correct datatype in transformation validator
> -------------------------------------------------------------------------------
>
> Key: TEIID-1486
> URL: https://issues.jboss.org/browse/TEIID-1486
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 6.0.0
> Reporter: Marc Shirley
>
> When using NULL value as a column (ie, NULL as columnName), it is only implicitly converted to a string. When trying to use the NULL as a column of type date, integer, float, etc., the validator throws a warning that the transformation is not valid. If you wrap the NULL in a convert to the correct column datatype (ie, "convert(NULL,date)"), the transformation can be validated successfully.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months