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.
|
|
>CERTIFICATE 'FILE=certificate.id' 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
|
