The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.
Server A
CREATE SERVICE service_name TYPE 'RAW'
   AUTHORIZATION OFF USER user_name SECURE ON
   AS CALL procedure_name ();

Started with the 
dbsrv12 -xs https{Identity=certificate.id;Identity_Password=mypw} mydb.db

Server B
CREATE PROCEDURE "DBA"."test"()
URL 'https://url.../dbn/service_name'
CERTIFICATE 'FILE=certificate.id'
TYPE 'HTTP:POST'

File certificate.id is self-signed created with createcert.exe

Call test() returns
SqlCode: -983, SqlState: "WW052", Message: "HTTP request failed. Status code 'NONE'"

Starting Server A with dbsrv12 -xs http and call test() without CERTIFICATE and url 'http://' works fine.

Thanks in advance.

asked 01 Nov '15, 01:57

Veselin%20Ivanov's gravatar image

Veselin Ivanov
44357
accept rate: 0%


>CERTIFICATE 'FILE=certificate.id'
Please, change id-file ("file path to save identity") to crt-file ("file path to save certificate").

permanent link

answered 02 Nov '15, 01:25

Ilia63's gravatar image

Ilia63
706252947
accept rate: 16%

edited 02 Nov '15, 01:27

Here are links that I have googled in addition to your answer: http://sqlanywhere.blogspot.de/2010/10/using-https-with-your-sql-anywhere.html - this is a good Breck's article

Another one is from DCX: http://dcx.sap.com/index.html#sqla170/en/html/81311a8d6ce210148d3088cf123022ed.html. It shows a syntax, but keys&certificates can be taken from: c:\Users\Public\Documents\SQL Anywhere 17\Samples\Certificates\

(02 Nov '15, 05:22) Vlad
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×28
×18

question asked: 01 Nov '15, 01:57

question was seen: 270 times

last updated: 02 Nov '15, 05:22