Home » SQL & PL/SQL » SQL & PL/SQL » REST API with DDOS protection (ORACLE 12c)
REST API with DDOS protection [message #666633] Fri, 17 November 2017 17:57 Go to next message
mmation
Messages: 2
Registered: November 2017
Junior Member
Hi,

I used to call an API, but now the website add a Cloudflare DDOS protection.

Now, when I call the API, the result is the DDOS protection instead the API result.

API: https: //bittrex.com/api/v1.1/public/getmarketsummaries

my call:
select UTL_HTTP.REQUEST( 'bittrex.com/api/v1.1/public/getmarketsummaries') from dual;

expected:
{"success":true,"message":"","result":[{"Mar.......

With the DDOS protection the API result is the DDOS protection page:
"Checking your browser before accessing bittrex.com."

Can anyone help me to solve this problem?

Regards, Murilo
Re: REST API with DDOS protection [message #666634 is a reply to message #666633] Fri, 17 November 2017 21:04 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
mmation wrote on Fri, 17 November 2017 15:57
Hi,

I used to call an API, but now the website add a Cloudflare DDOS protection.

Now, when I call the API, the result is the DDOS protection instead the API result.

API: https: //bittrex.com/api/v1.1/public/getmarketsummaries

my call:
select UTL_HTTP.REQUEST( 'bittrex.com/api/v1.1/public/getmarketsummaries') from dual;

expected:
{"success":true,"message":"","result":[{"Mar.......

With the DDOS protection the API result is the DDOS protection page:
"Checking your browser before accessing bittrex.com."

Can anyone help me to solve this problem?

Regards, Murilo
>https://bittrex.com/api/v1.1/public/getmarketsummaries
above uses https but below use only HTTP://
>select UTL_HTTP.REQUEST( 'bittrex.com/api/v1.1/public/getmarketsummaries') from dual;
They are NOT the same!
IMO, root cause & fix are external to Oracle & Oracle is the victim; not the culprit.

Re: REST API with DDOS protection [message #666639 is a reply to message #666634] Sat, 18 November 2017 09:47 Go to previous message
mmation
Messages: 2
Registered: November 2017
Junior Member
Hi,

the result is the same.

The result is the DDOS page protection.

I created an ACL too:
BEGIN
--DBMS_NETWORK_ACL_ADMIN.DROP_ACL(acl => 'network_services.xml');
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'network_services.xml',description => 'FTP ACL',principal => 'MURILO',is_grant => true,privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'network_services.xml',principal => 'MURILO',is_grant => true,privilege => 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'network_services.xml',host => 'bittrex.com');
END;

Regards,
Previous Topic: REGEXP_SUBSTR
Next Topic: ora 01882
Goto Forum:
  


Current Time: Wed Dec 13 11:51:19 CST 2017

Total time taken to generate the page: 0.03626 seconds