5:10 p.m.
I have VDB deployed and I can execute sql query on it. But when I try to run the query
using OData, I get error. Can someone please help?
http://localhost:8080/odata/TestODataVDB/$metadata
h1. JBWEB000065: HTTP Status 403 - JBWEB000015: Access to the requested resource
has been denied
----
*JBWEB000309: type* JBWEB000067: Status report
*JBWEB000068: message* JBWEB000015: Access to the requested resource
has been denied
*JBWEB000069: description* JBWEB000123: Access to the specified
resource has been forbidden.
Posted by forums
Original post: https://developer.jboss.org/message/906924#906924
3:37 a.m.
Hi Jaideep,
Make sure your user has the "odata" role.
OData Support - Teiid 8.9 (draft) - Project Documentation Editor
(https://docs.jboss.org/author/display/TEIID/OData+Support)
Thanks,
Ted
Posted by forums
Original post: https://developer.jboss.org/message/907020#907020
8:39 a.m.
Hi Ted.
Configuration in the web.xml looks correct, but still getting the same error
{emoticon:class=jive_macro
jive_emote|src=https://static.jboss.org/developer/6.0.3.60ddddd/images/em...
<security-role>
<description>security role</description>
<role-name>odata</role-name>
</security-role>
<security-constraint>
<display-name>require valid user</display-name>
<web-resource-collection>
<web-resource-name>Teiid Rest Application</web-resource-name>
<url-pattern>/*</url-pattern>
</web-resource-collection>
<auth-constraint>
<role-name>odata</role-name>
</auth-constraint>
</security-constraint>
<login-config>
<auth-method>BASIC</auth-method>
<realm-name>localhost</realm-name>
</login-config>
Posted by forums
Original post: https://developer.jboss.org/message/907059#907059
9:23 a.m.
Hi Jaideep,
You need to add the "odata" role for "user" in
*+{as7InstallLocation}/standalone/configuration/teiid-security-users.properties+*. By
default, the user will be authenticated against Teiid's default security domain
"teiid-security" and makes use of the security role *odata*.
Thanks,
Ted
Posted by forums
Original post: https://developer.jboss.org/message/907063#907063
10:41 a.m.
Hi Ted,
I don't see teiid-security-users.properties and teiid-security-roles.properties files
in standalone/configuration. I see application-roles.properties and
application-users.properties files only. Do I have to create teiid-security-***.properties
files manually?
Thanks,
Posted by forums
Original post: https://developer.jboss.org/message/907067#907067
11:01 a.m.
No Jaideep.. you don't need to create the property files. In older versions of Teiid,
the property files were located in the Teiid module (org/jboss/teiid/main/conf). What
version are you using?
Thanks,
Ted
Posted by forums
Original post: https://developer.jboss.org/message/907068#907068
1:02 p.m.
Ted,
I am using 8.8.1. These files are not in the distribution archive.
Image:teiidZip.png
Posted by forums
Original post: https://developer.jboss.org/message/907076#907076
2:07 p.m.
Ah.. it looks like those files have been removed. You can update "user" in the
application-roles.properties file to add the "odata" role.
Posted by forums
Original post: https://developer.jboss.org/message/907077#907077
3:48 p.m.
Ted,
I added application user using bin\add-user.bat and it did the trick. Now I am able to see
the data using OData API.
Thanks very much for all your help.
Best,
Jaideep
Posted by forums
Original post: https://developer.jboss.org/message/907079#907079
4:31 a.m.
That's great Jaideep. Glad we could get you up and running with OData.
Posted by forums
Original post: https://developer.jboss.org/message/907128#907128
4043
days inactive
4045
days old
jbdevstudio-users@lists.jboss.org
9 comments
2 participants
participants (2)
-
Jaideep Joshi -
Ted Jones