The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.
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
776273450
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:

×31
×21

question asked: 01 Nov '15, 01:57

question was seen: 614 times

last updated: 02 Nov '15, 05:22