on 2015 Nov 01 1:57 AM
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'
Please, change id-file ("file path to save identity") to crt-file ("file path to save certificate").
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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\\
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.