Apex Oauth Plugin not working for Facebook

[o7planning]

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.

[rmartenss4s]

Google and Facebook use the same way of working (let’s not call it procedure to prevent confusion :-)

• Did you also apply for a api-key at Facebook?
• Did you alter anything in the settings-table?

Met vriendelijke groet, Kind regards, Vale

Richard Martens

[https://ci5.googleusercontent.com/proxy/z0WpVJS0D82t2-juj23D5RcA-I1EOpO06i_S7vV3HNjaBR9qi98ohLxztY69Memh4BfFh55S7qxRJujydzs22VzxP6Vq5Yv_2aTk5-TnqIm7veEsISlSz9SdKN_QQrO2-GeMgg6Lzx5alzPP77AKd613=s0-d-e1-ft#https://docs.google.com/a/smart4unity.com/uc?id=0B1Evw6LbZ0hBaVEtVjVWeDI1NlU&export=download] [https://ci5.googleusercontent.com/proxy/R-hPv04YoT9_wWPnb0i4knC37k8KHCfQdmXGWSWZPeTekN0XMNXiq3QmU-uVhbX99BgsNP1q3gpT_kXZHG68bHyiqqU-eM9hD_Dy_4mCUsgrhPcsPX9SHLt2cVDEXYvvNCWTHrT0y_vqJG_9lXoER1AKmDIyiRwdTOed9rczgjQ12YLj7xR2dKePbZxQc_VEWww0pOqM7JA8ReU=s0-d-e1-ft#https://docs.google.com/uc?export=download&id=0B1Evw6LbZ0hBZC1Lajk1RHY5UEE&revid=0B1Evw6LbZ0hBa1AxQ2FnQk5ud0RXeEpXZWdSMFNEMDlXKzhFPQ]

Vendeliersstraat 80

5021 HM Tilburg

The Netherlands

t: +31 - 6 57946631tel:%2B31%20-%206%2057946631

e: r.martens@smart4solutions.nlmailto:r.martens@smart4solutions.nl

Chamber of Commerce: 17.21.62.98

Value Added Tax nr: :NL.81.886.4916.B01

[https://ci6.googleusercontent.com/proxy/06cm3Ewqt5mE6V3aORhh_iEivxP9h1Ylwqv1O-LcB4YSHgOwi2f8_-p8azwyriFa96c-oPiD7bMgmzjEzmhDLkHJiihj5D3lAnwgRnlzDEA69uFe76tM5itzDrNZfyWZpBLQBBAyRHLUCBduvlD2BA10JzMU8Q8JWVmEMWQTUuGYiy5p4zR4d1BX5Uu8SemCk_L-b1gWpOEARmg=s0-d-e1-ft#https://docs.google.com/uc?export=download&id=0B1Evw6LbZ0hBeE53SlBjbUVmM2c&revid=0B1Evw6LbZ0hBQXZoSU9xV0RvZUFMUWd3VG1tZTRSaGJhOGNBPQ]

Smart Holding B.V. is trading as smart4solution

The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In that case you must not use, disclose, distribute, copy, print or rely on this communication.

Smart Holding B.V. is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Smart Holding B.V. does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference.

Van: o7planning notifications@github.com<mailto:notifications@github.com> Beantwoorden - Aan: smart4solutions/apex_oauth reply@reply.github.com<mailto:reply@reply.github.com> Datum: dinsdag 26 januari 2016 06:18 Aan: smart4solutions/apex_oauth apex_oauth@noreply.github.com<mailto:apex_oauth@noreply.github.com> Onderwerp: [apex_oauth] Apex Oauth Plugin not working for Facebook (#5)

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://apexv-clickvn:8080/ords/devs4sf_auth_pckoauth2callback and http://apexv-clickvn:8080/ords/devs4sl_auth_pckoauth2callback

==> It not call to s4sf_auth_pckoauth2callback procedure

And work with google: http://apexv-clickvn:8080/ords/devs4sg_auth_pckoauth2callback ==> ORACLE REST DATA SERVICES 500 Internal Server Error (s4sg_auth_pckoauth2callback called!)

Can you give me a hint?

Thanks

— Reply to this email directly or view it on GitHubhttps://github.com/smart4solutions/apex_oauth/issues/5.

[o7planning]

Hi,

Of course, I have modified the data in the table s4sa_settings, for google and facebook. And working fine for google.

This is my apps: http://apex.v-click.vn:8080/ords/f?p=102:101:14229045550905::NO:::

When you click the login button facebook, it does not redirect to facebook.

\ Normally, if you do not configure the table settings, it still must forwards to facebook page to accept.

Thanks

[rmartenss4s]

Dear 07planning..

Your app IS redirecting to Facebook.

However, once granted, Facebook does not ask the question no more and immediately redirects back to the authorized app (your app).

You can “unguent” the application when you’re in Facebook. After that FB will ask the question again.

Met vriendelijke groet, Kind regards, Vale

Richard Martens

[https://ci5.googleusercontent.com/proxy/z0WpVJS0D82t2-juj23D5RcA-I1EOpO06i_S7vV3HNjaBR9qi98ohLxztY69Memh4BfFh55S7qxRJujydzs22VzxP6Vq5Yv_2aTk5-TnqIm7veEsISlSz9SdKN_QQrO2-GeMgg6Lzx5alzPP77AKd613=s0-d-e1-ft#https://docs.google.com/a/smart4unity.com/uc?id=0B1Evw6LbZ0hBaVEtVjVWeDI1NlU&export=download] [https://ci5.googleusercontent.com/proxy/R-hPv04YoT9_wWPnb0i4knC37k8KHCfQdmXGWSWZPeTekN0XMNXiq3QmU-uVhbX99BgsNP1q3gpT_kXZHG68bHyiqqU-eM9hD_Dy_4mCUsgrhPcsPX9SHLt2cVDEXYvvNCWTHrT0y_vqJG_9lXoER1AKmDIyiRwdTOed9rczgjQ12YLj7xR2dKePbZxQc_VEWww0pOqM7JA8ReU=s0-d-e1-ft#https://docs.google.com/uc?export=download&id=0B1Evw6LbZ0hBZC1Lajk1RHY5UEE&revid=0B1Evw6LbZ0hBa1AxQ2FnQk5ud0RXeEpXZWdSMFNEMDlXKzhFPQ]

Vendeliersstraat 80

5021 HM Tilburg

The Netherlands

t: +31 - 6 57946631tel:%2B31%20-%206%2057946631

e: r.martens@smart4solutions.nlmailto:r.martens@smart4solutions.nl

Chamber of Commerce: 17.21.62.98

Value Added Tax nr: :NL.81.886.4916.B01

[https://ci6.googleusercontent.com/proxy/06cm3Ewqt5mE6V3aORhh_iEivxP9h1Ylwqv1O-LcB4YSHgOwi2f8_-p8azwyriFa96c-oPiD7bMgmzjEzmhDLkHJiihj5D3lAnwgRnlzDEA69uFe76tM5itzDrNZfyWZpBLQBBAyRHLUCBduvlD2BA10JzMU8Q8JWVmEMWQTUuGYiy5p4zR4d1BX5Uu8SemCk_L-b1gWpOEARmg=s0-d-e1-ft#https://docs.google.com/uc?export=download&id=0B1Evw6LbZ0hBeE53SlBjbUVmM2c&revid=0B1Evw6LbZ0hBQXZoSU9xV0RvZUFMUWd3VG1tZTRSaGJhOGNBPQ]

Smart Holding B.V. is trading as smart4solution

The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In that case you must not use, disclose, distribute, copy, print or rely on this communication.

Smart Holding B.V. is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Smart Holding B.V. does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference.

Van: o7planning notifications@github.com<mailto:notifications@github.com> Beantwoorden - Aan: smart4solutions/apex_oauth reply@reply.github.com<mailto:reply@reply.github.com> Datum: dinsdag 26 januari 2016 09:25 Aan: smart4solutions/apex_oauth apex_oauth@noreply.github.com<mailto:apex_oauth@noreply.github.com> CC: Richard Martens r.martens@smart4apex.nl<mailto:r.martens@smart4apex.nl> Onderwerp: Re: [apex_oauth] Apex Oauth Plugin not working for Facebook (#5)

Hi,

Of course, I have modified the data in the table s4sa_settings, for google and facebook. And working fine for google.

This is my apps: http://apex.v-click.vn:8080/ords/f?p=102:101:14229045550905::NO:::

When you click the login button facebook, it does not redirect to facebook.

\ Normally, if you do not configure the table settings, it still must forwards to facebook page to accept.

Thanks

— Reply to this email directly or view it on GitHubhttps://github.com/smart4solutions/apex_oauth/issues/5#issuecomment-174887990.

[o7planning]

Dear Richard Martens,

Ok, you're right, I have logged out of Facebook and then use oauth again, it was opened to facebook login window, but after login I get the message "404 Not Found" of ORDS.

I checked around and found that your instructions only grant to google. No facebook.

After i running:

grant execute on S4SF_AUTH_PCK to APEX_PUBLIC_USER; grant execute on S4SL_AUTH_PCK to APEX_PUBLIC_USER;

Now it work!

Thanks you.

[rmartenss4s]

Please drop me a "like" on http://apex.world :-)

[o7planning]

I liked :D Thanks