[JBoss JIRA] (TEIID-3684) RoleBasedCredentialMapIdentityLoginModule throws exception at startup time
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-3684?page=com.atlassian.jira.plugin... ]
Juraj Duráni updated TEIID-3684:
--------------------------------
Issue Type: Bug (was: Enhancement)
> RoleBasedCredentialMapIdentityLoginModule throws exception at startup time
> --------------------------------------------------------------------------
>
> Key: TEIID-3684
> URL: https://issues.jboss.org/browse/TEIID-3684
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> If a data source is configured to use RoleBasedCredentialMapIdentityLoginModule, then exception is thrown at startup \[1\], because default username and password are null. Please, add module options "username" and "password" to set up default user (similar functionality have e.g. CallerIdentityLoginModule and PassthroughIdentityLoginModule), so DV is able to properly load data source at startup when no user is authenticated and therefore no mapping could be performed.
> Example configuration \[2\]. Note, there is no exception if UsersRoles login module is used instead of RealDirect. However, it means that EAP users are separate from DV users.
> *FYI:*
> -credentialMap module option should be defined as URL (file://...). It would be nice to have this information in the documentation.
> - I tried to use unauthenticatedIdentity module option for RealmDirect, but same exception has been thrown with different root cause (realm 'ApplicationRealm' not found). I do not know why.
> \[1\]
> ERROR [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer] (MSC service thread 1-5) Exception during createSubject()PBOX000016: Access denied: authentication failed: java.lang.SecurityException: PBOX000016: Access denied: authentication failed
> at org.jboss.security.plugins.JBossSecuritySubjectFactory.createSubject(JBossSecuritySubjectFactory.java:84)
> at org.jboss.jca.deployers.common.AbstractDsDeployer$1.run(AbstractDsDeployer.java:1084)
> at org.jboss.jca.deployers.common.AbstractDsDeployer$1.run(AbstractDsDeployer.java:1079)
> at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0_40]
> at org.jboss.jca.deployers.common.AbstractDsDeployer.createSubject(AbstractDsDeployer.java:1078)
> at org.jboss.jca.deployers.common.AbstractDsDeployer.deployDataSource(AbstractDsDeployer.java:600)
> at org.jboss.jca.deployers.common.AbstractDsDeployer.createObjectsAndInjectValue(AbstractDsDeployer.java:282)
> at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer.deploy(AbstractDataSourceService.java:316)
> at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.start(AbstractDataSourceService.java:120)
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980)
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
> \[2\]
> <security-domain name="my-sec">
> <authentication>
> <login-module code="RealmDirect" flag="required">
> <module-option name="password-stacking" value="tryFirstPass"/>
> <!--<module-option name="unauthenticatedIdentity" value="guest"/>-->
> </login-module>
> <login-module code="org.teiid.jboss.RoleBasedCredentialMapIdentityLoginModule" module="org.jboss.teiid" flag="required">
> <module-option name="password-stacking" value="useFirstPass"/>
> <module-option name="credentialMap" value="file:///home/jdurani/redhat/data-virtualization/dv_6.2.0/jboss-eap-6.4/standalone/configuration/teiid-credentialmap.properties"/>
> </login-module>
> </authentication>
> </security-domain>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 4 months
[JBoss JIRA] (TEIID-3683) Enhance the formula for caculating core size
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3683?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3683:
-------------------------------
Attachment: sizing-tools-cores.png
> Enhance the formula for caculating core size
> --------------------------------------------
>
> Key: TEIID-3683
> URL: https://issues.jboss.org/browse/TEIID-3683
> Project: Teiid
> Issue Type: Enhancement
> Components: Sizing Application
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Attachments: sizing-tools-cores.png
>
>
> I think we can consider to enhance in the following aspects:
> 1. Q7 is hard for user to input
> Q7 need some pre-test or run sample query via POC, this not easy for user to input, also they may feels confused.
> 2. How to caculate core size?
> Current we consider through serialize/deserialize, the linear serialize/deserialize percentage get from trial in my local pc, this may need more test/review.
> 3. Whether we can use runnable app replace Web UI
> If use runnable app like AdminShell, most of questions in attached png can cacualate and get a precise input,
> Any idea/advice for this?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 4 months
[JBoss JIRA] (TEIID-3683) Enhance the formula for caculating core size
by Kylin Soong (JIRA)
Kylin Soong created TEIID-3683:
----------------------------------
Summary: Enhance the formula for caculating core size
Key: TEIID-3683
URL: https://issues.jboss.org/browse/TEIID-3683
Project: Teiid
Issue Type: Enhancement
Components: Sizing Application
Reporter: Kylin Soong
Assignee: Kylin Soong
I think we can consider to enhance in the following aspects:
1. Q7 is hard for user to input
Q7 need some pre-test or run sample query via POC, this not easy for user to input, also they may feels confused.
2. How to caculate core size?
Current we consider through serialize/deserialize, the linear serialize/deserialize percentage get from trial in my local pc, this may need more test/review.
3. Whether we can use runnable app replace Web UI
If use runnable app like AdminShell, most of questions in attached png can cacualate and get a precise input,
Any idea/advice for this?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 4 months
[JBoss JIRA] (TEIID-3673) Subquery field with limit giving a wrong JDBC SQL in Oracle
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3673?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3673.
-----------------------------------
Fix Version/s: 8.12
Resolution: Done
Added the capability supportsCorrelatedSubqueryLimit to capture the Oracle limitation with creating the limit view at the translator layer.
> Subquery field with limit giving a wrong JDBC SQL in Oracle
> ------------------------------------------------------------
>
> Key: TEIID-3673
> URL: https://issues.jboss.org/browse/TEIID-3673
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.0
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> i'm executing the following query using Teiid 8.11.3 and Oracle translator:
> select "Trx_LjM_030915"."CID" as "Trx_LjM_030915_CID"
> ,"Trx_LjM_030915"."TransactionDate" as "Trx_LjM_030915_TransactionDa"
> ,(select "Trx_LjM_030915_sub"."TransactionDate" as "Trx_LjM_030915_TransactionDa"
> from "AUDIDATA_SCHEMANAME_MODEL"."AUDIDATA_SCHEMANAME"."Trx_LjM_030915" "Trx_LjM_030915_sub"
> where ("Trx_LjM_030915"."CID" = "Trx_LjM_030915_sub"."CID")
> AND ( ("Trx_LjM_030915_sub"."TransactionDate" < "Trx_LjM_030915"."TransactionDate") )
> order by "Trx_LjM_030915_sub"."TransactionDate" DESC
> LIMIT 0 , 1) as "SubQuery Trx"
> from "AUDIDATA_SCHEMANAME_MODEL"."AUDIDATA_SCHEMANAME"."Trx_LjM_030915" "Trx_LjM_030915" LIMIT 0 , 10
> And i'm getting this error:
> Error TEIID30504 AUDIDATA_SCHEMANAME_MODELVDB: 904 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT c_0, c_1, c_2 FROM (SELECT g_0."CID" AS c_0, g_0."TransactionDate" AS c_1, (SELECT c_0 FROM (SELECT g_1."TransactionDate" AS c_0 FROM "AUDIDATA_SCHEMANAME"."Trx_LjM_030915" g_1 WHERE g_1."CID" = g_0."CID" AND g_1."TransactionDate" < g_0."TransactionDate" ORDER BY c_0 DESC) WHERE ROWNUM <= 1) AS c_2 FROM "AUDIDATA_SCHEMANAME"."Trx_LjM_030915" g_0) WHERE ROWNUM <= 10
> You can notice g_0."CID" and g_0."TransactionDate" in the where condition are no longer valid in the Teiid generated JDBC SQL; Since they do not exist in the parent query.
> Note that the same case works fine with H2 and mysql
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 4 months
[JBoss JIRA] (TEIID-3538) Make OData V2 compatible with LINQPad
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3538?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3538.
---------------------------------
Resolution: Done
There is nothing further planned on this issue. So, resolving.
> Make OData V2 compatible with LINQPad
> -------------------------------------
>
> Key: TEIID-3538
> URL: https://issues.jboss.org/browse/TEIID-3538
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Labels: Final
> Fix For: 8.7.1.6_2, 8.11
>
> Attachments: $metadata
>
>
> Current OData V2 implementation is not able to load in LINQPad https://www.linqpad.net/
> Couple issues found
> - List(Edm.xxx) based collections are not supported. V2 Spec did not specify any List based collections. Only Collection(Edm.xxx) type. So, part of TEIID-3471 need to be rolled back and fix with Collection(Edm.xxx) type
> - Explicit definition of "not null" in Entity's key property.
> - TEIID-3471 did not go far enough to define accepts header to have "application/xml", "application/atom+xml" and "application/json" without "chaset=utf-8" appended to it. TEIID-3471 only added $metadata and service document. BTW, I was under the impression that I did add all the required places, and was surprised not see in commit :(
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 4 months