smart4solutions / apex_oauth Goto Github PK

If the installation is to be run while logged in as the target schema, it needs these grants:

create session
create table
create view
create trigger
create sequence
create procedure
create type

I am getting below error while creating authentication.

ORA-06550: line 13, column 28: PL/SQL: ORA-00904: "S4SG_UTIL_PCK"."G_COLLNAME": invalid identifier ORA-06550: line 11, column 5: PL/SQL: SQL Statement ignored ORA-06550: line 23, column 15: PLS-00201: identifier 'S4SG_UTIL_PCK.G_SCOPE' must be declared ORA-06550: line 22, column 2: PL/SQL: Statement ignored

In order to do a clean uninstall, need a "drop objects" script, e.g.

drop package json_ext;
drop package json_parser;
drop package json_printer;
drop package s4sa_oauth_pck;
drop package s4sf_auth_pck;
drop package s4sg_auth_pck;
drop package s4sl_auth_pck;
drop view s4sa_requests_vw;
drop view s4sg_oauth_user_vw;
drop type json;
drop type json_list;
drop type json_value_array;
drop type json_value;
drop sequence s4sa_req_seq;
drop table s4sa_requests;
drop table s4sa_settings;

Hello Sir,

Can you help me, give me format of redirectURL of Google (And Facebook, Twitter?)

I try some format but it not work!

For example:

http://localhost:8080/apex/s4sg_auth_pck.oauth2callback

And get error message:

Not found

The requested URL /apex/s4sg_auth_pck.oauth2callback was not found on this server

Thanks sir.

Hi,

We are facing issue to access the given procedure.

I've already given grants to the apex_public_user, public and APEX_REST_PUBLIC_USER too.

We are using ORDS 3.0.8 , APEX 5.0.4.00.12 and Oracle Database 11g Release 11.2.0.3.0 - 64bit.

Anything I am missing to configure please let me know ?

Please find the attached screenshot.

I have a problem with Linkedin login.

Everything worked fine, but when a couple of times to log out and log out error:
Caused by: java.sql.SQLException : ORA -20000 : Unable to verify access token

Is the same when I log in to one account then logout and try to login to another - the same error.

This error occur at your demosite (http://dapex50.smart4apex.nl/ords/f?p=100) too.
Facebook and Google + login works without error.
I tried to resolve this problem, but I have no idea how.

Regards and thank you for your good hard work with this plugin :)

The error message from your site:

Tried install the plug in in Apex 4.2, but error "File is not a valid Application Express plug-in export file." prompt.

In new version of Apache

<Proxy *>
  Order deny,allow
  Allow from all
</Proxy> 

is replace to

<Proxy *>
  Require all granted
</Proxy> 

It is describe at
https://httpd.apache.org/docs/2.4/upgrading.html

It could be helpful for someone :)

In apex_oauth.sql:

This index is not required, as the table already has it:

CREATE UNIQUE INDEX "S4SA_SETTINGS_PK" ON "S4SA_SETTINGS" ("CODE")
Error report -
SQL Error: ORA-00955: name is already used by an existing object

This type:

CREATE OR REPLACE TYPE "JSON_VALUE_ARRAY" force as table of json_value;
/

Needs to be created after:

CREATE OR REPLACE TYPE BODY "JSON_VALUE"

Otherwise you get this error:
CREATE OR REPLACE TYPE "JSON_VALUE" force as object
...
ORA-02306: cannot create a type that already has valid dependent(s)

In s4a_settings_data.sql, the schema name has been hardcoded so needs to be edited if a different schema is used.

Can you share also the apex sample application? Do you have any sample to read google mail with attachment?

Thanks

Was getting an error missing access token, after debugging I found the response wasn't being properly parsed.

Looking at your code, I think they may have changed the response type from a string separated by & to be a JSON object.

Example response:

{"access_token":"-removed-","token_type":"bearer","expires_in":5183211}

Hi,

I test your plugin, it work fine for me with google, but it not working for Facebook.

With Facebook i get message:

ORACLE REST DATA SERVICES
404 Not Found

http://apex.v-click.vn:8080/ords/dev.s4sf_auth_pck.oauth2callback
and
http://apex.v-click.vn:8080/ords/dev.s4sl_auth_pck.oauth2callback

==> It not call to s4sf_auth_pck.oauth2callback procedure.

And work with google:
http://apex.v-click.vn:8080/ords/dev.s4sg_auth_pck.oauth2callback
==> ORACLE REST DATA SERVICES
500 Internal Server Error
(s4sg_auth_pck.oauth2callback called!)

Can you give me a hint?

Thanks.

Hi
Can you shared also the demo application in apex.world?

Thanks

Vincent

Hi,
We want to only use your plug-in for Google authentication. We use Google at our school so all users have a Gmail account in our domain.
If we are already using Oracle wallet on Weblogic server, why would we want to do your reverse proxy approach?
Also, can this same plug-in be used to check on whether someone is in a Google group. I notice you have included "Extra options for google API" and "Google log-in scope" so possibly scope can be expanded to include read-only view of group membership.

thanks

http://richardmartens.blogspot.nl/2015/07/making-https-webservice-requests-from.html%20title=%22blogspot%22

not working, after installing and applying the plugin i am getting this error while accessing my webpage.
.

Also while select plugin from authentication type no sentry function field is appearing.

Hi, Will this work for APEX 5? I have installed this plugin on APEX 5. But if I select this plugin in "Scheme Type", the Callbacks tab(Session sentry function name, Authentication function name etc) is getting disappeared.