[JBoss JIRA] Resolved: (TEIID-1300) EDS adminshell - getSessions() - each session object returned always shows a VDB of null
by Steven Hawkins (JIRA)
[ https://jira.jboss.org/browse/TEIID-1300?page=com.atlassian.jira.plugin.s... ]
Steven Hawkins resolved TEIID-1300.
-----------------------------------
Resolution: Rejected
Admin connections are not made to a specific vdb context and will report the vdb as null.
> EDS adminshell - getSessions() - each session object returned always shows a VDB of null
> ----------------------------------------------------------------------------------------
>
> Key: TEIID-1300
> URL: https://jira.jboss.org/browse/TEIID-1300
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1
> Reporter: Len DiMaggio
>
> With these VDBs deployed
> [Interoperability.1[TextFileData[text-connector/file/java:TextFileDS]], weather.1[Weather[Weather/MessageWeather/java:WeatherDS]], ModeShape.1[ModeShapeFunctions[], ModeShape[ModeShape/modeshape/ModeShapeDS]]]
> And these in use: Interoperability, weather
> Every session created shows a VDB of null:
> [session: sessionid=pC2AQPpaMZr3; userName=admin@jmx-console; vdbName=null; vdbVersion=0; createdTime=Thu Oct 07 22:52:13 EDT 2010; applicationName=null; clientHostName=localhost.localdomain; IPAddress=127.0.0.1; securityDomain=jmx-console; lastPingTime=Thu Oct 07 22:52:53 EDT 2010, session: sessionid=1oGdlWx+B3Te; userName=admin@jmx-console; vdbName=null; vdbVersion=0; createdTime=Thu Oct 07 21:38:34 EDT 2010; applicationName=null; clientHostName=localhost.localdomain; IPAddress=127.0.0.1; securityDomain=jmx-console; lastPingTime=Thu Oct 07 22:51:30 EDT 2010, session: sessionid=TA2+3kyQ1Wff; userName=admin@jmx-console; vdbName=null; vdbVersion=0; createdTime=Thu Oct 07 21:38:04 EDT 2010; applicationName=null; clientHostName=localhost.localdomain; IPAddress=127.0.0.1; securityDomain=jmx-console; lastPingTime=Thu Oct 07 22:51:04 EDT 2010, session: sessionid=dEl7em6K6o0u; userName=admin@jmx-console; vdbName=null; vdbVersion=0; createdTime=Thu Oct 07 21:17:04 EDT 2010; applicationName=null; clientHostName=localhost.localdomain; IPAddress=127.0.0.1; securityDomain=jmx-console; lastPingTime=Thu Oct 07 22:51:04 EDT 2010, session: sessionid=SDyHIyvSgVUg; userName=admin@teiid-security; vdbName=Interoperability; vdbVersion=1; createdTime=Thu Oct 07 22:52:48 EDT 2010; applicationName=null; clientHostName=localhost.localdomain; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Thu Oct 07 22:52:48 EDT 2010, session: sessionid=Sc8tMciQJfbP; userName=admin@teiid-security; vdbName=Interoperability; vdbVersion=2; createdTime=Thu Oct 07 22:52:50 EDT 2010; applicationName=null; clientHostName=localhost.localdomain; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Thu Oct 07 22:52:50 EDT 2010]
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 3 months
[JBoss JIRA] Assigned: (TEIID-962) Create new system function to dump temp table contents to file.
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-962?page=com.atlassian.jira.plugin.sy... ]
Ramesh Reddy reassigned TEIID-962:
----------------------------------
Assignee: Ramesh Reddy (was: Steven Hawkins)
> Create new system function to dump temp table contents to file.
> -----------------------------------------------------------------
>
> Key: TEIID-962
> URL: https://jira.jboss.org/browse/TEIID-962
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 6.0.0
> Environment: All
> Reporter: Ken Johnson
> Assignee: Ramesh Reddy
> Fix For: 7.2
>
>
> A requirement to produce a CSV file reflecting the contents of a query result set so it can be subsequently FTP'd or email'd. In Nov 07 implemented this feature using the exec connector, a shell script and mods to JDBCISQL.
> Suggested capability: function will take the following parameters:
> - Temp table name as string
> - Target file name (path qualified) as string
> - Delimiter as string
> When invoked, the specified temp table contents will be written out to the specified file using the specified delimiter to separate the column values.
> This generic capability will allow the CSV file thats needed and subsequently process it with other UDF functionality as necessary.
> Open questions:
> 1. How does file path behave in a clustered environment? Is it relative to the MM Server install dir or fully qualified?
> Suggest this feature remain undocumented for the short term.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 3 months
[JBoss JIRA] Resolved: (TEIID-950) Add ability to control access to environment variables
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-950?page=com.atlassian.jira.plugin.sy... ]
Ramesh Reddy resolved TEIID-950.
--------------------------------
Resolution: Done
By default disabled the "ENV" system function. Added new "SESSION_ID" system function to retrieve the session information of the executing user. Removed the static nature of loading the system functions to enable the configuration controlled loading of the functions.
> Add ability to control access to environment variables
> ------------------------------------------------------
>
> Key: TEIID-950
> URL: https://jira.jboss.org/browse/TEIID-950
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Environment: Found by client on MMx 502, tested and found issue present through 551.
> Reporter: Marc Shirley
> Assignee: Ramesh Reddy
> Fix For: 7.1.1, 7.2
>
>
> SELECT ENV('os.name') || ' ' || ENV('os.version') || ' ' || ENV('java.home') returns the details of the server, which from the client perspective is a security risk. This information is even visible by a user with no access to any tables. Client is looking to have this disabled, or have the ability to disable it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 3 months