| Author |
store procedure and https
|
|
| Bob Piskac 2005-08-02, 8:23 pm |
| I am trying to write a stored procedure that calls a web service. The
following html code works.
<html>
<body>
<form method = "post" action="https://myserveranddomain//test.jsp">
<input name="SearchWord" size="20" maxlength="45" value=""/>
<input type="submit" value="Search"/>
</form>
</body>
</html>
I cannot get the stored procedure to work. It tells me that "The secure
connection to the remote host failed". Where do I start to fix this?
ALTER PROCEDURE "DBA"."sp_http_web_page"(SearchWord varchar(128)) url
'https://myserveranddomain//test.jsp'
type 'HTTP:POST'
certificate 'file=e:\\out.cer;'
| |
| Jeff Albion \(iAnywhere Solutions\) 2005-08-03, 11:23 am |
| 'https://myserveranddomain//test.jsp'
Have you tried ditching the double foreslash ("//") on the end of your
myserveranddomain string? Also, is your certficiate valid? Can you confirm
that?
Do you need a username and password to login to the HTTPS?
How is the database server being run? As a local system service? If so, does
the LOCAL_SYSTEM have access to E:? (i.e. is it a network drive or a hard
disk?)
--
Jeff Albion
Product Support Analyst
iAnywhere Solutions
"Bob Piskac" <Bob@pbsoftware.com> wrote in message
news:42efd19b$1@foru
ms-2-dub...
> I am trying to write a stored procedure that calls a web service. The
> following html code works.
>
> <html>
> <body>
> <form method = "post" action="https://myserveranddomain//test.jsp">
> <input name="SearchWord" size="20" maxlength="45" value=""/>
> <input type="submit" value="Search"/>
> </form>
> </body>
> </html>
>
> I cannot get the stored procedure to work. It tells me that "The secure
> connection to the remote host failed". Where do I start to fix this?
>
> ALTER PROCEDURE "DBA"."sp_http_web_page"(SearchWord varchar(128)) url
> 'https://myserveranddomain//test.jsp'
> type 'HTTP:POST'
> certificate 'file=e:\\out.cer;'
>
>
| |
| Bob Piskac 2005-08-04, 1:25 pm |
| That was just a typo. I can get this to work with Apache, but not IIS. I
changed it to pass the certificate as a parameter.
CREATE PROCEDURE "DBA"."sp_http_web_page"(url varchar(256),certFil
e long
varchar,arg1 long varchar)
url '!url'
type 'HTTP:POST' certificate 'certificate=!certFi
le'
Works great on appache. Errors on IIS.
"Jeff Albion (iAnywhere Solutions)" < jalbion_NO_SPAM_@syb
ase.com> wrote in
message news:42f0dc78$1@foru
ms-2-dub...
> 'https://myserveranddomain//test.jsp'
>
> Have you tried ditching the double foreslash ("//") on the end of your
> myserveranddomain string? Also, is your certficiate valid? Can you confirm
> that?
>
> Do you need a username and password to login to the HTTPS?
>
> How is the database server being run? As a local system service? If so,
> does
> the LOCAL_SYSTEM have access to E:? (i.e. is it a network drive or a hard
> disk?)
>
> --
> Jeff Albion
> Product Support Analyst
> iAnywhere Solutions
>
> "Bob Piskac" <Bob@pbsoftware.com> wrote in message
> news:42efd19b$1@foru
ms-2-dub...
>
>
| |
| Bob Piskac 2005-10-27, 7:41 am |
| I opened a case with iAnywhere support. https support does not work without
a private key in the certificate. We need it to work without the private
key.
|
|
|
|