search

cerndb / oracle-weblogic-1221-domain-ords-autodeploy

Oracle WebLogic docker image with ORDS deployed
GNU General Public License v3.0
1 stars 1 forks source link

SQL Developer 401 Error #1

Open JamesSB opened 6 years ago

JamesSB commented 6 years ago

Once up and running successfully, I am unable to create a connection with SQL Developer. I am able to connect to the database and enable the schema. However when trying to create a REST Development connection all I get is 401.

ORDS is working correctly as I am able to add the endpoints and navigate to them as described.

Has anyone had any luck connecting to SQL Developer?

lurodrig commented 6 years ago

Hello @JamesSB,

Does "REST Development connections" mean that you are trying to do something like this: F.2 Create a RESTful Service from a SQL Query ?

If this is the case you have to create a user with the role "SQL Developer" in WebLogic. You can use the console or a WLST script like this one: https://github.com/cerndb/oracle-weblogic-1221-domain-ords-autodeploy/blob/master/container-scripts/create_user_and_group.py

Hope it helps,

Luis

JamesSB commented 6 years ago

Hi,

I have tried this action before but it gives the same result. Please see the attached screenshots.

Thanks for you help.

Weblogic User image Weblogic Group to User image SQL Developer Settings image 401 image

lurodrig commented 6 years ago

Hi @JamesSB,

mmm, weird, I assume that SQLDeveloper prompted you for a password, if not that means that there is a missing bit in the documentation.

Do you have more than one authentication provider in weblogic ? I am asking because order and the JAAS Control Flag Option matter.

Hope it helps,

Luis

ps: sorry for the late response