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
44457
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
736253149
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
×19

question asked: 01 Nov '15, 01:57

question was seen: 316 times

last updated: 02 Nov '15, 05:22