cancel
Showing results for 
Search instead for 
Did you mean: 

Browsing a https web server with certificate from other database server

Former Member
0 Kudos
2,891
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.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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

Vlad
Product and Topic Expert
Product and Topic Expert
0 Kudos

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\\