[JBoss JIRA] (TEIIDSB-86) Plans for secure socket transports
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-86?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIIDSB-86 at 5/10/19 6:15 PM:
----------------------------------------------------------------
To expand on pg. To do sni you must be configure a passthrough route. To do edge termination requires a standard http service on the backend. pg is not end-to-end encryption. tls is part of of their protocol, so passthrough won't work.
I'll investigate tls with sni for Teiid JDBC though.
was (Author: shawkins):
To expand on pg. To do sni you must be configure a passthrough route. To do edge termination requires a standard http service on the backend. pg is not end-to-end encryption. Add tls is part of of there protocol, so passthrough won't work.
I'll investigate tls with sni for Teiid JDBC though.
> Plans for secure socket transports
> ----------------------------------
>
> Key: TEIIDSB-86
> URL: https://issues.jboss.org/browse/TEIIDSB-86
> Project: Teiid Spring Boot
> Issue Type: Quality Risk
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 1.1.0
>
>
> The Teiid Spring Boot configuration allows for only non-secured pg / JDBC socket transports. For external client scenarios and even for varying degrees of compliance with intra-cluster traffic, a secure layer may be required.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 11 months
[JBoss JIRA] (TEIIDSB-87) Upgrade Teiid to 12.2.0
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-87?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIIDSB-87:
---------------------------------------
I was in the middle of this locally to run some transport scenarios. I'm seeing a few dependency issues.
For example odata-client-api transitively uses commons-codec 1.11, when 1.12 is expected. After that is addressed 3 more issue popped up. All seem to be related to odata transitive dependencies. Do you already have this working?
> Upgrade Teiid to 12.2.0
> -----------------------
>
> Key: TEIIDSB-87
> URL: https://issues.jboss.org/browse/TEIIDSB-87
> Project: Teiid Spring Boot
> Issue Type: Task
> Components: core
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.1.0
>
>
> Upgrade the Teiid Spring Boot's version of Teiid to 12.2.0 release
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 11 months
[JBoss JIRA] (TEIIDSB-87) Upgrade Teiid to 12.2.0
by Ramesh Reddy (Jira)
Ramesh Reddy created TEIIDSB-87:
-----------------------------------
Summary: Upgrade Teiid to 12.2.0
Key: TEIIDSB-87
URL: https://issues.jboss.org/browse/TEIIDSB-87
Project: Teiid Spring Boot
Issue Type: Task
Components: core
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 1.1.0
Upgrade the Teiid Spring Boot's version of Teiid to 12.2.0 release
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 11 months
[JBoss JIRA] (TEIID-5741) Upgrade to Thorntail 2.4
by Steven Hawkins (Jira)
Steven Hawkins created TEIID-5741:
-------------------------------------
Summary: Upgrade to Thorntail 2.4
Key: TEIID-5741
URL: https://issues.jboss.org/browse/TEIID-5741
Project: Teiid
Issue Type: Feature Request
Components: thorntail
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: tt-2.1.0
As a likely terminal release, we should provide Java 11 support via Thorntail 2.4.
Since 2.4 is based upon WildFly 15.0.1, this will likely be off of 12.2.x, rather than 12.3.x.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 11 months
[JBoss JIRA] (TEIID-5739) Procedure does not get executed (without error) when comment and variable declaration are present
by Dmitrii Pogorelov (Jira)
[ https://issues.jboss.org/browse/TEIID-5739?page=com.atlassian.jira.plugin... ]
Dmitrii Pogorelov commented on TEIID-5739:
------------------------------------------
[~shawkins] thx a lot for the quick fix. I've already checked, these changed worked for us.
> Procedure does not get executed (without error) when comment and variable declaration are present
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-5739
> URL: https://issues.jboss.org/browse/TEIID-5739
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 12.0
> Reporter: Dmitrii Pogorelov
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 12.2, 12.1.2
>
>
> Using the below definition, it should delete the data from the table. It will do it if you either remove the comment or the variable declaration. Interestingly, it looks like the proc is executed, but the data is still present in the test table:
> {code:sql}
> create virtual procedure deleteTableTest (
> ) AS
> --
> begin
> declare string v;
> execute immediate 'DELETE from dwh.testRemove' without return ;
> end
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 11 months
[JBoss JIRA] (TEIID-5739) Procedure does not get executed (without error) when comment and variable declaration are present
by Dmitrii Pogorelov (Jira)
[ https://issues.jboss.org/browse/TEIID-5739?page=com.atlassian.jira.plugin... ]
Dmitrii Pogorelov edited comment on TEIID-5739 at 5/9/19 9:39 AM:
------------------------------------------------------------------
[~shawkins] thx a lot for the quick fix. I've already checked, these changes worked for us.
was (Author: dalex005):
[~shawkins] thx a lot for the quick fix. I've already checked, these changed worked for us.
> Procedure does not get executed (without error) when comment and variable declaration are present
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-5739
> URL: https://issues.jboss.org/browse/TEIID-5739
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 12.0
> Reporter: Dmitrii Pogorelov
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 12.2, 12.1.2
>
>
> Using the below definition, it should delete the data from the table. It will do it if you either remove the comment or the variable declaration. Interestingly, it looks like the proc is executed, but the data is still present in the test table:
> {code:sql}
> create virtual procedure deleteTableTest (
> ) AS
> --
> begin
> declare string v;
> execute immediate 'DELETE from dwh.testRemove' without return ;
> end
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 11 months
[JBoss JIRA] (TEIID-5619) Provide tables representing admin information
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5619?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5619.
-----------------------------------
Resolution: Partially Completed
Marking the issue as partially completed with a follow-up for 12.3. For now stats type information will not be addressed as that is available via jmx / prometheus as well.
> Provide tables representing admin information
> ---------------------------------------------
>
> Key: TEIID-5619
> URL: https://issues.jboss.org/browse/TEIID-5619
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.2
>
>
> Information provided over the admin api about sessions, requests, transactions, etc. should also be available via system tables.
> Similarly many of the admin operations could be provided as system procedures - kill session, flush cache, etc.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 11 months